Bring in your opening balances.

Download the Excel workbook in Settings, fill in your balances, customers, suppliers, items and stock, add the file to check it, then import it once.

Updated , for WorkBook 2.0i.

Use this when you move from another system or from paper. You enter what you owned and owed on the day your books start, in one import.

Before you start.

  • Set up the company first: chart of accounts, VAT codes, branches and locations.
  • Sign in as a company-wide Admin. Other users cannot see this screen.
  • The company must be new. WorkBook refuses an import once any sale, purchase, payment or stock movement has been posted.
  • Have the closing trial balance from your old system, the list of unpaid invoices and bills, and your stock count with costs.

Steps.

  1. Open Settings, then Setup, then Opening Position.

  2. Choose Download Workbook. It has one sheet each for customers, suppliers, items, the trial balance, unpaid customer invoices, unpaid supplier bills and opening stock.

    Step 1 of Opening position, with Download Workbook and the single-sheet links
  3. Fill in the sheets you need and leave the others empty. Keep the header row. Use this company's own account, VAT and location codes. Give new customers, suppliers and items new codes.

  4. Set the Opening date and the Branch for the opening journal.

  5. Add your file under Workbook or sheet files. WorkBook checks it at once and saves nothing.

    Step 2 with the opening date, branch and an added file in a red box after the check found problems
  6. Read the result. When the check finds problems, the file loses its tick and the box turns red. Each problem lists the sheet, row and column. Fix the file, then add it again.

    Step 3 listing two problems found in the file
  7. When the check passes, choose Import Opening Position and confirm.

Good to know.

  • The trial balance must include receivables, payables and inventory. The customer, supplier and stock sheets must add up to those totals.
  • Invoice and bill amounts are what is still unpaid, including VAT. Their own dates are kept, so statements and ageing show the original numbers.
  • These are opening balances, not new sales or purchases. They do not appear in sales totals or in your VAT return.
  • You can import once for a company and opening date. A file over 8 MB is refused. Excel formulas are refused: paste values.
  • You can also add separate Excel or UTF-8 CSV files named after each sheet.

Related.