Folders, Reports & Documents > Finance Reports Configuration

Management reporting is a category in the Finance reports where you can build your own report formats by fiscal year, year-to-date, by customer and by dimension. These reports can be customised to show specific information about your business.

There are two steps to creating a new management report:

1. Create your finance account groups to define the way you want to sum and show the various totals.

2. Create the format of your report in finance reports configuration to define the report, which account groups to show in which order, and the basic formatting (font, etc).

This article takes you through step 2, finance reports configuration.

WHAT TYPE OF REPORTS CAN I CUSTOMISE?

If there are specific report formats or account groupings that you need to review, that aren’t covered by a regular Profit and Loss report, this is where you can use the finance account groups & custom reporting formats to configure your own management reports.

Reports you can customise are:

Fiscal report, 12 months (310):

This report shows you your actuals and fills in the rest of the 12 months with a budget you’ve created.

Open

Fiscal report, year-to-date actuals (464):

This is a simple report that shows you the totals from the start of the year:

Open

Period and year-to-date (313):

See a comparison of one period to another, plus the year to date totals.

Period and year-to-date by customer (329):

This is the same as the above but shows the customers.

Statement of accounts by dimensions, 12 months (314)

This is one of the most popular reports as it shows your specified accounts by month and you can also select what dimensions you want to see. Is this example, the ‘client group’ dimension has been selected.

SETTING UP FINANCE ACCOUNT GROUPS

CONFIGURE YOUR REPORT FORMAT

• Go to the next option:

• ‘Create report’ to add your new report and give it a name

• Select the report you just created, from the drop down

• Add new row

• Select the groups that you created

• Decide how it looks:

  • Display title - change ‘new group’ to the group name

  • Sort by - the order they go in (suggestion - put multiples of 5 in here so you can add groups in later)

  • Bold font - good for totals

  • Underlining - use for the last group before the total

  • Lines before and after - to separate your groups

  • Page break before and after - i.e. put your income on one page and your overheads on another

EXAMPLE

This:

Creates this:

ACCESSING YOUR REPORT

Now that you have setup your reports you can access these from:

• The finance and administration module > general ledger sub menu, chart of accounts

Related articles