cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want an expert to help you set up your QuickBooks Online? Find out how: Click here

Reply to message

View discussion in a popup

Replying to:
ChristineJoieR
QuickBooks Team

Reply to message

Thanks for making your first post here in the QuickBooks Community forum. I'll share insight that could help you get through this, @waqarakram. I understand each bank formats CSV files differently, so it is vital to check the format of the CSV file received from the bank to ensure it can be uploaded into QuickBooks Online.

 

When importing a CSV file, the available balance column can be used to update the ending bank balance. However, you may need to map the column to the appropriate field during the import process and ensure that it accurately reflects the actual bank balance. After importing, review and reconcile your account to ensure accuracy.

 

QuickBooks can handle CSV files with either a 3-column or 4-column format, which includes the Date, Description, and Amount columns or the Date, Description, Credit, and Debit columns, respectively. Check out this article for more information: Format CSV files in Excel to get bank transactions into QuickBooks.

 

I'm always around and ready to help if you have more questions about organizing your banking transactions. Just click the Reply button to add your comment so I can further assist you. Keep safe, @waqarakram.