Skip to main content

Troubleshooting CSV Transaction Imports

How to fix common problems when you import bank transactions from a CSV file.

Written by Morgan Kratochvil

Most CSV import problems come from how the file was formatted. They’re usually quick to fix in the import screen or in a spreadsheet. To start an import, go to Settings → Import and click New. If you haven’t imported before, start with How to Bulk Import Transactions.

The sections below follow the order of the import steps, so jump to the step where you got stuck.


While uploading your file

My file won’t upload

Ambrook only accepts .csv files. If your bank gave you an Excel file (.xlsx or .xls), convert it first:

  1. Open the file in Excel or Google Sheets.

  2. In Excel, choose File → Save As. In Google Sheets, choose File → Download.

  3. Choose CSV as the file type and save.

💡 Tip: If your bank only offers PDF statements or QuickBooks/Quicken files, see “My bank doesn’t offer CSV exports” in the FAQ below.


While matching columns

The columns don’t line up

On the mapping step, Ambrook shows the column names from your file. If those names look like dates or amounts, or the first few rows are account details instead of transactions, change the format settings at the top of the screen:

  • Has header row: Check this box if the first row of your file has column names, like Date or Amount. Uncheck it if your file starts right in with transactions.

  • Starting Row: Some banks put account details or a summary above the transactions. Set Starting Row to the row where the column headers (or the first transaction) start.

If your file has no header row at all, you can also add one in Excel or Google Sheets (for example, Date, Description, Amount), save it as a CSV, and upload it again.

I can’t get past the mapping step

Next stays grayed out until every required field is matched to a column in your file. Required fields have an asterisk (*):

  • Date

  • Description

  • The amount fields, which change with the format you pick (see Amounts are backwards below)

For each one, choose the matching column from the CSV Column dropdown. Use the Preview column to check that you picked the right one.

Optional fields like Category, Check Number or Enterprise are under More Field Options. You don’t have to map them. Columns you leave unmapped won’t stop the import, and Ambrook keeps their data with the import.

Amounts are backwards

This usually means the amount format at the top of the mapping step doesn’t match your file. Pick the one that fits:

If your file has…

Choose

One amount column with negative numbers for money out (for example, -50.00)

Only Amount Column

Two columns: one for money out (debits) and one for money in (credits)

Separate Debit/Credit Amounts

One amount column with all positive numbers, plus a column that says “debit” or “credit”

Combined Debit/Credit

If you already chose the right format and the signs are still flipped (common with credit card exports, which often list charges as positive numbers), fix the amounts in the file before importing:

  1. Open the CSV in Excel or Google Sheets.

  2. In an empty column, multiply each amount by -1 (for example, =-C2).

  3. Copy the new column, paste it back over the original amounts as values only, and delete the helper column.

  4. Save as CSV and upload it again.

Dates are wrong

Ambrook reads dates with the month first. If your file writes dates with the day first (DD/MM/YYYY), the dates may import wrong.

  1. Open the CSV in Excel or Google Sheets.

  2. Format the date column as MM/DD/YYYY or YYYY-MM-DD.

  3. Make sure no transaction rows have a blank date. Delete any total or summary rows at the bottom of the file.

  4. Save as CSV and upload it again.


While selecting transactions

Some days can’t be selected

Ambrook won’t import transactions dated before the account’s Starting Date, so those days are grayed out. Hover over one to see the reason.

If those transactions belong in Ambrook, move the Starting Date back:

  1. On the select step, find the message asking if you’d like to change the account’s starting date.

  2. Click Update Account Starting Information.

  3. Enter the new Starting Date and the account’s balance on that date, then save. The days become selectable.

Duplicate warnings

If the account already has transactions on some of the dates in your file, Ambrook shows an orange banner listing those dates and an orange warning icon next to each possible duplicate. The warning doesn’t stop the import, but importing duplicates will double-count them.

  1. Click the orange warning icon next to a transaction. A new tab opens your Ledger, filtered to transactions with the same date and amount.

  2. If the transaction is already there, go back to the import and uncheck it.

  3. To skip a whole day, uncheck the box on the date row.

💡 Tip: The most common cause of duplicates is a file whose dates overlap a live bank connection or an earlier import. When you download a CSV from your bank, set the date range to start the day after your last import or connection date.


After the import

Transactions are missing

If some transactions didn’t show up after the import, confirm if:

  • They were unchecked on the select step. Every transaction starts checked, so check whether any rows or days were unchecked during review.

  • They’re dated before the account’s Starting Date. See Some days can’t be selected above.

  • The file didn’t include them. Check the date range you picked when downloading from your bank. Transactions that are still pending may not be in the export yet, so set the end date to yesterday.

  • They went into a different account. Go to Settings → Import, open the Transactions tab, and check which account the import went into.

To add the missing transactions, download a new CSV that covers only those dates. Then go to Settings → Import, click New, and import it.

Undo an import

If you imported to the wrong account, or brought in a batch of duplicates, you can delete the whole import at once.

  1. Go to Settings → Import and open the Transactions tab.

  2. Find the import, click the three dots next to it, and choose Delete imported data.

  3. Review what will be deleted, then click Delete.

This deletes every transaction from that import, including any tags and attachments you’ve added. It can’t be undone. Keep the window open until it’s done. It may take a few minutes.

If you see “Import Can’t Be Deleted”: some transactions in the import are matched to transfers or payments. Use the button in the dialog to find them, remove the transfer tags or unmatch the payments, then click Continue To Delete Import. See Unlinking Transfer Tags.

If you only need to remove a few transactions, or you’ve already done a lot of tagging you want to keep, delete just those transactions from your Ledger instead. See Excluding & Deleting Transactions.


FAQ

Can I import into a credit card or line of credit account?

Yes. Pick the account from the Account dropdown on the first step, or click New Balance Sheet Account to create it. Choose the correct account type so the balance is right. Then check that money in and money out come through the right way (see Amounts are backwards).

Can I categorize transactions in my CSV before importing?

Yes. Add columns for Category, Entity, Enterprise, Funding, Project or Location, and map them under More Field Options on the mapping step.

My bank doesn’t offer CSV exports. What are my options?

Try connecting the account to Ambrook directly so transactions come in on their own. See Connecting Your Bank and Importing Transactions, or Troubleshooting: Bank Connections if your bank won’t connect. Many banks also offer CSV downloads in their business banking portal even when it isn’t obvious, so it’s worth asking your bank. Moving from QuickBooks? See Importing Your Data from QuickBooks to Ambrook.


Still stuck? Message the Support team using the chat in the app or at support@ambrook.com, and include a screenshot of the step where you’re stuck. We’ll help you get it sorted!

Did this answer your question?