WorkBook brings in your opening position in one go: customers, suppliers, items, the trial balance, unpaid invoices and bills, and stock. You take the figures from your old software, put them into WorkBook’s opening workbook, and WorkBook checks every sheet before it saves anything.
Before you start
- Pick an opening date. The first day of a VAT period is easiest: each return then comes from one system.
- Set up your company, branches, chart of accounts, VAT codes and cost centres in WorkBook first. Every account, VAT code and cost centre the sheets name must already exist.
- The import is for fresh books: a company with nothing posted yet. Each company and opening date can be imported once.
- It needs a company-wide administrator, and a company that keeps its books in dirhams.
What to take from your old software
Run these reports as at the day before your opening date, and save them as Excel.
| What you need | TallyPrime | Zoho Books | QuickBooks |
|---|---|---|---|
| Trial balance | Trial Balance | Trial Balance | Trial Balance |
| Unpaid customer invoices | Bills Receivable | AR Aging Details | Open Invoices |
| Unpaid supplier bills | Bills Payable | AP Aging Details | Unpaid Bills |
| Stock on hand, with cost | Stock Summary | Inventory Valuation Summary | Inventory Valuation Summary |
These are the report names in each product; menus differ between versions. Customer, supplier and item lists can be exported from each product’s own lists. From Excel or any other system, fill the sheets by hand.
The seven sheets
In WorkBook, open Settings, then Bring in opening balances and stock, and download the workbook. It has one sheet for each part. Every sheet must be there, even if it holds only its headings.
| Sheet | What goes in |
|---|---|
| Customers | Code and name. Optionally the control account, credit limit and payment terms, and for UAE business customers the TRN, TIN or Peppol ID that e-invoicing needs. |
| Suppliers | Code and name. Optionally the control account, credit limit, payment terms, TRN and TIN. |
| Items | Code, name, unit, VAT code, and the sales, cost and stock accounts. Timber can be set to sell by cubic feet. |
| Trial balance | Each account’s debit or credit on the opening date. |
| Unpaid customer invoices | Each open invoice: customer, number, date, due date and the amount still owed. |
| Unpaid supplier bills | Each open bill, the same way. |
| Opening stock | Each item at each location: quantity and unit cost. Timber by size and number of pieces. |
Use .xlsx or UTF-8 .csv files, up to 8 MB each and 50,000 rows a sheet.
What WorkBook checks
- The trial balance balances: total debits equal total credits.
- Receivables and payables in the trial balance equal the unpaid invoices and bills.
- Stock accounts equal the value of the opening stock.
- Every code exists, nothing is repeated, no document is dated after the opening date, and no due date comes before its document’s date.
- A TRN has 15 digits and a TIN 10, and every UAE business customer has a TRN, TIN, Peppol ID or legal registration, so e-invoices can go out.
- For timber sold by cubic feet, the quantity matches the sizes.
This check saves nothing. It lists every problem by sheet, row and column; fix them and check again.
Import
- When every sheet is ready, choose Import. Balances, open documents and stock are saved together, in one opening journal for the branch you chose.
- Each open invoice and bill keeps its original number, date and due date.
- Importing the same files again changes nothing.
After the move
- Compare WorkBook’s trial balance on the opening date with your old one.
- Keep your old software, or its exports. Tax records must be kept for years after you move: 5 years for VAT, and 7 for Corporate Tax and real estate. Records to keep.
- Connect your accredited e-invoicing provider in WorkBook before you send your first e-invoice. How e-invoicing works.
- Questions about your move? Talk to us.
TallyPrime, Zoho Books and QuickBooks are trademarks of their owners, named only to say which reports to use.