Move from Sage¶
This is the step-by-step for a business moving its books from Sage Accounting (Sage Business Cloud Accounting, South Africa). The general picture (what a conversion is, and how old documents land in your books) is in Moving to BaseCloud from another accounting system. Coming from Sage Pastel (desktop)? Export from it and follow From any other system.
Nothing is changed in Sage, and nothing is sent to your customers. Keep Sage, read-only, until the move is proven.
What's different with Sage¶
Sage's connection gives BaseCloud less than Xero's or QuickBooks':
- What is owed today, not on a past day. Sage says what each invoice owes now, not what it owed on an earlier day. If your start date is in the past, anything paid since shows as paid and the preview warns you. Choose today as your start date, or bring those payments over afterwards with their own dates.
- No trial balance. You type or paste the trial balance into your opening balances yourself.
- No account numbers. Sage has none, so BaseCloud numbers your accounts by type.
- No paid history. Sage doesn't say which payments paid each invoice. To bring older paid invoices over, export them from Sage and use the batch import or the AI connection (see From any other system).
Before you start¶
- Pick your start date with your accountant: ideally today, and the first day of a VAT period, so no VAT201 is split between Sage and BaseCloud. The day before it is your balances day.
- Run Sage's Trial Balance for the balances day and keep it to hand (as a spreadsheet, so you can paste it).
- Note what isn't coming over: supplier invoices (BaseCloud has no bills yet), recurring invoices, quotes, bank transactions and reconciliations.
- You need Manage Users and the books' Manage Accounts right.
1. Connect Sage¶
In Settings › App Connections & Keys, connect Sage and pick your company. See Connect Sage.
2. Start your books with Sage's chart¶
Ask BaseCloud support to start your books with you. In the setup (see Start your books):
- Where does your chart of accounts come from? Import it from Sage, with your connection and company. Your accounts and VAT rates come across, numbered by type. Check each account's type on the Chart step.
- Start date: the date you picked. The move must use the same one.
- Financial year ends on: pick yours (often the last day of February).
- Opening balances: click Paste a trial balance and paste Sage's trial balance for the balances day, or choose it as a CSV file. Rows are matched to your accounts by name. Leave out Accounts Receivable (Customers control): it comes from the open invoices.
3. Preview the move¶
In Settings › Books, under Move from Xero, QuickBooks or Sage:
- Move from: your Sage connection. Company: the one you're moving.
- Start date: the same as your books'.
- Click Preview.
The preview shows how many customers come over (suppliers don't) and how many match clients already in BaseCloud, the items, the open invoices and credit notes with what's still owed on them, unused payments kept as credit, and Owed to you by age. It says that the trial balance doesn't come with the move. It lists anything that can't come over and why, and Clients to check after the move. Nothing has come over yet.
4. Bring it over¶
Click Bring it over. Each step shows Done, Working, Needs you or To come. Keep the page open, or close it and click Carry on later.
If a record couldn't come over, it's listed with the reason. Fix it (here or in Sage) and click Try these again.
5. Check your move¶
Click Check your move: each customer's balance in Sage against BaseCloud's, and documents by year. Then compare the Trial balance card on the Reports page, dated the balances day, with Sage's trial balance line by line, and check Historical Adjustment is zero.
6. After the move¶
- Lock the move: set a lock date once it's proven.
- Bank: import each bank account's statements from the start date. Pick your bank under Your bank (FNB, Standard Bank, Absa, Nedbank, Capitec) and the file is read for you. See Bank accounts.
- VAT invoices: add your VAT number in Settings so your invoices print as Tax Invoice with it, as SARS requires. See Sales tax and VAT.
- Online payments: connect Paystack or Stripe in BaseCloud.
- Recurring invoices: set up your Sage recurring invoices as recurring invoices in BaseCloud.
- Merge any clients listed under Clients to check after the move that are the same.
- Your accountant: give them access.