Upload Bank Statements to QuickBooks Online
Choose the upload route after checking what is already in the account. A missing bank feed, an older statement, and a few omitted transactions need different date ranges. Keep the original statement and record the gap you intend to fill.
Intuit's current US guide supports account statements as PDFs or images, as well as transaction-file uploads. Its statement guidance specifies English-language sources; its transaction-list guidance names QBO, QFX, and CSV.[3] An external converter is an option, not a prerequisite for every PDF.
Decide between statement and transaction uploads
PDF or image: Use the native statement route if it is available in your account. Review the extracted entries against the statement rather than treating automated extraction as approval.
Bank transaction export: Prefer an existing bank download when it covers the required account and period. Keep it unchanged until you know whether cleanup is necessary.
CSV from a PDF: Use a reviewed CSV when you want explicit control over rows and mapping, or when the native route is unsuitable. Open the converter to review its available exports, then check the resulting data before uploading. For paper sources, first follow the scan preparation guide.
Prepare dates and amounts
Make a dedicated import copy rather than uploading a workbook with balances, subtotals, or formulas. For a checking account, document a signed-amount convention: deposits positive, withdrawals negative. A separate Credit/Debit layout needs its own mapping; do not mix layouts in the same file.
Use one date format throughout and identify whether the source means month/day/year or day/month/year. Remove weekday text from date cells. Keep payee descriptions readable, but retain an unedited source copy when applying importer-specific cleanup. Inspect transaction references separately instead of using them as monetary values.
Worked example: illustrative three-column CSV
Date,Description,Amount
09/02/2026,Client payment,900.00
09/03/2026,Office supplies,-42.50
For these dates, choose month/day/year in the import mapping. Verify that the client payment appears as money received and the supplies payment as money spent. The illustrative movement is 857.50. With an opening statement balance of 1,000.00, the expected closing balance is 1,857.50.
This example uses a checking account, not a credit-card liability. If an issuer export uses a different sign convention, inspect a known purchase and a card payment before accepting the mapping. Do not reverse signs solely to make a displayed total look plausible.
Upload and pause at review
Intuit's current navigation is All apps → Accounting → Bank transactions, then Upload from file. Select the existing target account. For CSV, map the fields and choose the transactions to import; for PDF or image, review the side-by-side extraction and edit items needing attention.[3]
Check the account, period, first and last rows, and a deposit/withdrawal pair. Stop if dates or signs are reversed. If the upload fails, retain the error text and correct one issue at a time instead of changing the file extension or retrying blindly.
For transaction lists, Intuit specifies a 350 KB maximum and up to 1,000 transaction lines per upload.[3] Split larger work into clearly named, non-overlapping ranges and verify each range separately.
Match before creating another entry
After upload, review the bank transactions. Intuit's current guide calls the review area Pending; older interfaces may use other labels. Match an existing entry when appropriate instead of posting a duplicate.[4]
For example, a customer payment already recorded against an invoice needs matching, not a second income entry. Transfers and card payments also deserve a check on both affected accounts. Compare the completed period with the statement and investigate differences; an upload success message is not reconciliation.
Keep an import log and check overlap when reconnecting a feed. For file selection, see OFX vs QBO vs IIF. For spreadsheet cleanup, use CSV to Excel.
Official sources
[3] Intuit: Manually upload transactions into QuickBooks Online.
[4] Intuit: Categorize online bank transactions.