How to match two downloaded transactions to one credit carge

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.

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.

• The transactions brand new.
• Details of the recorded transactions in QuickBooks are different from the downloaded ones.
• It's already reconcile.
• Duplicate transactions.

Here's how to match multiple transactions with your downloaded bank transactions:

1. Go to Banking.
2. Click Use Register.
3. Choose the specific Bank account where the downloaded transaction is recorded.
4. Select the specific downloaded bank transaction.
5. Put a check mark on the transaction you want to match.
6. Choose Add More Details from the Action drop-down.

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.

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.

@windsor

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:

1. On the QuickBooks homepage, go to the Banking menu.
2. Select Bank Feeds.
3. Click on Bank Feeds Center.
4. Look for you bank account and go to the Transaction List.
5. On the Transaction List page, look for the transactions (put a check-mark).
6. Go to the Action column.
7. Select Ignore.
8. Click on Yes to confirm the deletion of the transaction.

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

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:

• QuickBooks Resource Center.
• Help Articles.
• QBDT Self-help.​

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.