This report represents a potentially highly valuable tool – since it gives the option to split self-defined groups of finance accounts into any dimension – typically to provide the answer to: “How is the gross profit split on customers/project managers etc.”. The report is hence mainly used to show accounts that contain job related postings – since these are always automatically fed with all available dimensions.
Financial bookings report (264)
Grouping on up to 3 dimensions is possible at a time.
The report is company-specific and can by design only be run in company basic currency.
How to setup the custom report
At first the “Financial bookings report (264)” is an empty report framework that requires set up before use. A new report is created by hitting the highlighted icon here:
Give the report a name (for instance “Gross Profit Report”) and you can now proceed to the setup tab.
Defining the report’s content
The report has up to 12 columns available – and the task is now to define which finance accounts should be included in the different columns – and with what time scope. It is done like this:
- Highlight column 1.
- Hit the green plus in the bottom grid.
- Insert desired name for the column – for instance revenue.
- Define From and To account. If possible use Header accounts in “From” and Sum to accounts in “To” – to reduce vulnerability with respect to later on added finance accounts.
- Indefinite account sequences can be applied in the same column without any restrictions.
- Select an argument. You have two options, “+” or “-“. “+” will add the sum of the selected accounts as they are. “-” will add the same amount, but reversed (amount*-1).
- Choose time scope in the “Date scale” column which will then be related to the date chosen when running the report. For instance choosing “Period” and running the report as per 30.06.2017 that particular column will show the month of June only.
- Settings below “Column 12” are detailed layout options that can easily be ignored.
- Repeat step 1-7 when adding other columns.
A very common example is as follows:
|Column 1||Revenue – period|
|Column 2||Purchases cost – period|
|Column 3||WIP – period|
|Column 4||Gross profit – period|
|Column 6||Revenue – YTD|
|Column 7||Purchases cost – YTD|
|Column 8||WIP – YTD|
|Column 9||Gross profit – YTD|
And the report would in this case look like this:
The totals in the bottom will per definition always reconcile to the balances on the included finance accounts.
A “<no dimension set>” line can sometimes appear in the top of the report – caused by one of the following scenarios:
- The chosen dimension(s) are generally not in use – or one or more jobs are missing a dimension value.
- Manual posting(s) without dimension value have been posted to one or more of the included finance accounts.