- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Negative Amount in AR Aging Report
How do I clear these negative amounts on the AR Aging Report? Please see attached.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
Thank you, I understand. My problem is how to correct these transaction.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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
- Select + New.
- Select Receive payment or Receive invoice payment.
- Select the customer, then the credit and the invoice.
- Select Save and New or Save and Close.
Apply the credit to a new invoice
- Select + New.
- Select Invoice or Send Invoice.
- Create the invoice.
- Select + New. Then select Receive payment or Receive invoice payment.
- Select the credit and then Save and New or Save and Close.
After doing these, check the A/R Aging Report to see if there are changes.
Let me know if you have other questions.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
Thank you for providing the solution. Appreciate your help
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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:
- Go to Banking and select the Banking tab.
- Click Find other records button.
- In the Match Transactions window, put a check mark on the transactions that should match to the downloaded transaction.
- If the transaction you want to match is outside the date range displayed, update it. Select the date field to manually change the From and To dates.
- Select Save if the total amount of both transactions is the same.
- Click Save.
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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.
- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
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:
- Sign in to your QuickBooks Online (QBO) account.
- Click on Reports at the left pane, then look for Balance Sheet or Balance Sheet Detail.
- Open the report, the go to the Customize button to get the customization you need.
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!