Two main ways to get transactions into QuickBooks: bank feeds and manual import.

Bank feeds are the automatic connection between your bank and QuickBooks. Once connected, transactions download daily or every few hours. This is the standard approach for ongoing bookkeeping. You connect each bank account and credit card once, and transactions flow in automatically from that point forward. In QuickBooks Online, go to Banking and click Link Account to set this up.

For transactions that aren’t coming through bank feeds you use manual import. This covers historical data, transactions from a bank that won’t connect, or data you’re moving from another accounting system.

To import transactions manually in QuickBooks Online, export transactions from your bank as a CSV, QBO, or OFX file. Then go to Banking, click Upload Transactions, and select the account where these transactions belong. Upload the file, map the columns if using CSV, and review what QuickBooks found. Desktop works similarly but the menu locations vary by version.

The import itself takes a few clicks. The real work happens before and after.

Before importing, make sure your file is formatted correctly. You need date, description, and amount columns at minimum. QuickBooks is picky about date formats and MM/DD/YYYY works reliably. Remove any header rows or summary totals that aren’t actual transactions. If your bank gave you an Excel file, save it as CSV first.

For credit card transactions, check whether the file shows purchases as positive or negative numbers. Different banks handle this differently. Importing with the wrong signs creates a mess that takes time to fix.

After importing, every transaction lands in your bank feed as “for review” status. They’re not in your books yet. You need to categorize each transaction and accept it before it affects your financial records. This categorization step is where the actual bookkeeping work happens.

Watch for duplicates. If you already have some transactions in QuickBooks and you import a file that overlaps those dates, you’ll end up with duplicate entries. QuickBooks tries to catch these but doesn’t always succeed. Import date ranges that don’t overlap with existing data when possible.

For historical catch-up work covering months or years of transactions, importing is just the starting point. You still need to categorize everything, reconcile accounts, and verify the totals match your bank statements. A bookkeeper for small business owners can handle this cleanup work and make sure the imported data is actually usable.

If you’re switching from another accounting system, you can often export your old data and bring it into QuickBooks. But the chart of accounts and categories rarely match perfectly. Expect to spend time mapping old categories to new ones.

Most people who struggle with imports aren’t having trouble clicking the import button. They’re having trouble with file formatting, unexpected duplicates, or not realizing that categorization is a separate step. If you’ve imported transactions and they’re not showing up in reports, check whether they’re still sitting in the bank feed waiting to be accepted.

Getting QuickBooks set up correctly from the start prevents most import headaches. When your chart of accounts is structured properly and bank feeds are connected, you spend less time fighting with manual imports and more time actually running your business.