Al Mizan Building Supplies L.L.C, a new company, brings in its customers, vendors, products, opening stock, open invoices and bills and bank balances with Get started, then posts the opening balances. Account 300090 Opening Balances then shows the opening equity of the old books: 60,010.00 AED.
The case
Al Mizan Building Supplies L.L.C (a made-up company, made fresh for this example) goes live on 26/10/2026, so the opening balances are dated 25/10/2026. From the old books: 3 customers, 2 vendors, 4 products with their stock, 2 unpaid customer invoices, 1 unpaid bill and the bank and cash balances.
Settings › Get started lists the ten items. Each card has Download template, Upload, its result, and Mark as done or Nothing to bring in.
2. Bring in the customers
Download template, fill in one customer per row from row 2, save as .xlsx and Upload on the same card.
Result3 rows imported: 3 new.
3. Fix the rows Gigoo marks
The vendors file has a TRN that is too short and an emirate with a country outside the UAE. Nothing is imported; the rows table shows each Row, Column and Problem. The corrected file goes in with Upload the file again.
First tryNothing was imported: 2 rows to fix.
Corrected fileDone
4. Products and opening stock
Operations uploads the products, then the opening stock: one row per serial number for the drills. The stock rows are checked and kept; nothing goes into the books yet.
Products4 rows imported: 4 new.
Opening stock5 rows checked and kept; they go into the books when you post the opening balances.
5. Open invoices and bills
Accounts uploads the unpaid customer invoices and vendor bills with their old numbers and due dates.
Invoices2 rows checked and kept …
Bills1 row checked and kept …
6. Bank and cash balances
Enter the balances: the statement balance of each bank and the cash on the opening date, then Save.
BalancesEmirates NBD 45,000.00 · Cash 1,500.00
7. Starting numbers
Customer invoices carry on from the old system: Next number 392. The other kinds start from 1.
8. Post the opening balances
The panel shows the totals; Post opening balances, then Post in the box.
BoxEverything is posted dated 25/10/2026. Account 300090 Opening Balances will show 60,010.00 AED, which should equal the opening equity in your old books.
EntriesSTJ/2026/0001 – 0004 (opening stock) · OPEN/2026/0001 – 0003 (invoices and bill) · BNK1/2026/0001 and CSH1/2026/0001 (bank and cash, already matched)
The result
300090 Opening Balances shows 60,010.00 credit, equal to the old books' opening equity. Payments are later matched against the old invoice numbers (AM-INV-0388 …), and ageing and reminders follow the old due dates.
Try Gigoo Trading free for 14 days.
Your own company, set up in minutes. No card needed.
