Before you start
- Add your company bank accounts under Settings › Company settings › Bank accounts.
- When you record money in or out, choose the bank account it went through. BizGen can only match money recorded against that account.
BizGen matches statement lines to client payments, payments to vendors, paid claims, paid cash advances, payroll runs, owner funding, outlet settlement receipts and banked outlet cash deposits.
Import a statement
- Download the statement from your bank as a CSV file.
- Go to Reports › Bank reconciliation.
- Select Import statement and choose the file.
- Say which column holds the Date, the Description and, if there is one, the Reference.
- Under Amounts, choose One column, money out negative, or Money in and money out apart. Then choose the amount columns.
- Select Preview. BizGen shows how many lines are new, how many were already imported and which have problems.
- Select Import.
BizGen remembers the columns for that account, so the next import is quicker. Lines you already imported are skipped.
Match the lines
- Choose the Account and the Month.
- For each line, BizGen suggests a match by amount and date, within three days, and then by reference.
- Check the suggestion and select Confirm. A suggestion is never reconciled until someone confirms it.
For a line with nothing to match in BizGen, such as a bank charge, select Set aside and give a reason.
For money an owner or director put in or took back, select Owner funding. Choose Capital paid in or Advance (a loan to the company), enter the person’s name and select Record. BizGen records it under Get paid › Owner funding and matches it to the line.
To reverse a match or a set-aside, select Undo.
When a month is reconciled
The summary shows how many lines are matched, set aside and suggested. A month shows Reconciled when every line is matched or set aside.
Under Recorded in BizGen, not on the statement yet, BizGen lists money it recorded for the account that no statement line matches. Check these against your bank. They may clear in a later statement, or they may have been recorded against the wrong account.
Part of Sales & Billing →