cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Frequent Explorer *

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 12-26-2018

Accepted Solutions
Moderator

Re: 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! 

14 Comments
Moderator

Re: 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! 

Frequent Explorer *

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

Moderator

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

Frequent Contributor *

Re: 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

QuickBooks Team

Re: How to match two downloaded transactions to one credit carge

Let me help you sort this out, @Davvyboy.

 

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.

Frequent Contributor *

Re: How to match two downloaded transactions to one credit carge

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

QuickBooks Team

Re: 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!

Not applicable

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

Established Community Backer ***

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

Not applicable

Re: 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

QuickBooks Team

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

Not applicable

Re: 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,

Not applicable

Re: How to match two downloaded transactions to one credit carge

Hi Angelyn,

 

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

Moderator

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

Need to get in touch?

Contact us