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

Accounts Receivable does not match up with total unpaid invoices

My accounts receivable balance (when viewed on the chart of accounts page) does not match up with the total unpaid invoices amount viewed on the sales page. Why would this be different and how can I easily reconcile the two to find the discrepancies? Is it maybe because the sales page only shows the past 365 days? If so, how can I edit that to show all time?

5 Comments 5
Rubielyn_J
QuickBooks Team

Accounts Receivable does not match up with total unpaid invoices

Hello there, @Hezzy.

 

Let me clear things out for you. The possible reason that A/R isn't matching with the total unpaid invoices is that the invoice overdue is already more than 365 days.  Another reason is if you have a multi currency transaction. Multi-currency is reported on the invoice and sales page and recorded differently on A/R. 

 

Also, Journal entries affect the Chart of Accounts A/R but not the invoice page or sales page.

 

Customer Dashboards work differently than the Chart of Accounts (COA) posting. The COA will report or account the type of transactions, while the dashboard has a limitation such as what transaction type to account and date to account.

 

You can check out this article on how to run the report if you'll want to compare the COA and the dashboard: Run reports in QuickBooks Online.

 

Let me know if you have other concerns. I'd be glad to assist you as soon as I can. Have a great day.

Hezzy
Level 2

Accounts Receivable does not match up with total unpaid invoices

Thank you! Would there be a way to run the report to only show the unpaid invoices / AR balance as of the past 365 days to see if it then matches up with the dashboard figure? I am having a hard time seeing on the AR report whether or not the amounts were potentially invoiced in 2019, thank you!

JonpriL
Moderator

Accounts Receivable does not match up with total unpaid invoices

Yes, there is, @Hezzy!

 

You can pull up your Open invoices report and make sure to select Since 365 days ago under Report Period to see the list of unpaid customer's invoice. Simply go to Reports and enter Open Invoice in the Search address.

 

Lastly, here's a few articles you can read to help manage your reports and related tasks: Reports and Accounting for QuickBooks Online.

 

Keep me posted in the comments if you have any other questions. I'll be here to lend a hand.

Hezzy
Level 2

Accounts Receivable does not match up with total unpaid invoices

Thank you for this update, I ran the open invoice report showing only invoices from past 365 days. There is still a discrepancy between that total and the total invoices from the dashboard. What did you mean about the other multi-currency issue? I do not think that could apply to us but maybe I am misunderstanding what it means. Thank you!

MaryLurleenM
Moderator

Accounts Receivable does not match up with total unpaid invoices

Hello there, Hezzy,

 

You might want to check the accounting method of the report. There might be transactions not showing if they're created under a different accounting method. QuickBooks Online has the accrual and cash basis.

  • accrual basis: income and expense is yours when you save the invoice or bill
  • cash basis: income is yours when you receive it, and expense is yours when you pay the bill

Furthermore, the multi-currency mentioned by my colleague means if you have received a customer payments using a different currency, for example, instead of USD, you're paid EUR.

 

If the same error persists, I recommend contacting our QuickBooks support to check your account.

  1. Click the Help icon.
  2. Select Contact Us on the pop-up.
  3. From the How can we help? field, enter your question.
  4. Choose Continue.
  5. Choose either of the following to contact us: Get a callback or Start messaging.

You can also refer to this article for more detailed information about the support we offer at Intuit and its availability: Support hours and types.

 

I'll be right here if you have other questions.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up