QuickBooks 2010 Solutions Guide for Business Owners and Accountants

( 3 )

Overview

This is the definitive, must-have QuickBooks 2010 reference for every business owner and accounting professional. Not a beginner's guide, this is a high-productivity resource for solving the problems that intermediate-to-advanced QuickBooks users encounter most often. Author Laura Madeira is well-qualified to write this book: she has 20 years experience training professionals on Intuit products, and has been selected by Intuit to introduce its new releases to accountants and business entrepreneurs. Here, she ...

See more details below
Other sellers (Paperback)
  • All (12) from $2.21   
  • New (5) from $19.99   
  • Used (7) from $2.21   
QuickBooks 2010 Solutions Guide for Business Owners and Accountants

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study

Want a NOOK? Explore Now

NOOK Book (eBook)
$17.99
BN.com price
(Save 43%)$31.99 List Price

Overview

This is the definitive, must-have QuickBooks 2010 reference for every business owner and accounting professional. Not a beginner's guide, this is a high-productivity resource for solving the problems that intermediate-to-advanced QuickBooks users encounter most often. Author Laura Madeira is well-qualified to write this book: she has 20 years experience training professionals on Intuit products, and has been selected by Intuit to introduce its new releases to accountants and business entrepreneurs. Here, she offers real solutions for every QuickBooks accounting module, helping you achieve their true goal for QuickBooks: a clear, up-to-date understanding of where the business stands, and where it's headed. Madeira's expert consulting advice covers: data files, banking; A/R, undeposited funds, employee advances, inventory, A/P, sales tax, payroll, reporting, sharing data with accountants, and much more.

  • Offers expert solutions, processes, and QuickBooks troubleshooting help users can't find in any other book
  • Shows how to fix errors and problems wherever they occur, from A/R and A/P to sales tax and payroll
Read More Show Less

Product Details

  • ISBN-13: 9780789743220
  • Publisher: Que
  • Publication date: 1/5/2010
  • Pages: 519
  • Sales rank: 1,205,885
  • Product dimensions: 7.00 (w) x 9.00 (h) x 1.30 (d)

Meet the Author

Laura Madeira is the owner of ACS, Inc., a software sales and consulting firm located in the greater Dallas, Texas area. Her affiliations with Intuit include being an Intuit Solution Provider, a select Member of the Intuit Trainer/Writer Network, Advanced QuickBooks Certified, Enterprise and Point of Sale Certified, and member of the Intuit Solution Provider Advisory Council.

Laura is also the author of the QuickBooks 2008 and 2009 Solutions Guide, QuickBooks Essentials: For All QuickBooks Users, 9+ hours of self-paced video instruction, and coauthor of QuickBooks 2009 and 2010 on Demand, all offered by Que Publishing.

For more than 22 years Laura has worked with companies of all sizes and from many varied industries. Her focus has been to help small to mid-sized growing businesses become more successful by automating their internal accounting processes and reporting functions.

Additionally, Laura is a guest speaker for Intuit, providing training to thousands of consultants and accountants nationwide. She is also a respected author for Intuit who writes technical training materials presentations and documents her research and review of competing software solutions. Her QuickBooks at Year-End document is one of the most sought-after publications that Intuit offers its ProAdvisor consultants.

Laura has served on two Intuit Customer Advisory Councils and has been a consultant representing the accountant community during product development for QuickBooks 2010. She earned her accounting degree from Florida Atlantic University.

You can find out more information about the author on her website: www.quick-training.com.

Read More Show Less

Table of Contents

Introduction

How This Book Is Organized . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .1

Conventions Used in This Book . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .3

1 Creating a New QuickBooks File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .5

EasyStep Interview–Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .6

Converting from Other Accounting Software to QuickBooks . . . . . . . . . . . . . . . . . . . .15

Setting Up a QuickBooks Data File for Accrual or Cash Basis Reporting . . . . . . . . . . . .22

2 Reviewing the Chart of Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .37

Understanding the Chart of Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .38

Importing a Chart of Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .40

Preferences That Affect the Chart of Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .48

Accounts That QuickBooks Creates Automatically . . . . . . . . . . . . . . . . . . . . . . . . . . . .50

Methods to Troubleshoot and Correct Chart of Account Issues . . . . . . . . . . . . . . . . . .51

3 Reviewing the Items List . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .61

Differences Between the Chart of Accounts, Items, Classes, and Customer Types . . . . .62

Using Item Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .66

Finding Item Errors in QuickBooks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .69

Fixing Item Errors in QuickBooks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .74

Creating Items as Subitems . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .81

4 Easily Review Your QuickBooks Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .83

Client Data Review–Improved for 2010! . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .84

Choosing a Reporting Basis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .85

Reviewing the Balance Sheet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .86

Additional Data Reviews . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .96

5 Power Reports For Reviewing Your Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .101

How Can These Power Reports Help Me? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .102

Troubleshoot Account Balances–Improved for QuickBooks 2010! . . . . . . . . . . . . . . .103

The Working Trial Balance Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .103

Tracking Changes to Closed Accounting Periods . . . . . . . . . . . . . . . . . . . . . . . . . . . .105

Using the Audit Trail Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .110

Using the Credit Card Audit Trail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .111

Using the Voided/Deleted Transactions Summary or Detail Report . . . . . . . . . . . . . . .114

Creating the Retained Earnings QuickReport . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .115

Using the Ctrl+Y Keyboard Shortcut . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .117

Running the Transaction List by Date Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .118

Documenting Changes Made to a Data File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .120

6 Reviewing Your Bank Reconciliations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .123

The Importance of Correct Bank Balances in Your QuickBooks Data . . . . . . . . . . . . . .124

Reconciling a Bank Account for the First Time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .124

Troubleshooting an Incorrectly Reconciled Bank Account . . . . . . . . . . . . . . . . . . . . . .130

Reconciling with an Adjustment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .139

7 Reviewing Accounts Receivable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .141

Accounts Receivable Forms and Workflow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .142

Preferences That Affect Accounts Receivable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .144

Reports to Review When Troubleshooting Accounts Receivable Errors . . . . . . . . . . . .157

Correcting Accounts Receivable Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .165

Unique Customer Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .186

8 Reviewing Undeposited Funds Account . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .193

The Purpose of the Undeposited Funds Account . . . . . . . . . . . . . . . . . . . . . . . . . . . .194

Preference Settings That Affect Undeposited Funds . . . . . . . . . . . . . . . . . . . . . . . . . .194

Reviewing the Balance in the Undeposited Funds Account . . . . . . . . . . . . . . . . . . . .197

Fixing Errors with the Undeposited Funds Account . . . . . . . . . . . . . . . . . . . . . . . . . .204

9 Handling Current Asset Accounts Correctly . . . . . . . . . . . . . . . . . . . . . . . . . . . . .213

Defining an Other Current Asset . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .214

Reviewing the Other Current Asset Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .214

Troubleshooting and Creating Unique Other Current Asset Account Transactions . . . .219

10 Reviewing Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .229

Overview of the Accounting for Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .230

Preferences That Affect Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .232

Inventory Processes and Forms and Their Effect on Accounting . . . . . . . . . . . . . . . . .236

Reviewing and Troubleshooting Inventory Balances . . . . . . . . . . . . . . . . . . . . . . . . . .238

Correcting Inventory Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .249

How QuickBooks Handles Negative Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .253

11 Reviewing Accounts Payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .261

Accounts Payable Forms and Workflow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .262

Preferences That Affect Accounts Payable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .268

Reports to Review When Troubleshooting Accounts Payable Errors . . . . . . . . . . . . . .275

Correcting Accounts Payable Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .290

Unique Accounts Payable Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .301

12 Reviewing Sales Tax . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .313

Preferences That Affect Sales Tax . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .314

Sales Tax Items, Groups, and Codes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .318

Assigning Sales Tax Codes to Products or Services . . . . . . . . . . . . . . . . . . . . . . . . . . .322

Assigning Sales Tax Codes and Sales Tax Items to Customers . . . . . . . . . . . . . . . . . . .323

Reports to Review When Troubleshooting Sales Tax Errors . . . . . . . . . . . . . . . . . . . . .324

Properly Paying Sales Tax . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .331

Correcting Sales Tax Errors . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .335

Unique Sales Tax Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .341

13 Reviewing Opening Balance Equity Account . . . . . . . . . . . . . . . . . . . . . . . . . . . .347

Purpose of the Opening Bal Equity Account . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .348

Transactions in the Opening Bal Equity Account . . . . . . . . . . . . . . . . . . . . . . . . . . . .348

Reports to Review and Troubleshoot the Opening Bal Equity Account . . . . . . . . . . . .358

Closing Opening Bal Equity into Retained Earnings . . . . . . . . . . . . . . . . . . . . . . . . . .360

Setting a Closing Date and Password . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .363

14 Reviewing Payroll . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .365

Payroll Service Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .366

Payroll and Employees Preference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .368

Payroll Forms and Workflow in QuickBooks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .370

Using the Payroll Setup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .373

Using the Run Payroll Checkup Diagnostic Tool . . . . . . . . . . . . . . . . . . . . . . . . . . . . .375

Reports to Review When Troubleshooting Payroll . . . . . . . . . . . . . . . . . . . . . . . . . . .382

Adjusting Payroll Liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .389

Unique Payroll Transactions and Processes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .393

15 Sharing Data with Your Accountant or Your Client . . . . . . . . . . . . . . . . . . . . . . . .411

Sharing QuickBooks Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .412

QuickBooks File Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .413

Data Sharing for the Business Owner . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .418

Data Sharing for the Accountant . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .432

16 Reporting Tips and Tricks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .449

Intuit Statement Writer–Improved for 2010! . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .450

Company Snapshot–Improved for 2010! . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .484

Newly Redesigned Report Center . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .487

Reporting Preferences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .490

Modifying Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .493

Report Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .495

Memorized Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .500

Exporting and Importing Report Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .501

Exporting Reports to a .CSV File or to Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .503

Emailing Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .504

17 Detecting and Correcting with the Client Data Review Feature

Online only at: www.informit.com/title/9780789743220

Introduction: Features and Benefits

Starting a Client Data Review

Customizing the Client Data Review Center

Account Balances

Review List Changes

Accounts Receivable

Accounts Payable

Sales Tax

Inventory

Payroll

Bank Reconciliation

Miscellaneous

Finishing a Client Data Review

Reopening a Client Data Review

Reporting on Review Activity

Creating an External Accountant User

Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .507

Read More Show Less

Customer Reviews

Average Rating 3
( 3 )
Rating Distribution

5 Star

(1)

4 Star

(0)

3 Star

(1)

2 Star

(0)

1 Star

(1)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 – 4 of 3 Customer Reviews
  • Anonymous

    Posted January 11, 2011

    Not Recommended - no in depth solutions provided!

    I purchased this book because it was a "Que Book". This book is not your standard "Que Book"; it is published as a user manual without the comprehensive index normally associated with "Que Books". I cannot find an answer related to Enter Time and how it corresponds to Overtime Payroll and I have issues related to the explanation of Charge Card purchases and payments.

    2 out of 2 people found this review helpful.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted January 14, 2010

    No text was provided for this review.

  • Anonymous

    Posted July 2, 2011

    No text was provided for this review.

  • Anonymous

    Posted February 15, 2011

    No text was provided for this review.

Sort by: Showing 1 – 4 of 3 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)