Fixed assets report

1

How can I get a report that shows the fixed assets’ names and their quantities? Currently, there is the name and value, but no quantity, even though I own multiple units of the same fixed asset. I understand that they are treated as a single asset by value, but if I want to do a physical inventory, I need this report

2

@15963 Manager doesn’t support “quantities” for fixed assets, so there’s no built‑in report that lists an asset name with a quantity. Fixed assets are meant to be tracked one unit per record so each unit can be depreciated and disposed of independently.

Workable options

Option A — Track each unit as its own fixed asset (recommended)

  • Create one Fixed asset record per physical unit (e.g., 25 laptops = 25 assets). This aligns with depreciation and disposal and makes physical counts straightforward.
  • In the Fixed assets tab, use columns like Code, Name, Description (put serial number/location here), and any custom fields you need; then click Copy to clipboard and paste into Excel/Sheets to use as your count sheet.
  • If you need to add many assets quickly, use Batch Operations (Batch Create/Update).

Option B — Keep identical units grouped but add your own “Units” field

  • If you prefer to treat several identical items as one asset for accounting, add a Custom field (Number) called “Units” under Settings > Custom fields > Fixed assets and tick “Show as column.” Enter the count on each asset.
  • Note: built‑in Fixed asset reports do not include custom fields, so you would still export the Fixed assets list via Copy to clipboard to get a names‑and‑quantities sheet.
1 Like