Access Dimension to Xero
Account Ability to Xero
clearbooks to Xero
Kashflow to Xero
MoneyWorks to Xero
myob essentials to xero
myob to xero
qb online to xero
qb to xero
Quicken to Xero
Reckon Home And Business to Xero
Microsoft Dynamic to Xero
Reckon to Xero
Saasu to Xero
Sage 50 to Xero
Sage One to Xero
TAS to Xero
VT to Xero
Free Agent to Xero
QB to QBO
XERO to QBO
TAS Books to QBO
MYOB to QBO
Sage 50 to QBO
Excel to QBO
Zoho to ClearBooks
Xero to ClearBooks
Twinfield to ClearBooks
Solar Accounts to ClearBooks
Bright Pearl to ClearBooks
MYOB to ClearBooks
FAQ- Excel to QBO Conversion
FAQ-Excel to QBO
1. What we Convert
Chart of Accounts(We do custom mapping as well)
Opening Account Balances
Bank Transactions (Includes Invoice payments, Bill payments, and other Bank Transactions) (All Bank Transactions reconciled as it was shown in EXCEL)
Credit Card (converted as QBO Bank Accounts)
Invoices and Credit Notes Detailed
Bills and Bill credit Detailed
All Manual Journals
Inactive Contacts/Accounts can be brought over on special request
We make our best attempt to give you the exact image of your EXCEL data, however, due to the limitations of few fields which are different in EXCEL and QBO, we might have to use some workarounds to bring the transactions.
2. What We Dont Convert
Transaction lines with Nil Values
Individual Payruns for the conversion period
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 information, we might not be able to get few fields.
Chart of Accounts - Sub Accounts in EXCEL are converted as Independent Accounts in QBO
Chart of Accounts - Inactive Accounts, if used in EXCEL in the conversion period are turned as Active Accounts in QBO
Open Receivable and Payable Invoices shall contain only single line showing the unpaid balance of Invoice in QBO
Custom Sales Tax Rates are converted into standard Sales Tax Rate with "Tax Adjustment" entry as a separate line item in QBO
Inter Bank Transfers may be converted through a Clearing Account in QBO
System Accounts like Retained Earnings, VAT control Account are used in QBO for their counterpart accounts in EXCEL.
In multi-currency files, while feeding the opening balances on the conversion date, QBO would use the same exchange rate for the conversion date for all the multi-currency accounts. This might cause a difference in the debit and credit side of the trial balance.
Rounding can be different in QBO and EXCEL because of the data precision techniques used in both of them.
4. Multi Currency
Multi-Currency Transactions (brought over in same currency as they were fed in EXCEL, same exchange rate as it was fed in EXCEL)
Total Accounts Receivable in QBO shall not exactly match the Total Accounts Receivable in EXCEL because of the different exchange rates used in QBO
Total Accounts Payable in QBO shall not exactly match the Total Accounts Payable in EXCEL because of the different exchange rates used in QBO.
Get in Touch with us
Get immediate assistance for any query you may have regarding MMC.
We are available 24x7 to resolve your queries.
Tweets by mmcconvert
1250 N Lasalle Street Chicago. 60610, USA
Level 1, 1034 Dandenong Rd Carnegie, VIC 3163, Australia
Babel Studios 82 Southwark, Bridge Road, London
PO Box 56754 Dubai, UAE
163, RNT Marg, Indore, India
Forgot your password
Haven't registered yet ? Sign up here
Confirm password does not match
Please select the destination software to which the file to be converted.
You are requested to please fill the Contact Us Form specifying your desired destination software, and we shall get back to you shortly.