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 often do I need to file GRT returns in New Mexico?
Your GRT filing frequency in New Mexico depends on your average monthly tax liability. Most small businesses file monthly or quarterly, though semi-annual and annual options exist for lower-volume operations.
Read answerDo I need to charge GRT to out-of-state customers?
Generally, no. Sales of goods shipped outside New Mexico and services delivered to out-of-state customers are usually not subject to Gross Receipts Tax. The determining factor is where the product is delivered or where the service benefit is received.
Read answerHow do I separate personal use from rental use in my books?
Track every day the property is used and by whom. Allocate shared expenses like insurance, utilities, and repairs based on the ratio of rental days to total use days. Keep direct rental expenses separate from direct personal costs.
Read answerWhy won't my QuickBooks balance sheet reconcile?
The most common causes are Opening Balance Equity that was never cleared, deleted or modified transactions that were already reconciled, and duplicate entries from bank feeds. Finding the problem requires checking specific accounts and running detail reports.
Read answerWhat chart of accounts should an art gallery use?
Art galleries need a chart of accounts that handles consignment properly. The key is separating gallery-owned sales from consignment commissions and tracking what you owe artists as a liability.
Read answerShould artists hire a bookkeeper?
Artists with gallery sales, consignment inventory, and irregular income often reach a point where professional bookkeeping pays for itself in time saved and taxes handled correctly.
Read answer
