Bank Import + Auto-Reconciliation

When to use it

Run this each month after you download your bank's CSV (or OFX) export. It gives you a clean, categorized ledger that ties spending back to your budget and feeds the annual audit, instead of hand-keying every transaction. The more statements you import, the smarter the auto-suggestions get, because DuesSync learns from how you've classified similar transactions before.

Step by step

1. Go to Finance → Bank Imports. If it isn't visible, the auditEnabled feature flag needs enabling.
2. Click Upload Statement. Pick the Bank Account, the statement Year and Month, and choose your CSV File. Exports from Chase, Bank of America, Wells Fargo, US Bank, and most banks work; max 2 MB. (Add a bank account first if none is configured.)
3. If DuesSync can't auto-detect the columns, it shows a Map CSV Columns step — point it at your Date, Description, and Amount columns (and an optional running balance), then re-process.
4. After import you'll see KPI cards: Total, Categorized %, Unassigned, and Last Import. Duplicate rows from overlapping statements are skipped automatically.
5. Click View all transactions (or the Unassigned card) to open the worktable.
6. For each unassigned row, accepted suggestions appear inline — click to assign the transaction to the suggested budget line. Or open a row to assign a budget line manually, split it across several lines, add a note, or skip it (for internal bank transfers that don't belong to any line).
7. When you assign one row that carries a bank "classification" tag, DuesSync offers to apply the same budget line to every other row sharing that tag — confirm to clear many at once.
8. Aim to drive the Unassigned count toward zero. Categorized transactions then feed your budget actuals.

Tips & gotchas

• ~70–85% auto-match is normal. Bank-internal transactions (transfers, fees) often carry no classification and need a manual touch or a skip.
• Suggestions are suggest-only — nothing is categorized until you accept it. Nothing is auto-applied behind your back.
• Imported transactions are immutable: your categorization is stored alongside them (as an enrichment), so re-importing never loses your work and duplicates are de-duped by content.
• Use Split when one bank line covers multiple budget categories (e.g. one check paying two bills).
• Deleting a statement removes its rows; do it only to fix a bad import.
• Categorized bank transactions show up as suggestions on the Budget page until you click Apply there — assigning them here is what makes them available.

Related

• See also budget
• See also vouchers