How do I get bank and credit-card transactions or statements into my accounting software (e.g., QuickBooks)?

Which intake route fits each account?

Bank and card activity reaches the books by one of four routes, and they differ in reach, refresh, what arrives and the work they leave behind:

Intuit's help for QuickBooks Online says a connection lets you automatically download your latest transactions, and that the first download reaches back anywhere from 90 days to 24 months, depending on the bank. Intuit also notes that the feature is limited on the QuickBooks Online Free and Lite plans. Zoho's help for Zoho Books says a new connection can fetch transactions from the last 90 days, and that feeds are fetched automatically every 24 hours for banks that don't require multi-factor authentication, while feeds from a bank that does must be refreshed by hand.

Some card programs sync straight into the accounting software. Ramp's documentation for its QuickBooks Online integration, for example, says it syncs credit card transactions as credit card transactions in the accounting software. Ramp's overview says the sync creates them as expenses in QuickBooks but doesn't say whether they wait in the For review tab; after the first sync, check where they appear.

Choose per account, not per business:

Entering individual transactions by hand is covered as its own question.

How do you set up a direct connection?

In QuickBooks Online, create each ledger account first: in Chart of accounts, select New and choose Bank for checking or savings or Credit card for a card, as Intuit's help describes. Pick that account when you connect or upload; for a card, don't use Add New on the upload screen, which Intuit says creates a bank account.

Intuit's help says an accountant can't connect a client's bank account; the client must do these steps. Intuit's help for QuickBooks Online sets out the connection in this order:

1. Go to Bank transactions, choose to connect an account and search for your institution. If it isn't listed but you can sign in to its website, Intuit says to use Request a provider to ask for it to be added. Intuit says American Express Business accounts can't be connected this way and names no alternative, so plan a file or statement upload for such a card.
2. Sign in with your online banking credentials and complete any extra security step the bank asks for.
3. Select the specific accounts you want to bring in. Intuit's steps don't show where each is linked to a ledger account, so confirm each link before you select Connect.
4. Choose the start date for downloading transactions from the date range list, deliberately, as described under the start-date question below.
5. Select Connect. QuickBooks downloads recent transactions to the Bank transactions tab, where you review, categorize and add them.

Zoho's help for Zoho Books follows the same pattern: you select the date from which to fetch transaction history, and you import statements for anything before that date. If Zoho Books can't find your bank, Zoho's help says to add the account manually, which leaves file import or manual entry as the routes.

When one login holds several accounts, such as an operating account, a reserve account and two cards, give each its own ledger account. After the first download, open each ledger account and confirm its arrivals belong there; a card purchase in the checking account means two links are crossed. For cards that share one statement, Intuit's subaccount guidance says to connect only the parent account if the transactions download to one account, and to connect the subaccounts, not the parent, if they download to each card separately. It adds that you can't connect both a parent account and its subaccounts.

How do you import a downloaded file?

When you bring in history older than a QuickBooks Online account's start date, move its opening balance too, or the older activity is counted twice. Intuit's help says you change it by editing its date and amount in the account register: set them to the beginning date and opening balance of the earliest statement you bring in.

Start at the institution. Wells Fargo, for example, says business customers can download account activity for QuickBooks (Web Connect), Quicken or a spreadsheet, covering the last 90 days by default and up to 18 months where available. Other institutions set their own formats and ranges.

Then check the shape your software accepts. Intuit's help says QuickBooks Online takes a list of transactions as a QBO, QFX or CSV file of 350 KB or less and up to 1,000 lines per upload, or an account statement as a PDF or image. Intuit adds that a CSV needs either three columns (Date, Description, Amount) or four (Date, Description, Credit, Debit). Zoho's help says Zoho Books imports CSV, TSV, OFX, QIF, CAMT.053, CAMT.054 or MT940 files, and PDF statements only from the banks and card issuers Zoho lists; it asks which amount layout the file uses, such as one column where positive values are deposits and negative values are withdrawals.

Intuit's help for QuickBooks Online sets out the upload in these steps:

1. From Bank transactions, choose to upload from a file and pick the file.
2. Select the account you want to upload the transactions into.
3. Match the columns in the file with the QuickBooks fields.
4. Select the transactions you want to import from the list QuickBooks shows, then confirm.

Intuit's prerequisites add that the record or statement must start at least one day before your oldest QuickBooks transaction in that account, so upload older history before you move the opening balance back. Intuit's help doesn't explain how the condition applies to routine uploads of later dates.

Zoho's help describes the same stages as a Map Fields tab, where file headers are mapped to Zoho Books fields, and a Preview tab, where you check for errors or unmapped fields before the import completes.

The list shown before you confirm is the last cheap check. Test three lines you know: a deposit, a payment out, and the earliest date. If a deposit reads as money spent, the file's sign convention is the reverse of what the software expects and every line is backwards; fix the mapping or the file instead of importing. Check the dates as well, because a day-month mix-up moves items into the wrong period.

Intuit's steps for a PDF or image statement, which can come from any bank if it's in English, are these:

1. From Bank transactions, choose Upload from file and upload the statement.
2. Select the account the transactions go into.
3. Compare the side-by-side view of the statement with what QuickBooks extracted, edit anything that needs it, then select Save.

When a file is the only route, make it a routine tied to the statement. Each time a statement closes, download activity from the day after the last imported date through the closing date, import it, verify it against the statement, and save the statement. Keeping each file's range contiguous with the last one avoids most gaps and overlaps; the statement check catches the rest.

What changes for a credit card?

A card balance is money the business owes: purchases increase it and payments reduce it. The card must land in a credit card account, never a bank account. Zoho's help has you create a card with Credit Card as the account type, and Ramp's documentation says its default transaction account must be a Liability and Credit Card type in QuickBooks.

Direction is where card intake goes wrong. Intuit's CSV guidance explains that a card file may show a payment as a negative amount because paying your credit card reduces your balance, and says to choose the credit card account, not a bank account, when you upload so the transactions are added correctly. Loaded into a bank account, the same file puts every purchase and payment on the wrong side, and the error repeats with every later file. Before you commit, confirm that a known purchase appears as a charge and a known payment as a payment.

Where should the history start?

For an account you're connecting for the first time, the start date also fixes the opening balance. Intuit's help for QuickBooks Online says the opening balance is the amount in the account on the day you start tracking it, and that when you connect, QuickBooks adds up the transactions since the date you picked to get the opening balance. For an existing account, Intuit's tip is to use the beginning date of your next statement, which gives you a printed balance to check the opening figure against.

If the account won't be connected, Intuit's help has you enter the statement's opening balance yourself when you create the account in the Chart of accounts, with the start date in As of. For an account your books already carry, Intuit's help doesn't say what connecting does to the balance; after connecting, check its register for a new opening balance entry at the start date. Zoho's banking help on adding accounts and importing statements doesn't cover opening balances.

The right start depends on what the books already hold for the account:

These rows are reasoned from Intuit's opening-balance and match rules, not taken from an accounting standard.

Reaching further back than the books' existing history is the remaining path, and it pays only when the books hold little in that range. Every overlapping arrival then has to be paired with its existing record or kept out of the books, and the software won't flag them all. Intuit's help says QuickBooks won't suggest a match when you already reconciled the record, or when the record falls more than 90 days before or 20 days after the arrival.

Before committing any intake, run a register or transaction report for the account over the dates you're about to bring in. If it isn't empty, move the start date or plan for the overlap.

What happens to transactions after they arrive?

Nothing is in the books yet. Intuit's help says downloaded items appear in the For review tab but won't affect your books until you match or categorize them. Zoho's help places feed and imported items in an Uncategorized Transactions tab, where you match or categorize them.

A connected account is therefore not a bookkept one. Each arrival still has to be matched to a record you already have, categorized as a new one, or kept out of the books, and the account then has to be reconciled; each of those steps is its own question.

How do you keep the same period from arriving twice?

Allow one route per account for any date range. The usual collisions are these:

• A connection's first download reaching into dates you entered by hand
• A file imported for dates a connection already delivered, or the same file imported twice
• A card synced by its program's connector and also connected as a bank feed
• A card payment that the card's connector syncs and that also arrives in the paying account's bank feed (Ramp's documentation says it syncs statement payments as checks)
• The same opening-balance transaction downloading to every card subaccount on first connection (Intuit says to delete all but one when you reconcile)

The platforms help only partway. Intuit's subaccount guidance says QuickBooks refuses to connect a parent account and its subaccounts together. Intuit's help says QuickBooks suggests matches for transactions with the same amount within 90 days before to 20 days after the transaction date, and Zoho's help says a Match found tag appears when an uncategorized transaction meets its matching criteria. These are suggestions you act on; an item added as new when its record already exists becomes a duplicate. If you upload the same statement twice, Zoho's help says you can undo your last import.

Dates catch most overlaps, but not all. Before committing, compare the first date in the file or date range with the last date the account already holds. After arrival, treat any item dated on or before that date as a likely copy and pair it with its record rather than adding it. Items your books recorded before the start date that hadn't cleared (the outstanding items on your last reconciliation) will arrive dated after it; list them before you connect or import, and pair each arrival with its record rather than adding it. Finding and removing duplicates already recorded is a separate question.

How do you confirm a period arrived complete?

Chase's guide lists starting and ending balances and all completed transactions as common elements of a statement, noting that contents vary by institution and pending items may be left out, so compare posted items only. Run this check for each period:

1. From the statement, note the dates, the starting and ending balances, and the count and total of money in and money out.
2. In the software, count and total the same period's arrivals, whether still waiting for review or already added.
3. Compare the counts and totals, then check that the starting balance plus money in minus money out equals the statement's ending balance.
4. Resolve any gap before relying on the period.

In this worked example, a checking account's April statement starts at 18,420.55:

One withdrawal of 425.00 never arrived. Find it on the statement, then enter that one withdrawal by hand (its own question) or, in QuickBooks Online, upload a file for the period and select only that line in the import list. If the connection delivers it later, pair that arrival with your entry instead of adding it. A connection that keeps missing items is a feed problem with its own question. For a card, the same test runs as previous balance plus charges minus payments and credits equals the new balance.

Why keep the statement once the lines are in?

A feed or transaction file carries lines, not the statement. The statement is the institution's own document, with the balances that a reconciliation and any later review rest on. Online copies don't last indefinitely: Wells Fargo's online-statement disclosure, for example, says statements stay available for up to 2 years for credit cards and up to 7 years for deposit accounts, and that each product's period is shown in Wells Fargo Online under Statements & documents; other institutions set their own periods. Download each statement as a PDF when it's issued, for connected accounts as well as imported ones, and file it with that period's records. Choosing software to store those documents is a separate question.

What does a finished pre-intake checklist look like?

Fill in one column per account before anything is connected or imported. This example covers a checking account whose books are reconciled through March 31 and a card whose issuer the software can't connect to: