• Welcome :

FAQ-SQL to Xero Conversion

Home FAQ-SQL to Xero
Convert Now

What we Convert

  • Chart of Accounts ( We do custom mapping as well)
  • Customer Details
  • Supplier Details
  • Opening Account Balances
  • Aged Receivables
  • Aged Payables
  • Bank Transactions (Includes Invoice payments, Bill payments and other Bank Transactions) (All Bank Transactions reconciled as it was done in SQL)
  • Credit Card and Paypal Accounts (converted as Xero Bank Accounts)
  • Classes (comes as "Tracking Category" in Xero)
  • Items (comes as "Inventory" in Xero)
  • All Invoices and Credit Notes Detailed
  • All Bills and Credit Notes Detailed
  • All Manual Journals
  • The entire conversion and matching of Reports is done on ACCRUAL Basis.
  • We make our best attempt to give you the exact image of your SQL data, however, due to the limitations of few fields which are different in SQL and Xero, we might have to use some workarounds to bring the transactions.

What We Dont Convert

  • Budgets
  • Track Inventory
  • Fixed Asset
  • Expense Claims
  • Memorised Transactions
  • Payment Terms
  • Custom VAT Rates
  • Invoice Templates
  • Time Sheets
  • Repeating Invoices after the "Convert To" date
  • Deleted/Void Transactions
  • Allocation of Invoices or Bills against credit notes
  • Transaction lines with Nil Values
  • Attachments
  • Unreconciled entries
  • Purchase Orders and Estimates (We import purchase orders and estimates as a "Draft" in Xero for a fixed fee)
  • Individual Payruns for the Conversion Period
  • Multi Currency Transactions
  • We are specialist in converting core financial information and we try our best to bring the other non-financial information as well, however, because of the limitation of APIs of both softwares, we might not be able to get few fields

Workarounds

  • Chart of Accounts - Sub Accounts in SQL are converted as Independent Accounts in Xero
  • Chart of Accounts - Inactive Accounts, if used in SQL in the conversion period are turned as Active Accounts in Xero
  • Open Receivable and Payable Invoices shall contain only single line showing the unpaid balance of Invoice in Xero
  • Multiple Accounts Receivables in SQL are merged in single Account Receivable in Xero
  • Multiple Accounts Payables in SQL are merged in single Account Payable in Xero
  • Multiple VAT Accounts in SQL are merged in single VAT Account in Xero
  • Custom Sales Tax Rates are converted into standard Sales Tax Rate with "Tax Adjustment" entry as a separate line item in Xero
  • Inter-Bank Transfers may be converted through a Clearing Account in Xero
  • Clearing Account is used in Xero for transactions where Accounts Receivable, Accounts Payable are passed as Journal Entry in SQL
  • Transactions without any contact/payee name in SQL would be transferred as "No Name" contact in Xero
  • System Accounts like Retained Earnings, Sales Tax Account, are used in Xero for their counterpart accounts in SQL
  • Rounding can be different in Xero and SQL because of the data precision techniques used in both softwares.
  • Blank Bill reference Numbers and Invoice reference Numbers:- In case we find any invoice or bill without a number, we use a dummy number example for Bills:- Bill1, Bill2 and for Invoices - Inv1, Inv2.
  • Duplicate reference Number in bank transactions or invoices/bills:- In case we find duplicate reference numbers then we use transaction numbers instead of reference numbers or make the numbers unique by appending an extra character with a hyphen
  • Limitation of Item number:- Xero have limitations of 30 characters for Item number thus for the item numbers more than 30 characters we have to trim them to 30 characters.
Convert Now
App Benefits Placeholder
What makes us Special?

Historical Years of Conversion

We convert the full previous years to date. Get a complete mirror image of your financial data including previous years.

Payroll

All transactions and payroll are setup so you can pick up where you left off.

Multi Currency

We bring over multi currency transactions in the same foreign currency at the same exchange rate as fed in the source software.

Customized Conversions

Just ask and we deliver. Data conversion can be customized depending on your requirement.

Timely Execution

We've done our best to make sure that we timely deliver converted data.

Constantly improving

We are always trying to improve the service we deliver to our customers.

What Our Customers Say

Read All...
Rob Cheesman
Rob CheesmanDirector, Kettering Professional Services
We used MMC for two Reckon conversions. One in Australia and one in New Zealand. Both had multi currency and one had payroll. We were very happy with the work done and especially how good the communication was. Highly recommend them.
Erica Chapman
Erica ChapmanDirector, Skyline Business Solutions
Great company to work with, fast turnaround and good communication. I had them do a conversion from Xero to QuickBooks Online that another company failed to do. Their team was quick to complete it and it was accurate! Highly recommended.
Telgavati Subramanyam
Telgavati SubramanyamDirector, First Idea Training Solutions
We are highly recommend MMC Convert and the great service the provide. Excellent service and 5 year data moved from MYOB to QuickBooks Online. Satisfactory data migration achieved.
Brian Schmitt
Brian SchmittCo-Founder, SureFoot
"MMC converted us from Wave to Xero. Our data in Wave was apparently a little unusual, but after a couple emails MMC had us totally setup and running in Xero w/ all our past data from Wave! I would definitely use them again."
Sharon Chapman
Sharon ChapmanManager at RMY Clements
Ankit has always been quick, efficient and very helpful when converting companies for us (2 so far) from Sage One to QuickBooks so I would have no hesitation recommending MMC Convert.

Our Conversion Packages

  • Basic

    £129GBP
    FIXED
    • Chart of Accounts
    • Conversion date balances
    • One Historical Year+ Current Year to Date Transactions
    • All open receivables
    • All open payables
    • All contacts (Customers, Suppliers & Employees)
  • Full Transactional

    £189GBP
    FIXED
    • Chart of accounts
    • Previous FY balances
    • One Historical Year + Current Year to Date Transactions
    • All receivables
    • All payables
    • All contacts (Customers, Suppliers & Employees)
We can go back historically for any number of years at an additional price of £69 GBP per year

Limitation of Services | What we Convert
*We do full bank reconciliations as fed in your previous software

How It Works We Convert your data file with few simple steps.

  • Step
    1
    Load File
  • Step
    2
    Select Service & Provide Details
  • Step
    3
    Make Payment
  • Approve Quotation
    Step
    4
    Leave file with MMC
  • Step
    5
    Receive Subscription Transfer
Copyright © 2025 - MMC. ALL RIGHTS RESERVED BY MMC CONVERT | Contact 9926477000.