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

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

 
Solved
Best answer April 30, 2020

Best Answers
MirriamM
Moderator

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

You are most welcome, drhealer55. It's my pleasure to help.

 

I have checked if there's a report with other users experiencing the same situation about First Bank in Virginia, but we haven't received any. 

 

To isolate the issue, I recommend checking with First Bank in Virginia to check what's going on.

 

Moreover, I don’t want to leave you empty-handed, you'll want to visit our Community Help Articles hub in case you need some related articles in managing your account.

 

As always, you can get back to me if you have any additional questions. I'm here for you. Have a great day!

View solution in original post

19 Comments
ReyJohn_D
Moderator

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

Welcome to the Community, @drhealer55.

 

QuickBooks Online will categorize downloaded transactions as deposits when they appear as Received. This means they are money-in transactions deposited to your bank.

Also, QuickBooks Online will also categorize these transactions as deposits when there's a bank rule created.

However, you can change the category of these downloaded entries in the For Review tab before adding or matching them. Here's how:

 

  1. Go to the Banking menu.
  2. Click the For Review tab then look for the transactions that you wish to categorize.
  3. Choose a category in the Category drop-down ▼ .
  4. Hit Add once done.

A43.PNG A44.PNG

You may also read this article to know what to do in case you aren't able to download bank transactions or if you're having a bank error: Steps to do when bank transactions won't download or having a bank error.

 

Please let me know if I can be of any help. Take care and have a good one!

drhealer55
Level 1

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

Thanks for the reply. I do change the category but QB still adds it as a deposit even when the category is an expense.

It seems all of my banking transactions are being added as deposits. Is there a way to fix this?

drhealer55
Level 1

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

Thanks for the reply. I do change the category but the transactions are added as deposits even if the category is an expense.

It seems QB is adding all of my banking transactions as deposits. How do I fix this?

JessT
QuickBooks Team

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

I'll help you fix your bank transactions, drhealer55.

 

In this case, we'll exclude the imported ones since we can't change their placement (mapping) anymore. Then, we'll re-import them again using your web connect file. I'll guide you with the mapping.

 

If you're using a CSV file format, you'll want to map the amount column/s correctly. For example, if your transaction list has only one column for the amounts (money in/out), you'd need to select 1 column. Otherwise, you would select 2 columns and specify the one for Money Spent (money out) and Money Received (deposits). See more details about using a CSV file.

 

mapping columns.PNG

That's it. Web connect file formats other than CSV do not need to be mapped. If you use any of them, I'd suggest downloading a fresh file from your bank's website and re-import your transactions.

 

Next will be matching and categorizing your imported transactions, and then reconciliation.

 

I'm confident that your next import will be faster and easier. We're just around if you need help.

drhealer55
Level 1

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

Thanks for your reply. I think I have found the problem. I use Libre Office and the CSV version seems incompatible with quick books.  Is there a way around this?

Also I imported data directly from my bank using the "connect securely to your bank" option and I have the same issue with everything categorized as deposits.

I appreciate any assistance. 

 

Mark_R
QuickBooks Team

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

Hi there, @drhealer55.

 

Any CSV file can be imported to QuickBooks Online (QBO) as long as it has the correct template format. You can use either a 3-column or 4-column format to import your CSV files.

 

Please see attached screenshots below.

 

3 Columns

1.PNG

4 Columns

2.PNG

Before doing it, please make sure that you exclude the bank transactions that were imported as a deposit.

 

However, if the manually imported bank transactions still showing as deposits, I recommend contacting our Phone Support Team. This way, they can further investigate this matter and create an investigation ticket if other users experiencing the same. They can also provide additional troubleshooting steps to get this fixed.

 

To reach them, click the ? Help button at the top right corner and select Contact Us to talk with a live agent.

 

You might also want to check out this article to learn how to match bank transactions: Categorize and match online bank transactions in QuickBooks Online.

 

Please keep in touch if there's anything else I can do to help you succeed with QuickBooks. I've got your back. Have a great day and keep safe.

drhealer55
Level 1

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

Thanks for your reply. QBO will not accept the CSV file that libre office creates. This is the reason that I used the option to securely connect to my bank. The problem is that even those transactions are showing as deposits only.

MirriamM
Moderator

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

Thanks for the prompt response, @drhealer55.

 

QuickBooks Online (QBO) is a read-only app. Once you connect a bank account, it will bring in data based on the transactions posted into your bank account. To resolve the issue, you can exclude the transactions showing as deposits on the For Review tab and manually enter the transactions. Since transactions downloaded directly from the bank can't be modified.

 

To exclude, here's how:

  1. Click Banking on the left menu.
  2. Go to the Banking tab.
  3. Select the account.
  4. Go to the For Review tab.
  5. Put a checkmark mark beside the transactions.
  6. Hit the drop-down arrow next to Batch actions.
  7. Pick Exclude Selected.

 

On the other hand, I also recommend sharing the name of your financial institution to check if there are reported cases from other users.

 

Visit us again for any concerns you need assistance with. I'm here to help. Have a blissful day!

drhealer55
Level 1

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

Thank you. This is helpful.  My bank is first bank in virginia

MirriamM
Moderator

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

You are most welcome, drhealer55. It's my pleasure to help.

 

I have checked if there's a report with other users experiencing the same situation about First Bank in Virginia, but we haven't received any. 

 

To isolate the issue, I recommend checking with First Bank in Virginia to check what's going on.

 

Moreover, I don’t want to leave you empty-handed, you'll want to visit our Community Help Articles hub in case you need some related articles in managing your account.

 

As always, you can get back to me if you have any additional questions. I'm here for you. Have a great day!

View solution in original post

drhealer55
Level 1

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

I think I have resolved the problem. Thanks for your help. I was able to download the data in QBO format and everything is now correct.

I appreciate everyone's help.

VVV2
Level 1

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

quick book bank.PNG

JonpriL
Moderator

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

Hello @VVV2,

 

Let me help share information about why you're seeing a VAT field in your bank transactions after uploading them.

 

When you start tracking sales tax, you'll be asked to assign a VAT code in any transaction including from your bank. You'll want to assign a VAT code of your uploaded transactions so you can save them in your register.

 

Additionally, you might also find this article helpful to ensure that you have the accurate bank account balance that corresponds with the transactions in your bank statement: Reconcile an account in QuickBooks Online.

 

You can always leave a comment below if you have any other questions aside from reviewing your bank transactions. Stay safe!

VVV2
Level 1

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

Please help on this with proper step wise solution I am still lacking to get this resolved.

 

Capture.PNG

VVV2
Level 1

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

Please advise to help on this step wise that we don't get Tax* with normal process we do just debit and credit positing to the proper account.

BettyJaneB
QuickBooks Team

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

I got you covered in assigning VAT code to your transactions in QBO, @VVV2.

 

The error that you've encountered usually occurs if you're tracking taxes using the Accounts Payable or Accounts Receivable type of accounts. The system will only allow you to track taxes on the expense, checking, and income accounts.

 

To fix this and get your work done, you'll need to create an invoice or a bill so you can allocate a VAT code to the transaction. This way, it will be added to the appropriate bank account and will help show the tax amount you've paid. 

 

Here's a sample snip on how you can add a VAT code in the transaction without any error upon adding or categorising them: 

 

I'm also sharing this link with you that you can always check out in case you need assistance with applying VAT on your transactions in QuickBooks Online: How do I set up sales GST/VAT rates and use them on forms?

 

Let me know if you need additional information by clicking the Reply button below. I'm always right here to assist you. Take care!

Marsha Romero
Level 1

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

 

I have this same problem and can't find a way to fix it. I imported the transactions for last year 2020 from SaasAnt and it's not going to the correct account. All of the transactions show as a Bank Deposit. I can see the transactions of the Chart of Accounts but not on the actual Banking tab to categorize the transactions since they were not downloaded from the bank. The bank could only download automatically the transactions from the last three months. Please help! Thank you in advance!

Candice C
QuickBooks Team

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

Good afternoon, @Marsha Romero

 

Thanks for joining in on this thread. I hope your day is going well so far. I want to make sure that you're able to get back to running your business with your QuickBooks Online (QBO) account. 

 

Since you've already tried a few of the steps that we suggested, I recommend contacting our Customer Support Team. They'll be able to use a few more tools to help walk you through some additional steps and check the back end of your account. 

 

  1. Go to the Help icon in the top right-hand corner. 
  2. Press the Contact Us button. 
  3. Give a brief description of the problem and hit Let's talk
  4. Scroll down and choose to Get a callback

 

That's all there is to it. For future reference, check out our tutorials page to see other available features that might be able to help you and your business in the future. 

 

Let me know how it goes. I want to make sure that you're able to get back on track. The Community is always here to have your back. I'll always be around to help. Have a great day! 

dhardy
Level 1

When importing data from my bank all transactions are categorized as deposits. How do I fix this?

In case anyone is still experiencing this problem, I found that it's an issue in the CSV file. When it's downloaded from a bank, excel automatically designates the column with numbers as an "Accounting" format or "Currency" format, which makes it appear red in parentheses. QBO must read this number as positive. If you format the numbers in excel to the "General" type, it will change the column to basic negative numbers, which QBO seems to read correctly. This worked for me, hopefully it's helpful for someone else, too.  

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

Need to get in touch?

Contact us