Skip to main content
Jun 25, 2024 11:48 AM UTC
Question

Upload of Bank Statements

Can I upload my bank statements in excel or CSV format into quickbooks and then reconcile to the appropriate accounts 

2 replies

Jun 25, 2024 12:40 PM UTC

You can use an importer tool as a workaround and it's a $199 one time license. You can get $100 cashback to purchase it via a partner.

(affiliate link removed by moderator)

 

Jun 25, 2024 1:44 PM UTC

Welcome to the Community, @adwoaaa. Let me share information about uploading bank statements to QuickBooks Desktop.

 

To begin with, please know that the option to upload bank statements using CSV files or Excel is currently unavailable. However, QuickBooks offers two ways to upload bank transactions: direct connect or web connect.

 

For further information and detailed guidance about direct connect and web connect, please refer to these articles:

 

Once you've successfully uploaded your bank statements, I suggest categorizing the transactions before reconciling them to keep your financial records accurate. You can check out these articles for further details:

 

Additionally, you can utilize our rules feature to ensure that every transaction is accurately captured and assigned to the correct account.

 

I'll be around if you need further assistance uploading your bank transactions. Have a wonderful day.