CapGate Pro – CapEx OpEx Tracker, Excel & Google Sheets, Software Capitalization Template, Amortization Schedule, Budget Dashboard

Log hours and invoices. CapGate Pro decides what to capitalize, builds the amortization schedule and shows the P&L impact, with audit checks on every row.

Built for finance teams, controllers, PMOs, fractional CFOs and IT leaders who need to split software, cloud and IT project costs between CapEx and OpEx, and defend the numbers to their auditor.

━━━━━━━━━━━━━━━━━━━━

WHY IT'S DIFFERENT

━━━━━━━━━━━━━━━━━━━━

✔ 4 accounting modes in one switch: US GAAP ASU 2025-06 (the new gate-based rules), legacy ASC 350-40 stages, IFRS IAS 38, or your own custom policy

✔ Capitalization gate per project: approval, funding, "probable to complete", uncertainty resolved and go-live dates decide the window. Work outside it is expensed and flagged automatically

✔ Your policy, not ours: every activity and cost category rule is editable. Nothing is hard-coded

✔ Auditor-friendly labor costing: overhead is kept out of capitalized labor, and every row shows exactly why it is CapEx or OpEx

✔ P&L impact view: expense everything vs capitalize and amortize, month by month, with EBITDA and operating-profit uplift

✔ Month-end journal helper with suggested entries and a debits = credits check

✔ Data health score and 10 automatic audit checks, with an evidence log for approvals

━━━━━━━━━━━━━━━━━━━━

WHAT'S INCLUDED

━━━━━━━━━━━━━━━━━━━━

• Excel workbook: blank + sample (fictional company with 18 months of data)

• Google Sheets: blank + sample, via "Make a copy" links in the Access Links PDF

• 13-page illustrated Quick Start Guide (PDF)

• Built-in Guide & FAQ tab

18 tabs: Start · Settings · Lists & Rules · Projects & Gate · Team & Rates · Time Log · Spend Log · Budget ·

Executive Dashboard · Project Deep-Dive · Team Utilization · Forecast & EAC · Asset Register & Amortization · P&L Impact · Journal Helper · Audit & Health · Guide

11 charts: monthly CapEx vs OpEx, CapEx:OpEx split, budget vs actual, top cost categories, capitalization rate, burn-up, cost mix, P&L comparison and more.

━━━━━━━━━━━━━━━━━━━━

FEATURES

━━━━━━━━━━━━━━━━━━━━

• 20 currencies, any fiscal-year start month, 5 colour themes

• "Current year" dashboards that never get stuck on an old year

• Capacity: 50 projects, 60 people, 3,000 time rows, 1,500 spend rows, 300 budget lines

• Straight-line amortization, write-offs, net book value

• Forecast and estimate at completion (EAC) per project

• Formula cells are protected (no password) so nothing breaks by accident

• "Start" button on every tab for one-click navigation

━━━━━━━━━━━━━━━━━━━━

COMPATIBILITY

━━━━━━━━━━━━━━━━━━━━

✔ Microsoft Excel 2019, 2021 and Microsoft 365 (Windows, Mac and Excel for the web)

✔ Google Sheets (free Google account)

✔ No macros, no scripts, no add-ins

✘ Not for Apple Numbers or LibreOffice

━━━━━━━━━━━━━━━━━━━━

HOW IT WORKS

━━━━━━━━━━━━━━━━━━━━

1. Purchase and download the files from Etsy (Purchases & Reviews)

2. Open the Excel file, or click "Make my copy" in Access_Links.pdf for Google Sheets

3. Follow the 15-minute setup checklist on the Start tab4. Log time and spend weekly. Every dashboard and schedule updates itself

━━━━━━━━━━━━━━━━━━━━

WHAT THIS IS NOT

━━━━━━━━━━━━━━━━━━━━

• Not accounting, tax or legal advice. CapGate applies the rules you choose; confirm your policy with your accountant or auditor

• Not an accounting system. It prepares journal entries for you to post in QuickBooks, Xero, NetSuite and so on

• Not a physical product. Nothing will be shipped

━━━━━━━━━━━━━━━━━━━━

LICENCE

━━━━━━━━━━━━━━━━━━━━

For use by one business (or one client engagement for consultants). Please don't share, resell or

redistribute the files or links.

Due to the digital nature of this product, returns and exchanges aren't accepted. If anything doesn't work as described, message me and I'll make it right.

Questions? Send me a message. I'm happy to help.