Track Your Sats Stacking
Why Spreadsheets Beat Every App for Sats Stacking
Exchange apps lose data during migrations and round sats to the nearest thousand, so serious stackers build their own sats stacking tracker instead. If you bought 0.05 BTC at $29,000 on January 15 2023 and another 0.03 BTC at $38,500 on June 4 2023, a spreadsheet records the exact satoshi amount, USD cost, and acquisition date without rounding errors. That level of detail matters when Bitcoin hits $95,000 and you sell 800,000 sats. Apps force FIFO or average cost; a spreadsheet lets you pick HIFO under IRS specific-identification rules from Rev. Proc. 2019-09 and Form 8949 instructions. You stay in control. Most people discover after two years that their exchange history is missing fees and timestamps, forcing them to reconstruct everything from bank statements. A simple tracker prevents that mess and keeps every number ready for Notice 2014-21 reporting. Consult a CPA before filing.
Setting Up the Free DCA Spreadsheet
Start with columns for date, USD spent, BTC received, satoshis, exchange rate, and running total. Add formulas that convert each buy into satoshis using eight decimal places so 0.0125 BTC becomes exactly 1,250,000 sats. Color-code rows by year so you see at a glance that 2024 purchases averaged $62,400 while 2023 averaged $31,200. Include a summary cell that shows total sats stacked and weighted average cost per sat. When you add a $500 purchase on March 12 2024 at $71,800, the sheet instantly updates your cost basis to $0.000718 per sat. Export the sheet as CSV before tax season and attach it to your records. This setup takes twenty minutes once and saves hours later. Consult a CPA for your specific situation.
Calculating Cost Basis With HIFO
HIFO is allowed when you maintain adequate records under Pub 550 and Form 8949 instructions. List every lot by acquisition date and cost, then sell the highest-basis sats first. Your sats stacking tracker already holds the data, so you sort by basis descending and subtract from the sale amount. A stacker who bought 0.04 BTC at $26,500 in late 2022 and 0.06 BTC at $44,000 in 2024 can sell 500,000 sats at $88,000 and assign the entire sale to the 2024 lot, realizing just $22,000 of gain instead of $31,000 under FIFO. That difference compounds across multiple sales. Keep the spreadsheet as your contemporaneous log so the IRS sees the specific identification you chose. Never rely on exchange default methods. Consult a CPA before using any method on your return.
Handling Exchange Rates and Timestamps
Use the exact UTC timestamp from your exchange receipt for every purchase. If the receipt shows 2023-01-15 14:37:12 UTC and the price was $29,012, record that rate, not a daily average. Small differences matter: a $112 variance on a 0.05 BTC buy changes your per-sat basis by $0.00000224, which scales to real dollars after several years of stacking. Add a column that pulls the daily high-low range from public sources so you can defend the rate chosen. When you move sats off-exchange, log the on-chain fee in sats and USD at the moment of the transaction. These details turn a vague history into an audit-proof trail that satisfies Notice 2014-21. Skip this step and you risk the IRS defaulting to FIFO on your entire stack. Consult a CPA for your jurisdiction.
Tax Season Ready Records
Export your sats stacking tracker to PDF and CSV every December 31 and store copies in three places. When you sell, pull the exact lots sold and attach the supporting sheet to your Form 8949. The IRS has accepted specific identification since Notice 2014-21 when taxpayers keep contemporaneous records. One stacker sold 1.2 million sats in 2024, used HIFO from a properly dated spreadsheet, and reported $14,800 less gain than the exchange summary showed. That outcome came from clean data, not luck. Keep the sheet updated after every buy so year-end work takes minutes instead of days. Grab the free spreadsheet and sign up for Exit Velocity updates to stay sharp on Bitcoin data habits.
📧 Want more like this?
Weekly Bitcoin and finance breakdowns. Free. No spam.
Frequently Asked Questions
What is sats stacking?
Sats stacking means buying Bitcoin in small, repeated amounts and holding the satoshis rather than thinking in whole coins. A typical stacker might add $150 every Friday at whatever price appears, turning those dollars into 2,100 sats one week and 1,850 the next. Over twelve months the total often reaches 80,000 to 120,000 sats with an average cost tracked to the cent. The habit removes timing pressure and builds a position through market swings without large lump-sum decisions.
How do I track DCA purchases?
Record every purchase the same day it settles: date, USD amount, BTC received, satoshi total, and the exact exchange rate at execution. A spreadsheet with those five columns plus a running total gives you cost basis and average price per sat instantly. Update after each buy so the sheet stays current. Export the file monthly and keep dated copies. This habit produces the records required for specific identification under IRS rules without extra work at tax time.
Should I track in sats or BTC?
Track in satoshis. Most DCA buys land between 1,500 and 4,000 sats, numbers that disappear when rounded to eight decimals of BTC. A sats column shows exactly how many units you own and makes percentage gains or losses obvious at a glance. You still keep a BTC total for portfolio views, but the satoshi line becomes the primary record for cost basis and future sales. The difference matters once your stack exceeds 500,000 sats.
What about exchange rate at purchase?
Use the precise rate shown on the trade confirmation at the exact UTC time of execution. A $500 buy at 14:37:12 that prints $71,812 per BTC creates a different basis than the daily average of $70,950. Record that rate and the timestamp. When prices move fast, the variance on a single purchase can reach $30 to $80, which scales across dozens of buys. Accurate rates keep your HIFO calculations defensible if the IRS reviews the return.
Best tools for tracking sats?
A lightweight spreadsheet remains the most reliable option because you control every cell and export format. It accepts any exchange CSV, adds satoshi conversion formulas, and supports HIFO sorting without vendor lock-in. Paid apps add convenience but often round values or default to FIFO. Whatever tool you choose, export dated backups after each month and store them separately. The goal is a clean, auditable history rather than pretty charts.
📊 Want to track this ongoing?
The spreadsheet bundle behind our calculations. Track cost basis, sats stacking, and tax lots forever — on your machine, never in someone else's database.