New: Drag & Drop HOA Website Builder now live — start your 30-day free trial ›

Importing Bank Transactions from a CSV File

Accounting & BookkeepingUpdated October 9, 20263 min readIntermediate

No Plaid connection for your bank, or need to catch up on older months? Export your transactions from your bank as a CSV file and import them into the matching Perfect HOA bank account. Nothing is saved until you confirm on the last step.

1. Start from the Right Account

Open Finances > Bank Account Transactions. On the card for the account the file belongs to, click the gear icon and choose Import Transactions.

The Bank Accounts page with an account actions menu open showing Reconcile Account, Import Transactions, Balance History and Edit Account
Use the gear on the account you are importing into

Note: The import goes into the account whose card you clicked, and the page header shows its name and last four digits. Double-check it before you upload.

2. Upload Your Bank Export

Drag a CSV file onto the page or click browse, then Continue to mapping. Files can be up to 10 MB and 10,000 rows. Comma, semicolon and tab separated files all work, and the column order doesn’t matter. For a bigger history, import it a few months at a time.

The Import transactions upload page with a CSV drop area and a Supported formats panel with a sample file
The side panel explains the accepted formats and offers a sample file

Tip: Click Download sample CSV to see the simplest layout: Date, Description, Amount.

3. Match the Columns

Perfect HOA guesses which column is which and marks each guess Auto-detected or Suggested. Check each one, and use the dropdown beside any column to correct it or choose Ignore this column.

The Match columns step with a table of the file columns, sample values and a Maps to menu, and an options panel for header row, amount format, sign and date format
Date and Description are required plus an amount
  • First row is a header: turn it off if the file starts straight with a transaction.
  • Amount format: one signed amount column, or separate Debit and Credit columns, whichever your bank uses.
  • Flip sign: see the note below.
  • Date format: leave on auto-detect, or choose a format if dates like 03/04 could be read two ways.

Warning: Positive amounts are read as money out and negative as money in. Many banks export it the other way around. If the review step shows deposits as expenses, go back and turn on Flip sign.

4. Review, Then Import

The last step lists every row with a status: Ready, Duplicate or Error. Money in shows in green with a plus, and money out with a minus. Use the tabs to look at just the duplicates or errors.

The Review and import step with tiles for total rows, ready, duplicates and errors and a table of transactions with their amounts
Check the amounts and signs before you import
  • A row is a duplicate when the account already has a transaction with the same date, amount and description. Skip duplicate transactions is on by default, so you can re-import an overlapping file safely.
  • Rows with errors (an unreadable date or amount) are never imported. Click Review the mapping to fix the cause.

Click the import button. You will see how many were imported and how many skipped.

5. What Happens Next

  • Your transaction rules run on every imported row, so known vendors are categorized for you.
  • Imported rows land in For Review. Approve or recategorize them as usual. See Reviewing and Categorizing Bank Transactions.
  • Only the date, description and amount are saved. Any category, notes or reference columns in your file are shown for checking but are not stored, so categorize in Perfect HOA.

Tip: After importing a full month, reconcile the account against the statement to prove nothing is missing.