Page tree

 

 


 

 

You may need to create a report if one doesn't already exist in one of the reporting areas.

The Reports area lets you to quickly create a new report, or edit, preview, print or export your saved reports.

For example, you can create a report to:

  • identify clients that are flagged under the Client > Extra tab, who you want to invite to a seminar.
  • show clients within a specific age range.
  • show client or partner wip and debtor to provide information not in MYOB standard reports.  

Any of these reports examples could be used generate a bulk email to some or all of these clients if required.

There are various reporting areas where you can create your report depending on the data you need.

For information on the fields available in the various Practice Manager reporting areas, see Practice Manager Reports and what they contain.

Designing a report

You'll need to decide what data to include in your report and where the data will be positioned on the page.

When you create your report, you can control the display of the fields within their columns. You can also apply filters to your fields/columns to control what data is displayed as well as specify how to sort your data.

Some questions you may want to think about:

  • What data you require in your report? This will determine which area you create your report in.
  • Will the report will show summarised or detailed information?
  • What grouping you need in your report?
  • How should the data be sorted?
  • What totals are required?
  • What columns widths do you need?
  • What titles to use above each column?
To create a report
  1. In the toolbar, click the Reports icon.

  2. Select the report area and sub-area for your new report.

  3. Click New at the bottom of the Reports page. The New Report page opens.

  4. Select a template from the template drop-down. The default options are MYOB-Portrait and MYOB-Landscape.

  5. Enter a name for your report in the Title field.

  6. Click the checkboxes for the fields you want to use in your report. Your chosen fields are displayed in the area above the field list.

    You can move fields around by clicking and dragging the fields.

  7. If you want to group the data by a specific field, drag the field to the Group bar under the report Title field.

    Grouping is optional in a report—you can group by a single field or by several.

  8. In the toolbar, click Save .

    Save your report regularly if you expect to use it as an ongoing report. If it is an ad hoc query, you can run it without saving.

Toolbar buttons/icons

When you create a report, you have access to a toolbar for testing your fields, summarising your data, exporting the results to Excel and more.

Icon/buttonPurpose

Save

Saves the new or edited report.

Edit Layout (AE)

Opens the Report Designer window.

Run Report

Runs the report.

Report Template drop-down

Specifies the template on which your report is to be based. You can select another template from the drop-down.

Show Summary

Displays the report in a summarised format. Click Run Report to test the results. You can save the results if required.

Export to Excel

Exports the report in Microsoft Excel spreadsheet format.

A report is always based on a template, so when you create or change a report you are doing so within a pre-defined template. A template contains a definition of headers, footers and margins into which you can add the data, generally it does not contain any fields or data. In AE, you can create your own templates.

  Additional Resources


Report creation and Designer formatting guide

MYOB Accountants Enterprise (AE) and MYOB Accountants Office (AO) include standard reports. You can create and format your own reports to meet the specific needs of your practice.

To create your own reports, see the following guides for your specific product.

ProductGuideProvides instruction on:
Accountants Enterprise

MYOB AE Report Creation and Formatting Guide.pdf

AE Formatting Guide using Designer.pdf

Details the basic steps to allow you to create and format reports along with a number of useful hints and tips.

 

The Edit Layout option, also known as Designer, lets you do more detailed editing. This guide provides heaps of useful info about using Designer features such as inserting logos and graphics, page breaks, headers and footers, and summarising data.

Accountants OfficeMYOB AO Report Creation and Formatting Guide.pdfDetails the basic steps to allow you to create and format reports along with a number of useful hints and tips.
Reports self paced on-line learning links

To learn how to create reports or edit an existing report using Edit Layout, see the following Self Paced Online Learning links.

Our consulting team can assist with the creation and customisation of reports. Contact your Client Manager to arrange this.
 
Related topics