Skip to main content
D
dairydetippe
May 31, 2021
Question

Matching one bank transaction to multiple quickbooks entries?

  • May 31, 2021
  • 1 reply
  • 0 views

Hi there,

I pay my employees with etransfer, for which I have to pay a $1.00 service fee.  In order to make this work in quickbooks, I'd like to be able to match one downloaded bank transaction with multiple entries in quickbooks desktop.  For example:

 

Employee A gets paid $298.95 and we pay $1.00 for the e-transfer so the downloaded banking transaction shows up as $299.95.  I have created two entries in quickbooks, one cheque for the employee's salary ($298.95) and one cheque for the service fee ($1.00).  Now, when I download my banking transactions and go to my bank feeds center to match the transaction, is there a way to match the banking transaction of $299.95 with the two QB entries for $298.95 and $1.00?  

 

Thanks in advance. 

1 reply

MichelleBh
MichelleBh
June 1, 2021

Yes, there's a way to match various transactions, @dairydetippe.

 

Thank you for providing detailed concerns in the Community. I've got just the steps on how to match your bank transaction to multiple entries in QuickBooks Desktop. 

 

Make sure that you're using Classic or Express mode before following the steps below. These modes use the Register or Transaction List window to add or match transactions. Also, you can control when aliases are created. This way, you can match your multiple entries seamlessly.  

 

Here's how to check: 

 

  1. Go to the Edit menu, select Preferences.
  2. Choose Checking then pick the Company Preferences tab.
  3. Review the Bank Feeds section and taps OK. 

 

To know more about different modes, visit this page: Switch between banking modes.

 

After that, you can now proceed in matching the transactions. Follow the steps outlined below. 

 

  1. Go to the Banking menu. 
  2. Select Bank Feed and pick Bank Feeds Center.
  3. Open the Match Transactions window and from the Financial Institution dropdown, pick the correct bank account. 
  4. Select the transaction in the $298.95 and $1 to match it. 
  5. Click Match.

 

For the complete instructions, visit this article: Add and match Bank Feed transactions in QuickBooks Desktop.

 

Moreover, for you to be guided correctly in handling your various transactions, I'd recommend reaching out to your accountant. This way, your books will accurate and precise. 

 

Additionally, feel easy to examine these articles about how to fix some banking issues and handling paychecks in QuickBooks. 

 

 

Should you need anything else, please don't hesitate to leave a comment below. My door is always open to you. Keep safe always. 

D
dairydetippeAuthor
June 1, 2021

Hi @MichelleBh ,

 

Thanks for the amazing reply!  So helpful.  But I have one problem.  When I go to change my banking mode in Preferences, I have no options in there.  I'm attaching a screen shot to show you what I do see.  Without this ability, I can't follow the rest of the instructions.  I'm really hoping you know how to fix this or what the problem might be, because I was so excited at the possibility!!  

 

Nicole

    MJoy_D
    MJoy_D
    June 2, 2021

    It's our pleasure to help, @dairydetippe.

     

    I'm here to help you with switching your banking mode. 

     

    Before switching the bank feeds modes, make sure to have the latest release of your QuickBooks Desktop to always have the latest features and fixes. To check the latest available release for your version and on how to set up automatic updates, refer to this article: Update QuickBooks Desktop to the latest release.

     

    Then, make sure that you're in a single-user mode. You can go to the File menu and click on Switch to Single-user Mode.

     

    Once you're done, turn off that Payee aliasing option. Then, click on OK. You can now switch your bank feeds mode. 

     

    Check out this article for detailed guidance on switching your bank feeds modes: Switch between banking modes.

     

    This article also tells you more about what you can do between single or multi-user mode: Features available and tasks you can perform in single or multi-user mode.

     

    Please leave a reply below if you have any other questions or concerns with your bank feeds and or anything else. I'll be here to help. Have a great day!

    Terms & ConditionsAccessibility statement