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

Leave a Reply

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

Read similar articles

How To Record Deposits and Fees in QuickBooks

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.

How to Track Hours Worked Using QuickBooks Timesheets

In this tutorial I'll show you how to use QuickBooks timesheets to keep track of your time worked and make sure you bill your time back to customers and clients correctly.

How To Reset Passwords in QuickBooks Desktop

In this training you'll learn how to reset the password in QuickBooks Desktop as both an administrator and a user so you'll never be locked out of your account.