Merchant Deposit Not Matching Register

I appreciate you providing details of your concern, @SH_PA.

I'm here to provide some info about your issue. First, you'll need to make sure that you don't add the transaction as income on the Banking page. This is to avoid resulting in duplicate sales. Also, you just have to use the Find match option. However, if the find match does not work, you'll need to do the Resolved Difference to allocate and record the cause of the difference.

For your additional reference, please see this article: Fix QuickBooks Payment deposits that don't match your bank statement.

Also, QBO has several ready-made reports that you can access to view your sales transactions and data. Just simply go to the Reports tab and type the "sales" keyword and click whichever customer report you'd like to open.

Feel free to post again here if you have further concerns about matching your sales in QuickBooks. I'll be always around to help, Keep safe. 

Thanks for your response. We don't do actual product and service sales through QB Online, we use another software for our POS transactions, which is why I have to manually enter the sales in QB Online. The products don't talk to each other. 

So I'm still needing to know how I should label the deposits  that we receive to our bank account (which automatically import into QB online), since they do not match the daily sales we put (manually) into QB Online. 

As I said, the batch times for our register sales have been adjusted, so this problem won't come up again in the future, however, I do need to edit about half the month of April. 

Thank you. 

Hi there, SH_PA.

I'd like to share some insights about matching POS transactions.

You'll need to make sure that both transactions have the same amount in order for you to match them. You can either edit the amount in QuickBooks or you can exclude the imported transaction. Then, you can manually clear them on your bank register. I'll show you how.

Here's how to Exclude:

1. Click the Banking or Transaction menu.

2. Select Banking.

3. In the For Review tab, checkmark the imported transaction

4. Hit Exclude selected.

Here's how to manually clear the bank register:

1. Click the Accounting menu.

2. Select Chart of Accounts.

3. Locate the bank account, then click View register.

4. Choose the bank transaction, then click until C(cleared) appear.

Adding some helpful materials for your reference: 

• Categorize and match online bank transactions in QuickBooks Online.

• Learn the reconcile workflow in QuickBooks.

Reply to this post if you have further questions about bank feeds. I'm always here to help. Take care.