June Costing Analysis Report

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), and Paid 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 individual Games entries of $150 and $100.
  • 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:

  1. 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).
  2. 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)
  3. 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.

Discover more from Robs Writing CV and Art

Subscribe to get the latest posts sent to your email.

Leave a Reply

Discover more from Robs Writing CV and Art

Subscribe now to keep reading and get access to the full archive.

Continue reading