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.
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.
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.
- 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.
- 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.