Solved

How to match two downloaded transactions to one credit carge

Forum|Forum|7 years ago
December 26, 2018
6 replies
0 views

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?

QuickBooks Desktop

Best answer by

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:

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

Let us know if you have any questions. Thanks!

A

Anonymous

Answer

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:

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

Let us know if you have any questions. Thanks!

L

LAGCAuthor

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.

A

Anonymous

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.

A

Anonymous

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

Let me help you sort this out, @402553.

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:

Go to Banking.
Click Use Register.
Choose the specific Bank account where the downloaded transaction is recorded.
Select the specific downloaded bank transaction.
Put a check mark on the transaction you want to match.
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.

W

windsor

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

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

P

premiumhobbies

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.

C

ChristieAnn 11

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!

K

keithsigg

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"

M

mlatzel

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.

B

birdys_flying

Ditto. One invoice, exceed email money transfer amount. So sent two transfers, but can't link them to one expense

M

Mark_R

I'll help match your two transfers in QuickBooks, @birdys_flying.

QuickBooks always match the transactions from your bank statement. Since you have two transfers from your bank, you should create two expenses in QuickBooks as well. Please also know that QuickBooks only allows you to match one downloaded bank transaction into multiple transactions.

To get this sorted out, you'll want to edit the amount of expense transactions and make sure it matches the one you transfer. Then, create a new one for the other transfer. Here's how:

Go to the Vendors menu, then select Vendor Center.
Select the vendor's name from the left menu.
Find and open the expense transactions.
Edit the amount and make sure it matches the transfer.
Click Save & Close.
Then, create a new expense transaction to the other transfer.

Once done, you can now proceed on matching your two transfers to your two expenses in QuickBooks. Here's how:

Go to the Banking menu, then select Bank Feeds and choose Bank Feeds Center.
From the Financial Institution drop-down, make sure the correct bank account is showing.
Select View. Then, download and view the electronic statement.
In the Match Transactions window, make sure the Show Register checkbox is selected.
Choose the transfer in the statement that you need to match to the expense transaction.
Select the transaction in the register to match to.
Click Match.

I'm adding this article for more details: Add and match Bank Feed transactions in QuickBooks Desktop.

Should you need any additional assistance while managing your bank transactions, you can leave a comment below. I'll be sure to get back to you.

F

FCNadine

Has this issue been rectified yet?

I am finding it a complete waste of time to enter an entire bill for a 95 cents service charge on a 5000 bill just so that I can match my banking transactions. We need to be able to select 2 debits to a single bill or this has just become more work than it's worth. It's especially frustrating when you have to go back months to create separate bills just to be able to reconcile anything.

It would seem from the multiple threads and endless requests for this function, with some even going back years that Quickbooks should have made this a priority.

B

bohemianworksllc

Couldn’t tell ya.

we went to Wave accounting (free) almost 2 years ago now…. Just as easy to do stuff like this without the monthly fee.

MichelleBh

I can help you make anything possible in QuickBooks, FCNadine. Your satisfaction means everything to us.

Able to select two debits to a single bill in QBDT makes it very beneficial for you and other companies. Also, this process will save you time. With this, I'll route you to the page where you can post follow-up feature suggestions to our product engineers. It enables our engineers to develop a solution to enhance your overall QuickBooks experience.

Here's how:

Go to the Help menu.
Select Send Feedback Online.
Type your concern in the box and click Send Feedback.

Many of the program's current features are available because of user feedback. Also, QuickBooks has a website where you can vote on and provide comments on any future suggestions. To access the page, visit this link: Customer Feedback for QuickBooks.

Further, check out these articles below on how to handle banking transactions and other related topics:

I'd be more than happy to work with you again to address other QuickBooks-related concerns. Just drop a comment below. I hope you and your loved ones are staying safe, FCNadine.

Sign up

Login with SSO

Login to the community

Login with SSO