CSV formats: QuickBooks Online accepts three columns (Date, Description, Amount) or four columns (Date, Description, Credit, Debit) for the documented bank transaction upload.
File requirements: Intuit's current US guidance specifies English-language transaction files, a maximum of 350 KB, and up to 1,000 transaction lines per upload.
Upload path: Go to All apps > Accounting > Bank transactions, then select the relevant account and Upload from file.
Map columns: Match your CSV fields to the corresponding QuickBooks fields and review dates and amounts.
Complete the import: Choose the transactions, continue, confirm, and review the imported records.
Avoid duplicates: Check which transactions are already present before uploading.
PDF statements: QuickBooks Online also documents direct PDF and image statement uploads, so separate PDF-to-CSV conversion isn't always necessary.
Need to add bank transactions to QuickBooks Online, but your bank connection isn't available or you have older transactions to import? You can upload a CSV file instead of entering each transaction manually. A QuickBooks CSV import brings transaction records from a properly formatted spreadsheet file into a selected bank or credit card account in QuickBooks Online.
The basic process is straightforward: prepare a supported CSV, open Bank transactions, upload the file, match its columns with QuickBooks fields, select the transactions, and confirm the import. The part that deserves the most attention is your data. Incorrect dates, reversed transaction amounts, duplicate records, and mismatched columns can create accounting problems even when the upload succeeds. This guide shows you the accepted CSV formats, how to complete the import, and how to check your books afterward.
What Is a QuickBooks CSV Import?
A CSV, or comma-separated values file, stores data in rows and columns.
For bank transactions, each row generally represents a transaction. The columns describe important details such as its date, description, and amount.
QuickBooks Online can read properly formatted CSV transaction files and bring that information into its Bank transactions workflow.
This is useful when:
Your bank isn't connected to QuickBooks.
A bank feed is temporarily unavailable.
You need to import older transactions.
You're preparing historical bookkeeping records.
A client gives you transaction information in a spreadsheet.
You're transferring bank transaction data from another approved source.
Importing is not the same as reconciling. Uploading creates transaction records for review; you still need to match, categorize, and reconcile them appropriately.
If your bank offers a direct QuickBooks Online (QBO) export, consider using it. Intuit recommends QBO for some manual upload workflows because it is designed for QuickBooks.
Before You Import: Check Your File and Account
A successful import begins before you open the Upload from file dialog.
Check Whether You Already Have the Transactions
If a bank feed is connected, QuickBooks may already contain some of the transactions you're preparing to upload.
Open the account's Bank transactions view and identify the most recent downloaded records.
Choose an import date range that avoids duplicating previously downloaded or manually entered items.
Be particularly careful when importing across the date when an automatic bank connection started.
Select the Correct Bank or Credit Card Account
The account selected during upload determines where the transactions appear.
For example, transactions belonging to a company credit card should not be imported into its operating bank account.
If the appropriate account doesn't exist in QuickBooks, review your Chart of accounts and create the required account through the supported workflow.
Check the CSV Limits
Intuit's current US documentation for QuickBooks Online transaction-list uploads specifies:
A CSV, QBO, QFX, or other supported transaction-list format.
A maximum transaction-list file size of 350 KB.
Up to 1,000 transaction lines per upload.
Consistent dates and recognizable transaction amounts.
These restrictions apply to the documented transaction-list import workflow, not necessarily to every PDF or image upload feature.
For a larger file, divide your records into manageable date-based batches without omitting or duplicating transactions.
How to Format a CSV for QuickBooks
QuickBooks Online supports two documented CSV structures for bank transaction imports.
Use one format consistently throughout the file.
Option 1: Three-Column CSV Format
The three required columns are:
Date, Description, Amount
This format uses one amount column with positive or negative values.
A typical example:
Date | Description | Amount |
01/10/2026 | Customer payment | 450.00 |
03/10/2026 | Office supplies | -75.50 |
05/10/2026 | Internet bill | -60.00 |
The corresponding CSV could be:
Date,Description,Amount
01/10/2026,Customer payment,450.00
03/10/2026,Office supplies,-75.50
05/10/2026,Internet bill,-60.00
Illustrative bank-account data only.
For a conventional bank-account import, money received is generally positive and money paid out is negative.
If you're importing credit card transactions, check the source's sign convention and the preview in QuickBooks before proceeding.
Option 2: Four-Column CSV Format
The second format uses:
Date, Description, Credit, Debit
A conceptual example is:
Date | Description | Credit | Debit |
01/10/2026 | Customer payment | 450.00 | |
03/10/2026 | Office supplies | 75.50 | |
05/10/2026 | Internet bill | 60.00 |
The corresponding CSV could be:
Date,Description,Credit,Debit
01/10/2026,Customer payment,450.00,
03/10/2026,Office supplies,,75.50
05/10/2026,Internet bill,,60.00
This example assumes the source uses Credit for money received and Debit for money paid out.
Bank statements and credit card records can use different conventions. Check your source and verify QuickBooks' field mapping and amount preview rather than relying on column names alone.
For each transaction, populate the relevant amount field and leave the unused field empty.
Important Formatting Rules
Before uploading, review these details.
Dates: Keep every date in a consistent format. Intuit currently recommends dd/mm/yyyy in its US transaction-list guidance, but you should also select the matching date interpretation in the import workflow.
Amounts: Use plain numeric values where possible. Avoid currency symbols and unexpected thousands separators that may confuse the import.
Zero-value fields: Intuit recommends leaving cells blank when the applicable Amount, Credit, or Debit field would contain only zero.
Column headers: Use simple headings matching the fields QuickBooks expects. For four-column files, Intuit specifically recommends Credit and Debit rather than headers such as “Credit amount” and “Debit amount.”
Descriptions: Keep transaction descriptions clear. Remove unintended formatting and investigate unusual characters if the import fails.
Extra columns: Remove unnecessary summary fields, running-balance columns, and unrelated information from the import copy if they interfere with field mapping.
Keep a separate original file so you can verify every transaction after cleanup.
How to Upload CSV Bank Transactions
These steps follow Intuit's documented QuickBooks Online US workflow.
The exact menu labels may vary between accounts, countries, and product versions.
Step 1: Open Bank Transactions
Sign in to QuickBooks Online.
Go to:
All apps > Accounting > Bank transactions
Open the relevant banking area.
Step 2: Select Upload from File
Choose the bank or credit card account associated with the transactions.
Select Link account, then Upload from file.
If the account isn't connected to online banking, you may see Upload from file or Or upload transactions manually instead.
Step 3: Choose Your CSV
Select Drag and drop or select files, then choose the prepared CSV from your device.
Select Continue.
If QuickBooks rejects the file immediately, inspect the format, file size, encoding, and date fields.
Step 4: Choose the Destination Account
Use the QuickBooks account dropdown to select the correct bank or credit card account.
If you're adding a new account, the interface may offer an Add New option.
Confirm the account carefully before continuing.
Step 5: Map the CSV Columns
QuickBooks asks you to match the columns in your file to its transaction fields.
Map the date, description, and amount fields according to the selected CSV structure.
For example:
CSV field | QuickBooks field |
Date | Date |
Description | Description |
Amount | Amount |
For a four-column file, map Credit and Debit to the corresponding supported fields.
Check the date interpretation and transaction sign preview.
Step 6: Review the Transactions
QuickBooks shows the records available for import.
Verify that amounts and transaction details are correct.
Select the transactions you want to import.
Avoid choosing records that already exist in your books.
Step 7: Confirm the Upload
Select Continue, then confirm using Yes and Done, following the on-screen prompts.
The selected transactions become available through your bank transaction workflow.
The exact buttons may vary with interface updates.
Step 8: Categorize and Reconcile
After importing, review transactions for categorization or matching.
Use the appropriate income, expense, transfer, or other accounting categories.
Then reconcile the account against the official bank or credit card statement.
For current instructions, see Intuit's manual transaction upload guide.
How to Check Imported Transactions
A successfully uploaded file can still contain incorrect financial information.
Before categorizing everything, review the data.
Confirm Transaction Counts
Compare the number of imported transactions with the number you intended to upload.
Exclude records you deliberately skipped because they were already present.
Review Positive and Negative Amounts
Check a known deposit and a known payment.
If their signs are reversed, stop before categorizing or adding more records.
Correct the source data or use the appropriate supported correction procedure.
Check the Date Range
Make sure the earliest and latest imported transactions fall within the expected period.
Dates that are interpreted incorrectly may make records appear in the wrong month or year.
Watch for Duplicates
Duplicates may arise when an import overlaps with a bank feed or earlier manual upload.
Before adding or matching records, inspect transactions with the same date, description, and amount.
Not all repeated amounts are duplicates, so compare them against the bank statement.
Reconcile the Account
Bank reconciliation is the final accuracy check.
Compare the transactions and balances in QuickBooks with the bank's official statement.
If the totals don't reconcile, investigate missing transactions, duplicate records, reversed amounts, fees, and timing differences.
How to Convert a PDF Bank Statement to CSV
Sometimes the bank provides only a PDF statement rather than a CSV transaction export.
There are two possible approaches.
Option 1: Upload the PDF Directly to QuickBooks
Intuit's current QuickBooks Online US documentation describes uploading an English-language PDF or image bank statement directly.
In this workflow, QuickBooks extracts transaction details and presents them for review.
Use the Bank transactions upload area, select your statement, and follow the review process.
Intuit notes that some documents may require additional review. Always check the extracted information before saving.
This feature's availability and processing conditions should be checked for your specific QuickBooks account.
Option 2: Convert PDF to CSV Before Importing
If you need a CSV for review, cleanup, or use in other applications, a separate conversion tool may be appropriate.
GoDocLab provides an online PDF to CSV converter.
Its published process is:
Upload the PDF statement.
Confirm the selected document.
Select Process PDF to CSV.
Download the generated converted.csv.
Check the extracted rows and columns.
Restructure the data into one of QuickBooks' supported CSV formats.
GoDocLab's public page lists a maximum PDF upload size of 100 MB and advertises free conversion.
Important: A generic PDF-to-CSV file is not automatically ready for QuickBooks. It may contain balances, duplicate headers, extra columns, or misread transactions.
If your PDF contains scanned images, a separate OCR workflow may be necessary.
For a detailed explanation, see GoDocLab's guide to converting PDF bank statements to CSV.
Common CSV Import Problems and Fixes
Problem | Likely cause | Recommended fix |
File is rejected | Unsupported structure or file exceeds requirements | Use a supported format and divide oversized uploads |
Columns don't match | Incorrect header names or mapping | Recheck three- or four-column format |
Wrong transaction signs | Bank or credit card sign conventions | Compare known transactions and correct the mapping |
Dates import incorrectly | Ambiguous or inconsistent dates | Standardize dates and select the correct import format |
Some amounts are missing | Blank or malformed values | Compare the rows against the source |
Duplicate transactions | Overlap with bank feed or previous upload | Review the existing account history |
Unexpected characters | Encoding or special-character problems | Review CSV encoding and clean affected fields |
Wrong account receives transactions | Incorrect destination selected | Follow Intuit's supported correction workflow before reimporting |
The CSV Has Too Many Columns
Remove columns that aren't needed for importing transactions.
For example, a PDF-derived file may include a running Balance column, document headers, or transaction reference fields.
Keep the required transaction fields in the correct structure for the selected workflow.
QuickBooks Cannot Read the Dates
Dates such as 05/06/2026 can be interpreted in more than one way.
Confirm the intended source format and make every row consistent.
When QuickBooks asks for date mapping, choose the matching option.
The File Contains Invalid Amounts
Inspect currency symbols, comma separators, unusually large amounts, and nonnumeric text.
Intuit also documents a specific error involving transaction amounts with 12 or more digits. Check its bank upload error guide when you encounter that issue.
Don't silently alter a financial amount simply to make it import successfully.
The Import Worked, but Transactions Are Missing
Check which rows you selected during the import.
Then compare transaction dates and amounts with the source file.
Also inspect any import errors and confirm that records weren't excluded or previously added.
Transactions Were Imported Twice
Stop further uploads and review the duplicates.
Use QuickBooks' supported exclusion or correction workflow, depending on their status.
If transactions have already been categorized or reconciled, consider consulting your bookkeeper before making changes.
QuickBooks Online vs Desktop
The steps in this article are written for QuickBooks Online bank transaction imports.
QuickBooks Desktop has different import features and supported formats. Do not assume that the same CSV workflow applies to Desktop's bank-feed transactions.
Similarly, importing invoices, customers, products, or journal entries involves different requirements from importing bank transactions.
Before following a tutorial, confirm both the QuickBooks product and the type of data being imported.
Privacy and Financial Data Safety
Bank files often contain account details, balances, transaction descriptions, and other sensitive financial information.
Use trusted export and import workflows, and follow your organization's data-handling requirements.
If you use a third-party PDF converter, check its privacy policy before uploading bank statements.
GoDocLab's Privacy Policy describes HTTPS transfers, server-side processing, and automatic removal of processed files. Those are the site's published practices, not an independent security certification.
Keep backup copies of your source files, but store them securely.
Avoid sharing real financial CSV files or screenshots containing bank account numbers when asking for troubleshooting help.
Final Thoughts
A successful QuickBooks CSV import depends on more than choosing a file and clicking Upload.
Start with the correct CSV structure, confirm the target account, review date and amount formatting, and check for existing transactions before importing.
Then map the fields, review the results, categorize records, and reconcile them against your bank statement.
If your transaction data is trapped in a PDF, GoDocLab's PDF to CSV converter can provide a starting point for creating an editable file. Just remember to validate and format the resulting data before uploading it to QuickBooks.
Taking a few extra minutes to verify the input can save significantly more time correcting accounting errors later.
FAQs
Frequently asked questions
Yes. QuickBooks Online supports CSV bank transaction imports when the file meets the applicable format and size requirements.