cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
sovak
Level 2

Recording sales and matching to deposits

Hi, I need help inputting information correctly so my numbers are not off. Please let me know where I am messing up.

 

I create a Sales Receipt (since the customers pay on the spot) with the total amount paid and categorize it under Payments to be Deposited for credit card payments only. The following day, bank transactions are updated in Quickbooks Online and automatically synced. However, when they sync the amount is in a batch and has merchant fees already taken out. Can someone please show me how to match the sales receipt to this automatic bank deposit? Also, since the transaction is already pulled, do I click on it and erase the numbers and input the original amounts without any deducted fees? Is there a step by step process to help me match either one or more sales receipts to a batch of a merchant deposit in my account which is automatically synced and how to properly record the fees?

2 Comments 2
MadelynC
Moderator

Recording sales and matching to deposits

Good day, @sovak. I’m here to help manage your sales transactions in QuickBooks.


You’ve mentioned your sales receipt is categorized under Payments to be deposited for credit card payments. Do you mean you’ve set this account under Deposit to fields when creating sales receipts? If so, then yes, you need to edit the original transactions in QuickBooks Online. This way, you can enter the merchant fees and match them successfully.


Here’s how:

 

  1. Open your sales receipt.
  2. Next to your line item, add the fee. See the sample below:
  3. Save it after, then match it to your downloaded transaction.


Otherwise, create a deposit to combine the payments received and add the fees from there. Before that, make sure the account selected in your sales receipts is an Undeposited funds account. Then, follow the steps below:

 

  1. Select the + New button, then click Bank Deposit.
  2. Choose the account you want to put the money into.
  3. Select the checkbox for each transaction you want to combine.
  4. Please ensure the total of the selected transactions matches your deposit. You can use your deposit slip as reference.
  5. Scroll down to the Add funds to this deposit section.
  6. Enter the fee as a line item and in a negative amount.
  7. Select Save and close once done, then you can start matching them.


Check this reference to learn more about handling multiple transactions into a single record: Record and make bank deposits in QuickBooks Online.


Additionally, here’s our reconciliation guide to ensure amounts are balanced and moved into the right accounts.


If you have other banking concerns or something else, please don’t hesitate to tag me. I’ll get back to you as soon as I can. Take care always!

sovak
Level 2

Recording sales and matching to deposits

Yes, it allows for us to find a match when adding it manually. However, if you have autofeed setup pulling transactions automatically from the bank, the $$$ amounts and dates have to match.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us