QuickBooks HelpQuickBooksHelpIntuit

Resolve accounts receivable and accounts payable balances on a cash basis balance sheet in QuickBooks Desktop

by Intuit•1• Updated 3 days ago

Learn how to resolve A/R and A/P balances on a cash basis balance sheet report in QuickBooks Desktop.

A balance sheet report in cash basis shouldn’t show A/R or A/P balances because these accounts track open (unpaid) invoices and unpaid bills. If they show up, here’s how to fix the issue.

image

The following reports should help you find the root cause transactions:

  1. Go to Reports, then select Customers & Receivables.
  2. Select Open Invoices.
  3. Select the Date ▼dropdown then select the correct date.
  4. Select Customize Report, then select Advanced.
  5. Select Report Date, select OK, then select OK again.

The payments that appear on the report (included in the CBBS) have been received but not applied to an invoice.

  1. Go to  Reports, then select Vendors & Payables.
  2. Select Unpaid Bills Detail.
  3. Select the Date ▼dropdown then select the correct date.
  4. Select Customize Report, then select Advanced.
  5. Select Report Date, select OK, then select OK again.

The bill payment checks that appear on the report (included in the CBBS) have been entered but not applied to a bill.

  1. Go to Reports, then select Company & Financial.
  2. Select Balance Sheet Standard.
  3. Select Customize Report, then select Cash.
  4. Delete the From date, then select OK
  5. Double click the A/R amount to bring up the Transactions by Account report.
  6. Select Customize Report, delete the From date, then select Advanced.
  7. Select Report Date, then select OK
  8. Select Customer in the Total by ▼ dropdown.
  9. Select Filters.
    1. .Select Customer in the Total by ▼ dropdown.
    2. Select All accounts receivable in the Account ▼ dropdown.
    3. Select No under Include split detail.
    4. Select  Paid Status in the FILTER▼dropdown, select Open, and then select OK.

Each nonzero customer subtotal affects the A/R balance.

  1. Go to  Reports, then select Company & Financial.
  2. Select Balance Sheet Standard.
  3. Select Customize Report, then select Cash.
  4. Delete the From date then select OK.
  5. Double-click the A/P amount to bring up the Transactions by Account report.
  6. Select Customize Report, delete the From date, then select Advanced.
  7. Select Report Date, then select OK.
  8. Select Vendor in the Total by ▼ dropdown. 
  9. Select Filters.
    1. Select Account in the FILTER ▼ dropdown. 
    2. Select  All accounts payable In the Account ▼ dropdown.
    3. Select No under Include split detail.
    4. Select  Paid Status in the FILTER ▼ dropdown, select Open, and then select OK.

Each non-zero vendor subtotal affects the A/P balance.

Important: Back up the QuickBooks company file before you proceed with these steps.

  1. Change your Sales Tax preference to Upon receipt of payment (Cash Basis).
  2. Link transactions in the Receive Payment window (A/R).
  3. Link transactions in the Pay Bills window (A/P).
  4. Be sure that your service, non-inventory part, and other charge items are linked to income and expense accounts:
    1. Go to Lists, then select Item List.
    2. Look for any balance sheet accounts (assets, liability, or equity) listed in the Account column.
    3. Make sure items with asset accounts are set up correctly. Some items like sales tax and retainers should have asset accounts.
  5. Temporarily delete the transactions you identify as problems.
    1. Memorize the open transactions and then delete them.
    2. Print your cash basis reports.
    3. Reenter the transactions from the memorized transactions list.
  6. Edit your journal entries.
    1.  Separate the A/P and A/R  of journal entries with several transactions involving balance sheet accounts, into separate JEs.
    2. Move the A/R  to the first line (source) of the JE. JEs with an income or expense account will drop off the report. JEs with a balance sheet account will remain on the report.

Note: Every QuickBooks transaction has one source account and one or more target accounts.

Note: Don't use Inventory items if you only have very few actual inventory items.

  1. Write off your inventory.
  2. Deactivate your inventory items.
  3. Re-create them as non-inventory parts.
  4. Use only cash transactions such as checks, sales receipts, and credit card charges.If you must use invoices and bills, make sure that none of the targets have balance sheet accounts.
  5. Track A/R and A/P in separate data files.
    1. Enter only cash transactions in the main (or cash) data file.
    2. Enter only accrual transactions into the secondary (or accrual) data file.
    3. Delete the open accrual transactions and reenter them as cash transactions when the cash has been paid out or paid in.
QuickBooks Accountant Desktop PlusQuickBooks Desktop Enterprise AccountantQuickBooks Desktop Enterprise DiamondQuickBooks Desktop Enterprise GoldQuickBooks Desktop Enterprise PlatinumQuickBooks Desktop Premier PlusQuickBooks Desktop Pro Plus