Was this page helpful?
Thank you!

Comments or suggestions?


May we contact you? Although a personal response may not be provided, we value your feedback.
Privacy Policy

Enter Email Address (optional)
email

Accounts Receivable reports show zero balances for customer:jobs

Accounts Receivable (A/R) reports include customer:jobs with a zero total balance. This issue affects the following reports found under Reports > Customers & Receivables:

  • A/R Aging Summary.
  • A/R Aging Detail.
  • Open Invoices.
Why this is happening

Customers that show a zero balance have unapplied debits (invoices, journal entries) and unapplied credits (payments, credit memos, journal entries):

  1. A customer has an unpaid invoice for $100 and you entered a credit memo for $100, but you have not applied the credit memo to the invoice.
  2. You entered a Journal Entry (GJE) to post an entry to a customer, then you entered a reversing GJE in the next accounting period. Both JE s will appear on the reports until you link them in Receive Payments.
How to fix it

Apply the outstanding credit or payment balance to the unpaid invoice.

NOTE: If you have multiple A/R accounts, both transactions must use the same A/R account.

  1. In the menu bar, select Reports > Customers & Receivables > Open Invoices.
  2. Find the customer that displays a zero total balance.
  3. Confirm that the total credits and payments equal the total of all outstanding invoices.
  4. Apply the outstanding payment or credit.

 

Credit Memo.

  1. Double-click on the Credit Memo displayed on the report.
  2. On the Create Credit Memos/Refunds window, click the Use Credit To drop-down arrow and select Apply to invoice.
  3. In the Apply Credit to Invoices window, click in the checkmark column to apply the credit to the selected invoice(s).
  4. Click the Done button.
  5. Click Save & Close on the Create Credit Memos/Refunds window.

 

Payment.

  1. Double-click on the Payment displayed on the report.
  2. In the Receive Payments window, click in the checkmark column to apply this payment to the selected invoice(s).
  3. Click Save & Close.

 

General Journal Entry.

  1. Select Customers > Receive Payments.
  2. Click the Discounts & Credits... button near the bottom of the window.
  3. On the Discounts and Credits window, QuickBooks will automatically select the available credit(s).
  4. Confirm that the selections are correct.
  5. Click the Done button.
  6. Click Save & Close on the Receive Payments window.

 

If this solution does not resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site for free. You can contact an agent for additional guidance. Fees may apply.

KB ID# SLN40686
5/21/2013 7:57:29 AM
QYPPRDQBKSWS06 9090 Pro 2012 5eb395