cancel
Showing results for 
Search instead for 
Did you mean: 
tamaro722
Level 2

Correct a Customer Balance

How do I correct an incorrect amount owed on a customer statement? The customer statement shows the customer owes an additional $50 more than the customer balance report shows. If I do a payment of $50 to just get rid of the difference - the statement then looks correct, but the customer balance is now wrong by $50. Is there a journal entry or anything I can do to just offset it so they are equal?

3 Comments 3
MariaSoledadG
QuickBooks Team

Correct a Customer Balance

When you create a statement, ensure to correctly set it up and enter the correct amounts so that it is error free, tamaro722.

 

To create one, you can  follow the steps below: 

 

  1. Go to Customers, select Create Statements.
  2. Choose the appropriate A/R account.
    Note: QuickBooks displays the A/R Account field ONLY when your Chart of Accounts contains more than one A/R.
  3. Check the statement date.
  4. Select the date period of the transactions.
    Note: You can specify the dates or you can include all open (unpaid) transactions as of the statement date.
  5. Select the customers you want to print statements for.
  6. Select additional options.
  7. Select Print or E-mail depending on how you want to send the statements to your customers.

 

However, if the Email button doesn't work, I've outlined the steps below on how you can correct it.

 

  1. Ensure all preferences are appropriately selected to generate a statement.
    • The appropriate customer should be selected.
    • The customer should have an invoice or sales receipts within the statement period or before the statement date.
    • If the desired customer has a zero balance, under the Do not create statements: the box for with a zero balance should be unchecked.
  2. For the Template, select the Intuit Standard Statement.
  3. If the Create One Statement is blank, choose Per Customer or Per Job from the drop - down.
  4. Ensure that the customer has a working email address set up, and that all the email preferences are appropriately chosen:
    1. Select the Edit tab, then choose Preferences.
    2. Select Send Forms.
    3. Check if the email address setup is working, then select OK.
  5. If the emails still fails, the issue may be an overflow error.
    1. Under the , put a check on the box for with a balance less than.
    2. Change the input to 0.00
    3. Re-send the email.

 

If you really want to offset the amount through journal entry, I suggest reaching out to your accountant for more details. Moreover, learn how to track customer transactions and help you organize your cash flow, track sales, receivables, and profitability more accurately in QuickBooks. To learn more, I've added this article for your guide: Get Started With Customer Transaction Workflows In QuickBooks Desktop.

 

Please get back to us if there's anything else you need help with statements. We're always right here to assist you further.

tamaro722
Level 2

Correct a Customer Balance

Thank you - the issue is that the statement is incorrect and doesn't match the customer balance report. Apparently the file didn't reindex properly or something - as it's a glitch on this one customer. I need to match the statement balance to the customer balance report. Is there an offsetting entry to achieve this?

User610
Level 1

Correct a Customer Balance

Did you ever get an answer to this?  I am having the same issue.  No open invoices or payments but Customer shows a balance in Customer listing.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us