QuickBooks Bank Statement Import Template (CSV Format + Examples)

Short answer: QuickBooks does not provide a downloadable import template, but it accepts a bank statement CSV in one of two fixed layouts. The 3-column template is Date, Description, Amount (money out is negative). The 4-column template is Date, Description, Credit, Debit (deposits in the credit column, withdrawals in the debit column). Build your file to match one of those exactly, keep it under 1,000 rows and 350 KB, and QuickBooks will read it.

People search for a "QuickBooks bank statement import template" expecting a file to download from Intuit. There isn't one. Intuit's own guidance says QuickBooks does not supply a CSV template because you are meant to download the file from your bank. That leaves you to build the template yourself, which is easy once you know the two layouts and the handful of formatting rules below. Copy the examples, drop your data in, and upload.

The QuickBooks Online CSV import template

QuickBooks Online reads exactly two column layouts on the bank upload, and nothing else. Pick one, use its header row, and keep every column in the order shown. Here is each template with real example rows you can copy straight into a spreadsheet.

3-column template (Date, Description, Amount)

Use one signed Amount column: deposits are positive, withdrawals are negative. This is the simplest template and works for most checking and savings statements.

Date,Description,Amount
07/01/2026,Opening Deposit ACH Payroll,2450.00
07/03/2026,Square Inc Deposit,318.55
07/05/2026,Comcast Business Bill Pay,-149.99
07/08/2026,Check 1042,-800.00
07/12/2026,Amazon Web Services,-64.20

4-column template (Date, Description, Credit, Debit)

Use this when your bank splits money in and money out into two separate columns. Put deposits in the Credit column and withdrawals in the Debit column, and leave the other cell blank on each row.

Date,Description,Credit,Debit
07/01/2026,Opening Deposit ACH Payroll,2450.00,
07/03/2026,Square Inc Deposit,318.55,
07/05/2026,Comcast Business Bill Pay,,149.99
07/08/2026,Check 1042,,800.00
07/12/2026,Amazon Web Services,,64.20

Both templates produce the same result inside QuickBooks. Choose whichever matches how your bank exports its data, so you do the least rearranging.

Does QuickBooks provide a CSV import template?

No. QuickBooks does not provide a downloadable CSV template for bank transactions. Intuit's position is that you download the CSV directly from your financial institution, then reshape it into the 3-column or 4-column layout above before uploading. So the "template" is really just those two column structures. Recreate one in a blank spreadsheet, or convert your statement into that shape, and QuickBooks treats it exactly as if Intuit had handed you a file.

QuickBooks CSV template formatting rules

Matching the columns is half the job. The other half is formatting each cell the way QuickBooks expects. These rules clear almost every rejected import.

The two rules people miss most often: a stray comma inside a description splits the row into extra columns and breaks the whole file, and a Category column makes QuickBooks reject the upload because it only accepts three or four columns. QuickBooks ignores categories on import anyway, so you categorize the transactions inside the For Review tab after they load.

Credit card statement template (watch the signs)

Credit card CSVs often list amounts in reverse. On a card, a purchase increases what you owe and a payment reduces it, so some banks export purchases as positive and payments as negative, the opposite of a checking account. Two things keep this correct. First, when you upload the file, select the credit card account in QuickBooks, not a bank account, so QuickBooks interprets the signs the right way. Second, check a few rows after import: a large purchase should read as an expense and your monthly payment should read as a payment, not the reverse. If they are flipped, invert the sign on the Amount column and re-upload.

QuickBooks Desktop vs QuickBooks Online templates

The templates above are for QuickBooks Online. QuickBooks Desktop imports bank data differently: it prefers a Web Connect (.qbo) file or a mapped CSV brought in through a third-party import tool rather than the same drag-and-drop upload. The column data you need, date, description, and a signed amount, is the same, but the import path is not. If you are on the desktop edition, follow our companion guide on how to import bank transactions into QuickBooks Desktop so you use the right method for your version.

How to turn a PDF statement into the QuickBooks template

Most people reach this page because their bank only gives them a PDF statement, and QuickBooks will not read a PDF. You have two options. You can retype every line into the template by hand, which is slow and one wrong sign throws off the reconciliation, or you can convert the PDF automatically. A bank statement converter reads the statement and outputs the date, description, and amount columns already in the layout QuickBooks wants, so the file is import-ready without manual typing. From there, the convert bank statements to QuickBooks tool builds the exact CSV shape, and if you would rather hand QuickBooks a native file than a spreadsheet, our walkthrough on how to convert a bank statement PDF to QuickBooks covers the QBO Web Connect route. For the full upload steps once your template is filled in, see how to import bank transactions into QuickBooks Online.

Common template errors and how to fix them

When a file that looks right still fails, it is almost always one of these:

• "Some info may be missing from your file." A header name does not match or there is an extra column. Rename the headers to Date, Description, and Amount, and delete any column QuickBooks does not use, including Category and Balance.
• Amounts import blank or doubled. A dollar sign or thousands comma is being read as a column break. Strip $ and , from the amount column and leave plain numbers like 1042.50.
• Every row lands on the wrong date. The column mixes formats. Reformat the entire Date column to MM/DD/YYYY before saving as CSV.
• File rejected as too large. You exceeded 1,000 rows or 350 KB. Split the statement by month and upload each month separately.
• Deposits and withdrawals reversed. On the 3-column template, money out must be negative; on the 4-column template, withdrawals go in the Debit column. For credit cards, select the credit card account on upload.

If your starting point is already a CSV from a bank or app and you want a native QuickBooks file instead of a plain upload, a dedicated CSV to QBO converter turns that spreadsheet into a .QBO Web Connect file, and if you are working straight from the statement document, a PDF to QBO converter takes the PDF to the same finished file. Either way, once your data sits in the 3-column or 4-column template, importing a bank statement into QuickBooks takes under a minute.