cancel
Showing results for 
Search instead for 
Did you mean: 
Janet32
Level 1

Assets - Accounts Receivable

I just took over QB Desktop Pro. All Accounts are paid up. But on Balance Sheet under Assets shows Accounts Receivable with (-)165.00.

I went to Reports - Customers & Receivables - Customer Balance Detail and found the errors.

It shows a member paid but there is no Statement Charges for this. I know the previous treasurer sent him a statement. How to find out why these statement charges did not go through. 

Another entry in payments shows statement charges but does not show payment although I know he paid.

Another entry shows $125 paid on open account of $124 so it shows overpayment of $1. How to correct these balances?

 

 

1 Comment 1
RenjolynC
QuickBooks Team

Assets - Accounts Receivable

I'll share some steps where you can find the information, Janet32.

 

You'll want to run the Audit Trail report to track the list of all your QuickBooks activity in chronological order. There might be changes on the transactions that caused the overpayment or missing charges.

 

You can customize and filter the report to locate the specific statement charge by following these steps:

 

  1. Go to Reports Account & Taxes Audit Trail.
  2. In the Audit Trail window, click the Customize Report button.
  3. Click the Filter tab and search for Transaction type.
  4. Choose Statement Charge and select OK.
  5. Make sure to filter the dates and find the statement charge.

Please see this sample screenshot for a visual guide:

 

 

You can also read this article to guide you in customizing a report in QuickBooks: Customize reports in QuickBooks Desktop.

 

If the statement charge for the missing payment is deleted, you can follow these steps to re-create it:

 

  1. Go to Customers > Statement Charges/Enter Statement Charges.
  2. Select the customer from the Customer Job drop-down menu. Note: If the Customers & Jobs list shows more than one job for the customer, select the correct job. QuickBooks maintains a separate register for each job.
  3. (Optional) Change the date of the statement charge.
  4. Select the item. Note: When you select or add an item, the description and amount are automatically populated based on the description and unit cost entered when the item was set up. You can delete or modify this when creating invoices.
  5. Click Record.

Here's an article for reference: Create statement charges.

 

With regard to the overpayment, I recommend consulting with your accountant to make sure you have the correct balances.

 

I'm here to help you out again if you have any follow-up questions or other concerns with QuickBooks Desktop. Take care and stay safe.

Need to get in touch?

Contact us