Breadcrumbs

Replicating the Reporter Master Formats presentation

This support note applies to:

  • AE Reporter (AU)

Article ID: 27779

 

 

MYOB Master Formats presentation in MYOB Accountants Enterprise Reporter

Format

Details

Normal Text

  • Font style: Arial

  • Font size: 10

  • Left aligned

  • Wrapped and with Automatically adjust row height to fit text within cell if width is beyond column width.

Title Text

  • Font style: Arial

  • Font size: 12

  • Bold

  • Left aligned.

Column Headings

  • Font style: Arial

  • Font size: 10

  • Bold

  • Centre aligned.

Sub Heading Text

  • Font style: Arial

  • Font size: 10.

Numerical

  • Display zero as dash including total and subtotal

  • Expected sign is always established

  • Display negative with bracket, no red indicator

  • Display numerical with comma separator for thousands

  • With 2 decimal places

  • Currency displayed in column heading but not in each individual numerical cell

  • No border around cell apart from underlines

  • No pattern, apart from Comment

  • No colour

  • Right aligned.

Total

Single overline and double underline.

Subtotal

Single overline and single underline.

Bookmark/Note

  • Left aligned

  • Bold.

Page Layout

  • Total column width is 17 cm

  • Numerical columns are 3 cm

  • Bookmark column is 1.3 cm

  • Blank column between Current Year and Previous Year columns is 0.5 cm

  • Text column width is the balance to make the 17 cm total.

Comment

  • Font style: Arial

  • Font size: 10

  • Bold

  • Italics

  • Left aligned

  • Blue pattern.

Report Names

Main Job stream: [Entity] [Size] [Disclosure Level].

For example Company Large Reporting.

The word Report doesn't meet the naming convention.

Format Names

  • Description of format with the first character of each word in capital letter, apart from words eg. and of. E.g. Accounting Policy Note 1 Cash

  • No dash in the name unless for Page Header, Page Footer or Named range. E.g. Page Header - Audit Report, Named range - Calculated Balances or Named range - text.

Formula

  • SUM(C1:C5)

  • SUM(C1,C2,C5)

  • SUM(C1)

  • SUM(C3:C5)-C1 - SUM appears first in the formula

  • SUM(C3:C5, C7:C10).

The formula C1+C5 for the first example could also be used with the same result but the above formulae have been used in the Solution 6 Masters.

Row Height

0.56cm except for in between paragraphs of text, which are 0.23.