Skip to main content
All CollectionsHow To Guides
How Do I Export the Data from My Xero File?

How Do I Export the Data from My Xero File?

Diana avatar
Written by Diana
Updated over 9 months ago

Whether switching over to other accounting software or just wanting to tidy things up, we'll show you the Step by Step Guide on how you can get the reports and data to you need when closing your Xero file. 💗

Ready to dive in? Let's get started! ✨

What are the Reports I need to retrieve if I decided to switch from Xero to other accounting software?

Are you a sole trader looking to move to Rounded? We hear you! Here’s a handy checklist of the reports you’ll need if you decide to make the switch:

  • Payables and receivables (Please generate reports from opening Xero to present date)

    • Aged Payables Summary - in Excel

    • Aged Receivable Summary - in Excel

  • Reconciliations (Please generate reports of all bank accounts from opening Xero to present date)

    • Bank Reconciliation - in Excel

  • BAS and GST Reconciliations (Please generate reports from opening Xero to present date)

    • Latest finalised Activity Statement - in Excel and PDF

    • GST Reconciliation - in Excel and PDF

  • Financial Statements

    • Fixed Asset Reconciliation in PDF and Excel (Please generate reports from opening Xero to present date)

    • Profit and Loss

      • Profit and Loss in all tax years - Cash - in Excel

      • Profit and Loss in all tax years - Accrual - in Excel

      • Profit and Loss month by month for the current FY - Cash - in Excel

      • Profit and Loss month by month for the current FY - Accrual - in Excel

    • Balance Sheet

      • Balance Sheet in all tax years - Cash - In Excel

      • Balance Sheet in all tax years - Accrual - In Excel

  • Taxes and balances (Please generate reports for the current year)

    • Trial Balance

      • Trial Balance - Cash - In Excel

      • Trial Balance - Accrual - In Excel

  • Transactions (Please generate reports of all accounts from opening Xero to present date)

    • Account Transactions - in Excel

Step By Step Guide:

  1. Log in to your Xero account.

  2. On your Dashboard, click Accounting and choose Reports.

  3. Choose which report you want to export. Let's have Profit and Loss for 2024 Tax Year - Accrual Basis as a sample.

  4. Change the date range to this financial year or 1 July 2023 to 30 June 2024; compare with 4 years or more; and choose Accrual as accounting basis. (Note: We only chose Accrual as accounting basis based on our sample listed in Item #3.)
    Then click Update.

  5. At the right bottom of the screen, select Export then Excel.

That's it! If you have any questions, just let us know. We're just an email away! ✉️

Did this answer your question?