cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Established Member

Handling Deposits after a bounced check is recorded.

I recorded a check as "bounced" that was rejected by the bank, due to "hundred" not being written out correctly. The invoice shows unpaid, and it automatically recorded the journal entry correctly. However, the deposit still shows for the full amount. Do I need to manually correct the deposit, or will QB due this function automatically? The owner, always wants the reconciliation to match exactly. 

 

Thanks in advance! 

3 Comments
Established Community Backer *

Re: Handling Deposits after a bounced check is recorded.

When you say that the QuickBooks corrected this have you looked at the correcting entry in journal entry form?  The original deposit should show as this was the deposit made and will correspond to a line item on your bank statement.  There should be a second entry for the amount of the bounced check.  The entry is a credit to the bank account in the amount of the bounced check and a debit to accounts receivable in the same amount.

Community Contributor *

Re: Handling Deposits after a bounced check is recorded.

I had a check get returned.  Both the original deposit and the return from the bank are showing as deposits and making it unable to be reconciled.  How do I change one to a debit so that it balances?  

Thanks!

QuickBooks Team

Re: Handling Deposits after a bounced check is recorded.

Hello there, @Cari_Rose.

 

I'm glad you've reached out to the QuickBooks Community. Let me help guide you on correcting your recording transaction in QuickBooks Online (QBO). 

 

In this case, you can exclude the transaction in QBO then manually upload it again. From there, you can select the debit when mapping the bank statement. 

 

To exclude the transaction, here's how:

  1. Go to your Banking tab.
  2. In the For Review window, put a check mark on the transaction. 
  3. Go to the Batch Actions drop-down and choose Exclude SelectedCapture.PNG

Once done, you can now upload or import the bank transaction by following these steps:

  1. On the Banking page, click the Update drop-down arrow, then choose File upload.
  2. Click Browse to select the file, then click Next.
  3. Choose the bank account, then click Next.
  4. Under CSV file has amounts in, choose 2 column: separate positive and negative numbers.
  5. Under Money Spent, choose Credit.
  6. Under Money Received, choose Debit.
  7. Click Next.
  8. Review the transactions on the Select the transactions to import page, then click Next.
  9. You'll receive a message, "QuickBooks will import 4 transactions using the fields you chose. Do you want to import now?, click Yes.

For additional reference, you can check this article on how to import bank transactions using Excel CSV files

 

If you need further assistance with the steps, I recommend contacting our QuickBooks Online Support Team. They have additional tools to pull up your account and do a screen-sharing.

 

Here's how to contact our customer support:

  1. Sign in to your QuickBooks Online company.
  2. Select Help (question mark icon) at the top right.
  3. Select Contact us to connect with a live support agent.

For future reference, you can also visit this article for the detailed steps and video tutorial on how to reconcile your accounts

 

This should get you on the right track. Fill me in if you have additional questions about excluding or uploading banking transaction. I'm always here to help you out.