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 nowQBO will often show invoices for as "paid" and/or "deposited" when in actually they have not been deposited in our bank. Luckily, some customers' accountants have noticed this and contacted us to re-run the payment and collect the funds.
Is there a report we can run to verify invoice "payments" have actually been "deposited" each week?
I see there is a "Invoices and Received Payments" report, but it will show that an invoice has been "paid" when it actually has not been "deposited."
Comparing the data for deposited and paid invoices ensures that your bank balances are accurate and correct. I'll share some details and how we can compare this, jay87.
There isn't a built-in report to verify what was paid and what was deposited. Though, we can use two reports and compare the data by exporting them to Excel. We can use Deposit Detail, then Invoices and Received Payments reports.
Here's how to pull it up and export them:
In addition to this, I would like to share an article that will guide you in making the most out of your financial reports: Customize reports in QuickBooks Online.
Keep me posted if have other concerns aside from reports. I'll respond to you as soon as I can.
Thanks, but that seems far more work than what I'm already doing to verify payments/deposits. I'll stick to hacking my way through it until QBO comes up with a feature to design your own reports some day
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.