Skip to main content
T
TOBOOKS
January 7, 2021
Solved

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

  • January 7, 2021
  • 2 replies
  • 0 views
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.
    Best answer by IamjuViel

    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.

    2 replies

    IamjuViel
    IamjuVielAnswer
    January 7, 2021

    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.

    T
    TOBOOKSAuthor
    January 7, 2021

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

      J
      JAK-TSD
      April 28, 2021

      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 

      L
      LeizylM
      April 28, 2021

      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-transactions-for-bulk/01/853552#M61048

       

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

       

       

       

      Terms & ConditionsAccessibility statement