Moving to WorkBook.

From Tally, Zoho Books, QuickBooks or Excel: your balances, open invoices and stock, in one checked import.

Matches WorkBook as of .

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 needTallyPrimeZoho BooksQuickBooks
Trial balanceTrial BalanceTrial BalanceTrial Balance
Unpaid customer invoicesBills ReceivableAR Aging DetailsOpen Invoices
Unpaid supplier billsBills PayableAP Aging DetailsUnpaid Bills
Stock on hand, with costStock SummaryInventory Valuation SummaryInventory 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.

SheetWhat goes in
CustomersCode 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.
SuppliersCode and name. Optionally the control account, credit limit, payment terms, TRN and TIN.
ItemsCode, name, unit, VAT code, and the sales, cost and stock accounts. Timber can be set to sell by cubic feet.
Trial balanceEach account’s debit or credit on the opening date.
Unpaid customer invoicesEach open invoice: customer, number, date, due date and the amount still owed.
Unpaid supplier billsEach open bill, the same way.
Opening stockEach 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.

Bring your books over.