cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
dogsgrandadbrewery
Level 1

Matching multiple daily banking transactions to a monthly invoice receipt

We receive daily deposits from our POS system which includes the charges for the service, however we only receive a monthly invoice for the charges as a total.  How do I match the invoice to the transactions?

1 REPLY 1
Jovychris_A
Moderator

Matching multiple daily banking transactions to a monthly invoice receipt

I'll help you match the invoice to the transactions, @dogsgrandadbrewery.

 

Usually, we can match each downloaded transaction from online banking or POS application by pairing them to an invoice, bank deposit (may contain mixed transactions like income and expenses/charges), or expenses recorded in QuickBooks.

 

To match an online banking transaction (deposit) to a single bank deposit that contains combined transactions, you can follow these steps:

 

  1. When you receive the invoice payment in QuickBooks Online (QBO), you can account it in the Undeposited Funds before the money goes into your bank register. It will make the invoice payment appear in the Select the payments included in this deposit section when you create a bank deposit.
  2. Then create a bank deposit to combine the invoice payment and the fee/charge (create manually) that you can add in the Add funds to this deposit section of the Bank Deposit window. Make sure the fee/charges amount is in a minus (-) sign to negate the invoice payment total.
  3. This way, you're able to match the online banking transaction to the deposit entry recorded in QuickBooks.

 

However, if you're referring to match an invoice to a couple of online banking transactions, this feature isn't available at this time. Please know we're always looking forward to boosting your experience as our Product Developers work innovatively to create new features.

 

On the other hand, when you receive a monthly invoice for the total charge, you can exclude this transaction when you follow the scheme above. That said, it will be easier to record the transactions in the bank register.

 

For more details, these will be your learning sites for today's topic:

 

Furthermore, if you want to share more details or have additional questions, feel free to place a comment here. I'll get back to you shortly. Have a nice day!

Need to get in touch?

Contact us