Bookkeeping & General Ledger
Double-entry journal, trial balance, income statement and balance sheet.
See what is insideEXCELCRAFT PRO TEMPLATE
Fixed asset register
and depreciation schedule.
Every asset, what it cost, what it is worth on the books today and what it will cost you in depreciation next year. Add an asset once and the register does the monthly maths.
Planned pricing: $8 a month or $60 a year. No payment is taken today.
ExcelCraft / Fixed Asset Register & DepreciationFictional sample
- Two depreciation methods
- Disposals & gains
- 6-year schedule
INSIDE THE WORKBOOK
Every sheet
has one job.
Mint cells are where you type. White cells calculate. Instructions inside the file explain each field.
- Dashboard
- Cost of assets held, accumulated depreciation, net book value and depreciation this year, by category and by fiscal year.
- Assets
- The register: ID, category, location, in-service date, cost, salvage, life, method and disposal; depreciation, book value, status and gain or loss calculate.
- Schedule
- Depreciation per asset for six fiscal years, with totals.
- Settings · Checks · Instructions
- Fiscal year start, report date and categories; checks for missing data and disposals without proceeds.
WHY IT HELPS
Built around
the real task.
Asset register with straight-line or declining-balance depreciation and a 6-year schedule.
Monthly depreciation, done right
Depreciation starts in the month an asset goes into service and stops in the month it is disposed of, never below salvage value.
Two methods side by side
Straight-line spreads the cost evenly. Declining balance front-loads it at twice the straight-line rate. Choose per asset.
The next six years at a glance
The schedule shows depreciation for each asset and in total for six fiscal years, ready for budgeting.
GETTING STARTED
Three steps
to your own version.
The sample shows a working example; the blank version keeps every formula ready for your records.
Set the year
On Settings, set the fiscal year start, the report date and your asset categories.
Register assets
Add each asset with its in-service date, cost, salvage value, useful life and method.
Review each month end
Move the report date forward. Record disposals with a date and proceeds.
QUESTIONS
Before you begin.
Short answers about how the workbook behaves.
Which method should I use?
Straight-line is the most common for management accounts. Declining balance suits assets that lose value quickly, such as vehicles or computers.
Does it follow tax depreciation rules?
No. Tax rules (such as MACRS or capital allowances) differ by country. Use this for management accounts.
What happens when I sell an asset?
Enter the disposal date and proceeds. Depreciation stops, the asset leaves the totals and the gain or loss is calculated.
How many assets can it hold?
500 on the register; the schedule shows the first 200.
How do I keep my changes?
Use Download XLSX or PDF in the editor before closing the tab. Nothing is saved to a server automatically, and your workbook never leaves your device while you edit.
Will it work in Excel and Google Sheets?
The files use standard XLSX formulas without macros, pivot tables or external links. They are checked with the ExcelCraft engine; compatibility with every Excel or Google Sheets version is not guaranteed. Review formulas, charts and formatting in your app before relying on important figures.
Can I change the currency?
Amounts use a $ number format. Change the cell format to your currency; the formulas do not convert between currencies.
EXCELCRAFT PRO · EARLY ACCESS
Part of
ExcelCraft Pro.
Pro workbooks cover whole workflows: purchasing to receiving, journal to balance sheet, tasks to portfolio health. Pro is planned to include AI credits for editing through chat. Pro downloads and the AI assistant are not available yet.
- Every Pro workbook as it is released, with dashboards, checks and instructions
- Planned: monthly AI credits for editing spreadsheets through chat
- Planned launch pricing; final terms are not set
$8/ month
or $60 / year · planned launch price
No payment today. We email you once when Pro opens.
How Pro worksRELATED
Works well with.
Separate workbooks for neighbouring jobs. Records do not sync between files.
Balance Sheet & Reconciliation
Two-period balance sheet with ratios and a reconciliation status for every line.
See what is inside
Business Budget & Variance
Monthly budget by department and category, actuals, and variance with a full-year forecast.
See what is insideYour workbook stays in this browser while you edit. Use Download in the editor to keep your work, and review important figures in the saved copy. How local files are handled.
Original ExcelCraft workbook design, formulas and fictional sample data · CC0. Management tool only; not tax, legal or accounting advice.