Uttoxeter Juniors FC Cash Flow Forecast 2024-25
| Starting cash on hand Cash on hand (beginning of mon Cash Receipts |
£ 10,731.11 | Starting date | Starting date | Jul 2024 | Cash minimum balance aler | Cash minimum balance aler | Cash minimum balance aler | t £ 3,000.00 | t £ 3,000.00 | t £ 3,000.00 | t £ 3,000.00 | t £ 3,000.00 | t £ 3,000.00 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Actual Actual Actual |
Actual Actual Actual Actual |
||||||||||||
| July 2024 | August 2024 | ### | October 2024 | ### | ### | January 2025 | February 2025 | March 2025 | April 2025 | May 2025 | June 2025 | Ttl | |
| th £ 10,731.11 | £ 13,424.33 | £ 14,625.31 | £ 11,653.02 | £ 14,682.20 | £ 9,887.75 | £ 13,282.21 | £ 12,610.04 | £ 15,039.03 | £ 14,416.20 | £ 10,338.66 | £ 11,352.50 | oa | |
| Membership subs - One of paym Membership subs - Direct Debit Sponsorship funds Interest, other income Loan proceeds Contributions Fundraising Committee Income Total Cash Receipts Total Cash Available Cash Paid Out |
|||||||||||||
| e £ 2,280.00 | £ 1,140.00 | £ 970.00 | £ 375.00 | £ - | £ 190.00 | £ - | £ - | £ - | £ - | £ - | £ - | £ 4,955.00 | |
| £ 210.00 | £ 494.67 | £ 2,457.67 | £ 4,058.64 | £ 3,326.35 | £ 3,321.81 | £ 3,308.70 | £ 3,421.71 | £ 3,320.43 | £ 3,196.61 | £ 3,248.19 | £ 2,988.25 | £ 33,353.03 | |
| £ 3,725.32 | £ 801.39 | £ 1,671.91 | £ 1,331.59 | £ 300.00 | £ - | £ - | £ - | £ 391.65 | £ 900.00 | £ - | £ 850.00 | £ 9,971.86 | |
| £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | |
| £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | |
| £ 1,587.81 | £ - | £ 215.99 | £ 153.00 | £ 1,037.00 | £ 529.57 | £ 25.85 | £ 754.75 | £ 192.31 | £ 1,545.00 | £ 4,200.36 | £ 3,086.06 | £ 13,327.70 | |
| £ 1,169.16 | £ 353.52 | £ - | £ 94.00 | £ 115.00 | £ 2,662.17 | £ 813.72 | £ 1,042.18 | £ 383.94 | £ 332.77 | £ 507.52 | £ 1,347.92 | £ 8,821.90 | |
| £ 8,972.29 | £ 2,789.58 | £ 5,315.57 | £ 6,012.23 | £ 4,778.35 | £ 6,703.55 | £ 4,148.27 | £ 5,218.64 | £ 4,288.33 | £ 5,974.38 | £ 7,956.07 | £ 8,272.23 | £ 70,429.49 | |
| £ 19,703.40 | £ 16,213.91 | £ 19,940.88 | £ 17,665.25 | £ 19,460.55 | £ 16,591.30 | £ 17,430.48 | £ 17,828.68 | £ 19,327.36 | £ 20,390.58 | £ 18,294.73 | £ 19,624.73 | ||
| BJFL Mid Stafs League Match kits - Players Coaches kit Of pitch clothing - Players Training Equipment Team Contribution Trophies Tournament Entries Ref Fees Everyone Active Elkes ULT Pitch Hire IT Costs FA Costs DBS/Safeguarding Costs Taxes and licences Travel Utilities Wages (less emp. credits) Other expenses Other expenses Other expenses Miscellaneous Subtotal Owners’ withdrawal Total Cash Paid Out Cash on hand (end of month) Other OperatingData |
|||||||||||||
| £ - | £ - | £ 20.00 | £ 75.00 | £ - | £ - | £ 1,240.00 | £ 20.00 | £ 30.00 | £ 102.00 | £ 1,310.00 | £ - | £ 2,797.00 | |
| £ - | £ - | £ - | £ 40.00 | £ 160.99 | £ 30.00 | £ 81.00 | £ 46.43 | £ 85.00 | £ - | £ - | £ 443.42 | ||
| £ 3,943.87 | £ - | £ 3,356.28 | £ 94.80 | £ 963.36 | £ - | £ - | £ - | £ - | £ 1,579.94 | £ - | £ 391.65 | £ 10,329.90 | |
| £ - | £ 423.87 | £ 1,151.45 | £ 462.04 | £ 1,021.72 | £ - | £ 87.30 | £ 26.09 | £ - | £ 360.94 | £ - | £ 244.57 | £ 3,777.98 | |
| £ - | £ 306.00 | £ 1,865.05 | £ 767.72 | £ 1,569.94 | £ - | £ 50.49 | £ - | £ - | £ 1,922.51 | £ - | £ 942.24 | £ 7,423.95 | |
| £ 672.39 | £ 323.20 | £ 422.02 | £ 119.88 | £ 100.46 | £ - | £ 69.38 | £ 131.92 | £ 331.38 | £ 25.80 | £ 3,748.99 | £ 480.60 | £ 6,426.02 | |
| £ 66.50 | £ 20.00 | £ 143.73 | £ 20.00 | £ 143.00 | £ 693.82 | £ - | £ - | £ 351.00 | £ 114.65 | £ - | £ 355.00 | £ 1,907.70 | |
| £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ 150.00 | £ 92.08 | £ 170.00 | £ 2,797.44 | £ 3,209.52 | |
| £ 30.00 | £ 30.00 | £ 40.00 | £ - | £ - | £ - | £ 40.00 | £ - | £ 35.00 | £ 105.00 | £ - | £ 65.00 | £ 345.00 | |
| £ - | £ 14.00 | £ 245.00 | £ 403.00 | £ 250.00 | £ 305.00 | £ 225.00 | £ 295.00 | £ 632.00 | £ 360.00 | £ 173.00 | £ - | £ 2,902.00 | |
| £ 159.36 | £ - | £ - | £ 24.84 | £ 139.95 | £ 635.51 | £ 1,233.17 | £ 1,475.83 | £ 971.78 | £ 1,327.46 | £ 159.30 | £ 256.00 | £ 6,383.20 | |
| £ 83.33 | £ 145.14 | £ 280.00 | £ 177.64 | £ 20.00 | £ 33.00 | £ 45.53 | £ - | £ 379.98 | £ 142.21 | £ - | £ 39.98 | £ 1,346.81 | |
| £ 1,060.00 | £ 210.00 | £ 100.00 | £ 3,601.91 | £ 418.59 | £ 947.50 | £ 288.61 | £ 377.50 | £ 180.00 | £ 440.22 | £ 100.00 | £ 7,724.33 | ||
| £ - | £ 235.00 | £ - | £ 373.18 | £ 458.92 | £ 441.07 | £ 270.92 | £ - | £ 140.37 | £ 50.48 | £ - | £ - | £ 1,969.94 | |
| £ 29.40 | £ 35.39 | £ 35.39 | £ 54.00 | £ 64.71 | £ 64.51 | £ 64.51 | £ 62.99 | £ 259.96 | £ 169.37 | £ 582.40 | £ 144.83 | £ 1,567.46 | |
| £ - | £ - | £ 24.00 | £ - | £ - | £ 9.94 | £ 199.99 | £ 44.73 | £ 507.78 | £ 75.00 | £ 12.00 | £ 1,154.49 | £ 2,027.93 | |
| £ - | £ - | £ 50.00 | £ - | £ 40.00 | £ 43.00 | £ - | £ 52.50 | £ 79.01 | £ 221.52 | £ 63.50 | £ 100.00 | £ 649.53 | |
| £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | |
| £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | |
| £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | |
| £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | |
| £ - | £ - | £ 349.00 | £ 270.95 | £ 1,078.63 | £ 473.66 | £ 316.65 | £ 281.86 | £ 618.97 | £ 3,092.96 | £ 270.00 | £ 283.33 | £ 7,036.01 | |
| £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | |
| £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | £ - | |
| £ 234.22 | £ 56.00 | £ 95.94 | £ 40.00 | £ 80.20 | £ 30.00 | £ - | £ 29.12 | £ - | £ 45.00 | £ 12.82 | £ - | £ 623.30 | |
| £ 6,279.07 | £ 1,588.60 | £ 8,287.86 | £ 2,983.05 | £ 9,572.80 | £ 3,309.09 | £ 4,820.44 | £ 2,789.65 | £ 4,911.16 | £ 10,051.92 | £ 6,942.23 | £ 7,355.13 | £ 68,891.00 | |
| £ - | |||||||||||||
| £ 6,279.07 | £ 1,588.60 | £ 8,287.86 | £ 2,983.05 | £ 9,572.80 | £ 3,309.09 | £ 4,820.44 | £ 2,789.65 | £ 4,911.16 | £ 10,051.92 | £ 6,942.23 | £ 7,355.13 | £ 68,891.00 | |
| £ 13,424.33 | £ 14,625.31 | £ 11,653.02 | £ 14,682.20 | £ 9,887.75 | £ 13,282.21 | £ 12,610.04 | £ 15,039.03 | £ 14,416.20 | £ 10,338.66 | £ 11,352.50 | £ 12,269.60 | ||
| Sales volume (pounds) Accounts receivable balance Bad debt balance Inventory on hand Accounts payable balance Depreciation |
|||||||||||||
Uttoxeter Juniors FC - Cash Flow Chart
| Month | Cash on hand | £0 £2,000 £4,000 £6,000 £8,000 £10,000 £12,000 £14,000 £16,000 |
Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun |
|
|---|---|---|---|---|
| July 2024 | £ 10,731.11 | |||
| August 2024 | £ 13,424.33 | |||
| September 2024 | £ 14,625.31 | |||
| October 2024 | £ 11,653.02 | |||
| November 2024 | £ 14,682.20 | |||
| December 2024 | £ 9,887.75 | |||
| January 2025 | £ 13,282.21 | |||
| February 2025 | £ 12,610.04 | |||
| March 2025 | £ 15,039.03 | |||
| April 2025 | £ 14,416.20 | |||
| May 2025 | £ 10,338.66 | |||
| June 2025 | £ 11,352.50 |