Skip to main content
P
plumbguy1
March 15, 2021
Question

Customer pays their own credit card fees how do I record the sale?

  • March 15, 2021
  • 1 reply
  • 0 views

My credit card processing company collects their fee from the customer.

 

If I have a total sale of $100.00 and run it through my terminal my customer ends up paying $104.00 (example).

$100 for the sale and $4 for the fee. I have a receipt showing exactly that.

 

The bank deposit shows a deposit of $104.00 and then the next day or so another transaction for the -$4.00, netting me my $100.

 

How do I record this sale in Quickbooks Online correctly? I have tried several ways but nothing has proven solid.

1 reply

Kristine Mae
Kristine Mae
March 15, 2021

I can think of one way to help you get around your concern, Plumbguy1.

 

You'll have to receive the payment ($104.00), deposit it to the Undeposited Funds, then deduct the fee ($4.00) from there.


First, you'll have to receive the invoice payment. Here's how:

  1. Click the Plus sign (+) icon, then choose Receive Payment.
  2. Choose the customer, then the invoice.
  3. Enter the amount received ($104.00).
  4. Click the Deposit to drop-down arrow, then choose Undeposited Funds.
  5. Click Save and close.

Then, deposit the payment and add a line item for the fee. Here's how:

  1. Click the Plus sign (+) icon, then choose Bank Deposit.
  2. Choose the invoice.
  3. Under Add funds to this deposit, add the customer, then choose an expense account for the fee.
  4. Enter the fee as a negative amount (-$4.00).
  5. Click the Account drop-down arrow, then choose the bank account.
  6. Click Save and new. 

If transactions are downloaded automatically from your bank, you can match the deposit to the payment.

 

Get back to this thread if you have more questions. We're right here to help you. Take care!

P
plumbguy1Author
March 15, 2021

Let's try this scenario. I'm not in the office for the sale and the service manager writes up a paper invoice totaling $100 and runs it through the terminal. The terminal adds $4 to the customer making the transaction total $104.

 

2 days later in my quickbooks online connected to my bank account, I see a transaction from merchant services for $104 and another for -$4. This nets me my $100 sale.

 

For the life of me, and I followed your example as best I could, I can't get it to work. Mind you I have yet to enter the invoice so I can do it the way you describe but there is nothing to match the 2 bank entries to in the end.

 

If I am not making sense please let me know.

 

1. I believe I only want to record invoice at $100. I don't want to fudge any numbers there to cloud my sales        numbers.

2. I don't think it matters where the fees go or what they are called because they will always end up at a 0          balance (hopefully) because I have nothing to do with the fees themselves.

3. I have to be able to clear the bank transaction pulled from my account that shows the original sale plus the      fee and the following credit for the same fee.

 

 

LieraMarie_A
LieraMarie_A
March 15, 2021

Thank you for getting back to us, @plumbguy1.

 

Being able to clear the bank transactions from the bank feeds would be handy as you won't have to enter them manually in QuickBooks. However, the steps provided by my colleague would be the best way to handle this kind of scenario. For the detailed steps, refer to this article: ​​​​​Enter a bank service fee while using a third-party merchant service.

 

Make sure to enter the fee as a negative amount on the Bank Deposits screen when depositing a payment. This way, it will zero out the bank fee. Then, you can just remove the transactions from your bank feeds. After that, manually clear these entries from your bank register.

 

These instructions will show how to delete them from the For Review tab:

  1. In the left navigation panel, select Banking.
  2. Choose the bank.
  3. Go to the For Review tab.
  4. Select the payments you want to delete.
  5. Select Exclude.

 

Once done, manually clear these transactions in QuickBooks:

  1. Go to the Gear icon, then choose Chart of Accounts.
  2. Locate the account of the transaction.
  3. Select View Register from the Action column.
  4. Identify the transaction to clear.
  5. Under the reconcile status column, select C for Cleared. You can also manually reconcile by selecting R or you can leave it as blank if they aren't cleared or reconciled.
  6. Select Save.

 

Should you have any additional questions or concerns, the Community will have you covered. Thanks for reaching out, best wishes.

Terms & ConditionsAccessibility statement