It is possible to setup customized management accounts in WorkBook and have them printed in various formats.
First step is to build the categories of accounts that should be shown on the reports which is done here:
Simply add new groups by pressing the green plus, give the group a name, and then define the account interval applying for that group in the bottom grid. Multiple account intervals can be defined for the same group – not necessarily being next to each other in the Chart of accounts.
A group can be any of 3 types:
“Account sum” = Interval of accounts
“Group sum” = Sums of groups which will then summarize all the underlying account intervals
“Group divide” = A division of 2 groups which in the printed reports will appear as a percentage (%)
Once all the needed groups have been created simply add them to the report that you wish to setup by pressing the green plus:
There are numerous formatting options that should be selfexplanatory and that can easily be tested on the printed reports (see below).
You can create as many reports as desired – simply add them by pressing the “Create new” icon:
When all the setup is done the reports can be run from the Finance module/Chart of accounts:
Detailed notes to these reports are:
- Besides report 465 they can all include finance budget numbers if these have been entered.
- Report 329 is designed to show Gross Profit by client – and hence requires a report setup with only Group containing all the finance accounts that add up to the Gross Profit.
- If “Show accounts” is chosen you will have a very detailed report containing all the selected finance accounts, but in your own format compared to the “Balance sheet (216) report.
- “From” and “To” dates are available as report criteria where it makes sense according to the layout of the reports.