Matching bank transactions with multiple expenses

DSRoberts · ‎March 24, 2023

Is there an option to "select all" when matching expense transactions in the bank review? For example - if I have an ACH payment that includes 400 expense (vendors) transactions, clicking every single one of those boxes is very time consuming and tedious. Thanks! DRoberts

Angelyn_T · ‎March 24, 2023

My pleasure to have you here today, @DSRoberts. I'm here to share information about matching bank transactions with multiple expenses in QuickBooks Online (QBO).

The system allows you to match available transactions from the Match transactions window by picking them manually. Getting the Select All option is not yet available for now. I can see how beneficial this feature is for your business to save time from clicking every single transaction by hand. While it's not supported, I recommend sending a feature request directly to our product developers. This way, they can determine what enhancements and improvements are needed to make our product more effective and convenient for our users.

Here's how:

Go to the Gear icon, then Feedback.
Enter your comments or product suggestions.
Tap Next to submit.

Once done, your valuable feedback goes to our Product Development team to help improve your QBO experience. You can track feature requests through the QuickBooks Online Feature Requests website.

For more hints while categorizing your bank data in our system, you can open this article: Categorize and match online bank transactions in QuickBooks Online.

On the other hand, you may also use bank rules to speed up the review process. I'm adding this material as your guide: Set up bank rules to categorize online banking transactions in QuickBooks Online.

Thank you for adding your first post to our forum. If you have follow-up questions, please feel free to post again or leave a comment below. I'm just a few clicks away to help you again. Have a good one!

View solution in original post

Angelyn_T · ‎March 24, 2023

My pleasure to have you here today, @DSRoberts. I'm here to share information about matching bank transactions with multiple expenses in QuickBooks Online (QBO).

The system allows you to match available transactions from the Match transactions window by picking them manually. Getting the Select All option is not yet available for now. I can see how beneficial this feature is for your business to save time from clicking every single transaction by hand. While it's not supported, I recommend sending a feature request directly to our product developers. This way, they can determine what enhancements and improvements are needed to make our product more effective and convenient for our users.

Here's how:

Go to the Gear icon, then Feedback.
Enter your comments or product suggestions.
Tap Next to submit.

Once done, your valuable feedback goes to our Product Development team to help improve your QBO experience. You can track feature requests through the QuickBooks Online Feature Requests website.

For more hints while categorizing your bank data in our system, you can open this article: Categorize and match online bank transactions in QuickBooks Online.

On the other hand, you may also use bank rules to speed up the review process. I'm adding this material as your guide: Set up bank rules to categorize online banking transactions in QuickBooks Online.

Thank you for adding your first post to our forum. If you have follow-up questions, please feel free to post again or leave a comment below. I'm just a few clicks away to help you again. Have a good one!

Anonymous · ‎July 01, 2024

So I see it's been over 3 years since first reported. Why is this simple improvement for select all in EFT and other multiple transactions is not in yet???

DSRoberts · ‎July 01, 2024

I also send a screenshot EVERY month asking for the select all in Feedback. Like you said, simple improvement smh

Anonymous · ‎July 01, 2024

It only makes sense I was stunned not to see the check off all button when first started using QBO.

However, I think for EFT/ACH purposes makes more sense to pay through a made up account (say ACH Payments), then transfer from there amount you sent as ACH/EFT, and that way you only match to one transaction.

ACH Payments account you do reconciliation which is fast and easy.

ML55 · ‎October 07, 2024

I am trying to match bank feed transactions with multiply expenses, QBO pulls only unpaid bills, while filter setup to pull all. When I change filter setting to expenses, it shows no transactions to match. The expenses that I need to match have not been matched previously. What causes it and how to fix it? I have had this issue for on-going basis. It is annoying to go and combined several expenses in one to match bank feed.

SashaMC · ‎October 07, 2024

Hello ML55,

Thank you for reaching out to the QuickBooks Community! I will be happy to help. Could you share with me how you recorded those transactions in QuickBooks? That would help tremendously as we assist you further!

Looking forward to your reply! See you soon.

ML55 · ‎October 08, 2024

I record the expenses by entering manually thru expense sub-menu in vendors menu of Q.B.O.. They are not feed automatically. I am not sure why this question arise. Q.B.O. match other expenses where amount is the same with bank feed and fails to match if amounts differ. There is not such issue with matching deposits. If amount does not match, I can do adjustments to match. It is not the case with expenses, because the software does not pull any expenses to choose and match..

Candice C · ‎October 08, 2024

Hey there, @ML55.

Thanks for coming back on this thread.

With the details you gave, I recommend contacting our Customer Support Team for some further assistance. Here's how:

Go to the Help ? icon in the top-right hand corner.
Press the Contact Us button.
Enter your question and hit Let's talk.
Scroll down and choose to Get a callback.

Please let us know how the call goes. Have a great day!

ML55 · ‎October 08, 2024

I had spent more than hour online with Q.B.O. tech support to figure out the cause of the issue. Currently, we have few credit cards that used in the field. The expenses are posted to each card GL account that are sub-accounts of CC main control account. All transactions rolled from each card to control account at the bank and feed to QB. QB matches practically all CC expenses posted to sub-accounts if amount of transaction match bank feed. In case of multi expenses or with different amount of expense, QB does not pull the expenses that posted into sub-accounts. In order to match, we have to re-post those expenses to control account. It is a big glitch in QB software that creates extra work by users and does not allow to post expenses against proper card and subsequently employee. Tech support promised to address this glitch to software developers. Will see how it will be taking care and when.

Topics

Training

Community

Resources

Matching bank transactions with multiple expenses