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.
Examples of reports you can run here are:
310 - Fiscal report, 12 Months
313 - Period and Year to Date
314 - Statement of Accounts by Dimensions, 12 months
329 - Period and Year to Date by Customer
465 - Fiscal report, Year to Date Actuals
...
ON THIS PAGE YOU WILL FIND: | ||||||
|---|---|---|---|---|---|---|
|
...
ABOUT MANAGEMENT REPORTS
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.
...
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 YOUR FINANCE ACCOUNT GROUPS
In the settings menu module > open the folders, reports & documents tab sub menu > select finance account groups
...
This is where you create the different groupings in your report. Each group represents a line on your report.
There are 3 different options for the reporting line:
Account sum allows you to calculate the total of 1 or a selection of accounts (must be sequential)
...
Group sum calculates group totals that you’ve already created
...
Group divide takes 2 accounts and divides them by each other to get a percentage
...
Notes:
Reverse sign -
thiswill make the credits positive and the debits negative. If you use it for one, use it for all
.To show a single account on a line, use the account sum type and put the same account in from
and& to
.
...
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
Pagebreak before and after - i.e put your income on one page and your overheads on another
EXAMPLE
This:
...
Creates this:
...
ACCESSING YOUR REPORT
Go to Finance and Administration
Chart of Accounts
Select your report. This configuration is available in the following report types:
Fiscal report, 12 months (310)
Fiscal report, year-to-date actuals (465)
Period and year-to-date (313)
Period and year-to-date by customer (329)
Statement of accounts by dimension, 12 months (314)
Select the report you created in the report group
View the report
...
Related articles
| Filter by label (Content by label) | ||||||
|---|---|---|---|---|---|---|
|