Skip to content

Exporting reports

You can export reports in various file formats so that they can be viewed and edited in other programs.

There is currently two reports which can't be exported due to the complex format of the report.

  • Tick

    Card List [Detail]

  • Tick

    Employee Employment Details

Alternatively you can print or export employee details or export card details to get the information you need. You can also customise the Cards List, copy the list and paste it into a spreadsheet or another document.

To export reports

  1. Display the report you want to export.

  2. If you customise the report, click the Print Preview tab to ensure your changes are saved for export.

  3. Go to the File menu (as circled below).

    print export options with dropdown arrow circled

  4. Hover over Export to view the list of file format options.

    list of export options

  5. Click the file format option you need:

    • PDF: Portable Document Format: Select the PDF option if you want to view or print the report later and keep the same format and appearance that's used in AccountRight. If you save a report as a PDF, the person who receives the report will need a PDF viewer, such as Adobe Reader, to view or print the report.

    • Excel: Microsoft Excel spreadsheet: Select the Excel option if you want to view the report in Microsoft Excel, or use Excel's features to further analyse the data. You can edit the default spreadsheet templates that AccountRight uses. If you save the report as an Excel document, the person who receives the document will need a program that can open Microsoft Excel spreadsheets, to view the report.

      You can only export a report as an Excel file if Microsoft Excel 2010 or later is installed. If you're exporting a custom report, the Export to Excel button is not available in the Index to Reports window, but you can export it after displaying the report.

      Using Office 365? Make sure Excel is installed on your computer and not accessed via a web browser.

    • XPS: XML Paper Specification: Select the XPS option if you don't need to edit the report and want to use the XPS Viewer provided with Windows to view or print the report

    • CSV: Comma-separated values text file: Select the CSV option to save a text file where all the report data is separated with commas. This is a file format that can be opened and edited by most spreadsheet programs.

    • TSV: Tab-separated values text file: Select the TSV option to save a text file where all the report data is separated by tab characters. This is a file format that can be opened and edited by most spreadsheet programs.

    • Depending on the report format you chose, one of the following will happen:

  6. Depending on the report format you chose, one of the following will happen:

    • the Export report as window will appear. Specify the file name and location, and then click Save.

    • the report is displayed in the selected program (such as Excel). Save the report in the program as you normally would.


How do I include account numbers on exported reports?


Account numbers are not included on all account reports by default. This includes the Balance Sheet, P&L, accounts list and trial balance reports. To add account numbers, you need to add the Account No. column to the report (if available).

  1. Open the report, such as the Accounts List [Summary] report.

  2. Select the Insert/Modify tab.

    Insert column

  3. Click Show/Hide (in the Report Columns section of the ribbon). A list of available columns appears.

    Insert column2.0

  4. Select the Account No. column and then click Show.

    Insert column3.0

  5. Click OK.

  6. Click the Print Preview tab to save the changes as printable and exportable.

Why am I getting an error referring to a .XLT file when exporting to Excel?


When you export a report to Excel, AccountRight uses an Excel report template to display your report. If the template for your report is missing, an error like this will display:

Export to excel error

To fix it, you'll need to uninstall then reinstall AccountRight. This will restore your Excel templates with the default ones that come with AccountRight. Be aware that if you've edited any of the Excel templates, take a copy of the edited templates before uninstalling AccountRight.

Your Excel templates are found here: