Crypto Cost Basis & 1099-DA Record Kit: Excel + Google Sheets Workbook and Printable Log Book

The Crypto Cost Basis & 1099-DA Record Kit is a record-keeping workbook for Microsoft Excel and Google Sheets, plus a printable log book, for keeping track of your digital asset transactions, lots and cost basis in one place. It's for people who buy, sell, trade, move or receive crypto and want organized records to check against each Form 1099-DA and to hand to a tax professional.

Not tax, legal or investment advice. Consult a tax professional.

WHY RECORDS MATTER NOW

Under the IRS Form 1099-DA instructions, brokers report cost basis only for "covered" units: generally ones acquired after 2025 in the same custodial broker account and held there until sold. Units acquired earlier or transferred in from another wallet can show proceeds with a blank basis. The IRS says you must report all digital asset gains and losses whether or not you receive a Form 1099-DA. This kit helps you keep the records to fill those gaps.

WHAT'S INCLUDED

• Crypto-Cost-Basis-1099-DA-Record-Kit_BLANK.xlsx: ready for your records
• Crypto-Cost-Basis-1099-DA-Record-Kit_EXAMPLE.xlsx: clearly marked sample rows so you can see how it works
• Crypto-Cost-Basis-1099-DA-Log-Book_Printable.pdf: 37-page printable log book (US Letter)

8 WORKBOOK TABS

How to Use · Wallets · Transactions · Lots · Cost Basis · 1099-DA Check · Income · Year Summary

Room for 40 wallets/accounts, 750 transactions, 500 lots, 500 disposals, 300 income entries and 200 Form 1099-DA lines per file.

KEY FEATURES

• One transaction log for buys, sells, crypto-for-crypto trades, transfers between your own wallets, income received and fees paid in crypto
• Lots build themselves from your log, tracked wallet by wallet and asset by asset
• Cost basis matching: FIFO by default, or choose a specific lot for any disposal
• Short-term / long-term split using the "more than 1 year" holding period
• Transfers between your own wallets carry the original acquired date and basis
• 1099-DA Check: copy each line from the form and compare proceeds and basis with your own records, with MISSING BASIS and mismatch flags
• Year Summary grouped by Form 8949 digital asset box (G, H, I short-term; J, K, L long-term), plus income totals and a records check
• Warnings for missing lots, over-used lots and lots dated after a sale

PRINTABLE LOG BOOK (37 PAGES)

Wallets & accounts directory · transaction log · lot register · disposal & cost basis worksheets · transfer log · income log · Form 1099-DA check pages · year-end summary by Form 8949 box · checklist · notes

HOW IT WORKS

1. Buy and download instantly: your download page opens right after checkout, and the link is also emailed to you.
2. On a computer, open the BLANK file in Microsoft Excel, or upload it to Google Drive and open it with Google Sheets.
3. Start on the How to Use tab. List your wallets, then log each transaction in the blue cells. Lots, cost basis, 1099-DA checks and the Year Summary update automatically.
4. Open the EXAMPLE file any time to see a filled-in version. Print the log book if you prefer pen and paper.

COMPATIBILITY

• ✔ Microsoft Excel (Windows and Mac desktop, Microsoft 365)
• ✔ Google Sheets (free): upload the .xlsx to Google Drive, then Open with Google Sheets
• ✘ Not designed for Apple Numbers or phone screens. A computer is recommended.

FREQUENTLY ASKED QUESTIONS

Q: Does it connect to my exchange or wallet?

A: No. You type or paste your own records in. Nothing is connected, uploaded or shared.

Q: Does it file my taxes or tell me what I owe?

A: No. It organizes your records and totals them by Form 8949 box so you can review them with a tax professional or your tax software.

Q: Can I get a refund?

A: Yes, within 14 days of purchase, in two cases: a file has a problem I can't fix, or you bought the same product twice by mistake. Email [email protected] with your order details.

GOOD TO KNOW

• Not tax, legal or investment advice. Consult a tax professional.
• Record-keeping only. It does not recommend any asset or transaction.
• US-focused: IRS Form 1099-DA and Form 8949 categories. Not affiliated with or endorsed by the IRS.
• Never store passwords, seed phrases or private keys in the workbook or log book.
• This is a digital product. Nothing will be shipped.
• For personal use. Please don't share or resell the files.
• Questions or a problem with a file? Email [email protected].

AI disclosure: this kit was designed with the help of AI tools. The formulas, layout and example data were reviewed and tested before release.