Is there a way to match multiple bank transactions to a single receipt which does not have a subtotal?

Thank you for your reply @IamjuViel . I will try this out and report back if there are any troubles!

Thank you @IamjuViel . I will try this out and report back if I have more questions.

---

@IamjuViel wrote:

I appreciate the complete details you've shared, @TOBOOKS.

 

Currently, uploading your amazon receipt and automatically matching it to multiple downloaded transactions is not available. However, you can attach the receipt to your downloaded bank transactions. I can guide you on how to do it.

1. Go to the Banking menu.
2. Choose the Banking tab.
3. Select the bank account where the transactions were downloaded.
4. Pick the For Review tab.
5. Locate the downloaded Amazon transaction.
6. Expand it to add more details.
7. Click the Add Attachment link.
8. Search the saved receipt from your computer or device, and click Open. 
9. Click the Add button.

You may check this article for additional information about attachments in QuickBooks: Attachments in QuickBooks Online.

 

Also, I'm adding these articles that you can use as reference in reviewing and categorizing your bank transactions:

• Categorize and match online bank transactions in QuickBooks Online
• Setup bank rules to categorize online banking transactions in QuickBooks Online

Stay in touch here if you have other questions about managing your bank transactions. I'm always here to help.

---

Thank you so much for helping with this wonderful article.

I am using Quickbooks for Mac 2019 Desktop. I want to match multiple transactions from the same vendor when they differ by only an order ID- how can I do these in a batch and not one by one? I have hundreds and it will take me a week to them one by one. Ridiculously annoying 

Hi there, JAK-TSD. 

I can see that there are separate threads with have similar questions about matching transactions in QuickBooks Desktop for Mac. 

Let me share these links so you can follow the steps provided in this threads: https://quickbooks.intuit.com/learn-support/en-us/banking/re-how-to-select-multiple-downloaded-trans...

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success. 

This does not answer the question, so not sure how it is solved. Simply adding a receipt attachment does not solve the issue. What we have is multiple credit card transactions that need to be matched to a single invoice - and yes they add up to the same value of the invoice.

Hello there, @chittermorree. I'll be sharing more information about this matter.

I can see that matching a multiple transactions in one invoice is really useful for your situation. However, it's currently not an option in QuickBooks Online.

Although, you can either exclude the bank transactions and manually clear the payment status of the invoice in the register, or you can record each received payment and bank deposit it to each of the corresponding bank transaction to link them.

Here's how to exclude bank transaction:
 

1. Go to the For review tab.
2. Tick the checkbox for each transaction you want to exclude.
3. Select Exclude.
    

To manually clear payment status:
 

1. Select Invoices, and click View/Edit to open the invoice transaction.
2. Under Payment Status, click the 1 payment link and click on the Date hyperlink.
3. Click the More tab and choose Delete.
4. Click Yes to confirm.
    

For more details about matching and categorizing transactions, you can refer to this article: Categorize and match online bank transactions in QuickBooks Online

To learn how to combine multiple transactions into a single records QuickBooks matches your real-life bank deposits, you can check out this article: Record and make bank deposits in QuickBooks Online.

I'll be around if you need anything else or if you have any further clarifications about your bank transactions. Have a great day!

Well, this makes no sense at all.

Why would I want to exclude transactions and clear them ? The whole point of QBO is to record transactions for accounting purposes.

The instructions to match multiple transactions to an invoice are not clear. 

Please advise.

Hello there, @chittermorree.

Thanks for getting back to us. Allow me to hop in and add information about matching multiple bank transactions to an invoice in QuickBooks Online (QBO).

The two ways that were shared by my colleague above are the workarounds you can do in QBO since the option to automatically match multiple bank transactions to an invoice is currently unavailable.

I can see how having this option would be helpful for you and your business. I highly suggest sending feedback directly to our product developers. They're always looking for ideas to consider on how to improve QuickBooks.

Here's how to submit feedback:

1. In QBO, select the Gear icon at the top, then Feedback.
2. Enter your comments or product suggestions. Then click Next to submit feedback.

In case you need it, I'll add this article that tackles matching and categorizing bank transactions in QBO: Categorize and match online bank transactions in QuickBooks Online.

For more tips and other resources, you can visit our website for future reference: Self-help articles.

Please post again or leave a comment in this thread if you have additional questions about matching bank transactions or anything else. I'll be here to answer them. Take care always.

It's been two years now. QBO should have come up with a solution by now.  This is a typical problem with Amazon purchases which create multiple charges if items ship separately on an order.  I want to be able to create a single expense when the purchase is made and then match up all the payments once the order has shipped in full. Your current work around has me creating separate expenses to match each partial shipment or excluding the charges from the bank feed and manually creating the expense. QBO should make things easier not harder.

Why is this marked "solved" when it does not solve the issue?

Many vendors, not just Amazon, charge by the shipped package but present the purchaser with a single invoice. Costco does it. UPS does it when creating shipments. This is and will continue to be a PITA until it becomes possible to combine multiple bank drafts that add up to a single bill.

Doesn't have to be automatic. I think we're all fine with manual matching in this situation.

So, ladies and gents, please reconsider adding this functionality.

Thanks for following this thread, CreativePrinters.

The issue you reported has been marked as Solved because the troubleshooting steps and workaround provided have worked for some other users experiencing a similar problem.

I see the benefit of combining multiple bank transactions into one bill to streamline your business processes. You can consider sharing this feedback directly with our QuickBooks product development team.
 
They're continuously looking for ways to enhance the product based on customer needs, so sharing this suggestion could be valuable.

Here's how:

1. Go to the Gear icon at the top.
2. Select Feedback.
3. Enter your comments or product suggestions. Then select Next to submit feedback.

In addition, I'm sharing these articles to help you manage bank transactions in QuickBooks Online:

• Setup bank rules to categorize online banking transactions in QuickBooks Online
• Reconcile account.

If you have any other questions about matching bank transactions, feel free to leave a comment below. I'll be sure to get back to you with an answer.