Understanding the Lead Schedule by Category Report in Fixed Asset Manager
A practical walkthrough of the Lead Schedule by Category report in QuickBooks Fixed Asset Manager, covering preparation, column definitions, and landscape formatting tips.
QuickBooks Fixed Asset Manager ships with a family of reports designed to present depreciation data in a traditional lead-schedule layout. Among these, the Lead Schedule by Category gives accountants and bookkeepers an activity summary grouped by the year each asset was placed in service, sorted by acquisition date. It is one of several lead-schedule variations available — others group by general ledger asset account, by location, or by tax form and property description — and all of them sort assets by asset number within each group.
Where to Find the Report
The Lead Schedule by Category is generated from within Fixed Asset Manager rather than the main QuickBooks Desktop company-file interface. Once FAM is open, the report lives under the Reports menu. Navigate to Reports → Asset Reports, then look for the Lead Schedule group. Selecting Lead Schedule by Category opens the report for review and printing.
Preparing the Report
Before generating or printing, two preparation steps matter. First, confirm that every asset record includes the required information on the Asset tab — description, acquisition date, cost, method, life, and convention all feed directly into the report columns. Missing entries will show up as blank fields or skewed totals. Second, apply categories to the assets and select the number of months to use for depreciation calculations. Because the report groups by category, any asset without one assigned will land in an unexpected bucket or appear outside the intended grouping entirely.
What Each Column Shows
The report presents a wide set of columns, each drawing from the underlying asset record. Here is what to expect:
- Asset Description — the name entered for the asset.
- Date Acquired — the date the asset was placed in service.
- Cost — the original cost recorded for the asset.
- Sold? — indicates whether disposal information has been entered.
- Tax System — the set of depreciation rules applied (for example, federal tax versus book).
- Method — the calculation method, such as MACRS, straight-line, or declining balance.
- Life — the asset’s useful life expressed in a year/month format.
- Convention — the averaging convention applied, such as half-year or mid-quarter.
- Business Percentage — the percentage of total use attributed to business activity.
- Section 179 Deduction — any Section 179 deduction claimed for the asset.
- Depreciable Basis — the remaining basis still available for depreciation.
- Prior Depreciation — total depreciation taken in prior years.
- Current Depreciation — the current-year depreciation calculation.
- Accumulated Depreciation — the total depreciation taken across all years of service.
Reading across a single row gives a complete snapshot of one asset’s cost basis, depreciation history, and remaining depreciable basis. Reading down a column — particularly Current Depreciation or Accumulated Depreciation — gives the category subtotal.
Formatting for Print
Because the report spans many columns, portrait orientation rarely fits the content legibly on a single page width. Switching to landscape solves most readability problems. From the File menu in Fixed Asset Manager, select Print Setup, choose Landscape, and confirm. The report reformats to the new orientation, and the full column set becomes far easier to read on paper or in a print-preview window.
When the Report Matters Most
The Lead Schedule by Category is most useful during year-end review and tax preparation, when accountants need a category-level roll-up of every asset’s depreciation activity for the period. It complements — but does not replace — the depreciation expense totals that flow back into the main QuickBooks company file. For users troubleshooting depreciation data that does not match between Fixed Asset Manager and the company file, the lead schedule serves as a reliable mid-point check: if the numbers on the report are correct but the general ledger differs, the disconnect lies in the sync between FAM and QuickBooks, not in the asset records themselves.
Other Lead Schedule Variations
If grouping by category does not fit the workflow, consider the alternatives. Lead Schedule by G/L Asset Account aligns the report with the chart of accounts, which is useful when reconciling to specific balance-sheet accounts. Lead Schedule by Location groups assets by physical placement — helpful for businesses with multiple facilities. Lead Schedule by Tax Form and Property Description organizes assets to mirror how they will appear on the tax return itself. Each variation presents the same underlying column set; only the grouping and sort order change.