cancel
Showing results for 
Search instead for 
Did you mean: 
TOBOOKS
Level 2

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

I am trying to match multiple transactions to a single Amazon receipt which has a separate total for each order. For example, if I buy 5 items, the email receipt will show 5 different totals for each order. Then I will have 5 different credit card transactions but only one receipt. And QBO seems not to be able to match multiple transactions to one receipt. Is there a way to reconcile this situation? I tried totaling them myself and logging the receipts as expenses, but this messed my books up, as now these expenses are logged twice, once as unmatched bank transaction expenses and then as unmatched receipt expenses. I appreciate your help.
Solved
Best answer January 06, 2021

Best Answers
IamjuViel
QuickBooks Team

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

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:

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

View solution in original post

11 Comments 11
IamjuViel
QuickBooks Team

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

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:

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

TOBOOKS
Level 2

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!

TOBOOKS
Level 2

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

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

EmilyBecker
Level 1

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


@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:

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.

JAK-TSD
Level 3

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

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 

LeizylM
QuickBooks Team

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

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. 

 

 

 

chittermorree
Level 2

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

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.

GebelAlainaM
QuickBooks Team

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

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!

chittermorree
Level 2

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

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.

 

 

FritzF
Moderator

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

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.

Mike_CMP
Level 2

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

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.

Need to get in touch?

Contact us