QuickBooks Tip: Cash Basis Balance Sheet for A/R or A/P

by Lynnea Bylund on October 17, 2010 · 5 comments

certified quickbooks bookkeeping for small businesses in orange county and san diego

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:

From Laura Madeira’s QuickBooks 2010 Solutions Guide

• Select Reports, Company & Financial

• Select Balance Sheet Standard

• Click the Modify Report button

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

• Click OK

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

• The Transaction by Account report is created

• Click the Modify Report button. The Display dialog opens

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

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

• Click the Filters tab

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

• Select the Open for Paid Status radial button

• 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.


1 Dizzy Martin February 23, 2011 at 3:41 am

Great QB tp, it helped a lot. thanks!

2 Oscar Ruisi April 1, 2011 at 11:07 am

That was a GREAT QB tip! TY!

3 Grover Eberhart April 7, 2011 at 3:17 am

Very helpful QB tip! Thanks!

4 gry dla dzieci April 28, 2011 at 6:42 pm

You’re just jealous because the voices are talking to me and not you!

Comments on this entry are closed.

Previous post:

Next post: