cancel
Showing results for 
Search instead for 
Did you mean: 
Grimayoj
Level 3

Sale to customer then check was recieved and bounced then customer reissued check and it cashed QBO

I had a sale to a customer who then sent a check that bounced and then they sent another check that cashed.

My bank register shows the original sale(Credit) then it shows the bounced check(Debit) and then it shows the reissued check(Credit) that actaully cashed.. I need the entries for QBO for each item so our bank register matches the books.. However when I do the Bounced check(Expense method) for some reason with the other two SALE ENTRIES the A/R Aging report shows that there is still 6500 outstanding that they owe us however 

in the Sale register it shows the two sales entries are paid and the expense item as well.. What am I doing wrong?

Thanks

8 Comments 8
AbegailS_
QuickBooks Team

Sale to customer then check was recieved and bounced then customer reissued check and it cashed QBO

Hello there, @Grimayoj. I can help you with the check transactions and the outstanding balance in your accounts. Let's follow some steps to ensure your records are accurate in QuickBooks Online (QBO).

 

First, open the expense or check you've recorded and set the customer as the payee, and categorize it under the Accounts Receivable.

 

  1. Go to the Expenses tab.
  2. Open the appropriate transaction.
  3. From the Payee ▼ drop-down menu, make sure to select a customer.
  4. From the Payment account drop-down menu, select the account you use to pay expenses.
  5. Under the Category column, choose Accounts Receivable.
  6. Enter the amount you were charged for then hit Save to confirm.

expense core.png

 

Next, make sure to unapply the initial payments from the two invoices.

 

  1. Go to the Sales tab, then select Invoices.
  2. Find the two invoices that were initially paid and open them.
  3. Click on Receive Payment and then remove the payments applies to these invoices.
  4. Save changes.

 

As you've mentioned that the invoices are showing as unpaid, make sure to record the payment first before unapplying them. On the other hand, if the payment has already been unlinked, let's proceed to link the check to the unapplied payments.

 

  1. Click the + New button.
  2. Select Receive payment.
  3. Choose the customer and link the check you created to the two unapplied payments.

 

These steps ensure that the payments are appropriately accounted for. After this, record the invoice payments to account for the reissued check and to pay the two invoices from which the payments were unapplied.

 

Lastly, if you connected your bank in QuickBooks, you can match the corresponding downloaded transactions for the recorded check and payment.

 

You can also check out this article for more details: Record a returned payment or bounced check in QuickBooks Online

 

Additionally, QuickBooks provides a variety of reports to get the information you need for your business. We can pull up one,and then customize it to filter for certain things.

 

If you have any other concerns about recording bounced payments in QBO, please let me know in the comments. I'm here to help! Take care and stay safe.

Grimayoj
Level 3

Sale to customer then check was recieved and bounced then customer reissued check and it cashed QBO

Thank you Abigail but for some reason its still not right...I have no problem with the first action of creating the expense item. I then went to the original invoices the first invoice that was paid but bounced and I took out the payment made to it and then I went to the second invoice that was recorded and took the payment out that actually did cash... At this point Im lost because I have three transactions in the books.. An expense transactions and two invoices that are open with no payments applied to them which means the only thing showing up in the bank register is the expense item at this point.. Can you be more specific as to the steps to clear up the open invoices... 

Thanks

Aldren18
QuickBooks Team

Sale to customer then check was recieved and bounced then customer reissued check and it cashed QBO

I appreciate your understanding as we handle the recent transactions, Grimayoj. Your cooperation means a lot to us, and I'm here to ensure that every detail of your account is clear and precise.

 

To resolve the issue with the open invoices and ensure that your bank register accurately reflects the transactions in QuickBooks Online (QBO), let's clarify the steps to handle the bounced check and the reissued check.

 

Here’s a more detailed breakdown of the steps:

 

Begin by reclassifying the bounced payment to reactivate the invoice. This step will generate an expense that reflects the deducted amount, ensuring your records remain accurate.

 

Here's how:

 

  1. Navigate to Transactions and select Bank Transactions.
  2. Find the bounced check or returned payment in the bank feed. Select it to expand the transaction details.
  3. In the Vendor/Customer dropdown, choose the customer whose payment bounced.
  4. In the Account dropdown, choose Accounts Receivable.
  5. Once done, select Add.

 

This balances out the outstanding invoice. If you haven't connected a bank account to QuickBooks or if the returned payment hasn't appeared yet, you can record this transaction as an expense and match it to your bank account later.

 

After that, follow the steps below to remove the payment for the bounced check from the original invoice:

 

  1. Go to Sales and select Customers.
  2. Find and select the customer whose payment bounced.
  3. Find the payment for the bounced check and hit Edit.
  4. Select the payment link.
  5. Uncheck the checkbox for the invoice to which the payment was applied.
  6. Select the new expense you created in the first step.
  7. Choose Save and Close.
  8. A message displays saying that the transaction is linked to others. Select Yes.

 

Finally, generate an invoice for the bank fees to bill your customer:

 

  1. Click on the + New UI.
  2. Under Customers, choose Invoice.
  3. In the Add customer dropdown, choose the customer whose payment bounced.
  4. For the Invoice date, use the date when your bank charged the fees.
  5. In the Product/Service column, select the service Bank Fees Charged to Customer. If this service doesn’t exist:
    1. Select +Add new.
    2. Choose Service as the type.
    3. In the Name field, enter Bank Fees Charged to Customer.
    4. In the Income account dropdown, select Other Income. If you don’t see this income account, select +Add new to add it to your chart of accounts.
    5. Hit on Save and Close.

 

Moreover, I’ll provide valuable resources to help notify your customers about their outstanding balances and the reasons behind them. This includes guidance on maintaining accurate financial records for effective communication and financial management:

 

 

Finally, you may want to consider exploring our QuickBooks Live Expert Assisted service for additional personalized support. This service connects you with certified QuickBooks professionals who can help you manage the complexities of your financial records. It allows you to control your bookkeeping while ensuring that your accounting processes are efficient and accurate.

 

Consider the QuickBooks Community team your dedicated resource for all things in QBO. We will be actively monitoring this thread and are ready to assist you with your payments or any other questions you may have about our program. Please provide the details below. We want to ensure that your success is our top priority.

Grimayoj
Level 3

Sale to customer then check was recieved and bounced then customer reissued check and it cashed QBO

when you say 

  1. Find the payment for the bounced check and hit Edit. You mean the expense that was created correct?
Grimayoj
Level 3

Sale to customer then check was recieved and bounced then customer reissued check and it cashed QBO

Now the original invoice because we unchecked the payment and checked the expense is now UNPAID and is an OPEN INVOICE... 

MariaSoledadG
QuickBooks Team

Sale to customer then check was recieved and bounced then customer reissued check and it cashed QBO

You'll have to locate the invoice payment by clicking the payment link, and uncheck it on the Receive Payment window, and selecting the expense instead. Allow me to guide you through the process, Grimayoj.

 

To confirm the steps shared by my colleague, you'll need to click the payment link to choose the correct entry. I've added a screenshot for your visual reference:


Please know, that this is only a sample screenshot. The amount may not accurately reflect your specific issue. To continue, click the link on the red box.

Payment1.png

 

Next, untick the invoice payment, and select the expense transaction instead. See below:

Payment2.png
By following this method, the original invoice will still be left open and unpaid. To address this, you should record the payment once your customer completes the payment. For detailed guidance on how to do this, please refer to the article: Record Invoice Payments in QuickBooks Online.

 

Additionally, learn how you can maintain financial integrity, improve operational efficiency, and ensure compliance with external regulations. Go through this article for reference: Reconcile Accounts in QuickBooks Online.

 

If you have any other questions about bounce checks or anything about invoices, let us know. We're always here to further assist you. Have a great day!

Grimayoj
Level 3

Sale to customer then check was recieved and bounced then customer reissued check and it cashed QBO

Ok so there seems to be some confusion.. Here is what my Bank register(QBO) looks like and matches my bank account. 

BANK ACCOUNT                              QBO INVOICE TRANSACTIONS 

11/15 - 6500 Credit                            10/31 INVOICE PAID(CHECK) BUT LATER BOUNCED

11/20 - 6500 Credit                             10/31 NEW INVOICE PAID VIA ACH 

11/20 - 6500 Debit                               11/20 EXPENSE ITEM

This is what QBO Sales EXPORT LOOKS LIKE 

DateTypeNo.CustomerAmountStatus  
11/20/2024Expense XYZ 6,500.00paid  
11/20/2024Payment XYZ -6,500.00applied  
11/15/2024Payment XYZ -6,500.00applied  
10/31/2024Invoice868XYZ 6,500.00paid  
10/31/2024Invoice805XYZ 6,500.00overdueTHIS INVOICE IS OPEN

 

IM ATTACHING A PRINT SCREEN OF THE EXPENSE APPLIED TO THE ORIGINAL INVOICE 805...  Which is the invoice that had the bounced check... Invoice 868 was the new invoice I resent to the customer and they paid via ACH and it cashed. 

AlverMarkT
QuickBooks Team

Sale to customer then check was recieved and bounced then customer reissued check and it cashed QBO

Hi, @Grimayoj. It can be quite tricky when dealing with bounced checks and re-issuing payments, especially when it impacts your accounts and reports. I see that your bank register reflects the original sale, the bounced check, and the reissued check, but you're running into an issue with your A/R Aging report showing an outstanding balance. Let's go through the right entries in QuickBooks Online (QBO) to ensure your records match accurately and that your reports reflect the correct status.

 

The process in handling bounced checks QuickBooks Online (QBO) is recording the returned payment as an expense transaction and assigning it to the Accounts Receivable (A/R) category for the customer who made the payment. This allows you to apply the original payment to the expense when using the Receive Payment function, effectively offsetting the bounced payment and reopening the original invoice so you can resend it to your customer which my previous colleagues may have mentioned in this thread.

 

Ideally, there's no need to create and reissue a new invoice since we can use the same original invoice to capture the second successful ACH payment. I understand that otherwise can happen and I appreciate you further clarifying the situation. To resolve this, we can recategorize the expense transaction from A/R to the same item in your original invoice so your income isn't overstated. You can follow these steps:

 

  1. Go to Customers & leads on the left navigation panel. Then, pick Customers.
  2. Locate the customer profile and click on it.
    image (17).png
  3. Under the Transaction list tab, locate the expense transaction and click on Edit.
    image (18).png
  4. Delete the Accounts Receivable line item in the Category details section.
    image (19).png
  5. From the Item details, choose the item Product/Service in your original invoice.

    image (20).png
  6. Optional: Enter a memo indicating that this is a bounced payment for tracking purposes.
  7. Ensure that the Payment Method, Payment account, and Payment Date are correct.
  8. Hit Save and close.

 

After this, reopen the Receive payment transaction to relink the original invoice payment to Invoice 805. Then, ensure that the second successful payment is linked to Invoice 868. You can follow these steps:

 

  1. On the same customer profile page, locate the first Payment transaction. It should show as Unapplied under the Status column.
  2. Click on View/Edit.
    image (22).png
  3. Place a checkmark for Invoice # 805.
    image (23).png
  4. Select Save and close.
  5. Repeat Steps 1 to 4 for the second payment.

 

Then, you can run the Profit and Loss report to ensure everything is recorded accurately. 

 

When this is resolved, match your transactions in QBO with the downloaded transactions in your bank feed. I'm adding this article as a guide: Confirm suggested matches for bank transactions in QuickBooks Online.

 

I hope this information helps you resolve the recording bounced payments in QuickBooks Online (QBO). If you have any other questions or need further clarification, feel free to click the Reply button, and we’ll do our best to assist you. Take care!

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Expert help for your business tax return

Susan, Business Tax Expert since 2010

File your business taxes with confidence thanks to our 100% accurate guarantee.

Explore QuickBooks Live Tax

QuickBooks Live Tax, powered by TurboTax

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up