Our company performs the same job in the fall for 300+ customers, all invoiced at the same price ($70.00).
When I review the items downloaded from our bank, how do I differentiate one customers $70 payment from another when I have so many? (Below is just showing 5, I have others that are a dozen plus.)
|Date||Desc||Payee||Category or Match||Spent||Received||Action|
|11/26||IntuitSoln||Customer Name||5 Records Found||$70.00||View|
Add Match Transfer
|Invoice #5880||11/24||$70.00||(Open Balance)|
|Invoice #5894||11/24||$70.00||(Open Balance)|
|Invoice #5929||11/24||$70.00||(Open Balance)|
|Invoice #5966||11/24||$70.00||(Open Balance)|
|Invoice 5954||11/24||$70.00||(Open Balance)|
Bank Detail Electronic Deposit Intuit Pymts Downloaded from ...
Thanks for dropping by the Community. I'm here to help match your downloaded credit card payments in QuickBooks Online (QBO).
If QBO finds multiple matches from the downloaded transactions, you'll open the transaction row to review the possible matches. Here's how:
1. Go to Banking menu at the left panel.
2. On the For Review tab, click View to open the transaction row under Action column.
3. Review the possible matches listed under Records found, then pick the correct one.
4. Select Match to accept it.
I also attached some sample screenshots below for your guide.
That should help you match help match your downloaded credit card payments. For your reference, you can check out this article and scroll down to match a downloaded transaction to multiple QuickBooks Online transactions: How to add and match downloaded banking transactions.
Please let me know how it goes by leaving a comment below. I'm only a post away should you need some additional assistance. I'll be here to help. Enjoy the rest of the day!
The dilemma I'm having is how do I know which transaction to match it to? We have many open invoices for $70 and just as many payments coming in for $70. How can I be certain I am not matching the Jones' payment to the Smiths' open invoice?
Let me join in this thread to help you, Lisa617.
I can share some details about matching credit card payments to the transactions that are already entered in QuickBooks Online (QBO).
If you're using Merchant Service but haven't linked your account to QBO, the system is unable to identify which invoice the deposits will apply. You'll need to match these deposits manually by finding the correct invoice.
Since you're unable to determine which transactions to match, you can go to your Merchant Services Center account to verify incoming payments. However, if you'd like to automatically sync your customer payments to your invoices without matching them manually, you can connect your payments account to QBO.
- Sign in to QuickBooks Online.
- Choose the Gear icon, then select Account and Settings.
- On the right side choose Payments, then click Connect.
- Once the payment account is detected, you'll see a screen like this. Click Next to proceed.
- When the account has been successfully linked, you'll receive a confirmation page like below. Click Done.
- Once the account in linked, in Payments tab of the Account and Settings you will see a Manage Details button. This means your QuickBooks Payments account is now successfully linked to QBO.
That should work for you. If you have other questions about QBO, feel free to let me know. I'm always happy to help. Have a good day.
Good morning, @Lisa617.
Welcome to the Community. I'm here to point you in the right direction for matching credit card payments to the transactions entered in QuickBooks Online (QBO).
Customers that pay through the sent invoice should automatically match to the transactions in the QuickBooks system. If it doesn't match directly, you'll need to give us a call.
Please also note that payments that you enter directly to the Merchant Center don't directly match to your QuickBooks transactions.
You can contact our QuickBooks Payments Team to correct the setup of your account. You can reach them through this article (scroll-down to QuickBooks Payments support):
If I can be of further assistance, I'm just a post away. The Community Team is on a lookout for your response on this thread.