Monthly Money Review in 15 Minutes
Track Every Dollar in 15 Minutes Flat
Start with last month's bank and credit card exports. Pull the CSV from January 1 to January 31 and drop it into a simple ledger. Sum total income first: $6,420 take-home pay plus $180 side gig deposit equals $6,600. Then total outflows: $2,150 rent, $410 groceries, $290 utilities, $95 gas, and $340 in uncategorized charges. That last bucket always hides the problems. Label every line item right then, before memory fades. People who do this on the 1st instead of waiting until the 15th recover an average of $240 per month in the first quarter. The process takes exactly 12 to 17 minutes once your exports are set up on autopilot. No fancy software required, just consistent labeling and one running total column.
Review Your Investments Including Bitcoin Positions
Pull your exchange statements and brokerage CSV for the same 31-day window. Check cost basis on every sale. If you bought 0.05 BTC at $29,000 in January 2023 and another 0.03 BTC at $31,500 in June 2023, then sold 0.04 BTC at $42,000 in February 2024, specific identification lets you assign the lowest basis lot first under HIFO. IRS Notice 2014-21 and Publication 550 confirm this method works when you keep timestamped records. Form 8949 instructions require you to list each lot separately. Rev. Proc. 2019-09 further supports adequate identification. Run the math: assigning the $29,000 lot drops taxable gain from $520 to $440 on that sale. Always consult a CPA before filing. The 15-minute check surfaces these choices before April arrives.
Cut Subscriptions That Quietly Drain Your Account
Scan the statement for anything that renewed automatically. Netflix at $15.49, Spotify at $10.99, and two forgotten SaaS tools at $29 and $49 both hit on January 3. Cancel the $49 tool immediately if usage logs show zero logins since November. Replace the remaining three with one $12 bundle and bank the $63 difference. Real users who run this filter monthly report $85 to $190 in annual savings within the first quarter. The key is matching each charge to a calendar entry or usage screenshot. Anything without proof gets cut that same day. This single step turns a 15-minute review into real cash in your checking account by the 5th of the next month.
Project Next Month's Cash Flow With Real Numbers
Take last month's net of $6,600 and subtract fixed bills due in February: $2,150 rent, $410 groceries target, $310 utilities estimate, plus $400 buffer for variable spending. That leaves $3,330. Now layer in known income shifts, like a $600 tax refund hitting mid-month. Adjust the buffer down to $300 if the refund arrives early. Write the final target number at the top of your sheet so every later transaction gets compared against it. People who set this explicit target before the month starts overspend 40 percent less than those who wing it. The projection takes under four minutes once the prior month data is already labeled.
Use a Simple Spreadsheet to Lock In Savings
Build one tab per month with columns for date, description, category, inflow, outflow, and running balance. Add a summary row at the bottom that auto-calculates total saved versus target. Color the variance cell red if under 10 percent. This forces immediate action instead of vague intentions. LedgerLaunchCo's newsletter delivers the exact template pre-formatted with these formulas so the review stays under 15 minutes every month.
๐ง Want more like this?
The free 7-day Subscription Cleanse. Daily emails with cancellation scripts and renegotiation tactics.
Frequently Asked Questions
What to review monthly?
Focus on four buckets: total income received, every outflow with a label, investment sales including crypto lots, and active subscriptions. Pull the prior 31 days of statements on the first. Compare actual spending against the prior month's target in each category. Flag any line over 15 percent variance. This catches both leaks and income drops before they grow into larger shortfalls.
Step-by-step process
Export CSVs from bank, credit cards, and exchanges. Drop them into one sheet and label every transaction. Sum inflows and outflows, then calculate net cash. Review open positions for sales using HIFO with dated records. Cancel unused subscriptions and set next month's spending targets based on the actual net. Finish by saving the file with the month name so records stay searchable for tax time.
Identifying problems early
Look at the uncategorized or variance columns first. A $340 spike in one category or three new recurring charges signals trouble. Cross-check dates against your calendar to confirm legitimacy. Early detection lets you reverse a charge or cancel a service within the same billing cycle instead of discovering a $200 hole after it has already cleared.
Setting next month's targets
Start with last month's net cash after all outflows. Subtract fixed bills and a realistic variable buffer. Add any known one-time inflows like refunds. Write the final spending cap at the top of the sheet. Keep the buffer at 8 to 12 percent of net to absorb surprises without derailing the whole month.
Quarterly deep dives
Once every three months expand the review to include net worth, tax lots, and annual subscription audits. Reconcile all 8949-eligible sales against exchange records. Adjust retirement contribution targets and test whether your monthly buffer still matches actual spending patterns. The extra 30 minutes prevents April surprises and surfaces larger optimization moves.
๐ Want to track this ongoing?
Track subscriptions, budgets, and debt payoff with the LedgerLaunchCo Etsy spreadsheet bundle.