The $112 Hiding in Tab 41 of My January Spreadsheet

Every first Saturday of January, the dining table becomes an accounting firm with one employee: laptop, phone, paper notebook, and a spreadsheet that has grown to forty-one tabs, one for every account, wallet, exchange, and forgotten corner of my financial life since 2021. This year that was January 3rd, 12:10 PM, kettle on its second boil, and the situation was this — six accounts actually holding $87,512, while the spreadsheet claimed $87,400. I do not tolerate a $112 disagreement between my records and reality, so the afternoon went to the hunt, and the hunt turned up three things I'd forgotten I owned.

The stakes sound miniature until you've let a mismatch ride. In January 2023 the gap was $1,900 and it took three weekends to untangle, because I had double-counted a single transfer between my own wallets — once in the sending exchange's export, once in the receiving wallet's — and every downstream number, net worth, allocation, the works, had been quietly wrong for a year. A reconciliation habit that tolerates modest drift isnt a system. It's a diary with opinions.

The $112 lived in three places, and the strangest was 0.0004 Bitcoin I mailed to myself in October 2021 as a transfer test and never merged back — my own money, addressed to me, forgotten for fifty-one months. Tab 41 is where forgotten money goes to get found, and this is the story of the other two places too, plus the $1.32 of unclaimed rewards nobody warned me about.

six accounts, $87,512, one table

The ritual began in January 2021, the year I first snagged crypto and discovered that no app would tell me my total position across the brokerage, the bank, the exchange, and the hardware wallet, so I built the sheet myself: one tab per institution, a summary tab at the front that just adds. Six actual holdings now — the checking account, the high-yield savings account at 4.2%, the brokerage with the ETF position, the 401(k) with its index fund, the main exchange, and the hardware wallet — plus assorted ghost tabs for closed accounts. The crypto tabs are invariably the problem children. The bank and brokerage tabs reconcile themselves from CSV imports in minutes, every January, like adults. The crypto tabs require me to become a forensic accountant for an afternoon, which is either the tax or the charm of the asset class, depending on the year and my blood pressure.

the tab named 'dust 2021'

The tab named dust 2021 was created, per its own notes column, on October 9 of that year, to track test transfers — the $20 shakedown cruises you're advised to run before moving real money to self-custody, back when a network fee was $4 and my nerves were worse. It sits at position forty-one, dead last, which is why the hunt began there. Most of the tests got merged into the main wallet later that autumn. One did not.

the 0.0004 BTC I mailed to myself

The one that did not was 0.0004 Bitcoin, sent from the exchange to a fresh receive address on October 14, 2021, at 4:11 PM, fee $2.19, confirmed in thirty-one minutes, and then simply never touched again — the real transfer that followed went to a different address entirely, and the test sat where it landed like a letter mailed to an old apartment. For fifty-one months it grew from $20 to $34.80 without my knowledge, which sounds like a miracle and is actually just 0.0004 times the price of Bitcoin with zero decisions involved. I found it by exporting every address my wallet had ever generated. There it was. My own signature on both ends of a transaction I'd forgotten conducting.

exchange two and its $58.62

Exchange two and its $58.62: a referral bonus in USDC, credited in August 2022 for talking my brother-in-law into an account he used for exactly three weeks, and it sat on that exchange because the withdrawal fee at the time exceeded my motivation. The exchange emailed me a quarterly statement, which I archived within seconds, every quarter, for three years. During the January hunt I logged in expecting the worst. The account still existed. The $58.62 was still there, and moving it home cost $1.01 in fees, which the notebook records as the price of my own laziness, annualized.

the $18.58 in a wallet I'd nicknamed

The $18.58 was in a software wallet I'd nicknamed phonejar in 2023, scattered across three learn-to-earn tokens collected during a phase when I watched short videos for pocket change, and finding it required remembering a twelve-word phrase I had, thank God, stored properly — cuz the alternative ending to this paragraph is short and humiliating. Two of the three tokens still had functioning markets. One had been delisted, and its $6.40 is now a number in a ledger and a lesson in a notebook. The salvage operation, net of gas, recovered $11.19.

the January that was off by $1,900

The $1,900 January deserves its retelling every year, like a ghost story. The 2023 hunt consumed three weekends cuz the mismatch wasnt missing money — it was the same money counted twice, a $1,900 transfer appearing in both the sending exchange's CSV and the receiving wallet's, each export confident and internally consistent. I fixed it with a txid column: every row now carries the transaction hash, and a transfer between my own accounts gets matched on both sides before the summary tab will accept either one. The fix took an hour to build. The lesson it encodes took a year of wrong numbers to earn: crypto's double-counting problem is solved by treating yourself as two institutions, which is either rigorous or bleak, depending on how you feel about being, functionally, your own correspondent bank.

what goes in the paper notebook

The paper notebook is the exception log, and its rules are short: exceptions only, written by hand, never erased, dated. Twelve entries since 2021. The 0.0004 test, the $58.62, the delisted token, the double-count, a $19.40 fee I once paid in a hurry, and seven others, each a place where the system met a human and the human blinked. The spreadsheet is the machine; the notebook is where the machine's failures get names. My wife calls it the book of modest embarrassments, and she is exactly right, and I've come to think the annual reading of it is the most valuable ten minutes of the whole ritual.

the half hour with the tax lots

The half hour with the tax lots is the other January constant: exporting the year's transactions from two exchanges and the wallet, matching transfers, flagging the lots with actual disposals — this year, one sale of $530 trimming the crypto allocation from 4.6% back to its 4% ceiling, a capital gains tax entry of about $61 in gains, bundled for an accountant who charges me less because the bundle is clean. The ETF and index fund tabs contribute their 1099s automatically, one PDF each, no assembly. The crypto tab contributes a 214-line CSV and a swagger, and I've decided, after five Januaries, that this is the tax the asset charges for being its own bank. its deductible nowhere. its the fee for the education, and the education is: keep the txid column.

the tabs that reconcile themselves

The tabs that reconcile themselves are the ones I trust most, and I've spotted the direction of the correlation: the more an institution behaves like a boring utility, the less its January requires of anybody. The bank tab, the high-yield savings tab, the brokerage tab — import, glance, sign-off, three minutes combined, cuz their CSVs are clean and their history goes back further than my spreadsheet does. The crypto tabs, five years in, still hand me surprises annually, and the surprises are invariably mine: a forgotten test, an abandoned bonus, a nickname I don't remember choosing. The asset didnt hide the money. I hid it from myself, and January is when I get it back.

why I still print page one

Page one gets printed every year — net worth summary, one page, taped inside the coat closet door where my wife can see it — a tradition that predates the spreadsheet and goes back to 2016, when it was a photocopy of a bank statement and the number had four fewer digits. This year's page shows $87,512, corrected in my own handwriting after the hunt, with the $112 circled: 0.0004 of a Bitcoin mailed to myself, $58.62 of forgotten gratitude, $18.58 in a jar with a nickname. The kettle was on its third boil by the time page one printed. I taped it inside the closet door at 4:40 PM, next to nine predecessors, and stood in the hallway a minute the way I stand there every year, doin the same modest arithmetic: the number grew, the drift got caught, nothing was double-counted. Next January I'll do it again, forty-two tabs prolly, hunting whatev version of $112 I've managed to lose in twelve months. My money forgets itself. The spreadsheet remembers. thats the whole job.