FitSmallBusiness
  • HR
  • Retail
  • Sales
  • Marketing
  • Accounting
  • Real Estate
  • More Categories
    • Starting a Business
    • Banking
    • Credit Cards
    • Financing
    • Insurance
    • Office Technology
    • Online Business
    • Taxes
  • BE A PARTNER
  • WORK AT FSB
  • About
  • HR
  • Retail
  • Sales
  • Marketing
  • Accounting
  • Real Estate
  • More Categories
    • Starting a Business
    • Banking
    • Credit Cards
    • Financing
    • Insurance
    • Office Technology
    • Online Business
    • Taxes

Accounting | How To

How To Record a Bounced Check in QuickBooks Online

Tim Yoder, Ph.D., CPA

REVIEWED BY: Tim Yoder, Ph.D., CPA

Tim is a Certified QuickBooks Time (formerly TSheets) Pro, QuickBooks ProAdvisor, and CPA with 25 years of experience. He brings his expertise to Fit Small Business’s accounting content.

 

WRITTEN BY: Mark Calatrava

Published June 27, 2022

Mark has researched and reviewed accounting software at Fit Small Business since 2019 and has developed an extensive knowledge of accounting software features and how unique business needs determine the best accounting software.

Published June 27, 2022

This article is part of a larger series on Accounting Software.

Learn More With Our QuickBooks Online Course
Explore the chapters in the guide.
  1. How to Set Up QuickBooks Online
  2. Part 1: Setting Up QuickBooks
    1. How to Set Up Company Information
    2. How to Customize Invoices, Sales Receipts & Estimates
    3. How to Set Up Invoices, Sales Receipts & Estimates
    4. How to Set Up Products and Services
    5. How to Set Up Messages
    6. How to Set Up Statements
    7. How to Set Up Expenses
    8. How to Set Up Advanced Settings
  3. Part 1: Setting Up QuickBooks (Cont.)
    1. How to Import Bank Transactions
    2. How to Import Credit Card Transactions
    3. How to Set Up Multiple Users
    4. How to Set Up the Chart of Accounts
    5. How to Set Up the Products and Services List
    6. How to Set Up Customers
    7. How to Set Up Vendors
  4. Part 2: Managing Sales and Income
    1. How to Create Estimates (Quotes or Bids)
    2. How to Create and Send Invoices
    3. How to Receive Payments
    4. How to Create & Send Sales Receipts
  5. Part 3: Managing Bills and Expenses
    1. How to Write & Print Checks
    2. How to Enter Bills
    3. How to Pay Bills
  6. Part 4: Managing Banking Transactions
    1. How to Enter Banking Transactions Manually
    2. How to Manage Downloaded Banking Transactions
    3. How to Record Bank Deposits
    4. How to Transfer Funds Between Bank Accounts
    5. How to Handle Bounced Checks From Customers
    6. How to Process Bank Reconciliation
  7. Part 5: Managing Business Credit Card Transactions
    1. How to Enter Business Credit Card Transactions Manually
    2. How to Manage Downloaded Business Credit Card Transactions
    3. How to Enter a Credit Card Refund
    4. How to Reconcile Business Credit Card Accounts
  8. Part 6: Managing Credit Card Sales
    1. How to Manage Credit Card Sales With QuickBooks Payments
    2. How to Manage Credit Card Sales With a Third-party Credit Card Processor
  9. Part 7: Set Up and Manage Payroll
    1. How Set Up and Run Payroll
    2. How to Manage Payroll Tax
    3. How to Add Historical Payroll Data
    4. How to Set Up Automatic Deposits
    5. How to Print Payroll Checks
    6. How to Run Payroll Reports
    7. How to Reconcile Payroll Liabilities
  10. Part 8: Reporting in QuickBooks Online
    1. How to Run a Profit and Loss Statement
    2. How to Run a Balance Sheet Report
    3. How to Run a Statement of Cash Flows
    4. How to Run an A/R Aging Report
    5. How to Run an A/P Aging Report

In this tutorial, you’ll learn how to record a bounced check in QuickBooks Online, as it doesn’t have an automated bounced check feature. There are multiple ways to do this, but we present what we believe is the most efficient way while still maintaining a paper trail and making reconciling your QuickBooks banking activity as simple as possible.

This lesson—which is part of our QuickBooks Online course library—is designed to help you make the most of QuickBooks Online, our best small business accounting software. If you’ve already subscribed, we suggest following our guide with your own account open; otherwise, you can sign up to get a free 30-day free trial or 50% off for three months.

Visit QuickBooks Online

To teach you how to record a bounced check in QuickBooks Online, we’ll use this sample scenario: Paul’s Plumbing issued Aaron Berhanu Invoice #71166 for $240, and he paid the full invoice with check #100. Paul’s Plumbing recorded the check as received and placed it in undeposited funds and deposited check #100, along with other customer checks, in its Chase Bank checking account. Chase notified Paul’s Plumbing that check #100 was returned for nonsufficient funds (NSF) and charged them an NSF fee of $25.

Step 1: Record the Decrease in Bank Balance

With the scenario above, let’s decrease the Chase checking balance since the $240 check from Aaron Berhanu bounced. We’ll do this by recording an expense out of the Chase account—click the + New button at the top of the left menu bar and then select Expense in the second column, Vendors, as shown below.

Preparing to create a new expense in QuickBooks Online.

Preparing to create a new expense in QuickBooks Online

The expense entry should decrease the bank account and increase accounts receivable (A/R) since the customer, Aaron, now owes Paul’s Plumbing for the check that bounced. Here’s the expense entry to decrease the Chase checking account for our example:

Decrease the bank balance for a bounced check in QuickBooks Online.

Decrease the bank balance for a bounced check in QuickBooks Online

A. Payee: Select the customer whose check bounced.

B. Payment account: Choose the bank account where the bounced check was deposited.

C. Payment date: Enter the date the bank notified you of the bounced check.

D. Payment method: Select cash as the payment method.

E. Category: Set the category to Accounts Receivable, which is an asset account and records the amount owed to you by the customer.

F. Description: Provide a description indicating that this entry is being made to record a bounced check.

G. Amount: Enter the amount of the bounced check.

Click the green Save and close button when you have entered all the information.

Avoid a common mistake:

While it’s tempting, don’t account for a bounced check by deleting the receipt of the original check. This removes the paper trail, which may misstate undeposited funds and the checking account, thereby making it difficult to reconcile your QuickBooks account to the bank statement. The bank statement will show the original deposit, followed by a reduction for the bounced check. You want your QuickBooks account to show the same transactions.


Step 2: Reopen the Original Invoice

The customer invoice was marked as paid when the original check was received. However, now that the check has bounced, the invoice needs to be reopened and sent to the customer.

Navigate to customers by hovering over Sales in the left menu bar and then clicking on Customers.

Arrow Navigating to customers in QuickBooks Online.

Navigate to customers in QuickBooks Online

Scroll down to find the customer whose check bounced and click on their name to open a list of their transactions. In the list of the customer’s transactions, locate the original invoice and the original payment received.

The original invoice and payment received from the customer’s transaction list.

The original invoice and payment received from the customer’s transaction list

Click Closed (highlighted in the screenshot above) on the right side of the payment line to open the receive payment screen.

The Receive Payment screen applies check #100 to invoice #71166, which is no longer correct since the payment bounced.

To reopen the invoice, uncheck the box to the left of the invoice and check the box to the left of the check that was created in step one. Now, click the green Save and new button, and the invoice in the transaction list should show a status of Open or Overdue.

Short video on Removing the payment from the original invoice and applying it to the new check created.

Removing the payment from the original invoice and applying it to the new check created

You can now email or print and mail the invoice to the customer, as discussed in our tutorial on how to create and send invoices.


Step 3: Record the NSF Fee

Next, record the NSF fee charged by your bank. If this is the first time you’re recording an NSF fee, you should first create a Service Item so that the fee can be marked up and billed to the customer.

The details of adding Service Items are covered in our guide on how to set up products and services, but we’ll go over them here so that we can talk about the specifics applicable to setting up the NSF Fee.

Hover over Sales in the left menu bar and then click Products and services.

Arrow Navigating to Products and Services in QuickBooks Online.

Navigate to Products and Services in QuickBooks Online

From the Products and services screen, click the green New button in the upper right corner to create a new product or service item. The Product and service information screen that appears after clicking New provides the four item types that can be created for products and services. Click on the third item, Service.

Short video on Create a new service item in QuickBooks Online.

Create a new service item in QuickBooks Online

Here’s an example of how to complete the add service screen:

Add Service Item in QuickBooks Online (1 of 2)

Add Service Item in QuickBooks Online (1 of 2)

A. Name: Name the Service Item “NSF Fee” or something similar.

B. Sell this product/service tick box: Check the box indicating you sell this service to your customer. This will make it easier to add an NSF Fee to your customer’s invoice.

C. Description field: Enter a description of the charge you would like to appear on your customer’s invoice.

D. Sales price/rate: Input the amount you would like to charge your customers for a bounced check. This doesn’t necessarily have to be the same amount as the bank charges you. There’s nothing wrong with charging the customer for your inconvenience, but it’s a good idea to state your charge for returned checks at the bottom of all your invoices.

E. Income account: Select the income account where you want to record the fees collected from your customers.

F. Sales tax: Select nontaxable if NSF fees charged to clients aren’t subject to sales tax in your state.

Scroll down to complete the purchasing information for the NSF free service item.

Add a service item in QuickBooks Online (2 of 2).

Add a service item in QuickBooks Online (2 of 2)

G. Purchasing information tick box: Check the box to indicate that you purchase this product or service from a vendor.

H. Description field: Provide a description to appear on your internal purchase and expense forms.

I. Cost: Enter the amount of your bank’s NSF fee.

J. Expense account: Select the expense account where you want to record the NSF fee charged to you by your bank.

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

Now that we have created a service item for the NSF fee, recording the expense of the fee will be easy. Open a new expense screen by clicking on + New at the top of the left menu bar and then selecting Expense, as done in Step 1.

Here’s an example of how to record the NSF fee for the sample scenario with Paul’s Plumbing:

Recording an NSF fee in QuickBooks Online.

Recording an NSF fee in QuickBooks Online

A. Payee: Select the bank that charged you an NSF fee as the payee. If the bank isn’t yet set up as a customer, select Add New and provide the bank’s information.

B. Payment account: Select the account where the NSF fee was charged.

C. Payment date: Enter the date the NSF fee was charged to you.

D. Payment method: Select cash for the payment method.

E. Product/Service: Under Item details (not Category details), select the NSF Fee item you set up in the first part of this step. Once you select the item, the Description, Qty, Rate, and Amount will populate automatically based on the information you provided when you set up the item.

F. Billable: If you want to charge your client a fee for the bounced check, place a checkmark under Billable. This will populate the sales amount field automatically. This box must be checked for the charge to be available when you create a customer invoice in the next step.

G. Customer/Project: If you’ve marked the expense as billable, you must select the customer whose check bounced.

When you’ve finished entering the data, click the green Save and close button. If you want to bill your client for an NSF fee, then continue to Step 4. Otherwise, you’re done recording the bounced check activity.


Step 4: Bill an NSF Fee (Optional)

The last step is to bill your customer an NSF fee, which is optional. Click on + New on the top of the left menu bar and then select Invoice under Customers in the first column.

Navigate to invoices in QuickBooks Online.

Navigate to invoices in QuickBooks Online

A new invoice screen will appear. In the customer field, select the customer whose check bounced. A list of billable expenses will then appear to the right of the invoice. Locate the billable NSF fee you created in the prior step and then click Add.

Add the NSF fee to invoice in QuickBooks Online.

Add the NSF fee to the invoice in QuickBooks Online

The billable expense will populate the billing detail of the invoice automatically. Here’s the completed invoice screen for our example with Paul’s Plumbing:

Create an NSF fee invoice in QuickBooks Online.

Create an NSF fee invoice in QuickBooks Online

A. Customer: Select the customer whose check bounced. After selecting the customer, all the other customer information fields will auto-populate. Of course, you can change them if needed.

B. Service information: This entire section gets populated automatically when you added the billable expense in the previous screenshot.

Click Save and send to finish the process. For additional information on saving, printing, and emailing invoices, review our previous tutorial on how to create and send invoices.


The Importance of Recording a Bounced Check in QuickBooks Online

When a check bounces, the bank balance that’s shown in QuickBooks Online is overstated since the bounced check is shown as a deposit. It’s important to adjust your QuickBooks bank balance immediately so that the correct amount is displayed. You also must show that the customer still owes you for the original invoice and for any fee you charge for returned checks.

Wrap Up

Congratulations on finishing what could be the most complex tutorial in our QuickBooks Online Training Course. Hopefully, you won’t have to do it often, but you now know all the steps needed to record a bounced check in QuickBooks Online and bill the customer an NSF fee. Our next guide looks at how to process bank reconciliations, and it covers reconciling your QuickBooks Online banking activity with your bank statement to ensure you recorded all the activity.

← Previous Tutorial

QuickBooks Tutorials

Next Tutorial →

About the Author

Mark Calatrava

Find Mark OnLinkedIn

Mark Calatrava

Mark Calatrava is an accounting expert for Fit Small Business. He has covered more than 50 accounting software for small businesses and niche industries and has developed an in-depth knowledge of the important features of accounting software and how the importance of these features vary by business.

Fit Small Business

Facebook Twitter LinkedIn YouTube

Company

  • About Us
  • Editorial Policy
  • Careers

Partners

  • Work With Us

Contact Us

228 Park Ave S # 20702
New York, NY 10003-1502

info@fitsmallbusiness.com

Fit Small Business BBB Business Review

Facebook Twitter LinkedIn YouTube

© Fit Small Business 2023

California Privacy Rights | Privacy | Terms | Sitemap

Need Assistance with QuickBooks Online?
QB Live matches you with a personal bookkeeper!
Visit QuickBooks Live

Was this article helpful?

Feedback

Join Fit Small Business

Sign up to receive more well-researched small business articles and topics in your inbox, personalized for you. Select the newsletters you’re interested in below.

Please select at least one newsletter.