cancel
Showing results for 
Search instead for 
Did you mean: 
junkremoval.dj@g
Level 2

Finding payments that aren't matched to online banking transactions

I use the online banking feature to make sure the payments on invoices when the $ hits my bank acc & I match them to the payments and/or deposits when they come in. This makes it so when I go into a payment, I can see a '1 online banking matches' in the corner of the payment page, and this links it directly to the bank transaction that I matched it to.

I was wondering a way to check and make sure that all my payments have a online banking transaction match. Is this maybe a report or something I can create? 

1 Comment 1
RCV
QuickBooks Team
QuickBooks Team

Finding payments that aren't matched to online banking transactions

Let me help you run the report you need to see all payments have an online banking transaction match. 

 

We can use the Check Detail Report or the Deposit Detail Report to show selected transactions and other transactions they are linked to (such as an invoice and its payment). Only the Check Detail Report and the Deposit Detail Report show links between transactions and these reports are comparable to a Cash Receipts Journal and a Cash Disbursements Journal. We can use the Check Detail Report if you need to see the paid amount on your report. The Deposit Detail Report does not have an option to add the Paid Amount column. Here's how:

 

  1. Open the Check Detail and/or Deposit Detail Reports.
  2. Click Report at the top, then Banking.
  3. Choose the desired report.
  4. Modify the Check Detail and/or Deposit Detail Report(s). These two reports have one important difference: the Check Detail Report has an additional column for Paid Amount.
  5. Once the report is open, select the Modify Report. (Mac users: select Filters.)
  6. Within the Modify Report window, select the Filters tab.
  7. Select/Edit your filters to display the transaction type for which you wish to report.
  8. Once you have finished, select OK to save your changes and return to the report.

 

You can also memorize the report for reuse:

 

  1. Click Memorize at the top of the report.
  2. In the Memorize Report window, enter a title for the report.
  3. If you want to assign the report to a Memorized Report Group, select the Save in Memorized Report Group checkbox, then an existing Report Group from the drop-down.
  4. Press OK. You can then access the saved report easily from Reports Memorized Reports.

 

 

I've also included these articles that will help you in managing reports in QuickBooks Online

 

 

Feel free to click the Reply button below if you need further assistance with your bank transactions in QuickBooks Desktop Mac. We're available 24/7. Stay safe.

Need to get in touch?

Contact us