How To Record Deposits and Fees in QuickBooks

Written By

In this training, you’ll learn how to record a deposit for a sale made through a processor like Stripe or Paypal. These types of transactions include fees that should be entered into QuickBooks.

Creating a Sales Receipt

In this example I’ll use a hypothetical sale that had a 3% Strip processing fee. 

To begin we’ll create a sales receipt by click the “+ New” button in the upper left hand side of the screen.

Under the CUSTOMERS column click Sales Receipt.

 

Creating a new Sales Receipt from the main menu in QuickBooks

For this example, I create a sales receipt for a $200 bathtub sold to “Stripe Customer.”

Sales receipt creation for a Stripe order depositing to

 

The most important part of this sales receipt creation is the “Deposit to” field should be an “Undeposited Funds” account. Undeposited Funds is an account used to temporarily hold funds.

Bank Deposit

The second step is to match the sales receipt with the deposit from the bank.

To do this click the “+ New” button in the upper left corner and in the OTHER column select Bank Deposit.

Creating a new Bank Deposit from the main QuickBooks menu

I select the account the sale will be deposited into, a checking account. Then check off the payment to include in the deposit.

QuickBooks still sees this as a deposit of $200.

Creating a bank deposit in QuickBooks Online

To add the fee scroll down to the “Add funds to this deposit” section.

Under RECEIVED FROM I’ll enter Stripe. The ACCOUNT is usually where the money is coming from. In this transaction it’s not actually coming from anywhere but instead “going to” the Stripe fee. I’m using an expense account for this called Merchant Service Fees.

Make sure the amount you enter for the fee is negative, my fee is 3% of 200 or -6.00.

The total for this deposit is now the correct amount of $194.00.

Bank deposit with the fee added to reflect the correct amount deposited into the bank

Profit & Loss Report

You can verify that this deposit has been processed correctly by checking the Profit and Loss report.

Click Reports in the left hand menu and select Profit and Loss.

Navigating to the Profit and Loss report in QuickBooks Online.

You should see the service fee under Expenses.

Profit and Loss report in QuickBooks Online showing a service fee in Expenses.

If I click Services under Income I can see the sales receipt for the $200 bathtub.

Viewing a Sales Receipt in the Profit and Loss report in QuickBooks Online.

You should do this process for any sale that includes a fee that isn’t recorded in the transaction downloaded from your bank.

For example a wire transfer with a $30-$40 fee would also be entered into QuickBooks this way.

You now know how to record deposits with fees into QuickBooks. If you’d like you can watch me walk through this process in the video below:

Need some one on one QuickBooks assistance?
Share Now
Share on facebook
Share on twitter
Share on linkedin

2 Responses

  1. Hi Rachel, I have 2 issues. I have started helping a newly started church who uses QBO. Their bank account linked to QBO so donations received in bank are net of egiving fees. It is now year end I see the fees have not been accounted for all year. The donation and expenses are under reported. Each month has already been reconciled for 2020.
    1) What is best way to record the gross fees now at year end and all months have been reconciled?

    2) What is best way to handle recording fees going forward keeping in mind the donations are deposited by church (which are batched) are linked/posted in QBO net of fees? The church records and tracks donations by member in a stand alone software (Powerchurch).

    Any help would be appreciated.

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

QuickBooks Online for Small Business Owners – Part 2

This is part two of a tutorial, where I walk through setting up QuickBooks Online for a small business that's about a year old.