Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I entered a restaurant receipt as one credit card charge and billed it to a customer. Then when I went to match transactions on my bank feeds, I found that the tip and meal were charged separately to my credit card. Is there a way to match two downloaded transactions to one existing transaction?
Solved! Go to Solution.
Hello LAGC,
In QuickBooks, we can match a bank transaction to multiple recorded entries. On the other way around, matching multiple bank transactions to an entry isn't possible.
You'll have to exclude both transactions and manually reconcile the entry from your register.
To exclude/delete:
Let us know if you have any questions. Thanks!
Hello LAGC,
In QuickBooks, we can match a bank transaction to multiple recorded entries. On the other way around, matching multiple bank transactions to an entry isn't possible.
You'll have to exclude both transactions and manually reconcile the entry from your register.
To exclude/delete:
Let us know if you have any questions. Thanks!
Thanks for the response. I was afraid that was the case. As I've already billed the charge to a customer, I'm left with no clean/easy way to fix this. If I divide it into two transactions, I'll have to go back through the invoice etc. If I ignore the bank transactions, I'll have unmatched transactions sitting there forever.
Thanks for your prompt reply, LAGC.
Yeah, you're right. For now, manual reconciliation is the applicable solution for this kind of situation. What I can do for you right now is to send your feedback to our developers.
Let me know if you need more assistance. We are here for you.
I have a similar situation. I have one QB Expense transaction having 4 different expense items. These are 4 transactions in the Credit card. I cannot match one QB transaction to 4 different bank transactions. I would be curious to know if you have a solution developed by the developers
Let me help you sort this out, @Anonymous.
Matching your multiple expense transactions with your downloaded credit card transactions is my priority.
To start with, there are different reasons your transactions won't match automatically.
Here's how to match multiple transactions with your downloaded bank transactions:
That's it! Stay in touch with me and let me know how it works on your end. I 'm always here to help you in matching your transactions with your bank records.
@IamjuViel, I have only 1 expense transaction and 4 credit card transactions in Bank Register. I understand that you can match 1 bank transaction to multiple expense transactions.
Adding more details would mean I am adding another 4 more Expense entries in QB.. Right? That would be duplicate entries.
Let me know if my understanding is incorrect.
Also, I am using QB online.
Hi there, Davvyboy,
Thanks for getting back to us and sharing additional information about your concern. I can add some more information about matching transactions in QBO.
At the moment, matching an expense to multiple downloaded bank transactions is currently not an option in QuickBooks Online. However, I have outlined a workaround for you to get your work done.
You can exclude the online banking transactions in the Banking page, and manually clear the expense in the register. This way, the total amount that's cleared in your bank matches with what's in QuickBooks. Let me guide you through the steps:
Step 1: Exclude online banking transactions
Select Banking from the navigation panel.
On the Banking page, click the For Review tab.
Step 2: Manually update the expense status
Click Accounting from the left navigation panel.
Select Chart of Accounts.
Look for the account where the expense is added, and click View register.
Find the transaction that needs to be cleared.
To highlight, click on the transaction.
Click on the top line of the transaction in the field between the Deposit and Payment amount.
You can continually click on the status field to get the cleared status (C it is cleared).
Click Save.
That should do it, Davvyboy. While the option you're requesting is unavailable, I'd recommend sending this preference to our engineers. Your suggestion helps them understand where we can improve and what features should be added so we can better serve you. You can follow the steps below for them to account your request:
I'll do the same thing on my end to reinforce your request. Please feel free to notify me if you have any more concerns with QuickBooks. I'll be your happy guide. Have a great day!
I have this same problem and would appreciate the QB developers coming up with a better solution. My payroll transactions download from my payroll processor into 1 QB entry, then the payments download as separate transaction lines for direct deposit, insurance, and hand-written checks. There's no way I've found to be able to add up the multiple bank transaction to match them to the one payroll entry.
You want to do what matches your reality. You stated the real banking entries clear on different Dates.
You either Change the entry from the payroll provider to break it out by individual Check amounts, which in a JE is "Credit Bank" lines. Or, run the original Bulk Value into a Bank Clearing account and the it starts to be offset as the Real Banking events are entered. For any one paydate, then, the Clearing Bank ends at 0.
That way, the paydate data creates one entry from the Clearing Bank. That shows as negative balance. Then, as the Real Banking arrives, you would show it is "expense to" the Payroll Clearing Bank, which acts as a transfer or deposit to Clearing Bank. These are not the date of payroll expenses; these are Banking events.
Hi,
I do have QB Desktop Pro 2017 and on this version, I don't have that "Items Review" section that is mentioned. Any other option to eliminate those two bank transactions.
thank you,
Mariale
I'm here to show you the steps on how to eliminate/remove downloaded bank transactions in QuickBooks Desktop (QBDT) Pro, @Mavilan.
If you wish to eliminate/remove the downloaded bank transactions, you can simply ignore them. Here's how:
Once completed, the transactions will now be removed on the list.
To learn more about the online banking features in QBDT, you can check this article: Get started with Bank Feeds for QuickBooks Desktop.
Keep posted if you have any other banking concerns. I'll be happy to help.
Thank you so much Angelyn for your prompt response. I don't have that option to review bank transactions on QB Desktop Pro 2017. Is there any other way? thanks,
Hi Angelyn,
I don't have the Transaction List option either. Thanks
Hi Mavilan,
The Transaction List button is available when there are already downloaded bank transactions. Below is a sample screenshot to show you its location.
Then, the Transaction List window pop-ups similar to the screenshot above. It lists all pending bank transactions waiting to get reviewed.
If you can't see this button, click on the Download Transactions button instead. It lets you download transactions from the bank. From there, you can start categorizing them.
In case there are no bank transactions, you can download them manually. Here's a reference for you for the detailed steps to follow: Import web connect (.qbo) files.
I'm happy to help you show where the Transaction List button is. Please let us know if you've got any questions.
With all due respect, it is asinine that we pay you monthly what we do and we can't do a simple function like matching two bank transactions with one expense without doing a bunch of manual work.
Add to which, I believe they have "Uber"ized their customer support, as both customer support reps I spoke to today were obviously working from home and posessed absolutely zero special knowledge about QB. We are basically on our own here, folks.
Hello there, Skylight.
I'm taking note of the feedback regarding your experience with phone support. Sharing this with us is very important so we'll know how we can make the service even better.
Now that you’re in the Community, I’ll make sure to do everything to help you out. Can you tell me more about your concern?
In the meantime, let me leave you with the following resources to be more familiar with QuickBooks Desktop or if you have QuickBooks related questions:
You can always find me here if you have other questions. Wishing you a good one.
I couldn't agree more. I am dealing with this exact same issue. The phone support staff recommended that I change the amount on my expense and then delete the unmatchable transactions -- so I am having to artificially make my books inaccurate for no other reason than to work around the inadequacies of this software.
This happens often when I place an online order and am charged or each item separately when they ship. The low tech method I use is to simply make multiple copies of the receipt, one for each CC transaction. Then I change the total on each receipt to match each transaction, and then pair them up. Its ridiculous but it seems to work until the QBO team get their act together.
I am frustrated that I cant simply add multiple bank transactions to one receipt.
I would have thought it would be a common issue many people have, more than one bank transaction to a single invoice.
Please quickbooks people, make this a possible function, it should not be difficult to allow more than one payment to a single receipt.
Hi Quickbooks people
I thought it was me being daft, as I thought putting more than one bank transaction to a single receipt/invoice would have been a standard feature.
It must be a common issue for users to need to do this, having to make multiple copies up is just not the way it should be done, but it is the only way I have been able to do it like the previous user comment.
Please quickbooks, it cant be that difficult to make this work correctly.
Hi there, premiumhobbies.
We want to make sure all of our customer's concerns are resolved as soon as possible, and this is not the kind of experience I want you to feel while using QuickBooks Desktop. I can see how the feature of putting more than one bank transaction to a single receipt/invoice would be helpful for you and your business.
QuickBooks is constantly changing and evolving based largely on the suggestions and requests of users, like yourself. Since the said option is currently unavailable, I'll take note of your suggestion as it helps our engineers determine what features to be added in QBDT future enhancements.
I suggest visiting our QuickBooks Firm of the Future blog to know about the latest news and updates from QuickBooks Desktop.
Please feel free to notify me if you have any more concerns with QuickBooks. I'll always here to help. Have a great day!
QB team, We have a very similar issue. We need to match multiple bank deposits to Customer payments. QBO only allows me to do it the other way and match multiple customer payments to a bank deposit.
We have tenants that pay in cash.
With Covid the bank only allows ATM deposits. The ATM limits the deposits to a specific number of cash bills, so we end up with multiple bank deposits that don't individually match with our tenants rent payment.
without a lot of corporate double speak can you please either explain to us paying QBO customers why this isn't possible or tell us when it will be done?
Please spare us empty responses like "your feedback is really important to our team for determining future product updates"
Hi LAGC (and Team Inuit),
here is a way to get around the issue of not being able match two bank transactions to a single QB transactions. I had the same issue with a bank deposit which was recorded properly in QB, but at the bank (due to other reasons) split into two separate transactions. Brining the two together and matching with the single Bank Deposit was impossible at first, except for this workaround:
1. Say the intended deposit was 2,000 and split into 1,200 and 800 at the bank.
2. Goal is to match the two bank transactions to the 2,000 deposit
3. Edit the deposit, "pretend" that a cash-back occurred, of 800. Choose another account, e.g. the Petty Cash account, as the "cash goes to" account. The deposit total amount is now 1,200.
4. Create a 2nd "deposit" for the balance of 800, from the Petty Cash account to the bank account
5. Go back to Banking > For Review
6. Both transactions should now be matchable to the two deposits.
I am assuming a similar "cash detour" will also work with split Credit Charges.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here