← RSA Guide

Banking

Bank CSV Import

RSA can import transactions from your bank as a CSV file. Go to Banking → Bank CSV Import:

  1. Export a CSV statement from your online banking portal (most banks offer this under Statements or Download).
  2. Upload the file and select the bank account (from your chart of accounts) it belongs to.
  3. Map the CSV columns to RSA fields: date, description, and amount. Debit and credit may be separate columns or a single signed amount column.
  4. RSA previews the transactions. Any bank rules that match (see below) are applied automatically — the suggested category is shown for each row.
  5. Review, adjust any categories, and click Confirm Import. Each transaction is posted as a journal entry.
Duplicate detection: RSA skips rows that match an already-imported transaction on the same account with the same date and amount.

Bank Rules

Bank rules automatically categorize imported transactions so you don't have to categorize them manually each time. Go to Banking → Bank Rules:

  1. Click New Rule.
  2. Choose the field to match on: Description (operators: contains, equals a keyword — e.g. "AMAZON", "STRIPE TRANSFER") or Amount in cents (operators: >, <, =).
  3. Choose the target account to assign matching transactions to (e.g. Office Supplies, Revenue).
  4. Optionally set a memo override and a numeric priority (higher runs first).
  5. Save. The rule applies on the next CSV import and retroactively when reviewing.

Rules are evaluated in order of priority (highest first) — the first matching rule wins. There's no drag-to-reorder; change a rule's priority number to move it earlier or later.

Reconciliation

Reconciliation confirms that your RSA books match your actual bank statement. Go to Banking → Reconciliation:

  1. Select the bank account and statement period.
  2. Enter the closing balance from your bank statement.
  3. Check off each transaction that appears on the statement. The running difference updates as you go.
  4. When the difference reaches zero, click Finish Reconciliation. RSA records the reconciliation date.

Transactions already matched in a previous reconciliation are greyed out and locked. If you find a discrepancy, look for missing imports, duplicate entries, or a bank fee that hasn't been recorded yet.