cancel
Showing results for 
Search instead for 
Did you mean: 
dairydetippe
Level 3

Matching one bank transaction to multiple quickbooks entries?

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. 

5 Comments 5
MichelleBh
Moderator

Matching one bank transaction to multiple quickbooks entries?

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. 

dairydetippe
Level 3

Matching one bank transaction to multiple quickbooks entries?

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
Moderator

Matching one bank transaction to multiple quickbooks entries?

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!

TrumanThomp
Level 1

Matching one bank transaction to multiple quickbooks entries?

Hello,

 

I have the same issue but after turning of payee aliasing and clicking ok then returning to preferences no further bank feed options pop up. I am on the latest QB release for 2021 as far as I know. 

ReymondO
QuickBooks Team

Matching one bank transaction to multiple quickbooks entries?

Good day, @TrumanThomp.

 

Thank you for joining the thread and following the steps that were shared above.

 

There are three Bank Feed modes available in QuickBooks Desktop. Each of them displays and handles transactions in your Bank Feeds separately. 

 

After updating the QuickBooks to its latest release and making sure that you're using a single-user mode, switching banking modes should reflect in your Preferences. If you're unable to find it, follow these steps:

 

  1. From the QuickBooks Edit menu, select Preferences.
  2. On the left pane, choose Checking then go to the Company Preferences tab.
  3. In the Bank Feeds section, choose either
    • Advanced Mode: This uses the Transactions List window to add or match transactions. You can quickly update transactions for future matches or create rules to automatically recognize and match transactions to your books.
    • Express Mode: This uses the Transactions List window to add or match transactions. Renaming rules are created automatically.
    • Classic Mode: This uses the account register to add or match transactions. Aliases match names exactly and you control when aliases are created.
  4. Click OK.

 

If you're still unable to see these options, run the verify and rebuild data tools. These tools can identify and fix the most commonly known data issues within a company file.

 

Once you're able to successfully switch modes, you can now proceed in matching the transactions.

 

Should you have any follow-up banking questions or concerns, don't hesitate to post again here in the Community or leave a comment on this thread. Take care and have a good one.
 

Need to get in touch?

Contact us