How to Import Bank Statement CSV into QuickBooks

QuickBooks is one of the most popular accounting platforms, and importing bank transaction data via CSV is a common workflow. This guide covers both QuickBooks Online and QuickBooks Desktop.

Preparing Your CSV

QuickBooks expects CSV files with specific columns. The most commonly accepted format includes:

Some versions also accept separate Debit and Credit columns instead of a single Amount column.

QuickBooks Online Import

Step 1: Navigate to Banking Go to Banking in the left sidebar, then select the account you want to import into.

Step 2: Upload CSV Click "Upload transactions" and select your CSV file.

Step 3: Map Columns QuickBooks will ask you to map your CSV columns to its expected fields. Match Date, Description, and Amount.

Step 4: Select Date Range Choose the date range for the transactions you are importing.

Step 5: Review and Accept QuickBooks will show a preview of the imported transactions. Review them and click "Accept" to add them to your account.

QuickBooks Desktop Import

Step 1: Open Web Connect Go to File > Utilities > Import > Web Connect Files.

Step 2: Select File Choose your CSV file. Note that QuickBooks Desktop prefers QBO format, so you may need to convert your CSV to QBO first.

Step 3: Select Account Choose which account the transactions belong to.

Step 4: Review Review the imported transactions in the banking register.

Tips for Smooth Imports

• - Make sure dates match QuickBooks' expected format
• - Remove any header rows that QuickBooks might misinterpret
• - Keep the file under 350 transactions for online imports
• - Always reconcile after importing to catch any discrepancies

Using letPdf with QuickBooks

letPdf's CSV output is formatted to be compatible with QuickBooks import. After converting your bank statement, you can import the CSV directly without additional formatting.