QuickBooks HelpQuickBooksHelpIntuit

Resolve accounts receivable or accounts payable balances on a cash basis balance sheet in QuickBooks Online

by Intuit68 Updated 2 days ago

Learn how to fix an Accounts Receivable (AR) or Accounts Payable (AP) balance on a cash basis balance sheet.

An issue with the balance is typically caused by one of two things: an accounts payable or accounts receivable transaction has affected the balance sheet account, or there's an unapplied payment.

Transactions affecting a balance sheet

An AR or AP balance on a cash basis balance sheet may be caused by an AR or AP transaction.

As soon as the entry is saved, the accounts receivable or accounts payable account shows a positive balance until you receive payment or pay the bill.

Common examples are:

  • Sales Tax: Normally reported under Sales Agency Tax Payable, a liability account.
  • Security Deposits: Often entered on invoices using a product/service item that is reported under a security deposit liability account.
  • Retainers: Often entered using a product/service item that is reported under a liability account.
  • Asset Purchase: A bill entered to purchase an asset.

In these cases, the balance can be left where it is. Such balances have no effect on the Profit and Loss report, which is the main focus of cash basis, not having a zero balance in accounts receivable or accounts payable. Your accountant can reverse the Accounts Receivable (A/R) or Accounts Payable (A/P) balances using the proper accounts when doing your taxes.

It's not a good idea to try to correct these accounts with a journal entry, especially for sales tax, as every customer account with a sales tax balance would have to have an individual line item entry made to it.

However, if you decide to create a journal entry, you should enter a date of the end of the time period, and set it to reverse on the following day. For invoices, the journal entry debits the account affected by the invoice and credits accounts receivable, while, for bill entries, it credits the asset account and debits accounts payable.

Warning: It is important to consult an accountant before trying to correct these accounts with a journal entry.

The following sections outline the steps to create and then reverse the journal entry. To see the steps, select the option below:

  1. Select + New.
  2. Under Other, select Journal Entry.
  3. Enter the Journal date. The Journal date is the date of the end of the time period.
  4. On the first line, select the account affected by the invoice from the dropdown list in the Account column.
  5. In the Debit column, enter the amount.
  6. Enter the reason for this journal entry in the Description field.
  7. In the second line, select Accounts Receivable (A/R) from the Accounts dropdown list. The amount is automatically entered in the Credits column.
    Note: If you're splitting this over several customer accounts, change the amount to reflect a single customer's sales tax.
  8. Select the customer from the dropdown list in the Name field.
  9. Select Save and close.

The journal entry is created.

Note that for offsetting accounts payable or vendor balances, the "Credit" account type is usually expense or liability. But it's really important that you consult an accountant. Same with accounts receivable adjustment.

  1. Select + New.
  2. Under Other, select Journal Entry.
  3. Enter the Journal date. The Journal date is the date of the end of the time period.
  4. On the first line, select the expense or liability account affected by the bill from the dropdown list in the Account column.
  5. Enter the amount in the Credits column.
  6. Enter the reason for this journal entry in the Description field
  7. On the second line, select Accounts Payable (A/P) from the Accounts dropdown list. The amount should be automatically entered in the Debit column.
  8. Select the Vendor from the dropdown list in the Name column.
  9. Select Save and close.

The journal entry is created.

Set the journal entry to reverse

Once the accounts receivable or accounts payable journal entry is created, you must set it to reverse:

  1. Select Search icon in the toolbar.
  2. Locate the journal entry you created and select it to open it.
  3. Select Reverse.
  4. Change the Journal date to one day after the original journal entry's Journal date.
  5. Select Save and close.

The journal entry you created will be reversed as you specified.

Unapplied payments

The second most common cause of a balance in accounts receivable or accounts payable is unapplied payments.

Bill payments that aren't applied to bills, or receive payment entries that aren't applied to invoices affect accounts payable and accounts receivable negatively. You can correct this situation by opening the payments from the Customer or Vendor registers and applying them.

Occasionally, unapplied payments are caused when you do not enter the corresponding invoices or bills. To correct this situation, you must enter the missing invoices or bills before you can apply the payments to them.

The following sections provide information about finding and addressing unapplied payments.

Find unapplied payments

To find unapplied payments, review the Customer Balance Detail or Vendor Balance Detail report.

  1. Go to Business overview, and select Reports (Take me there).
  2. Locate and select either the Customer Balance Detail or Vendor Balance Detail report.
  3. Review the report to identify any unapplied payments.

Once you have identified unapplied payments, you can apply them in Accounts Receivable (A/R) or Accounts Payable (A/P). To see the steps, select the option below:

  1. Go to Bookkeeping, select Transactions, then select All sales (Take me there).
  2. On the All Sales tab, select Filter.
  3. From the Type dropdown list, select Money received.
  4. Select a Customer name from the list.
  5. Select Apply.
  6. Locate and select the unapplied payment to open the Receive Payment window.
  7. In the Outstanding Transactions section, select the invoice or invoices the payment should be applied to.
  8. Select Save and close.

The payment is properly applied.

  1. Go to Bookkeeping, select Transactions, then select Expenses (Take me there).
  2. On the Expense Transactions page, select Filter.
  3. From the Type dropdown list, select Recently paid.
  4. Select Apply.
  5. Select the unapplied bill payment from the list to open the Bill Payment window.
  6. From the Add to Bill Payment panel, select Add for the bills to apply the payment to.
  7. Select Save and close.

The payment is properly applied to the bill.

Review Transaction Reports

The Transaction Report can show you the customer or vendor balance that creates a total in accounts receivable or accounts payable.

  1. Go to Business overview, and select Reports (Take me there).
  2. Locate and open the Balance Sheet report.
  3. Select the amount listed for the Accounts Receivable (A/R) or Accounts Payable (A/P) account to open Transaction Report for that account.
  4. Select Customize.
  5. In the Customize report panel, select the Rows/Columns item to open the section.
  6. From the Group by dropdown list, select Customer for accounts receivable or Vendor for accounts payable.
  7. Select Run report.

You can use the information in the report to identify the cause of the balance and decide what action is necessary.

QuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.