Fixed Asset Management
Fixed Asset Management
The Fixed Asset Management system extends Business Central's standard fixed asset functionality with municipal-specific features including rental property management, depreciation calculations, and asset allocation by department.
Accessing Fixed Assets
Navigate to Municipality Systems > Assets from the Municipal Manager Role Center, or use the standard Fixed Assets menu in Business Central.
Fixed Asset Setup for Municipalities
Municipal Asset Categories
The system supports specific asset categories for municipal operations:
Infrastructure Assets
Roads and Streets: Municipal road infrastructure
Water Systems: Water distribution and treatment facilities
Sewer Systems: Wastewater collection and treatment
Parks and Recreation: Parks, playgrounds, and recreational facilities
Building Assets
Municipal Buildings: Town halls, service centers, fire stations
Rental Properties: Municipal housing and commercial rentals
Schools: Educational facilities (if managed by municipality)
Healthcare Facilities: Municipal health centers
Equipment Assets
Vehicles: Municipal fleet including trucks, cars, snow plows
Machinery: Construction and maintenance equipment
IT Equipment: Computers, servers, networking equipment
Office Equipment: Furniture, copiers, and office supplies
FA Subclasses for Municipal Assets
Configure specialized subclasses for detailed asset tracking:
Navigate to Fixed Assets > Setup > FA Subclasses
Create municipal-specific subclasses:
Rental Residential: Residential rental properties
Rental Commercial: Commercial rental properties
Emergency Vehicles: Fire trucks, ambulances, police vehicles
Snow Removal: Snow plows, salt spreaders, sanders
Parks Equipment: Lawn mowers, playground equipment
Rental Property Management
Setting Up Rental Properties
For properties that generate rental income:
Create the Fixed Asset record
Navigate to Rental Properties from the FA card
Configure Rental Settings:
Property Type: Residential or Commercial
Number of Units: Individual rental units
Base Rent: Standard rental amount
Rental Terms: Lease duration and terms
Rental Period Management
Creating Rental Periods
Navigate to Fixed Assets > Rental > Rental Periods
Click New to create a rental period
Configure period details:
Period Code: Unique identifier (e.g., "2025-01")
Description: Period description
Start Date: Period beginning
End Date: Period end
Status: Active, Closed, or Cancelled
Rental Period Processing
Monthly rental processing includes:
Generate Rental Invoices: Create invoices for all active rentals
Allocate by Department: Distribute rental income by department
Post to General Ledger: Record rental income and allocations
Update Asset Values: Adjust asset carrying values if needed
Rent Allocation by Department
Allocation Setup
Configure how rental income is allocated across departments:
Navigate to Fixed Assets > Rental > Rent Allocation
For each rental property, set up:
Department Code: Receiving department
Allocation Percentage: Portion of rent allocated
GL Account: Account for rental income posting
Dimension Values: Department and project dimensions
Allocation Processing
The system automatically:
Calculates Department Shares: Based on allocation percentages
Creates GL Entries: Posts to appropriate revenue accounts
Updates Department Budgets: Compares actual vs. budgeted rental income
Generates Reports: Department rental income analysis
Municipal Depreciation Management
Depreciation Methods for Municipal Assets
Standard Methods
Straight Line: Equal depreciation over asset life
Declining Balance: Accelerated depreciation method
Sum of Years Digits: Front-loaded depreciation
Manual: User-defined depreciation amounts
Municipal-Specific Methods
Infrastructure Method: Special depreciation for roads, utilities
Building Composite: Different rates for building components
Vehicle Fleet: Mileage-based depreciation options
Technology Equipment: Accelerated tech depreciation
Depreciation Books for Municipal Assets
Standard Depreciation Book
Book Code: COMPANY
Purpose: Financial reporting depreciation
Method: Typically straight-line for municipal assets
Integration: Posts to General Ledger
Tax Depreciation Book
Book Code: TAX
Purpose: Tax reporting depreciation
Method: May differ from financial reporting
Integration: Tax reporting only, no GL posting
Advanced Depreciation Features
Partial Year Depreciation
Configure how to handle assets purchased mid-year:
None: Full year depreciation regardless of purchase date
First Year Convention: Half-year in first year
Actual Days: Depreciation based on actual ownership days
Full Month: Depreciation starts beginning of next month
Composite Asset Depreciation
For complex assets with multiple components:
Building Structure: 40-year depreciation
HVAC Systems: 15-year depreciation
Roof Components: 20-year depreciation
Technology Systems: 5-year depreciation
Asset Maintenance and Tracking
Maintenance Scheduling
Preventive Maintenance
Set up regular maintenance schedules:
Vehicle Maintenance: Oil changes, inspections, repairs
Building Maintenance: HVAC service, roof inspections
Equipment Maintenance: Calibration, service, replacement parts
Infrastructure Maintenance: Road repairs, utility maintenance
Work Order Integration
Link maintenance to the Job Request system:
Automatic Job Creation: Generate maintenance work orders
Resource Scheduling: Assign maintenance staff and equipment
Cost Tracking: Track maintenance costs by asset
History Maintenance: Complete maintenance history
Asset Location and Sublocation
Location Tracking
Track where assets are physically located:
Primary Location: Main asset location
Department Assignment: Which department uses the asset
Building/Room: Specific location within facility
GPS Coordinates: For mobile or outdoor assets
Sublocation Management
For assets with multiple components or locations:
Sublocation Code: Unique identifier
Description: Sublocation description
Responsible Person: Who manages this sublocation
Access Requirements: Security or access restrictions
Asset Insurance and Risk Management
Insurance Tracking
Insurance Policy Management
Policy Number: Insurance policy identifier
Insurance Company: Provider information
Coverage Amount: Insured value
Policy Period: Coverage dates
Premium Amount: Annual insurance cost
Insurance Valuation
Regular insurance valuation updates:
Replacement Cost: Current replacement value
Market Value: Current market value
Book Value: Accounting book value
Insured Value: Insurance coverage amount
Risk Assessment
Risk Categories
Physical Risk: Damage, theft, vandalism
Environmental Risk: Weather, natural disasters
Operational Risk: Equipment failure, obsolescence
Financial Risk: Value fluctuation, market changes
Asset Disposal and Transfer
Asset Disposal Process
Disposal Methods
Sale: Sell asset to external party
Trade-in: Exchange for new asset
Scrap: Dispose of worthless asset
Transfer: Move to another department or entity
Disposal Documentation
Required documentation for asset disposal:
Disposal Approval: Management approval for disposal
Market Valuation: Fair market value assessment
Environmental Clearance: Environmental disposal requirements
Gain/Loss Calculation: Financial impact of disposal
Inter-Department Transfers
Transfer Process
Initiate Transfer: Originating department requests transfer
Approval Workflow: Management approval required
Asset Valuation: Determine transfer value
Update Records: Change department assignments
Update Budgets: Adjust department asset allocations
Reporting and Analysis
Standard Fixed Asset Reports
Asset Register
Complete listing of all municipal assets:
Asset Details: Description, location, value
Depreciation Summary: Book value, accumulated depreciation
Department Assignment: Which department owns/uses asset
Insurance Information: Coverage and valuation
Depreciation Reports
Monthly Depreciation: Current month depreciation expense
Annual Depreciation: Year-to-date and projected annual
Depreciation Forecast: Future depreciation projections
Book vs. Tax: Comparison of different depreciation books
Rental Property Reports
Rental Income Summary: Income by property and period
Occupancy Analysis: Vacancy rates and trends
Maintenance Cost Analysis: Maintenance costs by property
ROI Analysis: Return on investment for rental properties
Asset Analytics
Asset Utilization
Department Utilization: How departments use assets
Asset Age Analysis: Age distribution of asset portfolio
Replacement Planning: Assets nearing end of useful life
Cost per Department: Asset costs allocated by department
Performance Metrics
Asset Turnover: Revenue generation per asset dollar
Maintenance Efficiency: Maintenance cost trends
Insurance Optimization: Insurance cost vs. risk analysis
Disposal Performance: Gain/loss trends on asset disposals
Integration with Other Modules
Job Request Integration
Maintenance Work Orders
Automatic Generation: Create maintenance jobs from asset schedules
Resource Assignment: Assign maintenance staff and equipment
Cost Allocation: Track maintenance costs to specific assets
Completion Tracking: Monitor maintenance completion rates
Budgeting Integration
Asset Budget Planning
Capital Expenditure Budget: Plan for new asset purchases
Maintenance Budget: Budget for ongoing maintenance costs
Depreciation Budget: Project depreciation expense
Disposal Budget: Plan asset disposals and replacements
Financial Reporting Integration
General Ledger Impact
Asset Acquisition: Fixed asset and cash/payable entries
Depreciation Posting: Monthly depreciation expense
Rental Income: Revenue recognition for rental properties
Asset Disposal: Gain/loss recognition on disposals
Common Issues and Solutions
Error: "Cannot post depreciation - period is closed"
Solution:
Check if accounting period is open for posting
Verify depreciation book setup allows posting
Confirm user has permissions to post depreciation
Check if year-end closing has been performed
Error: "Rental allocation percentages do not equal 100%"
Solution:
Review rent allocation setup for the property
Verify all department percentages add up to 100%
Check for inactive departments still included in allocation
Update allocation percentages to equal 100%
Issue: Asset maintenance schedules not generating work orders
Solution:
Verify maintenance schedule is active and current
Check job request integration settings
Confirm work department assignments are valid
Review maintenance schedule date calculations
Issue: Insurance valuation reports showing incorrect values
Solution:
Update asset replacement costs regularly
Verify insurance policy information is current
Check asset revaluation calculations
Review insurance valuation methodology
Best Practices
Asset Management Practices
Perform annual physical asset inventories
Regular maintenance schedule reviews and updates
Quarterly insurance valuation updates
Annual asset replacement planning reviews
Depreciation Management
Review depreciation methods annually for appropriateness
Ensure consistent application across similar assets
Document any changes to depreciation policies
Regular reconciliation of depreciation books
Rental Property Management
Monthly rental income reconciliation
Regular property condition assessments
Market rent reviews for lease renewals
Proactive maintenance to preserve property values
The Fixed Asset Management system provides comprehensive asset lifecycle management while ensuring compliance with municipal accounting standards and supporting effective resource planning.