A user wants to customize the Balance Sheet so fixed asset accounts are grouped in a more meaningful way. For example, instead of only showing individual asset and accumulated depreciation accounts, the report should show a subtotal such as:
Machinery Equipment Net Book Value = Machinery Equipment Cost - Accumulated Depreciation Machinery Equipment
Use the Financial Report Builder to customize the Balance Sheet row layout.
- Go to Reports > Financial > Balance Sheet.
- Run the report using the required period, subsidiary, accounting book, and other filters.
- Click Customize.
- In the Financial Report Builder, review the row structure for the Fixed Asset section.
- Edit the row criteria so the row includes the correct fixed asset cost accounts.
6. Add or edit a separate row for the related accumulated depreciation accounts.
7. Add a subtotal or calculated row, depending on the row layout available in your account, to present the net book value.
8. Save the customized report with a clear name
9. Run the report again and validate the totals