Ainsworth Accountants: Accounts, Tax and Business Advisors.

Convert from Sage to QuickBooks

Sage to QuickBooks Conversion


We will transfer your Sage historical data into QuickBooks to help you on your way to using Intuit's exciting QB2014 for small businesses.

When you convert your business records from Sage to QuickBooks you will discover how quick and easy QuickBooks is to use.

You will be able to access your data very quickly, and drill down to information through the easy-to-reach reports.

If you transfer your historical transactions from Sage to QuickBooks you will be able to keep your company transaction history together. This is very important and could prove invaluable.

We provide this service for any UK location.

When to Change Accounting Systems

A good time to change is the year end. This will be the time when you have worked with your accountants and have an up-to-date and checked Balance Sheet. Also, it means that after a year on the new system you will have a full prior year sales and expenses comparison for the Profit and Loss Account.

If you change mid-year, you will have to give your accountants two half-complete sets of records which will require them to do more work at the year end.

If you change only a month or two into a new accounting year, it can be a good idea to start the new system by going back to the start of the accounting year. This way you will ‘parallel’ the new with the old for a couple of months, which can give you extra confidence that the transfer has worked well.

What is Transferred from the Old System to the New System?

The transfer is in three broad areas:

• Fixed Information (mainly compulsory)
• Opening Balances (100% required)
• Transaction History (Optional)

Should you transfer just the fixed information or all the transaction history?

Fixed information includes: customer names and addresses, supplier names and addresses, product, services and prices, employees, accounts structure.

Transaction history includes: sales, purchases and expenses, bank and cash transactions, investments, fixed assets, capital introduced, loans, taxes, salaries and wages.

Fixed Information or “Standing Data”

You will need to transfer all or most your fixed information. If you decide not to transfer transaction history, you may further decide to limit your transfer of fixed information to just your current customers and suppliers. This also acts as a tidy up.

Transaction History

Transferring transaction history has the big advantage of having all of your company records ‘to hand’ in the new system and should make reporting a lot easier. One of the reasons why you may be changing systems is that you have found it difficult to get the right information and reports. If that is the case, it would be a disadvantage if your transaction history was not available on the new system.

It is unlikely that you can ‘pick and choose’ the transaction history to be transferred; it is usually an ‘all or nothing’ choice. It might be possible to add together some individual transactions into a summary, but this will take longer.

Transfer of Opening Balances

You will need to transfer your closing balances on the old system to be the opening balances on the new system. This is imperative.

Balances to transfer include: fixed assets, investments, stock quantities, customer balances, bank, cash, supplier balances, loans, equity, tax; and other technical accounting balances, eg. accruals and prepayments.

Can I destroy the old records and software ?

No, not for a while. Limited company records should be kept for six closed years plus the current open year. This means keeping the software data file and the paperwork.

Fixed Information Transfer

This is a list of just some of the fixed information to be transferred. Please note that it is not a definitive list.

Company Information

Business Name, Address, Tax Information, Year End,

Nominal Accounts / Chart of Accounts

Fixed Assets, Investments, Bank & Cash Accounts, Loans, Equity, Taxes, Accruals, Prepayments, Sales, Cost of Sales, Expenses, Budgets, Prior Year Comparatives, Currency,


Corporation Tax, VAT, PAYE, CIS, Intrastat, EE Sales List,


Name, Address, Ship To Addresses, Contact Details, Terms, Discounts, Bank Account, Credit Limit, VAT Number, Sales Orders, Back Orders, Quotations,


Name, Address, Contact Details, Terms, Discounts, Bank Account, VAT Number, Default Account, Purchase Orders,

Products and Services

Stock Name and Number, Description, Price, Default Account, VAT Code, Bill of Materials, Units of Measure, Bins & Lots, Bar Codes, Labelling, Minimum Order Quantities, Order Discounts, Freight Charges,


Name, Address, NINO, Salary, PAYE Code, Marital Status, Gender, Contact Details,


Starting Numbers, Templates and Layouts, Authorities, Security, Back Up, Reporting, Disaster Recovery, Memorised Transactions,