Free Bitcoin DCA Tracker — Google Sheets Template

A simple free Google Sheets template for Bitcoin holders who want to manually track their Bitcoin buys, average buy price, total invested, and current stack value.

This tracker is built for long-term Bitcoin holders who want a clean and simple way to track their Bitcoin portfolio without connecting a wallet, exchange account, seed phrase, or API keys.

No wallet connection.

No exchange connection.

No seed phrase.

No API setup.

Just make your own Google Sheets copy and start tracking your Bitcoin purchases.

What’s included

Dashboard

View a simple summary of your Bitcoin stack, including:

• Current Bitcoin price
• Total currency invested
• Total BTC owned
• Average buy price
• Current BTC value
• Unrealised gain/loss
• Weekly DCA amount
• Projected annual DCA

Inputs tab

Update your core assumptions, including:

• Current Bitcoin price
• Weekly DCA amount
• Starting date

The tracker also includes a live BTC price reference section for USD, AUD, and EUR. Live prices are for reference only and may be delayed or unavailable.

Bitcoin DCA Log

Record your Bitcoin purchases manually, including:

• Date
• Transaction type
• Fiat invested
• BTC amount
• Bitcoin price
• Fees
• Exchange
• Notes

Instructions tab

Basic usage notes to help you understand how to use the tracker correctly.

How it works

After downloading, open the tracker link and click Make a copy.

Your own editable version will be saved to your Google Drive.

Then update the orange cells and replace the sample Bitcoin purchase data with your own records.

Full version available

If you want more advanced tracking tools, check out Bitcoin Portfolio Tracker Pro.

The Pro version includes:

• Projection estimates
• Bitcoin price scenario planning
• Loan LVR modelling
• Estimated interest costs
• Tax log features
• DCA Stack Generator
• Planned Alternative Assets tab in a future update

Important

This is a manual Google Sheets tracker.

It does not connect to your wallet, exchange, seed phrase, or API keys.

Use one currency consistently throughout the tracker.

Disclaimer

This spreadsheet is an educational tracking tool only.

It is not financial, tax, legal, borrowing, credit, or investment advice.

Bitcoin is volatile. Always speak with a qualified professional before making investment, tax, legal, borrowing, or credit decisions.

Licence

© 2026 Bitcoin Stack Lab. All rights reserved.

This template is for personal use only. Redistribution, resale, public sharing, rebranding, uploading, copying, or modification for resale is not permitted without written permission.