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

credit expenses accidentally entered as deposit

credit expenses accidentally entered as deposit

 

Imported into QB online and the expenses show up as a deposit! How do I correct?

5 Comments 5
RenjolynC
QuickBooks Team

credit expenses accidentally entered as deposit

Thanks for visiting the Community space, NoNestor.

 

I'd like to help you correct the transactions.

 

When you say imported into QuickBooks Online, do you mean that the transactions are added in the Banking page? If so, transactions may have been incorrectly mapped. This is why your expenses are showing up as deposits.

 

What we can do is remove those deposits by excluding them.

 

Here's how:

 

  1. Go to Transactions Banking.
  2. In the For review tab, put a check mark on the duplicate transactions.
  3. Click the Exclude button.

Here's a sample screenshot for a visual reference:

 

 

After excluding these transactions, you can delete them in the Excluded section.

 

Then, review the file from your bank. If you have the 3 column format, make sure that the amount for these expenses are entered as negative. Here's a sample screenshot for a visual reference:

 

After editing the file, import the transactions again by going to Transactions > Banking > Upload from file

 

To learn more about the formats and manually importing your bank transactions, please check out these articles:

 

Once you have the correct transactions, you start categorizing and matching them. 

 

Please let me know if you have any additional questions or other concerns. I'll be around to help you out again. Take care and stay safe.

NoNestor
Level 1

credit expenses accidentally entered as deposit

&hanks/ When I go into Banking and click the Exclude button it says nothing excluded. Did I accept those and make the problem worse?

JasroV
QuickBooks Team

credit expenses accidentally entered as deposit

Thanks for getting back and for sharing an update with us, Nestor.

 

There's a great chance those transactions were already accepted. Rest assured I got the steps on how to exclude them and fix this issue. 

 

You'll want to go to the Categorize tab in your Banking page and undo those transactions. This way, they'll be visible in the For review tab and you can exclude them from there. I'll show you how.

 

  1. Go to the Banking or Transactions menu in your QuickBooks Online (QBO) account.
  2. Select the Banking tab and click your preferred bank account.
  3. Go to the Categorized tab.
  4. Locate the transaction you want to delete and click Undo under the ACTION column.
  5. Go back to the For review tab, locate and select the transaction you've removed from the Categorized tab, then select Exclude.

 

You can also check this link for the complete details: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Once done, you can refer to the steps shared by colleague RenjolynC on how to seamlessly map and upload your bank transactions

 

Furthermore, I also recommend working with your accountant to ensure your account is well accounted for. When everything looks good, you might want to read these resources for references. These contain details on how to seamlessly match your transactions and reconcile your accounts:
 

 

I'm always here ready to back you up whenever you need help with your bank transactions. Please feel free to tag me in your reply and I'll get back to you as soon as I can. Stay safe and have a great weekend ahead!
 

NoNestor
Level 1

credit expenses accidentally entered as deposit

Thank you.  That was helpful. Was able to exclude the transactions. In the original reply it mentioned deleting after excluding. After hunting around I did not see how to do that. Possible to send a screenshot on how to do that?

JessT
Moderator

credit expenses accidentally entered as deposit

I'm glad you were able to exclude your transactions, NoNestor.

 

In order to delete the ones you've excluded, you can check out the Excluded tab, select the transactions you want to delete, and click the Delete button.  I made sure to include a screenshot for you.

 

 

When you re-upload your transactions, you’ll want to be sure you map the columns correctly to avoid interchanging the amounts. If the deposit and the payment columns are separated in the file, just tell QuickBooks which column name is for Money Received and for Money Spent.

 

Here's a screenshot of an actual mapping of columns:

 

 

After uploading, you can proceed to categorizing and matching your transactions. I can see that my colleague, JasroV, has shared an article about this, which has an embedded video tutorial for your visual reference. Feel free to check it out.

 

Let me know if there's anything more that I can help you with your bank transactions. I'll be happy to lend a hand.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us