Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ON THIS PAGE YOU WILL FIND:

Table of Contents
maxLevel2
minLevel2

...

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 module > open the folders, reports & documents sub menu > select finance account groups

...

  1. Group divide takes 2 accounts and divides them by each other to get a percentage

...

Notes:

  • Reverse sign - will 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 & to

...

CONFIGURE YOUR REPORT FORMAT

  • Go to the next option:

...

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

...

  • 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

...

Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel = "reports"

...