BizHub365
Switching from Xero, QuickBooks, Sage or FreeAgent: moving your records in with a CSV export
Why owners put off switching, and what a tidy move involves
You have got used to your current software. Invoices go out, bookings land in the diary, and you know exactly where to click at the end of the month. Moving feels like a week of lost evenings, and the worry about losing a customer's history is a fair one.
A tidy move is less about the new software and more about the records. You want your customers in one list, your open invoices and payments easy to find, and a clear point where the old system stops and the new one starts. Plan for that, do your export in one sitting, and check what arrives before you rely on it.
Step 1: export your customers, invoices and transactions as CSV from your current software
Xero, QuickBooks, Sage and FreeAgent can each export data as CSV files. Menu names change between versions, so look for the export or report options in your provider's help pages rather than relying on a memory of where things used to be.
Export three things separately: your customers, your invoices, and your bank transactions. Note the date range each file covers, and save a dated copy somewhere safe. Keep the originals untouched. You will edit a working copy in the next step, and if something goes wrong you want a clean version to go back to.
Step 2: check the export for gaps, duplicates and odd dates before you bring it in
Open each file in a spreadsheet and spend ten minutes looking for the usual problems:
- Duplicate customers, such as the same firm listed twice with slightly different spellings.
- Blank email addresses or missing names on customers you still trade with.
- Invoices with no customer attached.
- Dates that have been read the wrong way round. An invoice dated 02/03 could mean 2 March or 3 February, so check a few against the paper trail you know.
- Transactions with blank descriptions, which will be harder to match later.
Fix problems in the working copy, not the original. Merging duplicate customers now saves you tidying up inside the new system. Do not try to correct every historic oddity. Focus on the records you still use: current customers, unpaid invoices and recent transactions.
Step 3: bring the records into BizHub365 and look over what has arrived
BizHub365 lets you bring your records in from a CSV export of Sage, QuickBooks, Xero or FreeAgent. Import the files, then do not assume everything has landed correctly. Check it.
Start with counts. The number of customers and invoices in BizHub365 should be close to the number in your old system, allowing for anything you deliberately merged or left out in Step 2. If the numbers are far off, stop and find out why before going further.
Next, spot-check five or six records from start to finish. Pick a customer, open their invoice, and check the amount, date and status. Compare the total of open invoices with your old system. These checks matter more than any single screen, because they tell you whether the import has carried across what you actually need. What comes across depends on what your export contains, so check the things you rely on.
Step 4: connect bank import and let smart matching pair payments with invoices
Once your customers and invoices are in place, connect your bank import. BizHub365 brings in your bank transactions and uses smart matching to suggest which payments belong to which invoices.
Treat the suggestions as a first draft. Review them before you accept, especially where two customers have paid the same amount on the same day, or where a payment covers more than one invoice. Matching saves time on the routine payments, but the judgement calls are still yours.
Step 5: set up your booking diary, opening hours and holiday closures so customers can self-book
If you take bookings, this is the step that makes the move worthwhile for your customers. Set your opening hours and add your holiday closures so the diary shows the right availability. Then turn on customer self-booking, so people can book their own slots without phoning or messaging you.
If you already keep your calendar in Google, Outlook or Apple, BizHub365 provides an iCal calendar feed you can subscribe to, so bookings show up where you already look. Check a test booking yourself before you tell customers the new system is live.
Keeping your old account open until you are happy, and asking your accountant or bookkeeper to take a look
Do not close your old account on the day you finish the import. Keep it running alongside BizHub365 until you have checked at least one full month of invoices, payments and bank matching against it. It costs you very little to keep it open for a few weeks, and it gives you something to compare against if a figure looks wrong.
If you work with an accountant or bookkeeper, ask them to look at your exports and your BizHub365 reports before you switch fully. They know which records they need and in what form, and they can tell you quickly whether anything is missing. Working alongside them in BizHub365 is simpler when both of you are looking at the same records.
Flat pricing with no per-user fees, and the trial wording
BizHub365 is one plan, BizHub365 One, with one subscription per business and no per-user fees. Adding a bookkeeper or a member of staff does not change the price.
14-day free trial. We take your card when you sign up and charge it when the trial ends, so cancel before then to pay nothing. Then 19 pounds a month or 190 pounds a year; the payroll add-on is extra and is not part of the trial.
If you want to try the move without commitment, start your free 14-day trial, bring in a CSV export from your current software, and see what arrives before you decide anything else.