cancel
Showing results for 
Search instead for 
Did you mean: 
kpierce1208
Level 1

Hello! RE: Recording NSF/bounced check that is included in a bulk ACH transaction downloaded from the bank feed? How do you do this?

 
8 Comments 8
Angelyn_T
QuickBooks Team

Hello! RE: Recording NSF/bounced check that is included in a bulk ACH transaction downloaded from the bank feed? How do you do this?

Hi there, @kpierce1208.

 

I'm here to help share ways to record NSF/bounced checks in QuickBooks Online (QBO).

 

You can record a bounced check using an invoice, a check, or a journal entry. Make sure that the check must have been received from a customer for a transaction in which accounts receivable was used.

 

For example:

  • A check entered as a payment through Receive Payment
  • A check recorded as a Deposit entered on an invoice
  • A check entered as a Bank Deposit posted to Accounts Receivable

You can check these articles for the detailed steps and instructions to record a bounced check using the following methods:

If you need further assistance with the process, you may get in touch with our Support Team.

 

To contact support:

  1. Go to: https://help.quickbooks.intuit.com/en_US/contact.
  2. Choose QuickBooks Online.
  3. On the Contact Us page, click a topic.
  4. Click on the Get Phone Number button to see the support number.

Let me know if you have any other questions about recording bounced checks in QBO. I'm always here to help!

margie286
Level 2

Hello! RE: Recording NSF/bounced check that is included in a bulk ACH transaction downloaded from the bank feed? How do you do this?

Hi,

I need to show it as returned on the customer side.  How could I do that by the steps that were shown?  The customer will still show he paid the invoice but he did not.  It bounced.  After all these years intuit still does not have a NSF feature for customers?  Thank you for any help you can offer.  I'd really like to post it right.

ChristieAnn
QuickBooks Team

Hello! RE: Recording NSF/bounced check that is included in a bulk ACH transaction downloaded from the bank feed? How do you do this?

Hi there, margie286.

 

Thank you for posting here in QuickBooks Community.

 

To show it as returned on the customer side, let's enter a returned or bounced check using Write Check. Then change the payment entry to apply to the bounced check.

 

Here's how to enter the bounced check into the Check window

 

1. Click the Plus icon at the upper right corner.

2. Under Vendors, choose Check.

3. From the Payee drop-down list, select the name of the customer who issued the bounced check.

4. Select your bank from the Bank Account drop-down arrow.

5. In the Payment date field, enter the date the check bounced.

6. Clear the Print Later checkbox and enter a note, such as NSF check, in the Check number box.

7. From the Account details, choose Accounts Receivable from the drop-down list in the Account column.

8. In the Amount field, enter the amount of the bounced check.

9. Choose the Save and close button.

 

Once done, the next step is to change the payment entry to apply to the bounced check.

 

Follow the steps below:

 

1. Select Sales on the left panel. Then Invoice tab.

2. From the Customer tab, choose the name of the customer who issued the bounced check to open the Transaction List.

3. Locate and choose the payment record you created for the bounced check.

4. Select the checkbox of the bounced check (NSF check) entry.

5. Clear the checkbox of the invoice the payment was originally applied to.

6. Choose the Save and close button.

 

The payment entry is changed to apply to the bounced check entry.

 

To finish the process please check this article and follow the step three to seven: How to enter a returned or bounced check using Write Check.

 

To sort it out why the invoice shows paid even the customer did not pay, I suggest contacting Merchant Services Support Team. They have the tools to pull up and to help you further with the status of the invoice.

 

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.​

margie286
Level 2

Hello! RE: Recording NSF/bounced check that is included in a bulk ACH transaction downloaded from the bank feed? How do you do this?

Hi and much thanks for the workaround!  I was able to do Part 1 of your instructions and did not need to do part 2.  The bounced check had already been imported over from financial institution so when I went back into banking-the program had already found the match of the NSF check you had me create.  PERFECT.  All better and thanks again!

SRichard
Level 1

Hello! RE: Recording NSF/bounced check that is included in a bulk ACH transaction downloaded from the bank feed? How do you do this?

Hello. I am currently having this issue as well. I had previously recorded the bounced check as a journal entry which i cannot put into the deposit. Did you ever find a solution for this?

MariaSoledadG
QuickBooks Team

Hello! RE: Recording NSF/bounced check that is included in a bulk ACH transaction downloaded from the bank feed? How do you do this?

Recording a bounced check using a journal entry is a little bit tricky and I've got your back covered, SRichard.

 

Before you begin, you'll have to make sure to create two items for the bank fee and the other for what you want to charge your customer for the returned check fees. To do this, follow the steps below:

  1. Click the Gear icon, then select Products and Services under Lists.
  2. Select New, then select Service.
  3. Name the item Bounced Check Fees.
  4. Select an account you use to track bounced check fees from the Income account drop-down list. (You can also use an expense account you use for tracking bounced check fees.)
  5. Click Save and close.

After you're done creating the two items, you can now proceed in recording the check using a journal entry. Make sure to correctly follow the steps to avoid any issues. 

 

However, if you're still unsure of the process, I recommend reaching out to your accountant so they can verify if you're using the right account. 

 

For your reference, you can run and customize the Journal report to view all the journal entries entered in QuickBooks Online. 

 

Please let me know if these steps help you. I'll be here to further assist you anytime you need.

Gdottore
Level 1

Hello! RE: Recording NSF/bounced check that is included in a bulk ACH transaction downloaded from the bank feed? How do you do this?

Hello!  

 

I had the same issue and was able to do step one and step two with no issue, however both the payment and the NSF check I matched it to are hanging out in my unapplied cash payment income account on my P/L for cash basis. The dates are correct so I'm wondering how to clear from this account so it's not sitting on my P/L.

 

Thank you!

QueenC
Moderator

Hello! RE: Recording NSF/bounced check that is included in a bulk ACH transaction downloaded from the bank feed? How do you do this?

Hi, @Gdottore.

 

It's good to know that you're following the steps given by my colleague. No worries, I can walk you through few steps to fully resolve it.

 

There are only two reasons why transactions are showing in the Unapplied Cash Payment Income account. It's either you record the payment before creating the sales form, or they weren't matched at all.

 

You can start with running the Open Invoices report to verify transactions showing as not yet paid. Here's how:

 

 

  1. Go to Reports, then enter Open Invoices in the Find report by name section.
  2. Set the report period, and click Run report.

 


 

If the Payment transaction matched the open invoice, you can proceed to Step 2. If it doesn't, go directly to Step 3.

 

Step 2

 

  1. Select the Payment date to open and click on Receive payment.
  2. Under Outstanding Transactions, check the open invoice.
  3. Select Save and Close.

 

Step 3

 

  1. Select +New and go to Invoice under Customers.
  2. Enter the customer, amount and date as the payment.
  3. Save and Close.
  4. Go back to the Open Invoices report.
  5. Find the unapplied payment and click the date to open.
  6. Under Outstanding Transactions, check the open invoice.
  7. Select Save and Close.

Repeat the same steps until there are no payment transactions anymore.

 

Run your Profit and Loss report again. You should no longer see the Unapplied cash payment income anymore. 

 

I've also added an article that will help you if you want to personalize the format of your reports: Customize reports in QuickBooks Online

 

I'll be here if you have any other queries in managing your reports. I'm available to you at all times. Be safe.

 

Need to get in touch?

Contact us