cancel
Showing results for 
Search instead for 
Did you mean: 
LAGC
Level 1

How to match two downloaded transactions to one credit carge

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
Best answer December 26, 2018

Best Answers
Anonymous
Not applicable

How to match two downloaded transactions to one credit carge

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:

  1. Choose Banking.
  2. Select Bank Feeds then Bank Feeds Center.
  3. In the Items Reviewed section, select the name of the account with the transactions you wish to remove.
  4. Choose the Select Items to Delete button.
  5. Select the transaction(s) you wish to delete.
  6. Select the Delete Selected button.
  7. Confirm deleting the transaction(s) by selecting Yes

Let us know if you have any questions. Thanks! 

View solution in original post

32 Comments 32
Anonymous
Not applicable

How to match two downloaded transactions to one credit carge

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:

  1. Choose Banking.
  2. Select Bank Feeds then Bank Feeds Center.
  3. In the Items Reviewed section, select the name of the account with the transactions you wish to remove.
  4. Choose the Select Items to Delete button.
  5. Select the transaction(s) you wish to delete.
  6. Select the Delete Selected button.
  7. Confirm deleting the transaction(s) by selecting Yes

Let us know if you have any questions. Thanks! 

LAGC
Level 1

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.

Anonymous
Not applicable

How to match two downloaded transactions to one credit carge

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. 

Anonymous
Not applicable

How to match two downloaded transactions to one credit carge

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

IamjuViel
QuickBooks Team

How to match two downloaded transactions to one credit carge

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.

Anonymous
Not applicable

How to match two downloaded transactions to one credit carge

@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.

Anonymous
Not applicable

How to match two downloaded transactions to one credit carge

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

  1. Select Banking from the navigation panel.

  2. On the Banking page, click the For Review tab.

  3. Select the checkboxes of the transactions to exclude.
  4. From the Batch actions drop-down, choose Exclude Selected.

Step 2: Manually update the expense status

  1. Click Accounting from the left navigation panel.

  2. Select Chart of Accounts.

  3. Look for the account where the expense is added, and click View register.

  4. Find the transaction that needs to be cleared.

  5. To highlight, click on the transaction.

  6. Click on the top line of the transaction in the field between the Deposit and Payment amount.

  7. You can continually click on the status field to get the cleared status (C it is cleared).

  8. 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:

  1. Go to the Gear icon.
  2. Choose Feedback from the drop-down.
  3. Enter your Comments, Suggestions or Feedbacks.
  4. Choose Next.
  5. Select a category.
  6. Click Send message.

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!

windsor
Level 1

How to match two downloaded transactions to one credit carge

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.

qbteachmt
Level 15

How to match two downloaded transactions to one credit carge

@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.

Mavilan
Level 2

How to match two downloaded transactions to one credit carge

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

Angelyn_T
QuickBooks Team

How to match two downloaded transactions to one credit carge

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.

b11.PNG

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.

Mavilan
Level 2

How to match two downloaded transactions to one credit carge

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,

Mavilan
Level 2

How to match two downloaded transactions to one credit carge

Hi Angelyn,

 

I don't have the Transaction List option either. Thanks

Anonymous
Not applicable

How to match two downloaded transactions to one credit carge

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. 

bohemianworksllc
Level 2

How to match two downloaded transactions to one credit carge

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.

Skylight
Level 1

How to match two downloaded transactions to one credit carge

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.

Charies_M
Moderator

How to match two downloaded transactions to one credit carge

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.

fixingmybooks
Level 1

How to match two downloaded transactions to one credit carge

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.  

AndyMigs
Level 1

How to match two downloaded transactions to one credit carge

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.  

premiumhobbies
Level 1

How to match two downloaded transactions to one credit carge

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.

premiumhobbies
Level 1

How to match two downloaded transactions to one credit carge

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.

ChristieAnn
QuickBooks Team

How to match two downloaded transactions to one credit carge

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!

keithsigg
Level 1

How to match two downloaded transactions to one credit carge

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"

mlatzel
Level 2

How to match two downloaded transactions to one credit carge

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.


 

Need to get in touch?

Contact us