QuickBooks Cash Basis Accounts Receivable or Payable

QuickBooks Help with Balance Sheet

What can you do if you do have an Accounts Receivable balance on your Cash Basis Balance Sheet? First, modify the following report, to help you locate the transactions making up this balance:

1.      Select Reports, Company & Financial

2.      Select Balance Sheet Standard

3.      Click the Modify Report button

4.      The Display tab opens. Select Cash for the report basis

5.      Click OK

6.      With your mouse pointer, double-click the Accounts Receivable amount in question

7.      The Transaction by Account report is created

8.      Click the Modify Report button. The Display dialog opens

9.      For the Report Date Range, remove the From date and leave the To date

10.    Click the Advanced button, and from the Open Balance / Aging pane, select Report Date

11.    Click the Filters tab

12.    In the Choose Filters pane, scroll down to select Paid Status

13.    Select the Open for Paid Status radial button

14.   Click OK

So, why exactly do I see an Accounts Receivable balance on a Cash Basis Balance Sheet? Any of the following can be the cause:

• A/R transactions have items posting to other Balance Sheet accounts.
• Inventory items on an invoice or credit memo (typically, inventory management should be done only in Accrual Basis reporting).
• Transfers between Balance Sheet accounts.
• Unapplied Accounts Receivable customer receipts.
• Payments applied to future-dated Accounts Receivable invoices.
• Preferences that contradict each other. (This situation can happen if you select Cash Basis on your Summary Reports, but Accrual Basis as your Sales Tax preference.)
• Data corruption (click File, Utilities, Verify Data to check for data corruption).

Look for transactions that fall into any of the categories above. Any item used on a customer invoice that is mapped to another Balance Sheet account will display on a Cash Basis Balance Sheet report.

This same process works for identifying Cash Basis Accounts Payable transactions as well.

This excerpt is from the QuickBooks 2010 Solutions Guide http://www.quick-training.com/book.html

Visit our Website for additional training products.  www.quick-training.com