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

6 Comments
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

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 1

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. 

 

 

 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us