--- title: "Import Bank Transactions From CSV: Avoid Errors | MCC" description: "Prepare columns, check signs and totals, and avoid duplicates when importing a CSV. Worked balance check included." url: "https://mcc-solutionsnj.com/bookkeeping/guides/how-to-import-bank-transactions-from-csv" --- Bookkeeping guide · Updated October 12, 2026 # How to Import Bank Transactions From a CSV File When a bank feed is unavailable, or you are catching up on old months, a CSV file is the practical route. The import itself is easy. Most of the trouble comes from preparation and from mistakes in columns, signs and dates. By [Matthew Coleman](/about), MCC Solutions **Quick answer.** To import bank transactions from CSV, download the file from your bank for the exact date range (you may need several files if the bank limits months or rows), keep the originals unchanged and work on copies. Want this handled for you? Monthly bookkeeping, cleanup and year-end close for small businesses. Start with a free health check of your books. [Free health check](/bookkeeping/health-check)[Get a quote](/bookkeeping/#interest) **Related:** [NJ 1099 contractor rule (ABC test)](/bookkeeping/guides/nj-independent-contractor-rule-abc-test-2026) · [Trial balance explained](/bookkeeping/guides/trial-balance-explained) · [Owner contribution or loan](/bookkeeping/guides/owner-equity-and-capital-contributions) **Free tools:** [Depreciation schedule calculator](/bookkeeping/depreciation-calculator) · [Was that craft fair worth it?](/bookkeeping/craft-fair-profit-calculator) [![Intuit ProAdvisor Gold tier badge](/img/credentials/intuit-proadvisor-gold.png)](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77)Gold tier in Intuit's ProAdvisor program. [See my Intuit listing](https://proadvisor.intuit.com/app/accountant/search?searchId=matthew-coleman77) Keeping your own books? Tallyfinch does invoices, bank import and reports on your computer. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) ## Download the right file Log in to your bank and look for the export or download option for transactions. Choose CSV, and select the exact date range. Many banks limit how many months or rows you can export at once, so you may need several files. Keep the originals unchanged in a folder, and work on copies. ## Prepare columns Most software wants a date, a description and an amount, either in a single column where negatives are payments, or in two columns for money in and money out. Remove header rows, summary lines and blank rows. Delete columns the importer does not need. Check that the dates are consistent, since a mix of day-month and month-day formats can silently scramble entries. ## Watch signs and totals A common problem is reversed signs, where deposits appear as spending. Check a few lines against the statement. Add up the file and compare the net movement with the statement's starting and ending balances. If the totals do not match, find the missing or doubled rows before importing. ## Map and import Upload the file and map each column to the right field in the import screen. Select the right account. Preview the results if offered. Then import and review in the For review or Reconcile area. If the software warns about possible duplicates, read the list carefully instead of accepting automatically. ## Avoid duplicates and gaps Before importing, find the last date already present in the account. Begin the file the next day, or remove overlapping rows. If the feed later comes online, set its start date after the CSV period so the same transactions do not appear twice. After the import, reconcile through the end date to confirm the balance. Keep a log of each file, the date range and the person who imported it. That record answers later questions quickly, and it lets you replace a bad import without guessing which rows came from where. For credit cards, remember that payments and refunds also move in opposite directions from purchases, so check the sign convention again. ## Credit cards and multiple accounts Credit card exports often show purchases as positive numbers, the opposite of the bank format. Check the sign rule in the import screen before you proceed. If you have multiple accounts, import each separately into the right account, and keep file names with the account and the date range. Never combine accounts into one file. Confirm the account and date range. Open the file in a spreadsheet and check headings. Verify that the first and last rows match the statement. Confirm the sign of deposits and payments. Count the rows. Check for text dates, merged cells and trailing blank lines. Save a copy as a plain CSV. Import into the correct account. Spot-check ten lines afterward. This short routine prevents almost every failed import. ## Worked example with numbers The CSV has 95 rows. Opening balance $4,200, deposits $9,850, withdrawals $8,420. Ending balance should be $4,200 + $9,850 - $8,420 = $5,630. After import, the register must show $5,630 on the last date. If it shows $5,300, a $330 row was missed or a sign flipped. ## Mistakes that cost money Reversed signs. Importing twice. Wrong date format turning day and month around. Header rows imported as data. ## Check your work Compare the first and last balances to the statement before reconciling. ## Common questions **Can I import a PDF statement?** Not directly. Some tools convert PDFs, but review the output closely or request a CSV from your bank. **Will imported transactions be categorized?** They arrive uncategorized. Bank rules or manual review then assign categories. This guide is general information, not tax, legal or accounting advice. Rules, fees and due dates change; check with the IRS, the NJ Division of Taxation or a licensed professional for your situation. Let us handle it [### Monthly bookkeeping Categorizing, reconciling and monthly reports, with cleanup, payroll and NJ filings available. Bookkeeping →](/bookkeeping/) [### QuickBooks Online Monthly bookkeeping, cleanup and reconciliation in QuickBooks Online for New Jersey small businesses. Your account stays in your name. QuickBooks →](/bookkeeping/software/quickbooks-online)[### Xero Bookkeeping and reconciliation in Xero for New Jersey small businesses, including cleanup and moving from spreadsheets or another program. Xero →](/bookkeeping/software/xero)[### Wave Bookkeeping help for Wave users in New Jersey, and when it makes sense to outgrow Wave. Cleanup, reconciliation and moves to another platform. Wave →](/bookkeeping/software/wave) More guides - [Importing Customers and Vendors Into QuickBooks](/bookkeeping/guides/import-customers-and-vendors-into-quickbooks) - [Moving From QuickBooks Desktop to QuickBooks Online](/bookkeeping/guides/migrate-quickbooks-desktop-to-online) - [How to Clean Up a Messy QuickBooks File](/bookkeeping/guides/how-to-clean-up-a-messy-quickbooks-file) - [How to Choose Accounting Software for Your Business](/bookkeeping/guides/how-to-choose-accounting-software) Free tool - [Bookkeeping health check](/bookkeeping/health-check) [All guides](/bookkeeping/guides) Reach small business owners, freelancers and bookkeepers who read this guide: [advertise here](/advertise#bookkeeping). Do it yourself ### Chart of Accounts and QuickBooks Import Pack Start your books with an account list built for your type of business, instead of the generic default, and compare it with the accounts you already have. [See what's inside ($24)](/toolkits/chart-of-accounts-quickbooks-import-pack)14-day full refund Tallyfinch ### Books you keep on your own computer Tallyfinch does invoices, bills, bank import, reconciliation and the main reports, in a file you own. $99 once, then $5 a month for updates; the app keeps working if you stop the plan. It does not do payroll or sales tax filing. The free download records up to 60 entries. [See Tallyfinch](/bookkeeping/mcc-books-downloadable-bookkeeping-software) [Download it free](/tools/pro/trial/mccBooks) [Compare the three apps](/software) ## Rather have us keep the books? Ask for a quote. [Get a Quote](/bookkeeping/#interest)[Call (908) 444-6373](tel:+19084446373)