How do I import transactions into QuickBooks?
Bank feeds are the fastest way to import transactions. Connect your bank account through QuickBooks Online and transactions download automatically, usually within 24 hours of posting. Go to Banking, click Link Account, find your bank, and enter your login credentials. Once connected, new transactions show up in the For Review tab where you categorize and add them to your books.
Manual imports work when bank feeds aren’t available or you need to add historical transactions. Download a CSV or QFX file from your bank’s website. In QuickBooks, go to Banking, then click the dropdown arrow next to Link Account and select Upload from File. Choose your file, select the QuickBooks account where these transactions belong, and map your columns.
Column mapping is where most imports fail. QuickBooks needs to know which column is the date, which is the description, and which is the amount. Some bank exports split deposits and withdrawals into separate columns. Others use negative numbers for outflows. Match your file’s columns to what QuickBooks expects or the import won’t work correctly.
Check for duplicates before adding imported transactions. If you have bank feeds running and also import a CSV covering the same period, you’ll end up with duplicate entries. QuickBooks catches some duplicates automatically but not all. Review imported transactions before accepting them into your register. Working with a San Diego bookkeeper helps catch these issues before they compound into bigger problems.
Date formats cause trouble too. QuickBooks expects MM/DD/YYYY. If your bank export uses DD/MM/YYYY or YYYY-MM-DD, fix it in Excel before importing or QuickBooks will misread your dates or reject the file entirely.
After import, transactions land in the For Review section just like bank feed transactions. Go through them one by one, assign categories and payees, then add them to your books. Don’t skip this step. Uncategorized transactions sitting in For Review means incomplete books and unreliable financial reports.
If you’re setting up QuickBooks for the first time or migrating from another system, getting QBO setup and training helps configure everything correctly before you start importing. Wrong account mapping or chart of accounts issues compound as you add more transactions, and fixing them later takes more time than getting it right from the start.
San Diego's Small Business Bookkeeper
The Next Step:
A Short Conversation
A quick call to tell us about your business. We'll listen, answer your questions, and give you a clear price quote.
More Questions
What does a bookkeeper actually do?
A bookkeeper maintains the day-to-day financial records of your business. They categorize transactions, reconcile accounts, manage bills and invoices, and produce monthly financial statements that show how your business is performing.
Read answerWhat is job costing for construction companies?
Job costing tracks every expense by individual project rather than lumping costs into general categories. It shows you exactly which jobs make money and which ones lose it, so you can bid smarter and catch overruns before they drain your profits.
Read answerHow do I track income and expenses by property?
Use class or location tracking in QuickBooks to tag every transaction to a specific property. This lets you run profit and loss reports by property so you can see exactly how each one is performing.
Read answerWhen should I hire a bookkeeper for my small business?
Hire a bookkeeper when you're spending several hours monthly on bookkeeping, when you can't answer basic questions about profitability, or when tax season becomes a scramble. Most business owners wait until their books are already messy. The better approach is getting help before problems compound.
Read answerHow do I set up QuickBooks Online for my business?
QuickBooks Online walks you through the basics when you create an account. The real work is configuring your chart of accounts, bank connections, and tracking features to match how your business actually operates.
Read answerWhat is the difference between QuickBooks Online and Desktop?
QuickBooks Online is cloud-based software you access through a browser from anywhere. Desktop is installed on a specific computer. For most small businesses today, Online is the better choice due to accessibility, integrations, and ongoing development from Intuit.
Read answer
