Bank accounts¶
To check your books against your bank, add each account your business banks with, then bring in its statement. You then reconcile the statement with your books, line by line.
Banking is part of Books, so your books need to be on first. Open it from Accounting › Bank accounts.
Who can do this
View Books to see your bank accounts and their statement lines. Manage Accounts to add, edit, archive or restore a bank account and change its Feed settings. Reconcile Bank to import a statement, sync a feed and reconcile. Buttons you don't have the right for don't show. See User rights.
Add a bank account¶
Click Add bank account.
| Field | What to enter |
|---|---|
| Name | What you call it, such as Business Checking. |
| Account number | Optional. Only the last four digits are kept, to tell your accounts apart. |
| Account in your chart | Pick it if your chart already has this bank account (say, from your opening balances or an import from Xero or QuickBooks). |
| Account code | For a new account in your chart. Leave it empty for the next free code. |
| Statement opening balance | The balance on the bank's statement just before the first line you'll import. |
Click Add bank account. Each bank account is one account in your chart of accounts, of type Bank.
Two opening balances
The statement opening balance is only used to compare your books with the bank. The balance in your books comes from your opening balances, or a manual journal for an account you open later.
Each account on the Bank page shows its Statement balance, the date of its Last line, its Balance in your books, and how many lines are left to Reconcile. When the two balances disagree, it says so. An account with a bank feed shows the bank it reads, with the bank's logo where there is one (a US bank through Plaid), or its first letter.
An account without a bank feed shows Connect a bank feed and Import a statement on its card. Everything else is under the card's ⋯ (or right-click the card): Feed settings (or Connect a bank feed), Import a statement (or Import earlier lines for an account with a feed), Edit details and Archive.
Edit details changes the name, account number or statement opening balance. Archive puts away an account you've closed. It's refused while the account still has a balance in your books (move it with a transfer first) or has statement lines still to reconcile. Tick Show archived to see them, and Restore to bring one back.
The bank account's page¶
Click a bank account to open it. Under its name it says where its lines come from and, for a feed, when it last synced. Three tabs: Reconcile (with how many lines are left), Statement lines and Transactions.
Reconciliation summary, at the top, compares the bank with your books As at a day you pick (today to start with): the Statement balance, the Balance in your books, what's Still to reconcile, and the Difference. It says The books agree with the bank when they do. Ignored lines count in the statement balance but need nothing in your books, and it says how many there are.
Check against your bank's balance¶
The statement balance is worked out from the lines you have. To check none are missing or doubled, click Check against your bank's balance, type Your bank's balance and the day it's for (At the end of), from your bank's statement or online banking, and click Check it. BaseCloud says whether the lines add up to the same. If they don't, a statement may not be imported yet, a line may have come in twice, or the opening balance may be wrong. A CSV file with a Balance column, and a bank feed, give BaseCloud the bank's balance by themselves. An account whose lines don't add up is marked on the Bank accounts list.
When your books opened the account at a different figure¶
If the statement's balance when your books started differs from the opening balance your books gave the account, the page says both figures. Click Use the statement's balance (it needs Post Journals) to change the books' opening balance to the statement's. See Opening balances.
For a printable bank reconciliation report, add the Bank reconciliation card on the Reports page. See The bank reconciliation report.
Bring in a statement¶
A statement can come from a file you download from your bank, or from a bank feed. Choose which in Feed settings (Connect a bank feed on a card in the Bank list, or Feed settings on the bank account's page), under How statement lines arrive:
- I import statement files
- A bank feed brings them in
Bringing in a statement never changes your books. The lines wait for you to reconcile them.
Import a statement file¶
- Download a statement from your bank's website as CSV, OFX, QFX or QIF. Most banks offer at least one of these where you download statements. Files can be up to 6 MB; for a bigger one, download a shorter period and import it in parts.
- On the bank account, click Import a statement.
- If Your bank lists your bank (in South Africa: FNB, Standard Bank, Absa, Nedbank and Capitec), pick it. It says where to find the file in your online banking, and its export is read without matching columns by hand.
- Drop the file in, or click to choose it.
- For a CSV file, Check the columns (see below). OFX, QFX and QIF files are read as they are; for QIF, check the Date format.
- Check the preview: how many Lines, the dates From and To, and Money in less out. The first rows show as they'll be imported, money in as a plus amount and money out as a minus.
- Click Import.
Lines you already have are skipped, so importing a file that overlaps an earlier one is fine, and so is importing the same file twice.
What the preview tells you:
- Rows that aren't transactions, such as a heading, an opening or closing balance or a total, are left out, and it says how many.
- Rows that can't be read (a missing date, an amount that isn't a number) are listed and left out. The rest import. If they look like transactions, check the date format.
- If most of the file can't be read, nothing would be imported: check the Date and Amount columns and the date format.
- If the dates could be read more than one way (
03/04/2027is March 4 or 3 April), it says so. Check the date format, so no line lands on the wrong day. - If the file says it's for an account with different last four digits from this one, it warns you. Check you picked the right bank account.
Check the columns of a CSV file¶
BaseCloud reads the columns for you: the way your last file for this account was read, your bank's export when you picked Your bank, or worked out from the file. The preview says which. Change any that are wrong; the preview updates as you go, and your choices are remembered for this account's next file. Start again goes back to what BaseCloud worked out.
| Setting | What it means |
|---|---|
| The file has a row of column names | Untick it if the file starts straight with a transaction. When the column names aren't on the first row, BaseCloud finds them and leaves out the rows above (usually details about the statement). |
| Date and Date format | The column with the date, and how it's written, such as MM/DD/YYYY in the US or DD/MM/YYYY in South Africa. |
| Amounts are in | One column, money out shown as minus, or Two columns: money in and money out. |
| Amount and Money in or out column (DR / CR) | With one column: the amounts, and, if your bank marks each one DR or CR in another column, that column. |
| Money in, Money out and Bank charges | With two columns: the amounts, and a separate column of bank charges if your bank has one. |
| Description, Payee, Reference | Optional columns that help you recognise a line. Choose Not in the file for any it doesn't have. |
| Balance | Optional. Your bank's running balance: BaseCloud keeps it to check the statement lines against. |
| Plus and minus | Money in is a plus amount (most bank statements), or Money out is a plus amount (most card statements). |
| Numbers look like | Work it out from the file, 1,234.56 (US and most banks), or 1.234,56 (a decimal comma). |
Undo an import¶
Imported the wrong file, or into the wrong account? On Statement lines, pick it under From a file import. The page shows that file's lines and how many are matched. Click Undo this import and confirm: its lines not yet matched are deleted. Matched lines stay, because they're in your books: unmatch them first to remove them too. Importing the file again brings the lines back.
Connect a bank feed¶
A bank feed brings each account's transactions in by itself. Which service brings them in depends on where your business is:
- United States: Plaid.
- South Africa: Yodlee.
- Anywhere: your Stripe or Paystack account can be a bank account too. See Stripe and Paystack as bank accounts below.
Feed settings offers only the services for your country. BaseCloud goes by the currency your books are kept in. Elsewhere, import statement files (South African banks have ready-made settings under Your bank).
- Connect your bank under Settings → App Connections & Keys. See Connect a bank account. A Plaid connection you already use for the Plaid Trigger works too.
- On the bank account's card in the Bank list, click Connect a bank feed (or open Feed settings on the account's page) and choose A bank feed brings them in.
- Pick the Bank feed provider, the Bank connection and the Account at this bank.
- Bring in lines from: the first day to bring in. Leave it empty to start the day after the newest line this account already has (from a file, say), or the day your books start if it has none. Through Plaid, banks share up to two years of lines; through Yodlee, up to a year. Import a statement file for anything earlier.
- Click Save. The feed brings lines in straight away.
On the first sync, a line a statement file already brought in for the same day and amount is recognised, not added again. After that, new transactions come in every hour. Click Sync feed to bring them in now. The bank account shows when it was last brought up to date and the day of the feed's first line. Yodlee updates its copy of your bank about once a night, so a Yodlee feed usually brings the day's lines in the next morning.
- Only transactions that have cleared come in. A pending card transaction waits until it clears, because its amount can still change.
- If the bank takes a transaction back, its line is removed, unless you've already reconciled it. Then it stays, marked The bank removed this line, until you unmatch it. If the bank sends the same transaction again under a new number (same date, amount and description), it takes that line over instead of coming in twice.
- If the bank changes a transaction (its amount, date or description), a line you haven't reconciled changes with it. A reconciled line keeps what you matched it to and shows what the bank changed. Unmatch it to use the bank's figures, then reconcile it again.
- One account at your bank can feed only one bank account in BaseCloud. If you reconnect your bank and it gives the accounts new numbers, BaseCloud follows them.
- The feed and the Plaid Trigger read the same Plaid connection without getting in each other's way.
Need lines from before the feed started? On a fed account, click Import earlier lines and import a statement file. It adds the days before the feed's first line; the file's lines from that day on are left out, so nothing comes in twice.
If the bank asks you to sign in again, the bank account says Your bank needs you to sign in again, and new lines wait. Click Sign in to your bank on the page. Plaid's or Yodlee's window opens; sign in to your bank there, and the feed brings in what it missed. If the feed couldn't reach the bank, the bank account says why and tries again every hour; click Try again to try now. When a feed stops, BaseCloud also leaves a note for your admins.
Stripe and Paystack as bank accounts¶
If you take payments through Stripe or Paystack, the money sits with them for a few days before it reaches your bank. Treat that account as a bank account in your books. Its feed brings in everything that happens there, and its balance matches what Stripe or Paystack is holding for you.
The feed uses the Stripe or Paystack connection you already have for online payments. You don't sign in again.
- Add a bank account for it. Pick the ledger account named Stripe Clearing or Paystack Clearing if your books have one. That's where BaseCloud already records the payments your clients make online, so those payments match their lines without any extra step.
- Click Connect a bank feed on its card, choose A bank feed brings them in, and pick Stripe or Paystack as the Bank feed provider.
- Pick your Stripe or Paystack connection, then the currency this bank account follows.
- Click Save.
What comes in:
- Each payment your customers make, at its full amount.
- The fee Stripe or Paystack kept on it, as a separate line going out.
- Refunds and disputes or chargebacks you lost, as money going out. A dispute you win comes back in.
- Payouts to your bank, as money going out. A payout that fails comes back in.
On Stripe, a payment comes in as soon as Stripe has it, even before it's ready to pay out. Lines are dated on the day the money moved, in UTC.
Reconcile the lines like any other bank account:
- A payment line matches the payment BaseCloud recorded, because both carry the same Stripe or Paystack reference.
- Record fee lines as a spend to your merchant fees account. A bank rule can do this for you.
- A Payout to bank line is a transfer from this account to your main bank account. Record the transfer once, then match the same payout on your main bank account's statement to it.
Each currency is a separate balance at Stripe or Paystack, so it needs its own bank account in BaseCloud. If a key stops working (you rolled it, say), the bank account asks you to update it. Paste the new key under Settings → App Connections & Keys, then click Sync feed.
Statement lines¶
Statement lines on the bank account lists every line the bank has given you. Search by description, reference or amount, and filter by Show (to reconcile, matched or ignored), the dates From and To, and From a file import. Order puts the newest or the oldest first. Each line shows what it's matched to.
- Tick lines to Ignore, Restore or Delete them together.
- Delete removes a line you imported by mistake. Only lines not yet matched can be deleted.
- Unmatch and Restore undo a match or an ignore. See Unmatch a line.
Transactions on the bank account lists the money you've spent, received or transferred through it.
Related¶
- Bank reconciliation: match each line to your books.
- Bank rules: reconcile everyday lines in one click.
- Spend, receive or transfer money: money with no invoice behind it.
- Month end