Matching of bank and sales receipt

Let's match those bank transactions with the corresponding sales receipts in QuickBooks Online (QBO) Ozan.

If a receipt does not match during reconciliation, it may be due to discrepancies between QBO and your bank account. Moving forward, verify that both records accurately reflect the same transaction information.

To match your bank transactions and sales receipt, you can manually edit the entries in QuickBooks by following these steps:

1. Sign in to your QuickBooks Online account.
2. Go to Transactions, and select Bank transactions.
3. Choose the relevant bank account, and select For Review tab.
4. Locate the downloaded sales receipt that's causing the mismatch.
5. Then, select Find match to locate the correct deposit or manually edit the transaction to reflect the correct amount as per your bank statement.

Furthermore, keeping your transactions organized in QuickBooks is vital for accurate financial record-keeping. You can refer to the following articles for assistance:

• Categorize online bank transactions in QuickBooks Online
• Match online bank transactions in QuickBooks Online

If you have any questions or need help with managing your bank, don't hesitate to reach out to us. We are here to assist you and want to make your experience with QBO easy and seamless.

Hi Eman.

Thank you for your reply but honestly I don't know what this should solve. I try it again:

In the For Review section of the bank transactions, there are 2 transactions that needs to be matched. And I have 2 sales receipts in the All Sales section that are the ones to be matched. Now the following happens:

When I click the first bank transaction and try to match it the correct sales receipt, the sales receipt is not showing up in the avaialble list. However when I click the second bank transaction, it can be matched to both sales receipts. 

OK I will try again, my first reply did not work. The problem is like following:

1. I have 2 bank transactions in the For Review section

2. I have 2 sales receipts that should match those 2 transactions

When I click the first bank transactions, I will not see the sales receipt to match

When I click the second bank transactions, I will see both sales receipts.

So what is the problem here?

Thank you for sharing more details, ozzy1982. I'd like to provide additional information to help you match your bank transaction entries to your sales receipts in QuickBooks Online (QBO).

In QuickBooks, if your sales receipts and bank transactions have the same date and amount, the system will typically suggest a match. All you need to do is approve the match if it's correct. However, if you cannot find a match for your transaction, here are several possible reasons:

• The amounts or dates don’t match.
• The bank account associated with the payment differs from the bank where the match is located.
• The transaction is older than six months.
• The payment has already been reconciled.
• The record is already matched to another transaction.
• Multiple currencies are involved, and the exchange rate has shifted significantly, making the amounts very different.

After reviewing your transaction, I suggest manually matching it using the steps outlined by my colleague Eman above.

Refer to this article for further guidance on how to match transactions accordingly: Match online bank transactions in QuickBooks Online.

Additionally, you can create bank rules to automatically categorize transactions, which will help streamline the review process for your online bank transactions.

Keep your post coming if you have further questions about matching your sales receipts and bank transactions in QuickBooks Online. The Community is always here to help.

Hi there and thannks for your support. Please check the PDF where I try to explain the problem. 

Hello ozzy1982,

Thank you for providing the PDF file. For this situation, you would need to connect with our Support Team so they can escalate or launch an investigation since we don't have the tools to do so in the Community. Here's how to connect with us:

1. Go to the Help menu.
2. Hit the Contact Us button
3. Enter "callback" in the "What can we help you with?" section.
4. Select "Let's Talk"
5. Pick the "Get a call" option to connect with us.
   
   

Please let me know how the conversation goes! I will be around. See you soon. 

Or yes i tried this, waited 45 minutes on the line and then hung up. Its hard to explain the issue, the hotline doesnt get it. Any other ways?

Hi there. I talked to the hotline and the solution provided is doing a manual entry for the transaction. Tried, didnt work and now I know why but I dont know if this can be resolved.

The transaction amount is: 1101.77

The sales receipt to be matched is: 1179.50

Because the difference between those 2 numbers is too high, they can not be matched. When I tried to upload a CSV manually with the transaction and changed the amount to something closer, like 1130, I was able to match. 

So what is the sense behind this matching procedure, I mean the customer can always change mind and send less money or the transaction fee can be higher due to some technical issues or some refunding process. So anyone in this QBO universe please tell me what do now. I have a sales receipt with 1179.50 $ and a transaction with 1101.77 $, fees for this transaction were 77.73 $ and because this fee is too high, Quickbooks will not let me match it!!!

Hi there, ozzy1982.

Thank you for following up on this thread and providing those details.

In this situation you may be interested in a new service from Intuit called QuickBooks Live Expert Assisted. With this program you'll be able to connect with a live accountant agent who can help you with recording these transactions based on your unique business setup and workflows. The following link provides additional info: QuickBooks Live Expert Assisted

If you need a hand with the entry please don't hesitate to reach back out. I'll be here to help in any way that I can.

Tried this 2 days ago, 1 hour phone call, 25$ payment and 0 solution!

@ozzy1982 

Add a line item to the sales receipt with the -$77.73 transaction fee.  That will reduce the sales receipt total to $1101.77, and should allow QB to match the payment to the sales receipt.