# Fixed asset summary report **URL:** \ **Category:** Uncategorized\ **Created:** [November 9, 2026, 5:52am UTC](https://forum.manager.io/t/fixed-asset-summary-report/70200 "2026-11-09T05:52:30Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Bomber](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/bomber/32/50174_2.png) [@Bomber](https://forum.manager.io/u/Bomber)\ **Post date:** [November 9, 2026, 5:52am UTC](https://forum.manager.io/t/fixed-asset-summary-report/70200/1 "2026-11-09T05:52:30Z")
Is it possible to add an option to run this report by Division (or by All Divisions) in order that Asset Values, Accumulated Depreciation and Net Written Down Values be grouped (sub-totalled) by Division, in addition to a Grand Total? ---
**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\ **Post date:** [November 9, 2026, 7:29am UTC](https://forum.manager.io/t/fixed-asset-summary-report/70200/2 "2026-11-09T07:29:27Z")
Just use `Advanced queries` under the `Fixed Assets tab`. Do the following: 1. Click on `Fixed Assets tab` 2. At the bottom of the Fixed Assets page click on Edit Columns ![Screenshot 2026-11-09 at 08.23.26](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/d/4/d48a7113f88ea669fb48e380541b0c049427fc03.png) 33 Enable all that you want included like Divisions ![Screenshot 2026-11-09 at 08.22.12](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/e/7/e7868cf6ce46afad5f444876356380ef1e386dfa.png) 3. Click on `Advanced Queries` in the Fixed Assets page and select at least Group by [Division]. ![Screenshot 2026-11-09 at 08.26.51](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/f/a/fa6b04c4ca57889c9ac6b267357017288f0553ec.png) Play around with settings, options etc until it creates the required report by Division. ---
**Author:** ![Bomber](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/bomber/32/50174_2.png) [@Bomber](https://forum.manager.io/u/Bomber)\ **Post date:** [November 9, 2026, 9:13am UTC](https://forum.manager.io/t/fixed-asset-summary-report/70200/3 "2026-11-09T09:13:12Z")
Great. Thanks Eko for taking the time to explain. I’ve been able to build a Custom Query to summarise Acquisition Cost and (Accumulated) Depreciation by Division, with drill-down back to the fixed asset detail. This will help as a work-around. Now that the Division is displayed (thanks to your Edit columns tip) I could also Copy to clipboard and export to Excel, if required. I notice the data displayed in the Fixed Assets page (now showing Division column) includes all transactions including future-dated (ie. Recurring Transactions) depreciation entries. Therefore, the Book Value shown under Fixed Assets menu, now by Division, cannot be run as at, say, 30 June 2026 or 30 June 2027. It would still be handy if the ‘Fixed Asset Summary’ under the Reports menu was customisable so that the user could expose the Division here as well. Clearly, the beauty of running Fixed Assets, as a report, is that time periods can be defined which would make reconciling back to the GL Control accounts, at any point in time, a breeze. Am I correct in assuming the standard report formats are fixed? If so, I wonder if the only solution then is to learn how to use the Developer Toolkit to extract the relevant database fields and then use AI to create the code (???) Thanks again for your valuable tips.