← RSA Guide

Banking

Bank CSV Import

RSA imports your bank or credit card statement as a CSV file. Importing adds statement lines to reconcile; it doesn't post anything to your books until you act on each line. That way a bank payment and the bill it pays are never counted twice. Go to Banking → Bank CSV Import:

  1. Export a CSV statement from your online banking or card portal (most offer this under Statements or Download).
  2. Upload the file and choose the bank account or credit card it belongs to. Only accounts marked as a bank account or credit card in the chart of accounts are listed.
  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 lines. Any bank rules that match (see below) set a proposed category for the line.
  5. Click Import. The lines appear on that account's months in Reconciliation, with a link to reconcile the month.
Duplicate detection: RSA skips a row when the account already has a statement line with the same date, amount and description. Two identical charges on the same day in one file both import. Rows dated in a month you have closed are skipped too. When the import finishes, See the skipped rows lists each skipped row with its row number in your file (counting from the first row under the header) and why it was skipped.

Bank feeds

Instead of importing statements, you can connect a bank account or credit card to your bank. Its transactions then arrive by themselves, about once a day, as statement lines to match. Like an import, a bank feed never posts anything to your books: each line waits in Reconciliation until you match it or choose an action. Go to Banking → Reconciliation; each account's card has a Bank feed row:

  1. Click Connect to the bank.
  2. Choose the day to bring in transactions from. RSA suggests the day after the last line already on the account, so days a statement import already covered aren't brought in twice.
  3. Click Continue to the bank and sign in to your bank in Stripe's secure window. RSA never sees your bank password or account number, and asks only for the transactions (not balances or account details).
  4. If the bank shares more than one account, choose the one that belongs to this RSA account. The others are disconnected. Cards that a bank lists as "other" accounts (Novo's card, for one) can be chosen too.

Once connected, the row shows the bank and the last 4 digits, and when the feed was last checked. Bank rules set the proposed category on each new line, just as they do for imports. A transaction that is still pending at the bank comes in once it posts. A transaction the bank cancels is removed again if it hasn't been matched yet. Nothing is added to a month you have closed.

  • Check now brings in anything the bank has already sent, without waiting for the daily update.
  • Disconnect stops the bank from sharing the account. Lines that already came in stay on the account.
  • If the row says the bank stopped sharing the account, disconnect it and connect it again.
Connecting and checking a bank feed needs permission to import bank statements; disconnecting needs permission to delete them. A line that a statement import already brought in (same day, amount and description) is linked to the bank's transaction instead of being added twice.

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 dollars (operators: >, <, =).
  3. Choose the target account to propose as the category for matching lines (e.g. Office Supplies, Revenue).
  4. Optionally set a memo override and a numeric priority (higher runs first).
  5. Save. The rule sets the proposed category on the next CSV import.

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.

The list reads each rule in plain words, such as Description contains "ADOBE" or Amount is over $5,000.00, with tiles for the lines a rule categorized and the lines no rule caught. Click a rule to open its page, where you can change its condition, category, memo or priority, turn it off, or Delete rule. The page also lists the statement lines waiting to be matched that the rule catches.

Bank accounts and credit cards

Reconciliation works on accounts marked as a bank account or credit card. Open an asset or liability account in Accounting → Chart of Accounts and choose Bank account or Credit card, with a nickname and the last 4 digits. Marked accounts show a Bank or Credit card tag in the chart of accounts.

Every account you have already imported a bank statement into is marked as a bank account for you, and its imported transactions become statement lines matched to the journal entries they created. Nothing in your books changes. An account with statement lines can't be unmarked, and a marked account must be unmarked before it can be deleted.

Reconciliation

Reconciliation confirms, month by month, that your RSA books match each bank and credit card statement. Go to Banking → Reconciliation:

  • Each bank account and credit card has a card with its balance in the books and the last 12 months, newest first.
  • Each month shows Reconciled (with the date it was closed), In progress (with how many statement lines are still to match), Not started, or No activity.
  • The tiles at the top count the accounts to reconcile, the months still open, and the statement lines not yet matched.
  • Each account shows three dates side by side: activity through (its latest statement line or entry), statement through (the last day its latest closed statement covers) and reconciled through (the latest closed month). Profit & Loss, Balance Sheet and Cash Flow say so when a report runs past the day an account is checked through.

Reconciling a month

Open a month from its card. The page lists the month's statement lines and, in the panel on the right, the opening balance, the closing balance from your statement and the difference.

  1. Type the closing balance from your bank or card statement, and the day the statement ends (Statement ends on; filled in when a PDF statement is read). For a credit card, enter the balance you owe as a positive amount.
  2. For the first month you reconcile on an account, also type the opening balance on the statement (for a card, the amount owed at the start). RSA fills in the balance from your books, so change it if the statement differs. Every later month starts from the previous closed month's closing balance.
  3. Match each statement line. When RSA finds an entry in the books for the same amount within 5 days, it shows it as a suggestion and one tap on Match links them. Otherwise choose Find a match to pick from nearby entries on that account: invoice payments, bill payments, expenses, payroll or journal entries. Unmatch undoes a match.
  4. A bill payment can be dated on a different day than its statement line (for example, the bank shows it as posted two days later). When you Record a bill payment from a line, or use Find a match for a bill payment, you can set the payment date, and RSA asks why the dates differ (for example "Novo statement shows posted Oct 2"). The line keeps its own date, and the reason is saved with the match and in the Audit Log. A matched line shows the payment's date and the reason.
  5. Each statement line shows Date source: the column of your file mapped as Date, the bank feed's transaction date, or entered by hand. Lines brought in before this was recorded show "Date source: Unknown".
  6. If a line is on the statement but not yet imported, add it by hand. Lines you added by hand can be deleted.
  7. For a line with nothing to match, choose Actions:
    • Post to an account: posts the line against a category, starting with the proposed one.
    • Create an expense (money out): records an expense paid from that account.
    • Record an invoice payment (money in) or Record a bill payment (money out): pays an open invoice or bill. A line smaller than what is owed is a part payment.
    • Split across invoices (money in): one deposit that pays several invoices. Tick the invoices and type each one's share, plus any fee the bank or card processor kept (for example $970 in for a $1,000 invoice, $30 to a fee account). You can also keep part of the deposit, or all of it, as a customer's credit. Nothing is recorded unless every share still fits.
    • Refund (money out, administrators): refunds a customer's credit or a paid invoice; see Invoicing.
    • Transfer to another account or Transfer from another account: moves money between two of your bank or card accounts and matches the other account's line too when there is one.
    • Exclude: leaves out a duplicate or pending line. Include again brings it back.
    Each action records the item in your books and matches the line to it. If the books are closed for that date (Close the Books), the action is refused. When the line already has a suggested match, RSA warns you and offers Match first, so the same money isn't recorded twice. Money between your own bank and card accounts always goes through Transfer, not Post.
  8. In the books, not on the statement lists what was still outstanding on the month's last day: entries for that account dated by then that no statement line dated by then covers, such as a check that hasn't cleared or a payment entered twice. Items still outstanding carry forward from earlier months and are labelled From an earlier month. An item matched to a statement line in a later month still shows in the earlier months it was outstanding in (for example, a payment recorded on May 31 that reaches the bank on June 1 stays on May's list, and clears in June). Entries and statement lines keep their own dates, and a closed month's figures don't change.
  9. When the difference is $0.00 and every line is matched, click Close month (it needs the Close reconciled months permission; someone who can match lines but not close sees a note). The month must have ended, and once an account has a closed month, the next month with activity must be closed before later ones. Months before the first one you close show as Before reconciliation start and never need closing, so you can start from a recent month.

Books to statement on each month shows how your books reach the statement: the books' balance at the month's end, items not on the statement yet, statement lines matched to entries dated later, the reconciled balance, the statement's balance and the difference. Anything that timing doesn't explain is shown separately.

A closed month can't be changed: lines can't be matched, added or removed, and its closing balance is fixed. Its entries are locked too: no payment, expense or journal entry on that bank or card account can be added, changed or deleted with a date in the closed month, from any screen or import. Marking lines reconciled still works. Its closing balance becomes the next month's opening balance. An admin can Reopen month on the most recently closed month to make corrections; the Audit Log records who closed and reopened it.

To import a statement straight into a bank account, use Import a statement for this account in an open month's panel. Imports skip rows dated in a closed month and tell you how many were skipped; reopen the month to import them.