Skip to main content
September 2, 2021
Question

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

  • September 2, 2021
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

September 2, 2021

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.