How do I import transactions into QuickBooks?
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.
Santa Fe's Small Business Bookkeeper
The Next Step:
A Quick Conversation
Tell us about your business and what you're dealing with. We'll listen, ask a few questions, and give you a straightforward quote.
More Questions
How do I track equipment costs across multiple job sites?
Track equipment hours or days on each job site, then allocate depreciation, fuel, and maintenance costs proportionally. Set up your accounting software to assign these allocated costs to specific jobs.
Read answerHow do I manage cash flow for a remodeling business?
Structure customer payments so money comes in before you need to pay it out. Require deposits that cover materials, set up progress payments tied to milestones, and negotiate supplier terms that give you breathing room between expenses and income.
Read answerWhat expenses should contractors track for each job?
Track labor hours, materials, subcontractor invoices, equipment costs, and permits for every job. Each expense needs a job code before it hits your books. Without this discipline, you won't know which projects actually make money.
Read answerShould owner-operators hire a bookkeeper?
Most owner-operators benefit from professional bookkeeping. The time spent doing your own books is time you're not earning money, and trucking-specific complexities like IFTA and per diem make DIY bookkeeping harder than it looks.
Read answerWhat is the best bookkeeping software for truckers?
The best software depends on your operation size and tracking needs. QuickBooks works well for core bookkeeping, though you may need trucking-specific apps for IFTA tracking and load profitability. What matters most is picking something you'll actually use consistently.
Read answerHow do I track business expenses effectively?
Start with a dedicated business bank account and credit card. Capture receipts immediately, categorize transactions weekly, and connect everything to accounting software that pulls in your bank feeds automatically.
Read answer
