The checklist
Settings → Data migration lists nine steps in the order that works best. Each step is short. Steps the system can check tick themselves and say so, for example "Profile set." or "Suppliers exist."
If you added sample data when you signed up, you can keep it while you work. Once your own products are in, remove it in one go under Settings → Company → Sample data.
- "Company profile": names, address, tax number and logo. "Open Company" takes you there.
- "Stores and warehouses": one location for each place that holds stock. "Open Locations".
- "Products and prices": import your product list from the CSV template on the Products screen. "Open Products".
- "Opening stock": post one opening-stock adjustment per store with quantities and unit costs. "Open Adjustments".
- "Suppliers": press "Import suppliers".
- "Customers": press "Import customers", so the till finds them by phone number.
- "What customers owe you": press "Enter what customers owe" to put each customer's unpaid amount on their account.
- "What you owe suppliers": press "Enter what you owe suppliers" so each unpaid bill is ready to pay under Finance → Payables.
- "Opening balances": press "Import balances" to bring in the old books' closing balances, except what customers owe and what you owe suppliers, which the two steps before it enter per person.
Import suppliers or customers from a CSV
- Press "Import suppliers" or "Import customers".
- Press "Download template". Open it in Excel or Google Sheets. It has the exact column headers and an example row.
- Fill one row per supplier or customer. Only "name" is required. The supplier template also has code, contact name, e-mail, phone, address, tax ID, payment terms in days, currency and notes. The customer template has name, phone, e-mail and notes.
- Save as CSV and press "Choose CSV…".
- Check the preview, which shows how many rows are ready and how many were skipped.
- Press the import button. Rows are created one by one; a row that fails does not stop the others. The results table shows "Created" or "Failed" with the reason for each row.
If you see "The file is missing these columns", download the template again and copy your data into it.
Enter what customers owe and what you owe suppliers
Enter these per person, not as one total, so every customer's account and statement and every supplier's bills are right from your first day.
- Press "Enter what customers owe" (or "Enter what you owe suppliers") and then "Download the template".
- Customers: one row per unpaid amount with the phone (or name), the amount and, if you know them, the bill's date and number. Suppliers: one row per unpaid bill with the supplier code (or name), the amount, the bill number, its date and its due date.
- Set "Opening date" to the day you start in Sevo. Bills with an older date keep it, so they show as late in ageing.
- For customers, leave "Add customers who are not in Sevo yet" ticked to create the ones you have not imported; they need a phone and a name.
- Press "Choose the file". Every row is checked first: each shows the person it matched, or what is wrong. Nothing is posted while a row has a problem.
- When it says the rows are ready, press "Post". Posting the same file again in the same window adds nothing twice.
The Opening balances sheet no longer takes Trade debtors (1100) or Trade creditors (2000): they are the sum of these per-person amounts.
Import opening balances
- Press "Import balances" and then "Download template".
- Fill one row per account with its code and either a debit or a credit, never both. The account codes must exist in Finance → Chart of accounts.
- Choose "As of": usually the last day of your old system's final period. Add a "Memo" if you like.
- Press "Choose CSV…" and check the totals. The sheet must balance to the cent. If it does not, add the difference to an equity account such as Opening balance equity.
- When it says "Debits equal credits - ready to post.", press "Post opening balances".
More in this area
- Company profile and logo
- Users, roles and permissions
- Two-step sign-in (extra security for your account)
- Approval limits
- Currencies and exchange rates
- Plans, trial, payment and invoices
- Audit log, backups and keeping your data safe
- Features you use: a shorter menu
- Several businesses in one company: shop, restaurant and pharmacy