Once you have created your custom account groups it’s time the make a report using them. The easiest way to make a custom report is to copy an existing report that is similar, and simply change it. The first step is to figure out which report you want to duplicate, in our case we’ll duplicate the ‘Balance Sheet – Detailed’. I have made my own account group named ‘My Fixed Assets’ that want to include it in the report.
In order to duplicate the existing report we will go into General Ledger > Financial reports and locate ‘Balance Sheet – Detail’. Then on the left of the line click ‘Edit’.
The Financial Report Writer will load with the Balance Sheet – Detail report displayed. At the top you will see a button that says ‘Duplicate’. Click that.
The Duplicate Report window will pop up prompting you to enter a name for your duplicate report. We will call ours ‘Custom Balance Sheet – Detail’, then click ‘OK’.
You will now be taken back to the financial reports list screen where you can look for your new report. Because I had filtered my list screen for ‘balance%’ my new report is not displayed. I will need to click ‘Clear’ on the filters in order to find my new report. There it is:
If you want to confirm the report still works, feel free to click HTML and view it. Because it is a direct copy of the standard balance sheet, it will currently print just the same. Now the fun part, adding our custom account group! Click ‘Edit’ beside the report you just created above and then go into Rows.
At the top of the Rows definition page you will see a button that says Select Account Groups. Click that.
Next dropdown the list of account groups and locate your custom group, ours is called My Fixed Assets. Select it.
Then click ‘Include in report >’. My new account group has been added to the list of account groups on the right of the screen. If you wish to reorder these account groups, simply drag and drop them into place. I will move my custom account group to the top so I see it first on the report.
Click ‘OK’ to go back to the Financial Report writer. Once back at the Financial Report Writer you should see your custom account group where you placed it. Mine is on top as shown below.
I would suggest saving your report now and then do a print preview to see how the report looks. Success! My custom account group is printing on the report!
Interested in learning more? Check out one of our upcoming webinars here.