How to Record a Deposit in QuickBooks Online When Fees Were Deducted First

If your business processes payments through platforms like Square, Stripe, or other payment processors, you’ve likely encountered deposits where the payment processor deducts fees before transferring the net amount to your bank account.

This can create discrepancies in your financial records if you don’t properly account for both the gross payment and the fees.

In this guide, I’ll show you step-by-step how to record a deposit in QuickBooks Online (QBO) when fees are taken out first, ensuring that your books remain accurate and your reports reflect your business’s true income and expenses.

Quick Instructions:

  1. Click the +New button in the upper left corner
  2. Click Bank deposit in the Other column
  3. Select the bank account where the money was received in the Account drop-down
  4. Enter the date the deposit was received
  5. Check off any transactions included in this deposit
  6. Add the Fee in the  Add funds to this deposit section
    1. Under ACCOUNT select the account you use for merchant account fees
    2. Under AMOUNT enter the fee amount as a negative number
  7. Double-check the AMOUNT in the upper right corner matches the deposit amount
  8. Click Save and close

Keep reading for a complete walkthrough with screenshots:

Why Accounting for Fees Is Important

When fees are deducted before deposit, the total amount deposited into your bank account won’t match the payment received from the customer. Properly recording these fees ensures:

  • Accurate Income Reporting: Gross payments are reflected as income, and fees are properly categorized as expenses.

  • Simplified Reconciliation: Deposits in QuickBooks match your bank statement, making reconciliation easier.

  • Tax Compliance: Recording fees separately helps you track deductible business expenses, reducing your taxable income.

How to Record a Deposit with Fees in QuickBooks Online

To create a deposit in QBO click the +New button in the upper left corner. Then select Bank deposit in the Other column.

Creating a bank deposit from the +New button in QBO

In the Account drop-down select the bank account where this money was received.

Enter the Date of the deposit.

In the Select the payments included in this deposit section, check off any invoices or sales receipts included in the deposit.

You’ll add the fee in the Add funds to this deposit section.

  • Under ACCOUNT select the account you use for merchant account fees.
  • Under AMOUNT enter the fee amount as a negative number.

If you deposited any cash in this deposit, enter it in the Add funds to this deposit section.

Double-check that the AMOUNT in the upper right corner equals the amount deposited into your bank account.

When you’re finished, click the Save and close button.

Here’s an example of a deposit with a few different income methods and an $18.00 merchant fee:

A bank deposit in QBO with merchant account fees added.

Fees on the Profit and Loss Reports

Here, you can see the full income reported in the Income section and the fees in the Expenses section of the Profit and Loss report:

Profit and Loss report in QBO with Merchant Account Fees in the Expenses section

Recording deposits with fees deducted upfront in QuickBooks Online doesn’t have to be complicated.

Following the steps outlined above can ensure your income and expenses are properly recorded, making reconciliation and tax preparation a breeze.

☕ If you found this helpful, you can say “thanks” by buying me a coffee… https://www.buymeacoffee.com/gentlefrog

If you have questions about recording fees in QuickBooks Online, click the green button below to schedule a free consultation.

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

Leave a Reply

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

Read similar articles

How to Record Stripe Deposits with Fees in QuickBooks Online

Learn how to find your Stripe fees and record them in a deposit in QuickBooks Online.

How to Track and Manage Bills in QuickBooks Online With the A/P Aging Summary Report

Learn how to track and manage Accounts Payable in QuickBooks Online.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.