Move your data (Settings > Documents and data) takes you through the move one step at a time. It opens by itself after the first setup of a new workspace, and you can come back to it whenever you like. Nothing is posted to your books until you review it.
Before you start
Pick your cut-over date: the first day DynamoOS keeps your books (usually the first day of a month or of the fiscal year). Every opening balance is the balance at that date. Export these from your old program at that date: the customer, supplier and item lists, the stock report of each warehouse or branch, the trial balance, and the receivables and payables aging (the open invoices).
The steps
| Step | What you bring |
|---|---|
| Company and fiscal year | The cut-over date, the month your fiscal year starts, your VAT and commercial registration numbers |
| Chart of accounts | Keep the chart you have, take the Saudi chart, or upload your own (numbers, names, parents, kinds) |
| Customers | Name, type, group, region, VAT number, commercial registration, mobile, e-mail, city, address |
| Suppliers | The same for your suppliers |
| Items and prices | Code, name, group, unit, stock item or service, selling and buying price, barcode |
| Opening stock | Quantity and unit cost of each item in each warehouse |
| Opening balances | The trial balance, then each customer's and each supplier's open invoices with their due dates |
| Employees | Only with People: name, gender, dates of birth and joining, department, job title |
| Review and post | The checks, then one click posts everything |
| Compare with your old system | Side by side, every difference highlighted; your accountant signs off |
Each file, the same way
- Download the template of the step. It is in your language, marks the required columns with *, offers drop-down lists (types, groups, units, accounts, warehouses) and has an Examples sheet. You can also upload the export of your old program as it is.
- Upload your file (Excel .xlsx or CSV). The reader finds the row with the column names even under a report title, skips the total line, and understands Arabic and English column names, VAT and commercial registration numbers, Hijri or Gregorian dates and amounts such as 1,250.50 or 1,250.50 SAR.
- Check the preview. Rows with a problem come first, each problem in plain words next to its cell. Correct the cell in place, or leave the row out. Under Columns of your file you can change what a column means; the next file with the same columns is matched the same way, and a name you corrected (an old account name, for example) is remembered too.
- Import. The import runs in the background with its progress on the screen. It is all or nothing: if one row fails, nothing is saved and the reason is shown.
- Undo the import takes back everything one file created, as long as the opening balances are not posted.
Opening balances done right
- The trial balance becomes one balanced opening journal at the cut-over date, through a temporary opening equity account. Bank and cash balances are lines of the trial balance.
- Receivable, payable and stock accounts are not posted from the trial balance: they come from the customers' and suppliers' open invoices (one per invoice, with its due date, so the aging is right from the first day) and from the opening stock (valued at your costs). Their totals must equal the trial balance; the review shows any difference before you post.
- If your cut-over is inside the fiscal year, revenue and expense balances of the year so far are posted in a second journal of the same date, so your profit for the year stays complete.
- Opening invoices carry no VAT and are not sent as e-invoices: your old system already issued and reported them.
Compare with your old system
After posting, the last step shows the trial balance of DynamoOS next to yours, account by account, then the receivables and payables by due date and the stock value of each warehouse, at the cut-over date. Every difference is highlighted. To check a later month side by side, choose the date and upload the trial balance your old system shows for that date. When everything is right, your accountant writes a note and clicks I checked it: sign off; who signed and when is kept with the figures.
We help you move
Prefer that we do it? Click We help you move at the top of the page. A support request opens with every file you uploaded attached, for our fixed-price setup service. You can follow it in Support.