Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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.