One post tagged with "fixed assets"

If you track fixed assets in your accounting—laptops, cameras, machinery, or even office furniture—your books need to reflect their declining value. This involves two key concepts: depreciation (the expense) and its running total, accumulated depreciation. This guide explains both in plain language and then shows you exactly how to model them in Beancount with copy-pasteable examples, including powerful automation options.

What is accumulated depreciation?​

Accumulated depreciation is the total amount of depreciation that has been recorded against an asset since the day it was put into service. Think of it as a running tally. It’s not a new kind of expense—it's just the to-date sum of all past depreciation charges for that asset.

In financial statements, you’ll see accumulated depreciation paired with the asset’s original price. This allows anyone reading your books to see both the historical cost (what you paid for it) and the net book value (what it's currently worth on your books).

A crucial detail is that accumulated depreciation is a contra-asset account. This might sound complex, but it's a simple idea:

• It's an "asset" account, so it lives in the Assets section of your chart of accounts.
• However, it carries a credit balance (a negative value in Beancount's asset accounts), which reduces the value of the related fixed asset.

Where does it appear on the balance sheet?​

Accumulated depreciation typically appears on the balance sheet directly underneath the fixed asset it relates to. For example:

Many financial statements simplify this by showing a single line item like “Property, plant & equipment, net”. This single number represents the total historical cost of all assets minus their total accumulated depreciation, giving you the final net book value.

How do you calculate depreciation?​

There are several methods for calculating depreciation. The one you choose determines how much expense you record each period, which in turn adds to the accumulated depreciation total. Two common families of methods are:

• Straight-Line (SL): This is the simplest and most common method for bookkeeping purposes. You expense an equal amount of the asset's value in each period of its useful life. For example, a $3,000 laptop with a 36-month (3-year) useful life would be depreciated at$83.33 per month.
• Tax Methods (e.g., MACRS in the U.S.): For tax purposes, governments often define specific accelerated schedules. In the U.S., the Modified Accelerated Cost Recovery System (MACRS) allows you to take larger depreciation deductions in the earlier years of an asset's life. Beancount can easily handle these schedules—you just need to calculate the amounts according to the official tables (like those in IRS Publication 946) and generate the corresponding journal entries.

Formula (Straight-Line)

Periodic Depreciation = $\\frac{\\text{Cost} - \\text{Salvage Value}}{\\text{Useful Life}}$

Accumulated Depreciation (at date t) = $\\sum (\\text{Periodic Depreciation up to } t)$

Salvage value is the estimated residual value of an asset at the end of its useful life. For simplicity, it's often assumed to be zero.

The Beancount Way: Model Cost and Accumulated Depreciation​

To properly track fixed assets in Beancount while preserving their original cost, you’ll use a pair of asset accounts for each category, plus an expense account.

• Assets:Equipment:Computers:Cost (to hold the historical cost)
• Assets:Equipment:Computers:AccumDep (the contra-asset, which will be credited over time)
• Expenses:Depreciation:Computers (to record the periodic expense)

This structure mirrors standard accounting practice and is the recommended approach for managing fixed-asset depreciation in Beancount.

Option A: Manual Straight-Line Entries​

This is the most direct method. You control every entry, which is great for understanding the mechanics.

1. Open the necessary accounts

2025-01-01 open Assets:Bank:Checking
2025-01-01 open Assets:Equipment:Computers:Cost
2025-01-01 open Assets:Equipment:Computers:AccumDep
2025-01-01 open Expenses:Depreciation:Computers

2. Record the purchase (at historical cost)

When you buy the asset, you debit the Cost account.

2025-01-20 * "Purchase MacBook Pro"
  Assets:Equipment:Computers:Cost      3000.00 USD
  Assets:Bank:Checking               -3000.00 USD

3. Record monthly depreciation

Each month, you'll record the depreciation expense. For a $3,000 asset over 36 months, the monthly depreciation is$3000 \div 36 = $83.33$.

The transaction involves debiting the expense account and crediting the contra-asset account.

2025-02-28 * "Monthly depreciation - MacBook Pro (SL 36mo)"
  Expenses:Depreciation:Computers           83.33 USD
  Assets:Equipment:Computers:AccumDep      -83.33 USD  ; This is the credit to the contra-asset

You would repeat this entry every month for 36 months. The balance in Assets:Equipment:Computers:AccumDep will grow more negative over time, reducing the asset's net book value.

Quick Check: You can easily check the net book value in Fava's Balance Sheet or by running a quick query:

bean-query myledger.bean "SELECT account, SUM(position) WHERE account ~ 'Assets:Equipment:Computers:(Cost|AccumDep)' GROUP BY account"

The sum of the balances of these two accounts is your net book value.

Option B: Automate with Fava’s amortize Plugin​

If you use Fava (the popular web interface for Beancount) and your depreciation is a fixed amount each month, you can automate it.

First, enable the plugin at the top of your Beancount file:

plugin "fava.plugins.amortize_over"

Next, create a single transaction that defines the entire depreciation schedule.

; 1. Record the initial purchase as usual
2025-01-20 * "Purchase MacBook Pro"
  Assets:Equipment:Computers:Cost      3000.00 USD
  Assets:Bank:Checking               -3000.00 USD

; 2. Set up the depreciation schedule
2025-01-20 * "Depreciation schedule - MacBook Pro"
  amortize_months: 36
  Expenses:Depreciation:Computers       3000.00 USD
  Assets:Equipment:Computers:AccumDep  -3000.00 USD

The plugin will see this transaction and automatically generate virtual postings for $83.33 each month for 36 months. These entries don't get written to your .bean file but appear in all reports. This is perfect for straight-line depreciation but won't work for irregular schedules like MACRS.

Option C: Generate Periodic Entries with a Third-Party Plugin​

If you prefer to have real, non-virtual transactions written into your files but still want automation, a periodic entry generator is a great choice. One of the most popular is beancount-periodic by Dallas Lu. This plugin can be configured to create dated postings on your behalf, giving you the control of manual entries with the convenience of automation.

Viewing Results: Cost, Accumulated Depreciation, and Net Book Value​

No matter which method you choose, your Balance Sheet will show both the Cost and AccumDep accounts under your Assets. The sum of these two is your net book value. This presentation—showing the gross cost less the accumulated depreciation—is exactly what accountants and financial analysts expect to see. It provides full transparency into the age and value of your assets.

Disposing of an Asset (Sell, Scrap, or Retire)​

When an asset reaches the end of its life, you either sell it, scrap it, or retire it. To remove it from your books, you must:

1. Remove its historical cost.
2. Remove its associated accumulated depreciation.
3. Record any cash received.
4. Record any resulting gain or loss (the difference between cash received and the net book value).

Example: Selling an Asset for a Gain

Let's say you sell the MacBook Pro on June 15, 2027.

• Original Cost: $3,000
• Accumulated Depreciation at time of sale: -$2,500
• Net Book Value: $3,000 -$2,500 = $500
• You sell it for: $800
• Gain on Sale: $800 (proceeds) -$500 (net book value) = $300

Here is the Beancount transaction to record the disposal:

2027-06-15 * "Sell MacBook Pro"
  Assets:Bank:Checking                     800.00 USD  ; Cash received
  Assets:Equipment:Computers:AccumDep     2500.00 USD  ; Debit to zero out the contra-asset
  Assets:Equipment:Computers:Cost        -3000.00 USD  ; Credit to remove the original cost
  Income:Gains:AssetDisposals             -300.00 USD  ; Credit to record the gain

If the proceeds had been only $400 (a loss of$100), you would post the difference to an Expenses:Losses:AssetDisposals account with a positive amount (a debit).

FAQ (Fast)​

• Is accumulated depreciation an asset or a liability? Neither. It’s a contra-asset. It's located in the assets section of your balance sheet but has a credit balance, which reduces the total asset value.

• Do I ever post directly to the Cost account after purchase? Generally, no. The purpose of the contra-asset account is to preserve the original historical cost. All reductions in value due to depreciation should be posted to ...:AccumDep.

• Can I use Beancount for MACRS (tax) schedules? Yes. You'll need to calculate the depreciation amounts for each period using the tables in IRS Publication 946. Then, you can record those amounts using manual entries or a periodic plugin. The Fava amortize plugin is not suitable for this, as MACRS amounts are not equal each month.

• What about Section 179 expensing? Section 179 allows you to expense the full cost of qualifying property in the year you place it in service, instead of depreciating it over time. This is an election you make for tax purposes. In Beancount, this would simply be a debit to an expense account instead of a fixed asset account at the time of purchase.

Common Pitfalls (and How to Avoid Them)​

• Posting depreciation directly against the Cost account.
  • Fix: Always credit the ...:AccumDep contra-asset account. This preserves the historical cost, which is important for financial reporting.
• Forgetting to remove Accumulated Depreciation on disposal.
  • Fix: When you sell or scrap an asset, your journal entry must include a debit to ...:AccumDep to clear its balance for that asset.
• Mixing up bookkeeping and tax depreciation schedules.
  • Fix: Your internal management books often use straight-line for simplicity, while your tax filings may require MACRS. Keep these purposes separate and document your policy.
• Expecting the Fava amortize plugin to handle non-equal schedules.
  • Fix: Remember that this plugin is designed only for equal monthly splits. For any other pattern, use manual postings or a more flexible periodic plugin.

Copy-Paste Template​

Here is a complete template you can adapt for your own ledger.

option "title" "My Business Ledger"
plugin "fava.plugins.amortize_over"  ; Remove if not using Fava automation

; --- Accounts ---
2025-01-01 open Assets:Bank:Checking
2025-01-01 open Assets:Equipment:Computers:Cost
2025-01-01 open Assets:Equipment:Computers:AccumDep
2025-01-01 open Expenses:Depreciation:Computers
2025-01-01 open Income:Gains:AssetDisposals
2025-01-01 open Expenses:Losses:AssetDisposals

; --- Purchase at historical cost ---
2025-01-20 * "Purchase MacBook Pro"
  Assets:Equipment:Computers:Cost      3000.00 USD
  Assets:Bank:Checking               -3000.00 USD

; --- Choose ONE depreciation approach ---

; (A) Manual monthly posting
2025-02-28 * "Monthly depreciation - MacBook Pro (SL 36mo)"
  Expenses:Depreciation:Computers           83.33 USD
  Assets:Equipment:Computers:AccumDep      -83.33 USD

; (B) Fava automation (for 36 equal monthly splits)
2025-01-20 * "Depreciation schedule - MacBook Pro"
  amortize_months: 36
  Expenses:Depreciation:Computers       3000.00 USD
  Assets:Equipment:Computers:AccumDep  -3000.00 USD

; --- Sale example (edit numbers for your actual sale) ---
2027-06-15 * "Sell MacBook Pro"
  Assets:Bank:Checking                     800.00 USD
  Assets:Equipment:Computers:AccumDep     2500.00 USD
  Assets:Equipment:Computers:Cost        -3000.00 USD
  Income:Gains:AssetDisposals             -300.00 USD

TL;DR​

• Keep asset Cost and AccumDep in separate accounts to preserve historical cost.
• Record depreciation with a debit to Expenses:Depreciation:... and a credit to Assets:...:AccumDep.
• Automate equal monthly depreciation with the Fava amortize plugin or generate dated entries with a periodic plugin.
• When disposing of an asset, you must remove both its Cost and its AccumDep from the books and record the resulting gain or loss.

Sources & Further Reading​

• Beancount.io "Amortization" Guide (Contra-asset approach, Fava plugin, examples).
• Investopedia on Depreciation vs. Accumulated Depreciation (Credit balance rationale).
• IRS Publication 946 (Official rules for MACRS and U.S. tax depreciation).
• beancount-periodic Plugin (Tool for generating periodic transactions).