Skip to main content

Setting Up a Depreciation Schedule

How to set up a book depreciation schedule on a fixed asset in Ambrook and have depreciation entries post automatically.

Written by Tiffany Yue

How to set up a book depreciation schedule on a fixed asset so Ambrook posts your depreciation entries automatically.

Ambrook can track how a fixed asset — a truck, a barn, a combine — loses value over its useful life and post the entries for you. Each entry records a depreciation expense on your Profit & Loss and increases accumulated depreciation on your Balance Sheet, lowering the asset's net book value.

Ambrook tracks book depreciation, not tax depreciation.

Book depreciation reflects how an asset actually wears out, which is what gives you accurate profitability and a lender-ready balance sheet. Tax depreciation follows IRS rules — Section 179, bonus depreciation, MACRS — and Ambrook doesn't calculate those. Your accountant still prepares your tax schedule.


Before you start

The asset needs to exist as an Equipment, Vehicle, or Structure account, entered at its original purchase price (cost basis) — not its current depreciated value. See Recording Asset Purchases and Adding Balance Sheet Accounts.

Set up a schedule

Navigate to Accounts, open the asset, then turn on Track Book Deprecation. From there, you can either have Ambrook calculate the depreciation schedule for you or input one manually to auto-post on a schedule.

Calculate For Me

1. Choose your depreciation method:

Method

Best for

Straight Line

Assets that wear evenly — grain bins, roofs, trailers

Double Declining Balance

Assets that lose value fastest early — pickups, appliances

2. Under Depreciate Over, enter the useful life in years, or how long you believe the asset will be in use.

3. Under Down to, enter the salvage value, what you estimate asset will be worth at the end. Ambrook depreciates to this number and stops. Enter $0 to depreciate all the way down.

4. Confirm or set the date the asset was first put into service using the calendar picker.

5. Choose monthly or yearly posting. Monthly is the default and spreads the expense evenly across the year.

6. Add any additional Enterprise, Location, or Funding tags

7. Review the projected entries and chart, then click Save

Enter Manually

If you have a manual book schedule you'd like to enter, you'll instead switch to Enter Manually. From there, add each depreciation expense with its post date and amount. If you have Prior Depreciation (the asset was put into service prior to today), ensure that Bring over my prior depreciation is selected and input the correct amount.


Where it shows up

  • Balance Sheet — the asset at net book value, with its cost and "Asset name – Accumulated Depreciation" nested beneath.

  • Profit & Loss — in the depreciation expense category you chose.

  • Ledger — as transactions on their post date. Upcoming entries appear about a week early and don't affect reports until they post.

  • The asset — progress, the next entry, and a value chart. View full schedule lists every entry.


Disposing of an asset

A disposal records that a fixed asset has left the business – sold, traded in, scrapped, or lost – removing its cost and accumulated depreciation from the books and recognizing any gain or loss on the way out. Disposals are still needed even if the asset is fully depreciated. To dispose of an asset:

  1. Cancel the depreciation schedule

    1. Go to Accounts

    2. Select the asset to open the details drawer

    3. Scroll down to Book Depreciation

    4. Click the "..." and select Cancel schedule not Delete schedule

  2. Record any final depreciation with a journal entry:

    1. Dr. Depreciation Expense

    2. Cr. Accumulated Depreciation

  3. Remove the asset and record the sale (if applicable) with a journal entry:

    1. Dr. Cash - the amount the asset was sold for (skip if scrapped or lost)

    2. Dr. Accumulated Depreciation - all depreciation to date, which zeroes it out

    3. Cr. the asset account - the original cost basis, which zeroes it out

    4. Gain/Loss - the balancing figure, credit for gain and debit for loss

  4. Only then close or delete the asset account


Frequently asked questions

Can Ambrook handle Section 179 or bonus depreciation?

Ambrook doesn't handle Section 179 or bonus depreciation. Both are tax depreciation methods, and Ambrook generates book depreciation only.

Does this replace the schedule my accountant gives me?

It doesn't. Your accountant's schedule is for your tax return; the schedule in Ambrook keeps your own books accurate year-round. Most operations need both.

Why isn't my first entry a full period?

Ambrook uses a mid-month convention. An asset is treated as going into service in the middle of its first month, no matter which day you actually bought it, so that month earns a half amount. The same applies at the end. Those two halves add up to one full period, which is why a schedule runs one period past the useful life you entered. A 5-year monthly schedule posts 61 entries and finishes a month into year six; a 5-year yearly schedule posts 6 entries, with half amounts in the first and last. The total still equals your cost basis, and the asset still reaches its salvage value.

What if I had prior depreciation on the asset?

If Ambrook is calculating the schedule for you, just enter the in-service date during setup and Ambrook will figure out the right prior depreciation and post it as a single prior depreciation. If you've been tracking that in an existing Accumulated Depreciation account, point the schedule at it during setup. Ambrook moves the balance over and hides the old account without touching your historical entries or any reconciled periods.

Did this answer your question?