Ask Lou

Importing a fixed asset schedule

Drop in the schedule you already keep, and Lou reads it, works out each asset's depreciation, and asks about anything unclear.

Import AssetsUploadContext3Analyze4ReviewFile loaded — 3 sheets foundFixed_Asset_Schedule.xlsxAnalyzing your spreadsheet…Detecting columnsExtracting assetsWorking out each depreciation methodFixed AssetsNAMEBOOK VALUESTATUSSep 2025 Device Refresh$61,388.40ActiveAug 2025 Platform Release$191,824.97ActiveMay 2025 Office Expansion$20,841.11ActiveMo. Depr: $41,288.19Book: $1,568,557.13Import LoansTerm Loan A$2,740,0008.75% · 92 paymentsStarts January 2025Ready to import

Before you start

On Asset Management, choose Import Assets. Your schedule can be Excel (.xlsx, .xls or .xlsm) or CSV, up to 10 MB. If the workbook has several sheets, you pick the one with your assets.

Have more than one year of schedules? Import the oldest first.

The four steps

  1. Upload: drop in your file.
  2. Context: Ask Lou reads your schedule as it stands and shows your latest trial balance month. Choose Analyze with AI.
  3. Analyze: Lou finds the columns, pulls out each asset, and works out its depreciation method from its own figures.
  4. Review: check what he found, then import.

Reviewing what Lou found

At the top: how many assets were found, how many are selected, how many need your input, and how many were sold or retired. Under What we worked out from your file, Lou explains anything he had to decide. If something looks wrong, choose Ask Lou what's off.

Each row shows how confident Lou is, with badges such as Already in your list, Will update existing, Sold / retired or Fully depreciated. You can change the name, type, depreciation method, useful life and date in service, answer any question Lou has, and untick anything you don't want.

If an asset matches one you already have at a different cost, choose Change to new price, Keep original price or Create new item.

When it looks right, choose Import to add the selected assets to your list.

Nothing is added until you import. Your accounting system is never changed.

Importing a fixed asset schedule
  1. 1Upload

    Excel or CSV, up to 10 MB. Several years? Oldest first.

  2. 2Context

    Ask Lou reads your schedule as it stands, beside your latest trial balance month.

  3. 3Analyze

    Lou finds the columns, pulls out each asset, and works out its depreciation from its own figures.

  4. 4Review

    Check what he found, answer his questions, and choose how to handle assets you already have.

  5. 5Import

    Only the assets you keep ticked are added.