Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
ReymondO
Moderator

Reply to message

Let me help you import these transactions into QuickBooks Online (QBO), @nolanneal.

 

When you the CSV file to manually upload your bank transactions, you'll have to make sure that its data is in correct format. This way, you can import them successfully into your bank register. 

 

There are two ways on how you can properly format your transactions when you create them in your Excel file. First, you can use the 3 column format. This will show the date on the first column, description on the next column, and amount on the last column. 

 

The other option is the 4 column format. This format has a Date, Description, Credit, and Debit column. You can check out this article for more information and review the format of the CSV file you got from your bank: Format CSV files in Excel to get bank transactions into QuickBooks.

 

In addition, you'll have make to sure that you're using an correct bank account when uploading these transactions. This way, they will be reported into your books once you're done reconciling them.

 

Once your transactions are in QuickBooks, it’s time to match and categorize them. They will go into your accounts after you review them.

 

The Community always has your back, so please let me know if you have more questions.

Need to get in touch?

Contact us