Understanding AR and AP Balances on a Cash-Basis Balance Sheet in QuickBooks Online
Learn why Accounts Receivable or Accounts Payable may show balances on a cash‑basis Balance Sheet in QuickBooks Online and what steps resolve the issue.
QuickBooks Online users who run cash‑basis financial statements sometimes notice non‑zero amounts in Accounts Receivable or Accounts Payable on the Balance Sheet. These balances can appear even when all invoices and bills seem to be paid.
Causes of unexpected balances
Transactions that post to a balance‑sheet account without affecting income or expense often generate the balances. Examples include sales‑tax liabilities, customer deposits, provisions, or asset purchases recorded through an invoice or bill. When the transaction is saved the related receivable or payable shows a balance until payment is received or made. In cash‑basis reporting the profit‑and‑loss statement ignores these amounts, so the balance may remain without impacting net income.
Checking the impact on reports
Open the Balance Sheet report and set the basis to Cash. Locate the Accounts Receivable and Accounts Payable lines. If the balances are small and relate to tax, deposits, or similar items, they likely stem from the transaction types described above. Run a Transaction Detail report filtered by the relevant account to see the specific entries that created the balance.
When to leave the balances unchanged
If the balance originates from a liability such as sales tax or a deposit, correcting it with a journal entry can create unnecessary work. Your accountant can offset the amount during tax preparation using the appropriate liability account. Leaving the balance as is does not affect the cash‑basis profit‑and‑loss statement, which is the primary focus of this reporting method.
Creating a reversing journal entry
When a journal entry is preferred, enter it with the last day of the reporting period and mark it to reverse on the following day. For an invoice that posted to a liability account, debit the liability and credit Accounts Receivable. For a bill that posted to an asset account, credit the asset and debit Accounts Payable. The reversing entry automatically clears the balance in the next period, keeping the cash‑basis reports clean.
Applying unapplied payments
Sometimes the balance results from a payment that was never linked to its invoice or bill. Open the Customers or Vendors centre, locate the open transaction, and select Receive Payment or Pay Bills. Apply the payment to the specific invoice or bill and save. The applied payment reduces the receivable or payable balance to zero, removing it from the Balance Sheet.
Verifying the correction
After making a journal entry or applying a payment, reopen the cash‑basis Balance Sheet. Confirm that the Accounts Receivable or Accounts Payable line now shows zero or the expected residual amount. Run a Profit and Loss report to ensure net income remains unchanged, confirming that the adjustment only affected the balance‑sheet section.
Summary
Balances in Accounts Receivable or Accounts Payable on a cash‑basis Balance Sheet usually arise from balance‑sheet‑only transactions or unapplied payments. They do not distort the profit‑and‑loss statement, so leaving them untouched is often acceptable. If a clean balance sheet is required, either create a reversing journal entry dated to the period end or apply the missing payment to its source transaction. Both approaches restore the expected zero balance while preserving the integrity of cash‑basis reporting.