If you’ve been running your finances on Access Dimension for years, a Xero Conversion isn’t just a software swap. It’s a decision that touches every transaction, every reconciled bank statement, and every aged receivable sitting in your system. Getting that wrong is expensive. Getting it right, though, means walking into Xero on day one with clean books and zero missing history.
That’s where things get tricky. Exporting from Access Dimension manually and re-entering data into Xero is the kind of project that sounds manageable until you’re three weeks in and your trial balance doesn’t match. MMC Convert exists to remove that risk entirely. The team handles the conversion end-to-end, running your Access Dimension data through a structured validation process and delivering a fully reconciled Xero file once the work is done.
This guide explains exactly what happens during that conversion, what data comes across, where the known limitations are, and how to place your order.
To migrate from Access Dimension to Xero using MMC Convert, you upload your Access Dimension backup file, choose a conversion type and add-ons, then MMC Convert handles the full transfer. Converted data includes chart of accounts, customers, suppliers, invoices, bills, bank transactions, manual journals, and opening balances. The process typically takes around 72 hours, and you receive a Comparative Trial Balance as a quality assurance report on completion.
Why organisations move from Access Dimension to Xero
Access Dimension has served a lot of organisations well. It’s a capable on-premise accounting system, and businesses that have used it for a long time have years of financial data locked inside it. The problem isn’t that Access Dimension stopped working. It’s that the rest of the accounting world has moved on.
Xero is cloud-native. That means your finance team can work from anywhere, your accountant can access your books in real time, and you can connect Xero to payment gateways, payroll tools, inventory apps, and dozens of other services through the Xero App Store. Access Dimension, by design, doesn’t do any of that natively.
There’s also a practical reality for businesses with Australian, New Zealand, or UK operations: Xero’s compliance tools are built around your jurisdiction. Bank feeds, GST or VAT returns, and payroll reporting are integrated, not bolted on.
You might be wondering whether the transition is worth the disruption. Here’s the thing: the disruption is largely in the conversion. Once your data is in Xero, the ongoing experience is considerably simpler. And if you’re working with MMC Convert, the conversion itself is handled by specialists who have done this migration many times before.
For more background on what a Xero migration looks like in practice, the MMC Convert Xero migration guide is worth reading before you start.
What MMC Convert transfers from Access Dimension
MMC Convert transfers chart of accounts (with custom mapping), customer and supplier details, opening balances, aged receivables and payables, bank transactions (fully reconciled), credit card and PayPal accounts, all invoices and credit notes, all bills and credit notes, and manual journals. Multi-currency transactions are brought across at the original exchange rates recorded in Access Dimension.
One of the first questions businesses ask before any migration is exactly what actually comes across. When you choose to convert Access Dimension data, the list is detailed. MMC Convert transfers:
- Chart of Accounts (custom mapping available)
- Customer details
- Supplier details
- Opening account balances
- Aged Receivables
- Aged Payables
- Bank transactions, including invoice payments, bill payments, and other bank transactions, all reconciled exactly as they were in Access Dimension
- Credit card and PayPal accounts (converted as Xero bank accounts)
- All invoices and credit notes, detailed
- All bills and credit notes, detailed
- All manual journals
The entire conversion is done on an accrual basis. That means your Profit and Loss and Balance Sheet in Xero will reflect the same accrual-based position you had in Access Dimension.
Once the conversion is complete, you’re not locked into the default setup. Xero gives you significant room to customise: chart of accounts structures, tracking categories, invoice templates, connected apps. Once your data is in, the platform is yours to configure as your business needs it.
| Data Type | Transferred by MMC Convert |
|---|---|
| Chart of Accounts | Yes (custom mapping available) |
| Customer and Supplier Details | Yes |
| Opening Balances | Yes |
| Aged Receivables and Payables | Yes |
| Bank Transactions (reconciled) | Yes |
| Credit Card / PayPal Accounts | Yes (as Xero bank accounts) |
| Invoices and Credit Notes | Yes (detailed) |
| Bills and Credit Notes | Yes (detailed) |
| Manual Journals | Yes |
| Multi-Currency Transactions | Yes (original rates preserved) |
Known limitations and workarounds
Certain fields differ between Access Dimension and Xero, which means some transactions require workarounds. The most notable limitations involve multi-currency reporting. Total AR and AP in Xero may not exactly match Access Dimension because Xero applies its own exchange rates for reporting purposes. FX variances from opening balance conversion are captured in Xero's "Historical Adjustment" account.
MMC Convert works hard to give you an exact replica of your Access Dimension data, but a few structural differences between the two systems mean some things can’t be transferred perfectly. Being clear about these upfront saves a lot of confusion later.
Multi-currency reporting differences
Multi-currency transactions are brought over in the same currency and at the same exchange rate as they were recorded in Access Dimension. That part is clean. The complication is on the reporting side.
Xero applies its own exchange rates when generating reports. Because of this, the total Accounts Receivable figure in Xero may not exactly match the sum of individual AR balances from Access Dimension. The same applies to Accounts Payable. This isn’t a data error. It’s a known difference in how the two systems calculate multi-currency totals for reporting.
Opening balance FX variance
When feeding opening balances on the conversion date, Xero uses a single exchange rate for that date across all multi-currency accounts. This can create a small difference between the debit and credit sides of your trial balance. That variance is brought through to a Xero system account called “Historical Adjustment.” It’s expected behaviour and doesn’t represent missing transactions.
Field-level differences
Some fields in Access Dimension don’t have a direct equivalent in Xero. Where this happens, MMC Convert uses workarounds to bring the underlying transaction across as accurately as possible, as detailed in the Access Dimension to Xero FAQ.
Data security during the conversion
MMC Convert uses industry-standard encryption protocols to protect financial data during the conversion process. Uploaded files are stored in AWS S3 buckets, with separate buckets created per country based on where the data was uploaded from the MMC Convert website.
Your financial records are sensitive. They contain customer details, supplier information, bank transactions, and years of business history. Sending any of that to a third party for conversion is a reasonable thing to be cautious about.
MMC Convert takes this seriously. Data transferred through the platform is protected using industry-standard encryption. On the storage side, uploaded files are held in AWS S3 buckets, with each bucket created specifically for the country from which the data was uploaded via the landing page. That regional separation means your data isn’t pooled into a generic storage environment.
Compatibility and version support
MMC Convert is built to support multiple versions of both Access Dimension and Xero. That said, it’s always worth confirming compatibility for your specific version before you start. Businesses running older or less common versions of Access Dimension should check this early in the process rather than after uploading the file.
If you’re unsure, the support team can advise. You can reach them via email or the online support portal.
Ready to move from Access Dimension to Xero?
Get a fixed-price quote for your conversion and know exactly what you're paying before the work begins. No surprises, no hidden fees.
Get a Quote →How the conversion process works, step by step
The MMC Convert process for migrating from Access Dimension to Xero takes approximately 72 hours after payment. You upload your Access Dimension backup, select a conversion type (Basic or Full Transactional), choose add-ons, confirm and pay, then MMC Convert executes the migration in a trial Xero account before transferring the Xero subscription to your email on completion.
The conversion process is designed to be straightforward on your end. You don’t need to be technically minded or have any prior experience with data migrations to get through it.
Click Convert Now on the home screen
Start at the MMC Convert website and hit the Convert Now button to begin the order process.
Select software by country
Choose "Convert from Access Dimension" and select the country relevant to your business.
Upload your Access Dimension backup file
Securely upload the backup file from your Access Dimension system through the MMC Convert platform.
Choose your conversion type and add-ons
Select Basic or Full Transactional (current year to date, or one historical year plus current year to date). Choose additional years if needed, then select any add-ons: payroll, multi-currency, customisation of chart of accounts, attachments, estimates, or purchase orders.
Confirm order and make payment
Review your order and complete payment. Once confirmed, your file is queued for conversion.
MMC Convert executes the migration
MMC Convert subscribes to a trial Xero account and runs the full migration. This takes approximately 72 hours. Your team can keep working in Access Dimension in the meantime.
Receive your Xero file and go live
On completion, you receive a Comparative Trial Balance for each financial year end, along with a Trial Balance as at date, as a Quality Analysis Report. The Xero subscription is then transferred to your email and your business is ready to operate in Xero.
The Quality Analysis Report: what you get on completion
When the conversion is finished, MMC Convert doesn’t just hand over a Xero login and wish you luck. You receive a Comparative Trial Balance for each financial year end, plus a Trial Balance as at the conversion date. These serve as your quality check, a way to verify that the numbers landing in Xero match what was in Access Dimension before you cut over.
This matters because it gives you something concrete to sign off on. You can compare the Xero trial balance against your last Access Dimension reports line by line. If there are questions, you have the data to ask them.
Why MMC Convert rather than doing it yourself
MMC Convert uses advanced algorithms and data validation checks to ensure converted data is error-free and consistent. The team has handled Access Dimension to Xero conversions across multiple versions of both platforms and provides customer support via email and an online portal throughout the process.
You could attempt this migration manually. Export what you can from Access Dimension, format it for import into Xero, rebuild the chart of accounts, manually re-enter transactions that don’t fit a clean CSV format. Plenty of businesses have tried this route and spent weeks on it — only to end up with a trial balance that doesn’t reconcile and no clean way to trace where it went wrong.
MMC Convert’s approach is different. The conversion runs through validated algorithms that check data integrity at multiple points before anything lands in Xero. Errors that would silently pass through a manual import get caught and corrected before your Xero file is handed over. The team has dealt with the field-level differences between Access Dimension and Xero many times, which means they know where the common problems sit and how to handle them.
There’s also the time argument. For most finance teams, the hours saved on a professional conversion more than justify the cost, especially when you factor in the cost of fixing a botched manual migration after the fact.
If you have questions during the process, the support team is reachable via email and the online support portal. You’re not on your own once you’ve placed an order.
Data validation at every stage
Extensive checks run throughout the conversion to catch errors before they reach your Xero file. What you receive has been verified, not just exported.
Full reconciliation on delivery
A Comparative Trial Balance for each financial year gives you a concrete quality check before you go live in Xero. Numbers you can verify line by line.
Hands-off for your team
Your finance team keeps working in Access Dimension while MMC Convert handles the conversion. No downtime, no disruption to daily operations.
Ready to make the move?
Migrating from Access Dimension to Xero is a reasonable decision for any organisation that’s outgrown on-premise accounting or simply wants the flexibility that comes with a cloud platform. The data involved is real and significant, which is exactly why it’s worth doing properly.
MMC Convert handles this conversion regularly. The process is structured, the pricing is transparent, and you get a reconciled Xero file with a quality report to verify the work before you go live. If you have a complex setup with multi-currency transactions or specific chart of accounts requirements, those can be accommodated as add-ons.
The best next step is to get a quote so you know what the conversion will cost for your specific file. If you want to talk through your situation before committing, please feel free to Contact us.
Migrate from Access Dimension to Xero with MMC Convert
Our team handles the full conversion (chart of accounts, customers, suppliers, invoices, bills, bank transactions, and manual journals) and delivers a reconciled Xero file with a Comparative Trial Balance for verification. No accountant fees, no manual re-entry, no missed transactions.
- ✓ Full historical data transferred
- ✓ All bank transactions reconciled
- ✓ Multi-currency support available
- ✓ Quality Analysis Report included
Frequently Asked Questions
What data does MMC Convert transfer from Access Dimension to Xero?
MMC Convert transfers chart of accounts (with custom mapping available), customer and supplier details, opening balances, aged receivables and payables, bank transactions reconciled exactly as in Access Dimension, credit card and PayPal accounts (as Xero bank accounts), all invoices and credit notes, all bills and credit notes, and manual journals. Multi-currency transactions are brought across in the same currency and at the same exchange rate as originally recorded in Access Dimension.
How long does an Access Dimension to Xero conversion take?
The conversion typically takes approximately 72 hours after payment is confirmed. During this time, your team can continue working in Access Dimension as normal. MMC Convert runs the migration in a trial Xero account and transfers the subscription to your email once the work is complete and quality checks have passed.
Why might my Accounts Receivable total in Xero differ from Access Dimension?
This is a known reporting difference caused by Xero applying its own exchange rates when generating reports. Individual multi-currency transactions are transferred at the correct original rates, but Xero recalculates the total AR and AP balances using its own rate for reporting purposes. This is not a data error. The same behaviour applies to Accounts Payable. Any FX variance arising from opening balances is captured in Xero's "Historical Adjustment" account.
Is my financial data secure during the conversion process?
Yes. MMC Convert uses industry-standard encryption protocols to protect data during the conversion. Uploaded files are stored in AWS S3 buckets, with separate buckets created for each country based on where the data was uploaded from the MMC Convert website. Your financial information is not pooled into a generic environment shared across regions.
Can I customise my Xero setup after the migration is complete?
Yes. Once your data is in Xero, you have full control to customise and configure the account to suit your business. Xero offers extensive options including chart of accounts adjustments, tracking categories, invoice templates, payroll settings, and integration with hundreds of third-party apps. The MMC Convert team can also assist with chart of accounts customisation as an add-on during the conversion.
What conversion types are available for Access Dimension to Xero?
MMC Convert offers two conversion types: Basic and Full Transactional. Full Transactional includes either the current year to date or one historical year plus the current year to date. Additional historical years can be added as an optional extra. Add-ons available include payroll, multi-currency, chart of accounts customisation, attachments, estimates, and purchase orders.
How do I migrate from Access Dimension to Xero?
The safest way to migrate from Access Dimension to Xero without losing historical data is by using a specialised conversion service like MMC Convert. Attempting a manual export via CSV often leads to unreconciled trial balances and lost transaction history. MMC Convert handles the end-to-end process, ensuring all data, including multi-currency transactions, is securely transferred.
Can I import Access Dimension data directly into Xero?
There is no native one-click integration to directly import Access Dimension data into Xero. You must either manually export CSV files and map the fields yourself, or use a conversion partner like MMC Convert to programmatically transfer and reconcile the data for you.
Will I lose my financial history when switching from Access Dimension to Xero?
No, if you use a full transactional conversion service, you will not lose your financial history. MMC Convert transfers detailed invoices, bills, manual journals, and reconciled bank transactions, ensuring your Xero file perfectly matches your Access Dimension records on day one.
Ankit has led over 1,200 successful accounting data migrations, specialising in QuickBooks Desktop transitions to cloud platforms. He advises businesses across the US, UK, Canada, Australia, and globally on data integrity, platform selection, and compliance-safe migration timelines.