Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
How do I clear these negative amounts on the AR Aging Report? Please see attached.
Solved! Go to Solution.
Allow me to help you correct your Accounts Receivable, simtreasurer86.
The negative balance is from the overpayments or credits. You'll have to check if these are duplicates or not.
Then, check if there should be an invoice to apply it to. Create one if needed.
Apply the credit to an invoice you already created
Apply the credit to a new invoice
After doing these, check the A/R Aging Report to see if there are changes.
Let me know if you have other questions.
QB breaks the accounting rules, customer credits (which is a liability) are kept in the A/R account.
So any negative amounts you have in A/R should be posted against a customer invoice
Thank you, I understand. My problem is how to correct these transaction.
Allow me to help you correct your Accounts Receivable, simtreasurer86.
The negative balance is from the overpayments or credits. You'll have to check if these are duplicates or not.
Then, check if there should be an invoice to apply it to. Create one if needed.
Apply the credit to an invoice you already created
Apply the credit to a new invoice
After doing these, check the A/R Aging Report to see if there are changes.
Let me know if you have other questions.
Thank you for providing the solution. Appreciate your help
my issue is these payments showing a negative in my aging ar report are not in fact credits. they were applied to invoices last winter and zeroed out. recently checking the ar report i found the negatives as if they were overpayments. that is absolutely not true. I do have the bank linked and not sure if they are duplicating. please advise and help me to stop this from continuing to happen
thank you
Thanks for jumping in to this thread, saratoga.
An overpayment will cause a negative Accounts Receivable. Since you have your bank linked with QuickBooks Online (QBO), let's make sure to match the transaction instead of adding them to avoid duplicates.
Use the Find Match option to display all the possible matched transactions. To do that, follow the steps below:
Once done, the transactions will now show under the In QuickBooks tab. This article serves as your complete guide on how to add and match downloaded transactions in QBO: Add and match downloaded banking transactions.
You can also have these links about the reconciliation process in QBO:
The Community is always open if you have other questions. I'll be around to help. Have a good one.
I'm working with a client that goes through a bonding company to be able to do big projects. They are wanting an accrual Profit and Loss that includes Accounts Receivables but I've tried to reflect different ways and it still doesn't show up on the report.
I appreciate you for joining the thread, @jijuvera. Let me share with you some insights about the Profit and Loss report and how you can get the details of your client's Accounts Receivable (AR) entries.
The P&L report displays all of the income and expense transactions recorded in QuickBooks. Thus, adding AR transactions isn't possible. The good news is, you can use the Balance Sheet report to get the information you need.
Here's how:
For more tips while running these reports, you can open these articles:
Just in case you want to save your reports for future use, you can mail, print, or export them to Excel. You can check out this link as your guide: Run reports in QuickBooks Online. From there, go to the Print reports, Email reports, and Export reports sections.
If you have any other follow-up questions while running QuickBooks reports, let me know by adding a comment below. I'll get back to you as soon as I can help you again. Keep safe!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here