Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowMy 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?
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.
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!
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.
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!
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.
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.
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.
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.