cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
useriphay
Level 1

If I have 2 banking payments associated with 1 expense. How do I get this to match?

 
5 REPLIES 5
Bryan_M
QuickBooks Team

If I have 2 banking payments associated with 1 expense. How do I get this to match?

Hi, @useriphay.

 

To clear things out, you can only match a single bank transaction with multiple expenses, not the other way around. 

 

In the meantime, you can create individual expenses for each transaction. Moreover, I'll also recommend excluding individual credit card transactions from the feed.

 

Here's how to exclude credit card transactions:

 

  1. Route to the Banking page and then choose your bank account.
  2. Check the bank transactions.
  3. Tap the Exclude button.

 

And to manually clear expense transactions, you can follow the steps below:

 

  1. To the Chart of Accounts, look for the bank account, then click Account history.
  2. Find and click the expense.
  3. Tao the "Check mark" column until a "C" appears.
  4. Click the Save icon once done.

 

For future reference, if you want to learn to reconcile your bank statement, feel free to read through this article: Reconcile an account in QuickBooks Online.

 

The Community always welcomes you whenever you need help managing your bank transactions. Keep safe and have a blissful week!

Bodilninnimaria
Level 1

If I have 2 banking payments associated with 1 expense. How do I get this to match?

Hello hello,

 

Surely there must be a function where we can match several payments to one receipt ? 

 

In construction the : deposit - part payment - final payment on one receipt is standard practise!

 

Or do I have to manually "make up" two more receipt for the other two payments?

 

Best,

 

Ninni

Archie_B
QuickBooks Team

If I have 2 banking payments associated with 1 expense. How do I get this to match?

Hello there, Bodilninnimaria.

 

To clarify, is the one receipt you mentioned a supplier transaction or a customer transaction? Could you also send me a screenshot of the transaction you're attempting to match with multiple payments in QuickBooks?

 

This will allow me to provide specific steps or relevant information that will help us address your concern.

 

In the meantime, you can check out this link to learn the difference and how to handle supplier transactions: Learn the difference between bills, cheques, and expenses in QuickBooks Online.

 

I've also added this article in case you need a complete guide in reviewing, adding, and matching transactions: Categorise online bank transactions in QuickBooks Online.

 

Feel free to add a few details by leaving a comment below. I'll also make sure to check on your response and get back to you as soon as possible. Have a wonderful day!

Bodilninnimaria
Level 1

If I have 2 banking payments associated with 1 expense. How do I get this to match?

Hello Archie,

 

Thank you for replying!

 

The invoice is from a supplier "Falcon Roofing" total amount £4092, I paid £1650 up front to get the works started, then £1290 after 50% was completed, then the final £1152 after it was all done. 

 

I split the "Receipt (receipt capture)" in 3 parts as per above thinking that I could match the three different banking transactions to the three splits, but the "matching" function only allows me to tick ONE split.

 

Surely it is not unusual to have an invoice / expense  paid in several parts ? Certainly it is very common when using contractors carrying out works in contstruction ..... btw I am a landlady for context !

 

Best,

 

Ninni

MirriamM
Moderator

If I have 2 banking payments associated with 1 expense. How do I get this to match?

Hi, Ninni. Let me step in to address your concern about matching multiple payments to a single receipt.

 

Currently, QuickBooks Online (QBO) doesn't allow you to match a receipt with multiple splits in one go, as you can only select a single split. As a workaround, you can attach the receipt to each individual downloaded payment transaction to keep track of all related receipts. Here's how you can add attachments to bank transactions in the For Review tab on the Banking page:

 

  1. In the left menu, choose Transactions and go to the Bank transactions tab.
  2. From the list, select the account you’re working on.
  3. Navigate to the For review tab and click the transaction to expand the line.
  4. Click the Add attachment link to append a document (see attached screenshot).

Add attachment.png

 

For more guidance, check out this article on downloading, matching, and categorising bank feeds entries. It even includes a video tutorial to help you follow the steps easily: Categorise online bank transactions in QuickBooks Online.

 

For future reference, explore this resource on the best practices for reconciling accounts: Reconcile an account in QuickBooks Online.

 

If you need more clarification on matching transactions from your receipts or guidance navigating QuickBooks Online, please leave a comment below, Ninni. I'm always here and ready to assist you with any future questions or needs!

Need to get in touch?

Contact us