Fixed Assets & Depreciation

Gather fixed assets (or other purchases), depreciate (or amortize) them, and load those monthly or in a batch.

Works In
Excel, Google Sheets

How It Works

The template’s schedule tab gathers the fixed asset purchases into a list that also captures the purchase amount, date those are put into service, and the usable life. The formulas then convert those amounts to depreciate (or alternatively amortize) the amounts over that determined lifespan. Those amounts are then fed to another tab, the Amalgam Journal Entry Resource, for preparation and loading into the GL. This specific template illustrates two methods of JE loads. One looks at just the entries for a particular month, the other provides a batch loading of all of the monthly amounts over the course of the asset lifetimes.

The schedule also runs a GL report to provide a check against the balances booked to ensure completeness and accuracy.

Evolving Your Financial Process

Amalgam makes finance teams more efficient. It's a customizable platform that links your financial tools together to automate your financial process.

Support

Support

Thank you for reaching out! Someone will contact you shortly.