Child pages
  • Exporting reports

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
HTML Wrap
classsection group
HTML
<span data-swiftype-index="true">
HTML Wrap
classcol span_3_of_5

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

UI Text Box
sizemedium
typenote

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

  • Card List [Detail]
  • 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.

UI Expand
expandedtrue
titleTo export reports

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 and click Export. A list of file format options appears.
  4. Click a file format option you need:

    File formatDescription
    PDFPortable 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.

    UI Text Box
    typenote

    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.

    XPSXML 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.
    CSVComma-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.
    TSVTab-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.
  5. 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.
HTML
<h2><i class="fa fa-comments"></i>&nbsp;&nbsp;FAQs</h2><br>
UI Expand
titleHow do I include account numbers on exported reports?

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.
  3. Click Show/Hide (in the Report Columns section of the ribbon). A list of available columns appears.
  4. Select the Account No. column and then click Show.
  5. Click OK.
  6. Click the Print Preview tab to save the changes as printable and exportable.
UI Expand
titleWhy am I getting an error referring to a .XLT file when exporting to Excel?

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:

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:

C:\Users\<Username>\Documents\MYOB\AccountRight\201x.x\Reports\Spreadsheet

HTML
<div style="display:none;" data-swiftype-name="keywords" data-swiftype-type="enum">drop report  xl</div>
</span>
HTML Wrap
width15%
classcol span_1_of_5
        

 

      
HTML Wrap
floatleft
classcol span_1_of_5
Panelbox
namegreen
titleRelated topics
HTML Wrap
classsidebarlinks

Displaying a report

Printing and emailing reports

Customising reports

Microsoft Excel templates

Panelbox
nameyellow
titleFrom the community

RSS Feed
titleBarfalse
max5
showTitlesOnlytrue
urlhttp://community.myob.com/myob/rss/search?q=export+reports&filter=labels%2Clocation%2CsolvedThreads&location=category%3AAccountRight&search_type=thread&solved=true&sort_by=-topicPostDate

HTML Wrap
classmorelinks
More »