cancel
Showing results for 
Search instead for 
Did you mean: 
jay87
Level 3

Paid vs. Deposited Reports

QBO 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." 

2 Comments 2
LouiseG
QuickBooks Team

Paid vs. Deposited Reports

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:
 

  1. Go to reports.
  2. Use the Find report by name box to search for either one of the reports mentioned.
  3. Click Print or Export icon.
  4. Do the same for the other report.

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.

jay87
Level 3

Paid vs. Deposited Reports

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

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us