Key Takeaways from June
- Significant Balance Recovery: The account started June in an overdraft state of -$300 (dropping to -$400 after the first transaction) but recovered significantly to finish the month with a positive balance of $1,000. This upward trend is visualized in the ‘June 2026 Account Balance Trend’ chart, which tracks the sequential impact of each transaction.
- Positive Net Cash Flow: Total inflows (Credits) for the month were $3,050, while total outflows (Debits) were $1,730, resulting in a positive net cash flow of +$1,320.
- The 4 credit records driving this inflow were:
Payday($1,500),cashout($800),savings($600), andPaid balance($150). - There were 14 debit records totaling $1,730. The largest individual expenses include:
utilities($400),games and gas and overdraft($150), and multiple individualGamesentries of $150 and $100.
- The 4 credit records driving this inflow were:
- Discretionary Spending Patterns: Discretionary spending on recreation and hobbies (primarily categorized under “Games” or “Smokes”) was the primary day-to-day expense, totaling at least $850 across 9 separate transactions, outstripping fixed costs like gas and food during this specific month.
Overview of Other Tables in the Spreadsheet
The remaining tables provide a broader look at your finances across the year, falling into three distinct categories:
- Standard Banking Logs (January – May, July 26): Like the June table, these sheets track daily transaction sequences with columns for Date, Debit, Credit, and Balance. They show a recurring pattern of personal expenses (e.g., games, food, propane, and gambling) punctuated by periodic income injections like Paydays or Tax Returns (such as a $2,400 Tax Return in March).
- Fixed Bills & Loan Tracking (September – December): These tables shift focus toward tracking fixed monthly overhead commitments and outstanding debts. They consistently monitor recurring bills such as:
Starlink($115.00)Rogers Mobile($170.00)Intact Insurance($90.00)Blue Cross($90.00 – $180.00)Groceries($200.00 – $300.00)
- Hobby Inventory & Baseline Budgeting:
- The main July table functions differently from standard banking logs, acting as an inventory and sales ledger for collectibles (e.g., National Album, Penny Blue) to forecast profit and loss.
- The Grant Budget table serves as a baseline reference sheet listing your standard projected monthly living costs (including Rent at $1,900 and Groceries at $750) against which actual monthly spending can be benchmarked.
Leave a Reply