cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
info1695
Level 1

Bank import with only spend monies comes in as received money in quickbooks. how do I fix

 
1 REPLY 1
jamespaul
Moderator

Bank import with only spend monies comes in as received money in quickbooks. how do I fix

Hello, info1695.

 

I have a couple of solutions to help you fix the imported expense entries from your bank. 

 

Are you using an Excel file to import your bank transactions? You'll want to check your formatting and ensure the expense and income entries are formatted properly. 

 

Make sure that your income is formatted as positive value, while the expenses have the negative signs. 

 

Check this article for more details about the proper file formatting: Format CSV files in Excel to get bank transactions into QuickBooks.

 

Though if you're importing those transactions automatically, you'll want to check your bank's website and how it imports data to third-party software. QuickBooks relies on what the bank sent us. There's likely a setting that causing the expenses to import as income. 

 

Also, you can check your bank's support channel and see if there are any issues on importing transactions. 

 

I would also like to know the name of your bank. That way, I can check for any import-related issues in our end. 

 

After fixing the issues, do you need help categorising your transactions for your books and your reconciliation? We have a couple of articles can serve as a guide: 

 

 

If you need more help categorising your transactions or managing your bank entries, please let me know the details below. I'll hop right back to this thread and help you out. 

Need to get in touch?

Contact us