Skip to main content
E
Estherallpipe
February 17, 2021
Question

Multiple bills match one bank transaction

  • February 17, 2021
  • 1 reply
  • 0 views

My suppliers send me a single statement at the end of the month.  The single statement contains all the individual invoices for that month.  I create multiple bills for each invoice but pay the statement amount in one. 

how can I link the multiple bills to my single bank transaction when it is paid?

1 reply

M
mv32
February 17, 2021

Hi there, @Estherallpipe.

 

When you pay a supplier in a lump sum, here's how you can match the bank transaction in QuickBooks Online:

 

  1. Select the transaction row that you know represents multiple QuickBooks transactions to view the details.
  2. If the transaction has a match, select Find other records. If the transaction does not have a match, select Find match.
  3. In the Match Transactions window, put a checkmark on the transactions that should be matched to the downloaded transaction.
  4. Be sure the total amount matches the downloaded amount:
    *If the total amount matches the downloaded amount, that's good. No further action needed.
    *If the total amount is more than the downloaded amount, remove some matches until the difference is 0. Or, adjust the QuickBooks transaction amounts and then try matching again.
    *If the total amount is less than the downloaded amount, select more matches, adjust the QuickBooks transaction amounts, or enter a new QuickBooks transaction to handle the remaining amount and then try matching again.
  5. Select Save.

 

For additional about matching transactions, you can refer to this article: Categorise and match online bank transactions in QuickBooks Online. This provides details on how to review transactions after you download them to avoid double entries.

 

You can also unmatch transactions to match them with the right transaction in QuickBooks Online.

 

I'll be here if you have additional concerns about matching transactions. Wishing you all the best!

C
crossbat
January 3, 2022

Hello, this might match the bank transaction to the bills, but once matched, they seem to split up into multiple payment without any linkage.  I've asked your support agents and they say that's the way it works.  So please advise if I have it wrong

Rubielyn_J
Rubielyn_J
January 4, 2022

Thanks for joining this thread, @crossbat. 

 

Yes, that's right that when you match the transactions to the bill, they will be split into multiple payments without any linkage. 

 

To further understand the process, please utilize this article:  Categorise and match bank transactions in QuickBooks Online.

 

In addition to that, let me share this resource to help you track bills and record the payments: Enter bills and record bill payments.

 

Please know that you can always get back here if you have further questions about handling invoice payments in QuickBooks. I've got your back always. Have a good one.

Terms & ConditionsAccessibility statement