Solavel Docs
English

Bank & Cash in Simple

Last updated

Bank & Cash shows your bank and cash accounts with their balances and activity, and, when enabled for your plan, lets you import bank statements, match them to your books (reconcile) and keep bank rules.

#What Simple does and does not do

Task In Simple
See balances and transactions Yes
Record money in, money out, transfer, expense from an account Yes (buttons on the account)
Import a statement (CSV, OFX, QFX) Yes, when the feature is on for your organization
Reconcile an account Yes, when on
Bank rules Yes, when on
Create, edit, archive or delete a bank/cash account Yes (see below)
Record a bank fee or interest found during reconciliation No. "To record a bank fee or interest, use Professional Mode."

If you lack permission, the pages show "You do not have access to this section."

#Add, edit, archive and delete accounts

Click New bank or cash account on the accounts list to add an account. Open an account and use Edit to change it.

  • Archive hides the account from new receipts, payments and transfers. Its register and history stay available, and the page shows an "Archived" note. Use Reactivate to bring it back.
  • Delete is offered on every row of the list except your main account. If nothing uses the account it is removed permanently (this cannot be undone). If it has history, Simple says "This account can't be deleted" and offers Archive instead.

#The accounts list

The top shows Total across active accounts in your base currency, with a note that balances in other currencies are listed separately. Stat cards show the number of Bank accounts and Cash accounts. Filter by Type (Bank, Cash) and status (Active, Inactive), or search accounts. Columns: Account, Balance, the base-currency amount, Status, Last activity. A foreign-currency account also shows Also holds and an approximate base equivalent.

The balance is a ledger balance "as of" today. Future-dated transactions are excluded and reported: "Excludes [n] future-dated transaction(s) ...". If some posted lines have no saved base value you see a warning that the base equivalent may be incomplete.

#One account

Open an account to see Current balance and the Transactions list. Filter by Direction (In and out, Money in, Money out), by dates, or search. Types shown: Expense, Expense payment, Money in, Money out, Transfer, Payment, Other income, Journal, Correction. Amounts are in each line's own currency and a running balance is shown in the account register. Rows that open in Professional are marked Opens in Professional Mode.

Buttons at the top: Money in, Money out, Transfer, and New expense (in the menu). Each opens the form with this account already chosen. The tabs are Activity, Reconcile, Import statement, Rules.

#Import a statement

  1. Open the account > Import statement.
  2. Drop or choose a file: CSV, OFX or QFX (TXT also accepted), up to 10 MB. Tick The first row contains column names when it does.
  3. Click Upload and preview. Simple shows Detected columns. Map Date, Description and the amount: One column (negative = money out) or Separate debit and credit columns. Click Update preview after changing the mapping.
  4. Check the preview: Money in, Money out, counts of valid rows, rows with errors and duplicates.
  5. Click Import statement (or Import valid rows only). Use Discard to cancel. Then Go to reconcile.

Recent imports shows each file with Imported, Discarded or Failed.

#Reconcile

  1. Open Reconcile > Start a reconciliation. Enter Statement start, Statement end and Statement closing balance from your bank statement, then Start reconciliation. Earlier ones are under Previous reconciliations (In progress, Reconciled, Locked).
  2. The meter shows Statement balance, Cleared in books and Difference.
  3. Left: Bank statement lines; right: Not yet matched in your books. Filter lines To match, Matched, Ignored. For a line, view Suggested matches (with a "% match" score and Exact, Close or Split labels), then Accept. Accept all exact matches matches every safe exact pair at once. Use Unmatch, Ignore or Restore to fix mistakes.
  4. When the difference is zero Simple says "Balanced. You can finalize this reconciliation." Click Finalize. Use Lock to stop further changes from Simple. A finished one shows "This reconciliation is no longer editable."
  5. Use Update closing balance if you typed the wrong figure.

#Bank rules

Rules recognise repeating statement lines and boost match suggestions. Click New rule: Rule name, conditions (Description contains, Payee contains, Amount from / Amount to; at least one), When it matches (Only suggest, Prepare an adjustment, Adjust and match with an Offset account), Confidence boost, Priority, Active. Turn rules on and off or delete them from the list. Deleting does not change past reconciliations.

#Worked example

Palm Grove's October statement closes at AED 48,250.00. After you match every line, the books show 48,305.00 because a 55.00 bank fee on the statement is not booked yet, so the meter shows a Difference of 55.00 (48,305.00 - 48,250.00). Simple cannot book the fee: record it in Professional, return, and the Difference becomes 0.00. Then click Finalize.

#If you see ...

Message Meaning
No bank or cash accounts yet. Click New bank or cash account.
You do not have access to this section. Your role lacks that banking permission, or the feature is off for your plan.
Not balanced yet. Match or ignore the remaining lines. Difference is not zero.
No safe exact matches were found. Match lines one by one.
CSV, OFX or QFX, up to 10 MB The file type or size was rejected.

See Troubleshooting.