Support

Your completed backups are stored in cloud storage you own and control: OneDrive, Google Drive or Dropbox. You connect your storage when you set up your account, and every finished backup is delivered straight into it.

To create a backup, we securely read your data from Xero and process it on our systems. Once the backup is complete, it's delivered to your connected storage. We don't keep a library of your backups for you to download later. Your own cloud storage is the home for your backups.

This means you decide where your data lives, who can access it and how long you keep it. If data location matters to your business, choose a storage account and region that suits your requirements.

Access to Xportmydata is through Xero's secure sign-on, so there's no separate Xportmydata password to manage. If you have questions about how we handle your data, email support@xportmydata.com.

There's nothing extra to download. Every completed backup is already saved in the OneDrive, Google Drive or Dropbox account you connected to Xportmydata.

To find a backup:

• Log in to Xportmydata with your Xero login.
• Open Backup History and find the backup you want.
• Open the backup folder in your connected cloud storage.

If you'd also like an offline copy, download the backup folder from your OneDrive, Google Drive or Dropbox to your computer or an external drive, the same way you would with any other file. Keeping more than one copy in different places is good practice.

If you can't find a backup or something looks wrong, contact our support team.

There are lots of reasons you might want to get data back into Xero. You could be starting a new company, selling a business but keeping its history, or moving between two Xero files where you're the subscriber for both.

It's worth knowing that Xero doesn't offer a full restore of your organisation from a backup. Not many people realise that. What we do is create Xero-ready CSV import files and Excel copies of your data, so you can get key records back in using Xero's own import tools.

Import areas:

• Bills: Accounts payable details (imported as inclusive of GST/VAT).
• Chart of Accounts: Your accounting structure.
• Contacts: Customer and supplier information.
• Inventory Items: Product and stock data.
• Manual Journals: Adjusting entries for special transactions.
• Sales: Income and sales receipts.

You'll find these in the 'Import' folder in each backup. Check the data lines up with Xero's import templates, as a little adjustment may be needed for everything to import successfully. Our Tutorials tab has step-by-step guides.

If you have questions or get stuck, our support team is here to help.

We've noticed that some of our valued customers are comparing the total from Xero's Bank Accounts tab with the Bank Transactions sheet in our Xportmydata Excel backup. We understand this may create some confusion, so we've prepared this article to clarify the situation.

What is Included in Xero's Bank Accounts Tab?

In Xero, the Bank Accounts tab shows the total that includes:

• Cash transactions (Spend and Receive Money)
• Accounts Payable (Bills)
• Accounts Receivable (Invoices)
• Bank Transfers

What Does the Xportmydata Bank Transactions Sheet Capture?

The Bank Transactions sheet in our Excel backup focuses solely on cash transactions, which are transactions coded directly to specific account codes. In Xero, these are "Spend Money" and "Receive Money" transactions. "Spend Money" transactions capture outflows that aren't related to bills, expense claims or refunds, like bank fees. "Receive Money" transactions track inflows that aren't related to sales invoices or refunds, like interest income.

Why the Difference?

The Bank Accounts tab in Xero displays a comprehensive list of transactions, either manually entered or imported directly through Xero's bank feed. This tab effectively mirrors the lines on your bank statement. It includes not just cash transactions but also bills (Accounts Payable), invoices (Accounts Receivable), and bank transfers.

On the other hand, the Bank Transactions sheet in the Xportmydata backup captures only the cash transactions. These are transactions that are directly coded to specific account codes in Xero, known as "Spend Money" and "Receive Money" transactions.

Moreover, the AccountsPayable and AccountsReceivable sheets in the Xportmydata backup can be a bit more complex. Each invoice or bill is often represented by multiple rows, each corresponding to a different line item. However, only one of these rows will contain the payment amount and date. Simply summing these rows won't give you an accurate total because of these multiple entries.

How to Reconcile the Numbers?

To reconcile the total number from Xero with the data in the Xportmydata backup, you'll need to:

• AccountsPayable & AccountsReceivable: Filter out duplicate entries based on the unique entry ID (InvoiceID) and sum up the relevant payment amounts.
• Bank Transactions: Sum up the relevant cash transactions.
• Bank Transfers: Add in the amounts from inter-account transfers.

We assure you that all data is captured in the Xportmydata backup. If you find any discrepancies, it's likely because the Xero Bank Accounts tab and Xportmydata backup are capturing different sets of transactions. We hope this article clarifies any confusion. Should you have more questions, feel free to reach out to our support team.

Standard Xportmydata subscriptions run set-and-forget weekly backups.

Need backups more often than once a week? Add the Daily Backups add-on and a fresh copy of your Xero financial data lands in the same cloud storage you already control, every day. You can add it to your existing plan from your account. For prices, see our pricing page.

If you only need a one-time backup, our Single Download gives you a full backup of your Xero data for a flat price, including the Files and Payroll add-ons where available, delivered into your own cloud storage.

Standard Xportmydata backups run weekly. The Daily Backups add-on steps that up, so a fresh copy of your Xero financial data lands in your own cloud storage every day.

• Same storage: Daily backups go into the OneDrive, Google Drive or Dropbox you already use with Xportmydata.
• Same setup: Set and forget, just more often.
• Works with your other add-ons: Keep Files and Payroll if you already use them.

Add Daily Backups to your plan from your account. See the Daily Backups page for details and our pricing page for prices.

The Files add-on backs up the files stored in Xero: uploaded attachments, receipts, invoices and other documents, plus the content of your Xero Files folder. Lots of businesses keep important documents there, like contracts and fixed asset invoices, which your accountant may need for reviews.

Files are saved into your own OneDrive, Google Drive or Dropbox as an organised archive, in their original format as when they were first uploaded to Xero. An Excel summary indexes the files, so it's easy to find the attachment that belongs to a particular transaction.

The Files add-on is available on all subscription plans and is included in Single Download. It isn't included in the free trial.

Yes, Xportmydata's monthly plans come with a 12-month minimum term for each organisation. After completing the initial 12 months, the subscription rolls over to a month-by-month basis.

Important Points to Note:

• Except for Single Download, all subscriptions carry a 12-month minimum commitment, in line with our Terms and Conditions.
• If you choose to cancel before completing the 12-month term, you'll be responsible for the remaining balance of the term.

If you wish to end your subscription after the 12-month period, we ask for one month's notice. For any queries or if you need further clarity on your Xportmydata subscription, please reach out to our dedicated support team.

At Xportmydata, we strive to make our payment process as seamless as possible. We currently accept all major credit and debit cards. Our payments are processed through the secure Stripe payment portal, ensuring your card details are always protected.

Additionally, each of our monthly invoices includes a link that allows you to update your payment method whenever you need to. You can also find all your invoices in the 'My Details' section once you're logged into Xportmydata.

If you're having difficulty updating your card details or encounter any payment-related issues, please get in touch with our support team for assistance.

Your billing security is paramount to us at Xportmydata. We've partnered with Stripe, a global leader in payment processing, to ensure your details are safeguarded. Here's how:

• Immediate Encryption: When you input your billing details, they're instantly encrypted, ensuring the data remains unreadable during transmission.

• Safe Storage with Stripe: Stripe stores your billing details in a high-security environment compliant with stringent industry guidelines. They are continuously innovating to stay ahead of potential threats.

• Tokenisation for Added Security: We never store your complete credit card details on our servers. Stripe provides us with a unique token for your card, allowing us to process charges without having direct access to your card details.

• Highest PCI Standards: Stripe's certification is at PCI Service Provider Level 1, the peak in the payment industry. It signifies their commitment to upholding the strictest security standards.

• Regular Check-ups: Stripe continually evaluates its systems for security, ensuring they remain airtight against any potential breaches.

• Advanced Fraud Prevention: With state-of-the-art machine learning, Stripe can promptly identify and prevent suspicious activities, safeguarding your card from misuse.

Our collaboration with Stripe provides you a secure, smooth, and worry-free billing experience with Xportmydata.

You can upgrade your Xportmydata subscription any time from your account. Add Files, Payroll or Daily Backups, or move to a higher-tier plan. If you need to back up another Xero organisation just once, you can also buy a Single Download.

Downgrades work a bit differently. You can only downgrade after your initial 12-month subscription period ends. When you're ready, contact our support team and we'll sort it out.

We're sorry to hear you're thinking of cancelling. Your feedback helps us improve.

Points to consider:

• Terms and Conditions: Most subscriptions have a 12-month minimum commitment per Xero organisation. If you cancel before that period ends, you're still liable for the balance of the 12-month subscription.
• Cancellation (full term): If you cancel before the term ends, we'll charge your card for the remaining balance of your subscription for the rest of the 12-month term.
• Cancellation (one-time backup fee): If you took out a subscription but really only needed a one-time backup, we don't usually offer immediate termination. In some cases we may make an exception and charge a one-time backup fee of $120 USD per Xero organisation (the same as our Single Download price), deducting any previous payments.
• Continuation: You can keep receiving your weekly backups until the term ends.

Please note: If you cancel early, you'll be charged the difference. To take the next steps or ask questions, contact our support team.

Our commitment to providing a quality service comes with a 12-month minimum term for most subscriptions. We've noticed some users attempt to sign up and cancel shortly after to circumvent this commitment. Please be aware that even if you choose to pay monthly and decide to cancel early, you'll be responsible for the balance of the 12-month subscription, meaning no refunds will be issued for early termination. This policy is in place to protect the integrity of our services and ensure fairness to all our loyal customers.

If you're considering updating your email address, it's crucial to understand the impact of this change, particularly regarding your Xero login which our system uses. Here's a breakdown of what you need to know:

• What Changing Your Email Does: Updating your email in our system mainly affects where you receive communications and notifications from Xportmydata. It ensures that you continue to stay informed about important updates and information related to our services.

• What It Doesn't Do: It's important to recognize that changing your email address with us does not automatically update your Xero login credentials. Since our system uses your Xero login, any changes made in our system will not affect how you access Xero.

• Changing Your Xero Login Email: To update the email associated with your Xero account, please contact our support team using the original email address registered with Xero. We will guide you through the process to ensure your Xero login reflects the new email. This update is crucial for maintaining seamless integration with our system.

• Limitations on Modifying Xero Login Details: Due to the security protocols with Xero logins, modifications to the login details are restricted. We can only assist in updating the email associated with your Xero account by contacting support on this address.

Should you require more information or have any questions, please feel free to contact our support team. We're here to help and ensure your interactions with Xportmydata are both smooth and secure.

We work with IT professionals, Managed Service Providers (MSPs), accountants and bookkeepers who look after Xero clients.

Accountants and bookkeepers: Sign up as usual and tell us you're a bookkeeper or accountant when you set up your account. Once we've verified that, we'll apply special pricing on your plan and on Single Download, including the option to pay monthly. More on our Accountants & Bookkeepers page.

IT professionals and MSPs: See our IT Professionals & MSPs page for how we can work together.

Questions? Email support@xportmydata.com.

Need to protect more than ten Xero organisations? Use our 11+ organisations tier. Per-organisation pricing is reduced compared with the smaller tiers, and you can keep adding organisations as you grow. There's no separate Enterprise plan.

See current rates on our pricing page. Accountants and bookkeepers can also get special pricing after we verify them. Details on the Accountants & Bookkeepers page.

Questions? Email support@xportmydata.com.

Xero is a great accounting platform. Xero looks after its platform and recommends you keep your own copy of your data. But there's no simple way in Xero to pull out all of your organisation's data in one go, and attachments have to be downloaded one at a time.

If you want your own complete copy, whether you're closing, selling your business or just want peace of mind, Xportmydata does the work for you.

We back up your Xero data into storage you own: OneDrive, Google Drive or Dropbox. That includes your accounting data in Excel with Xero-ready CSV import files, and optionally your files and attachments, Payroll data (Australia, New Zealand and UK) and daily backups. We use Xero's single sign-on, so you get the benefit of Xero's multi-factor security.

Keeping your own copy in a separate place is sound security practice and lines up with frameworks like the Essential Eight.

Your completed backups are saved in your own OneDrive, Google Drive or Dropbox, so they stay there even if you stop using Xero. They're your files and you can open them any time from your cloud storage.

If you stop using Xero you won't be able to log in to Xportmydata with your Xero credentials. If you need help with your account, contact us from the original email address you registered with Xero, so we can verify your identity, and we can update your account details to a new email.

If you'll still need new backups, we recommend setting up a new user in Xero that we can move the subscription to. Use your original email to let us know about the change.

Yes. Because your backups are saved in your own OneDrive, Google Drive or Dropbox, you can still open them even if you lose access to your Xero organisation. Here's how to stay prepared:

Keep access to your cloud storage: Your backups live in the OneDrive, Google Drive or Dropbox account you connected. Make sure you or your business keeps control of that account.

Check your latest backup: If you know you're about to lose Xero access, check Backup History and confirm your latest backup has landed in your cloud storage. Make a copy somewhere else too if you'd like extra peace of mind.

Keep access to your registered email: The email registered with Xero is how we verify you. If you might lose access to it, add a new email address as a user in your Xero file in advance.

Tell us about email changes: Email us from your original signup/Xero address with the new email, and we'll update your account.

If you need help, contact support@xportmydata.com.

After selling your business, you'll probably want to keep all the financial data, files, attachments and Payroll details (Australia, New Zealand and UK) from your Xero organisation. Our Single Download captures all of this in one go, with no subscription.

Your backup is delivered into your own OneDrive, Google Drive or Dropbox, so you keep a complete copy of your Xero financial data whether you keep using Xero or not.

If you need a hand, our support team is here to help.

Xero's Terms of Use and keeping your own copy:
Xero looks after its platform and recommends you keep your own copy of your data. Xero's Terms of Use make it clear that keeping your own records is your responsibility. Xero is a strong, secure platform, but technical failures, security incidents and accidental deletions can still happen.

The risks of data loss:
As well as accidental deletions, someone with access to your Xero file could remove attachments and historical records going back years. That could disrupt your business and leave you without important records.

How Xportmydata helps:
We give you regular, automated backups of your Xero data in storage you own. Weekly is standard, or daily with the Daily Backups add-on. You get Excel copies of your records plus Xero-ready CSV import files. Xero doesn't offer a full restore of your organisation from a backup, but having your own copy means you can still see your history and get key records back into Xero if something goes wrong.

Understanding the Scope of Financial Compliance Engagements:
For business owners relying on accounting professionals to back up their financial data from Xero, understanding the scope and limitations of financial compilation engagements, as outlined by the New Zealand Institute of Chartered Accountants, is essential. These engagements involve compiling your financial information based on the data you provide. However, it's important to note that they do not include conducting audits or reviews (unless specifically completed), meaning the accountants do not assume responsibility for the accuracy, reliability, or completeness of this financial information.

Limitations of Accountants' Backups:
While accountants may take snapshots of ledger transactions, this does not typically include the detailed extraction of invoice information, descriptions, detailed payments, credit details, or copies of all your invoices uploaded to Xero. These elements are crucial for maintaining a complete and accurate financial record. However, it's important to understand that the primary role of accountants in these engagements is focused on preparing financial reports, not on backing up your data in its entirety. As such, they may not extract and selectively save this detailed information that is vital for a comprehensive financial overview.

The Role of Xportmydata in Data Protection:
Given these limitations, having a robust data protection strategy is crucial. Utilizing a solution like Xportmydata ensures the safety and recoverability of your business's financial data. Xportmydata complements your accountant's work by capturing these finer details, maintaining the integrity and availability of your financial records. This comprehensive approach safeguards your financial health and operational continuity, providing an additional layer of data protection and peace of mind.

The Subscriber who signed up for Xero is the official owner of the data, not necessarily the business owner.

In the digital domain, understanding ownership can sometimes have its complexities. In Xero's context, the "Subscriber" refers to the individual or entity that registered with Xero and agreed to their terms of service. Holding the Subscriber status grants primary authority and responsibility over the data within the Xero organisation, irrespective of who is paying for the service. This key role dictates who can access the data and to what extent, making the Subscriber the principal figure in managing and safeguarding the organisation's data on the Xero platform.

It's crucial to review your account settings in Xero to determine the Subscriber status within your organisation, as this status is central to data management, security, and compliance. This becomes particularly significant if employees are using personal email addresses for business operations on Xero. For instance, if an employee with a personal email address is designated as the Subscriber and then leaves the company, regaining control over your Xero organisation and its data can become a cumbersome and potentially risky process. It's advisable to use a business-controlled email address for the Subscriber role to avoid such complications and ensure seamless control and management of your data.

Revenue agencies in different parts of the world, such as New Zealand's Inland Revenue Department (IRD), Australia's Australian Taxation Office (ATO), the UK's His Majesty's Revenue and Customs (HMRC), or the USA's Internal Revenue Service (IRS), generally require businesses to retain their financial records for a specified period, often seven years.

With Xportmydata, your financial data is backed up automatically into your own OneDrive, Google Drive or Dropbox, so there's no need for manual exports or local drives. Keeping those backups in your cloud storage for as long as your revenue agency requires helps you keep records that are readable and easy to get to.

GDPR (General Data Protection Regulation) is an EU law about how personal data is handled. It applies to any business, anywhere, that deals with people in the EU.

Xportmydata supports your GDPR approach in a few ways:

• You choose where backups live: Completed backups are delivered into your own OneDrive, Google Drive or Dropbox, so you control the storage location, who can access it and how long you keep data.
• No backup library with us: We process your data to create each backup, then deliver it to your storage. We don't keep your backups for you to download later.
• Secure sign-in: Access is through Xero's single sign-on with Xero's multi-factor authentication.

If data location matters for your business, choose a cloud storage account and region that suits your requirements. If you have questions, email support@xportmydata.com.

The Essential Eight is a set of cybersecurity strategies from the Australian Cyber Security Centre. It covers application control, patching applications, configuring Microsoft Office macro settings, user application hardening, restricting administrative privileges, patching operating systems, multi-factor authentication and regular backups.

Xportmydata helps with the backup piece. We back up your Xero data into storage you own, weekly as standard, or every day with the Daily Backups add-on. Access is through Xero's single sign-on, so you get Xero's multi-factor authentication with no extra passwords to manage.

Here's how we look after your data:

• Secure sign-in: Access is through Xero's single sign-on with Xero's multi-factor authentication. There's no separate Xportmydata password.
• Backups in storage you control: Completed backups are delivered into your own OneDrive, Google Drive or Dropbox. You decide where they live, who can see them and how long you keep them.
• Secure processing: We read your data from Xero through Xero's official connection and process it on our systems to create each backup before delivering it to you.
• Secure payments: Card payments are handled by Stripe. We never store your full card details.

If you'd like extra copies, you can download backups from your cloud storage to another location any time. Questions? Email support@xportmydata.com.

The Subscriber should review user access in Xero regularly, as maintaining a secure financial environment is a continual effort, particularly when multiple individuals like accountants or bookkeepers have access.

We advise conducting a comprehensive review of your account's user permissions every six months. This habitual check ensures that only authorized individuals have access, aiding in upholding a robust security posture.

It's also a good practice to consult with your accountant or bookkeeper before making changes to user access. Instead of deleting user logins outright, which may cause issues, ask them to review and manage user access as they are often more familiar with who requires access for various tasks. Note that depending on the tasks at hand, backup personnel, accountants, and bookkeepers may have multiple individuals within their organizations requiring login access.

Additionally, it's prudent to set reminders for reviewing user permissions. Setting a six-month interval for these reminders can assist in managing your Xero security.

An Introduction

If you're new to using Xportmydata, this video tutorial will guide you through the process of setting up your backups. In less than a minute, you'll learn how to connect your Xero organisation, select the data to back up, and schedule automatic backups for peace of mind. Watch the video below to get started.

Before you start: Xero doesn't offer a full restore of your organisation from a backup. These guides show you how to use the Xero-ready CSV import files in your Xportmydata backup to get key records back in using Xero's own import tools. Your Excel backup keeps the full history for reference.

This guide explains how to import your Chart of Accounts into Xero using files generated by Xportmydata. Completing this step is crucial, as all other data imports will refer to these account codes. Please ensure that someone experienced with Xero data imports performs this task. Consulting your bookkeeper or accountant is highly recommended.

Prerequisites

• Xportmydata Backup Files:
  • Chart of Accounts CSV file
  • TaxRates sheet (from your Excel backup file)
  • TrackingCategories sheet (from your Excel backup file)
• Xero Access: Administrative access to the new Xero organization where you will import the data.

Steps to Import the Chart of Accounts

Step 1: Review GST/VAT/Sales Tax Types

• Locate Tax Rates in Backup File:
  • Open the TaxRates sheet in your Xportmydata Excel backup file.
• In Xero:
  • Navigate to Accounting > Advanced > Tax Rates.
• Action:
  • Ensure that all GST/VAT/Sales Tax types in your new Xero file match those in your backup file.
  • Include Archived Tax Types: If importing historical data, you may need to recreate any archived tax rates.
• Tip: Consistency in tax rates is essential to prevent errors during data import.

Step 2: Check Tracking Categories

• Locate Tracking Categories in Backup File:
  • Open the TrackingCategories sheet in your Xportmydata Excel backup file.
• In Xero:
  • Navigate to Accounting > Advanced > Tracking Categories.
• Action:
  • Verify that the tracking categories and options match those in your backup file.
  • Create Missing Categories: Add any tracking categories or options that are missing.
• Tip: Accurate tracking categories ensure that your financial reports remain consistent after the import.

Step 3: Import the Chart of Accounts

• In Xero:
  • Go to Accounting > Advanced > Chart of Accounts.
• Action:
  • Click on the Import button.
  • Choose your Chart of Accounts CSV file from Xportmydata.
  • Click Open.
• Follow On-Screen Instructions:
  • Map the fields appropriately (e.g., Account Code, Name, Type, Tax Rate).
  • Review any warnings or errors before completing the import.
• Tip: Ensure that account codes and names exactly match those in your backup to prevent discrepancies.

Important Notes

• Order Matters: Complete the Chart of Accounts import before attempting to import contacts, invoices, or any other data.
• Backup Current Data: If your new Xero file already contains data, consider backing it up before importing.
• Professional Assistance: If unsure, seek assistance from a professional to avoid data inconsistencies.

Additional Support

• Xero Import Guides:
  • Refer to Xero's official documentation on Importing a Chart of Accounts for more detailed instructions.
• Contact Support:
  • If you encounter issues, contact Xportmydata support at support@xportmydata.com or consult with your accountant or bookkeeper.

Next Steps

After successfully importing your Chart of Accounts, you can proceed with importing other data types. Ensure that each import is completed successfully before proceeding to the next, as the correct sequence is important for data integrity.

Disclaimer: Xportmydata is not responsible for any data loss or discrepancies during the import process. Consult a professional if unsure about any steps.

Before you start: Xero doesn't offer a full restore of your organisation from a backup. These guides show you how to use the Xero-ready CSV import files in your Xportmydata backup to get key records back in using Xero's own import tools. Your Excel backup keeps the full history for reference.

This guide provides detailed instructions on how to import your contacts into Xero using the CSV files generated by Xportmydata. Importing contacts is a crucial step in migrating your data to a new Xero organization, as it ensures all customer and supplier information is accurately transferred. We recommend that someone experienced with Xero data imports performs this task. If you're unsure, please consult your bookkeeper or accountant.

Prerequisites

• Xportmydata Backup Files:
  • Contacts CSV file(s) generated by Xportmydata
• Xero Access: Administrative access to the new Xero organization where you will import the data.

Steps to Import Contacts

Step 1: Prepare Your Contacts CSV File(s)

• Review Multiple CSV Files:
  • If you have multiple CSV files for contacts, ensure all files are ready and accessible.
• Check for Duplicates:
  • Open the CSV files to scan for duplicate contacts. Removing duplicates beforehand can prevent import errors.
• Split Large Files (If Necessary):
  • For large contact lists, consider splitting the CSV files into batches of 500 to 1,000 contacts for smoother imports.
• Tip: Keeping your CSV files organized and free of errors will streamline the import process.

Step 2: Access the Contacts Import Feature in Xero

• In Xero:
  • Log in to your Xero account.
  • Navigate to Contacts > All Contacts.
• Action:
  • Click on the Import button located at the top right corner of the page.

Step 3: Import Your Contacts CSV File(s)

• Select the CSV File:
  • Click on Browse or Choose File in the import dialog.
  • Select your Contacts CSV file from Xportmydata.
  • Click Open.
• Map the Fields:
  • Xero will attempt to match your CSV columns to its contact fields automatically.
  • Ensure that each field (e.g., Contact Name, Email Address, Phone Number) is correctly mapped.
  • If necessary, manually adjust the mappings using the drop-down menus.
• Review and Confirm:
  • Click Next to proceed to the preview screen.
  • Review any warnings or errors highlighted by Xero.
  • Correct any issues in your CSV file if needed and re-upload.
• Complete the Import:
  • Once satisfied, click on Import to begin the process.
• Tip: Do not navigate away from the page until the import is complete to avoid interruptions.

Step 4: Verify the Imported Contacts

• In Xero:
  • After the import, return to Contacts > All Contacts.
• Action:
  • Review a sample of contacts to ensure data accuracy.
  • Check for any missing information or discrepancies.
• Tip: If you find errors, you can edit contacts individually or correct your CSV file and re-import.

Important Notes

• Handle Duplicates: Xero will notify you of any duplicate contacts during the import. Decide whether to merge or keep them based on your business needs.
• Data Consistency: Ensure all contact details are up-to-date to maintain consistency across your records.
• Backup Existing Data: If your Xero organization already contains contacts, consider exporting them as a backup before importing new data.
• Professional Assistance: If you're unsure about any steps, seek help from a professional to avoid data inconsistencies.

Additional Support

• Xero Import Guides:
  • Refer to Xero's official documentation on Importing Contacts for detailed instructions.
  • For troubleshooting, see Troubleshoot Contact Import Errors.
• Contact Support:
  • If you encounter issues, contact Xportmydata support at support@xportmydata.com or consult with your accountant or bookkeeper.

Next Steps

After successfully importing your contacts, you can proceed to import other data types such as invoices, bills, or bank transactions. Always ensure that each import completes successfully before moving on to the next to maintain data integrity.

Disclaimer: Xportmydata is not responsible for any data loss or discrepancies during the import process. Please consult a professional if you're unsure about any steps.

Before you start: Xero doesn't offer a full restore of your organisation from a backup. These guides show you how to use the Xero-ready CSV import files in your Xportmydata backup to get key records back in using Xero's own import tools. Your Excel backup keeps the full history for reference.

This guide provides detailed instructions on how to import your Inventory Items (Products) into Xero using the CSV files generated by Xportmydata. Importing your products is essential for accurate invoicing and inventory management in your new Xero organization. We recommend that someone experienced with Xero data imports performs this task. If you're unsure, please consult your bookkeeper or accountant.

Prerequisites

• Xportmydata Backup Files:
  • Inventory Items CSV file(s) generated by Xportmydata
• Xero Access: Administrative access to the new Xero organization where you will import the data.

Steps to Import Inventory Items

Step 1: Prepare Your Inventory Items CSV File(s)

• Review the CSV File(s):
  • Open the Inventory Items CSV file(s) to ensure all data is correctly formatted and there are no errors.
  • Check that all necessary fields are included, such as Item Code, Item Name, Description, Sales Price, Purchase Price, Sales Account, Purchase Account, and Tax Rates.
• Ensure Account Codes Match:
  • Verify that the account codes used in the CSV file match those in your Chart of Accounts in Xero.
• Tip: Keeping your CSV files accurate and error-free will facilitate a smooth import process.

Step 2: Access the Products and Services Import Feature in Xero

• In Xero:
  • Log in to your Xero account.
  • Navigate to Business > Products and Services.
• Action:
  • Click on the Import button located at the top right corner of the page.

Step 3: Import Your Inventory Items CSV File(s)

• Select the CSV File:
  • In the import dialog, click on Browse or Choose File and select your Inventory Items CSV file from Xportmydata.
  • Click Open to upload the file.
• Map the Fields:
  • Xero will attempt to match the columns in your CSV file to its inventory item fields automatically.
  • Ensure that each field is correctly mapped. Key fields include Item Code, Item Name, Description, Sales Details, Purchase Details, etc.
  • Manually adjust any mappings if necessary using the drop-down menus.
• Set Inventory Tracking (If Applicable):
  • If you wish to track inventory levels for your items, ensure that the Inventory Asset Account, COGS Account, and Quantity on Hand fields are correctly populated.
  • Note that once inventory tracking is enabled for an item in Xero, it cannot be disabled later.
• Review and Confirm:
  • Click Next to proceed to the preview screen.
  • Review any warnings or errors highlighted by Xero.
  • Correct any issues in your CSV file if needed and re-upload.
• Complete the Import:
  • Once satisfied, click on Complete Import to begin the process.
• Tip: Do not navigate away from the page until the import is complete to avoid interruptions.

Step 4: Verify the Imported Inventory Items

• In Xero:
  • After the import, return to Business > Products and Services.
• Action:
  • Review a sample of items to ensure data accuracy.
  • Check for any missing information or discrepancies in item codes, descriptions, prices, and account allocations.
• Tip: If you find errors, you can edit items individually or correct your CSV file and re-import.

Important Notes

• Inventory Tracking Limitations:
  • Once you enable inventory tracking for an item, it cannot be turned off. Ensure you want to track inventory for that item before importing.
• Data Consistency:
  • Ensure that all item codes and account codes match those in your Xero Chart of Accounts to prevent errors.
• Backup Existing Data:
  • If your Xero organization already contains inventory items, consider exporting them as a backup before importing new data.
• Professional Assistance:
  • If you're unsure about any steps, seek help from a professional to avoid data inconsistencies.

Additional Support

• Xero Import Guides:
  • Refer to Xero's official documentation on Importing Items for detailed instructions.
  • For troubleshooting, see Troubleshoot Inventory Item Import Errors.
• Contact Support:
  • If you encounter issues, contact Xportmydata support at support@xportmydata.com or consult with your accountant or bookkeeper.

Next Steps

After successfully importing your inventory items, you can proceed to import other data types such as invoices, bills, or bank transactions. Always ensure that each import completes successfully before moving on to the next to maintain data integrity.

Disclaimer: Xportmydata is not responsible for any data loss or discrepancies during the import process. Please consult a professional if you're unsure about any steps.

Before you start: Xero doesn't offer a full restore of your organisation from a backup. These guides show you how to use the Xero-ready CSV import files in your Xportmydata backup to get key records back in using Xero's own import tools. Your Excel backup keeps the full history for reference.

This guide provides detailed instructions on how to import your Bank Transactions into Xero using the CSV files generated by Xportmydata. Importing bank transactions is crucial for maintaining accurate financial records in your new Xero organization. We recommend that someone experienced with Xero data imports performs this task. If you're unsure, please consult your bookkeeper or accountant.

Prerequisites

• Xportmydata Backup Files:
  • Bank Transactions CSV file(s) generated by Xportmydata
• Xero Access: Administrative access to the new Xero organization where you will import the data.
• Bank Accounts Set Up in Xero: Ensure that the bank accounts you're importing transactions into are already created in Xero and have matching account names and numbers.

Steps to Import Bank Transactions

Step 1: Prepare Your Bank Transactions CSV File(s)

• Review the CSV File(s):
  • Open the Bank Transactions CSV file(s) to ensure all data is correctly formatted and there are no errors.
  • Verify that all necessary fields are included, such as Date, Amount, Description, Payee, and Reference.
• Ensure Account Codes Match:
  • Confirm that any account codes used in the transactions match those in your Xero Chart of Accounts.
• Tip: Correctly formatted CSV files will facilitate a smooth import process and reduce errors.

Step 2: Access the Bank Account in Xero

• In Xero:
  • Log in to your Xero account.
  • Navigate to Accounting > Bank accounts.
• Select the Bank Account:
  • Click on the name of the bank account into which you want to import transactions.
  • If the bank account is not yet set up, add it by clicking on Add Bank Account and follow the prompts.

Step 3: Import Your Bank Transactions CSV File(s)

• Initiate the Import:
  • Within the bank account, click on Manage Account > Import a Statement.
• Select the CSV File:
  • Click on Browse or Choose File and select your Bank Transactions CSV file from Xportmydata.
  • Click Open to upload the file.
• Confirm the File Format:
  • Ensure that CSV is selected as the file type.
• Click on Import:
  • Click Import to proceed.

Step 4: Map the Fields

• Field Mapping:
  • Xero will prompt you to map the columns in your CSV file to the corresponding fields.
  • Ensure that each field is correctly mapped, such as Date, Amount, Payee, Description, and Reference.
• Date Format:
  • Select the correct date format that matches your CSV file (e.g., DD/MM/YYYY or MM/DD/YYYY).
• Review and Confirm:
  • Click Next to review the transactions.
  • Check for any errors or warnings highlighted by Xero.
  • Correct any issues in your CSV file if needed and re-upload.

Step 5: Complete the Import and Reconcile Transactions

• Finish Importing:
  • Once satisfied, click on Complete Import to finalize the process.
• Reconcile Transactions:
  • After importing, you'll be taken to the bank reconciliation screen.
  • Because the transactions are pre-coded with account information, they should automatically match existing transactions if applicable.
  • Review each transaction to ensure it is correctly coded and reconciled.
• Tip: Reconciliation ensures that your bank account balances match your actual bank statements.

Step 6: Verify the Imported Transactions

• In Xero:
  • Navigate to Accounting > Bank accounts and select the bank account.
  • Click on Account Transactions to view all imported transactions.
• Action:
  • Review a sample of transactions to ensure data accuracy.
  • Check for any discrepancies in amounts, dates, or account allocations.
• Tip: If you find errors, you can edit transactions individually or correct your CSV file and re-import (after removing the incorrect transactions).

Important Notes

• Duplicate Transactions:
  • Be cautious to avoid importing duplicate transactions, as this can lead to discrepancies in your financial records.
• Bank Feed Considerations:
  • If you plan to set up bank feeds, import historical transactions first to prevent overlaps.
  • After setting up bank feeds, ensure that new transactions are not duplicates of imported ones.
• Data Consistency:
  • Ensure that all transaction details are accurate to maintain consistency across your financial records.
• Professional Assistance:
  • If you're unsure about any steps, seek help from a professional to avoid data inconsistencies.

Additional Support

• Xero Import Guides:
  • Refer to Xero's official documentation on Importing a Bank Statement for detailed instructions.
  • For troubleshooting, see Format Your CSV File for Importing Bank Transactions.
• Contact Support:
  • If you encounter issues, contact Xportmydata support at support@xportmydata.com or consult with your accountant or bookkeeper.

Next Steps

After successfully importing and reconciling your bank transactions, you can proceed to import other data types such as invoices, bills, or manual journals. Always ensure that each import completes successfully before moving on to the next to maintain data integrity.

Disclaimer: Xportmydata is not responsible for any data loss or discrepancies during the import process. Please consult a professional if you're unsure about any steps.

Before you start: Xero doesn't offer a full restore of your organisation from a backup. These guides show you how to use the Xero-ready CSV import files in your Xportmydata backup to get key records back in using Xero's own import tools. Your Excel backup keeps the full history for reference.

This guide provides detailed instructions on how to import your Invoices and Bills, along with their Payments, into Xero using the CSV files generated by Xportmydata. Utilizing the Xero Conversion Toolbox can significantly streamline this process. Importing your sales invoices, bills, and payments is essential for maintaining accurate financial records in your new Xero organization. We recommend that someone experienced with Xero data imports performs this task. If you're unsure, please consult your bookkeeper or accountant.

Prerequisites

• Xportmydata Backup Files:
  • Invoices CSV file(s)
  • Bills CSV file(s)
  • Payments CSV file(s) (if applicable)
• Xero Access: Administrative access to the new Xero organization where you will import the data.
• Xero Conversion Toolbox: Access to the Xero Conversion Toolbox.

Steps to Import Invoices & Bills with Payments

Step 1: Prepare Your CSV Files

• Review the CSV Files:
  • Open the Invoices and Bills CSV files to ensure all data is correctly formatted and there are no errors.
  • Ensure that all necessary fields are included, such as Invoice Number, Date, Due Date, Contact Name, Description, Quantity, Unit Price, Account Code, Tax Type, and Amount.
• Prepare Payment Data:
  • If your invoices or bills have payments, ensure the payment details are included in the CSV files.
  • Fields for payments should include Paid Amount, Paid Date, Payment Account Code, and Payment Reference.
  • For multiple payments against a single invoice or bill, consider combining them into a single payment if appropriate.
  • It is recommended to use a separate bank account code for the import of payments to keep them organized.
• Ensure Account Codes Match:
  • Verify that the account codes used in the CSV files match those in your Xero Chart of Accounts.
• Tip: Keeping your CSV files accurate and error-free will facilitate a smooth import process.

Step 2: Access the Xero Conversion Toolbox

• Open the Conversion Toolbox:
  • Navigate to the Xero Conversion Toolbox.
• Connect to Xero:
  • Click on Ready to connect to Xero.
  • Log in to your Xero account if prompted.
  • Click Allow access to authorize the Conversion Toolbox to connect to your Xero organization.
  • Select the Xero organization where you wish to import the data.

Step 3: Import Invoices or Bills with Payments

• Start the Import Process:
  • From the Conversion Toolbox dashboard, click on Import Invoices, Bills, and Payments.
• Select the CSV File to Upload:
  • Click on Select CSV File to Upload.
  • Choose the CSV file for invoices or bills from your Xportmydata backup.
  • Click Start Conversion.
• Choose the Type of Import:
  • Select whether you are importing Invoices or Bills, then click Next Step.
• Map the Fields:
  • In the Field column, map each column in your CSV file to the corresponding Xero field.
  • Ensure that all mandatory fields are mapped correctly.
  • Click Next Step when finished.
• Map Tax Types:
  • In the Xero Tax Type column, select the tax types that match the ones used in your CSV file.
  • Ensure consistency to prevent import errors.
  • Click Next Step to proceed.
• Preview the Transactions:
  • Review the preview of the invoices or bills to be imported.
  • Check for any errors or inconsistencies.
  • Click Next Step when you're satisfied.
• Complete the Import:
  • Review the summary of your import.
  • If everything is correct, click Complete Import to finalize the process.
  • If you need to make changes, you can edit your CSV file and re-upload it.
• Tip: Repeat the process separately for Invoices and Bills if you have both types to import.

Step 4: Import Payments Separately (If Necessary)

• Prepare Payment CSV File:
  • If payments were not included in your invoices or bills CSV files, you can import them separately.
  • Create a CSV file with the following fields: Invoice Number, Paid Amount, Paid Date, Payment Account Code, and Payment Reference.
  • Ensure that the invoices or bills you're applying payments to are already approved in Xero.
  • It's recommended to use a separate bank account code for importing payments to keep them organized.
• Import Payments Using the Conversion Toolbox:
  • In the Conversion Toolbox, select Import Payments.
  • Upload your payments CSV file.
  • Map the fields appropriately.
  • Review and complete the import following similar steps as above.

Step 5: Verify the Imported Invoices, Bills, and Payments

• In Xero:
  • Navigate to Business > Invoices and Business > Bills to Pay to review the imported data.
  • Check the status of invoices and bills to ensure they are correctly marked as paid or unpaid.
• Action:
  • Review a sample of invoices and bills to ensure data accuracy.
  • Verify that payments have been correctly applied.
  • Check for any discrepancies in amounts, dates, or account allocations.
• Tip: If you find errors, you can edit invoices, bills, or payments individually or correct your CSV files and re-import.

Important Notes

• Data Consistency:
  • Ensure that all contact names, account codes, and tax rates used in your CSV files match those in your Xero organization to prevent import errors.
• Invoice and Bill Numbers:
  • Xero uses invoice and bill numbers to identify transactions. Ensure that these numbers are unique and correctly formatted.
• Payment Accounts:
  • Using a separate bank account code for imported payments can help you manage and reconcile these transactions more effectively.
• Professional Assistance:
  • If you're unsure about any steps, seek help from a professional to avoid data inconsistencies.

Additional Support

• Xero Import Guides:
  • Refer to Xero's official documentation on Importing Invoices and Importing Bills for detailed instructions.
  • For using the Conversion Toolbox, see Use the Xero Conversion Toolbox.
  • For troubleshooting, see Troubleshoot Invoice Import Errors.
• Contact Support:
  • If you encounter issues, contact Xportmydata support at support@xportmydata.com or consult with your accountant or bookkeeper.
  • For further assistance, consider reaching out to Xero's Support Team.

Next Steps

After successfully importing your invoices, bills, and payments, you can proceed to import other data types such as bank transactions or manual journals. Always ensure that each import completes successfully before moving on to the next to maintain data integrity.

Disclaimer: Xportmydata provides CSV import files to help you get your data into a new Xero file. Xero doesn't offer a full restore of your organisation from a backup, and we don't offer a direct restore either. Xportmydata is not responsible for any data loss or discrepancies during the import process. Please talk to a professional if you're unsure about any steps.