| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||||||||
2 | |||||||||||||||||||
3 | |||||||||||||||||||
4 | |||||||||||||||||||
5 | |||||||||||||||||||
6 | |||||||||||||||||||
7 | |||||||||||||||||||
8 | Monthly Budget | ||||||||||||||||||
9 | |||||||||||||||||||
10 | |||||||||||||||||||
11 | |||||||||||||||||||
12 | |||||||||||||||||||
13 | CREATING A NEW MONTH | ||||||||||||||||||
14 | |||||||||||||||||||
15 | Easy | Change the name of the most recent month's spreadsheet to the name of the new month, then copy it and make the copy the original month's name. | |||||||||||||||||
16 | |||||||||||||||||||
17 | OR | ||||||||||||||||||
18 | |||||||||||||||||||
19 | Details | Don't edit the "Day of month" cells, as they are auto generated from the date options. | More Effort | When creating a new month, copy the previous month's spreadsheet, and do a find and replace on this sheet to replace the month name. See example. Make sure search within formulas is ticked. | |||||||||||||||
20 | Today's Date | December 5, 2025 | Selected Date | 2024-04-02 | Person 1 Payday this month | 2024-04-26 | Person 2 Payday this month | 2024-04-16 | |||||||||||
21 | Today's Day of Month | 5 | Selected Day of Month | 2 | Person 1 Payday Day of Month | 26 | Person 2 Payday Day of Month | 16 | |||||||||||
22 | |||||||||||||||||||
23 | Expenses | If the unplanned section on your transaction sheet does not start at line 48, these figures will be incorrect. Please find and replace 48 with whatever line number your unplanned starts on Person 2's totals are calculated based on the ratio of salary they pay in the monthly wages table | |||||||||||||||||
24 | Including Unplanned | Whole Month | Left From Today to Person 1 Payday | Left from Selected Date to Person 1 Payday | Left From today to Person 2 Payday | Left from today to EOM | |||||||||||||
25 | Including Unplanned | Total | €3,863.99 | €55.00 | €155.00 | €55.00 | €55.00 | ||||||||||||
26 | Person 1 Total | €2,207.99 | €31.43 | €88.57 | €31.43 | €31.43 | |||||||||||||
27 | Person 2 Total | €1,656.00 | €23.57 | €66.43 | €23.57 | €23.57 | |||||||||||||
28 | AIB Person 2 Current | €1,788.99 | €25.00 | €25.00 | €25.00 | €25.00 | Excluding Unplanned | Person 2's Totals | Including Unplanned | Person 2's Totals | |||||||||
29 | AIB Person 1 Credit Card | €0.00 | €0.00 | €0.00 | €0.00 | €0.00 | Total | €1,484.57 | Total | €1,656.00 | |||||||||
30 | To Send to Person 1 | -€304.42 | To Send to Person 1 | -€132.99 | |||||||||||||||
31 | Excluding Unplanned | ||||||||||||||||||
32 | Excluding Unplanned | Total | €3,463.99 | €55.00 | €155.00 | €55.00 | €55.00 | ||||||||||||
33 | Person 1 Total | €1,979.42 | |||||||||||||||||
34 | Person 2 Total | €1,484.57 | |||||||||||||||||
35 | AIB Person 1 Current | €575.00 | €30.00 | €30.00 | €30.00 | €30.00 | |||||||||||||
36 | AIB Person 2 Current | €1,788.99 | €25.00 | €25.00 | €0.00 | €30.00 | |||||||||||||
37 | |||||||||||||||||||
38 | Expenses | Income | Monthly Wages | ||||||||||||||||
39 | Total Including Unplanned | Remaining in Month | Total Excluding Unplanned | Remaining in Month | Total | Total | % of Total | ||||||||||||
40 | Totals | €3,863.99 | €55.00 | €3,463.99 | €55.00 | Totals | €7,140.00 | Totals | €7,000.00 | ||||||||||
41 | House/Utilities | €1,713.99 | €55.00 | €1,713.99 | €55.00 | Wages | €7,000.00 | Person 1 | €4,000.00 | 57.14% | |||||||||
42 | Debts | €0.00 | €0.00 | €0.00 | €0.00 | Other Income | €140.00 | Person 2 | €3,000.00 | 42.86% | |||||||||
43 | Cars | €0.00 | €0.00 | €0.00 | €0.00 | ||||||||||||||
44 | Health | €400.00 | €0.00 | €0.00 | €0.00 | ||||||||||||||
45 | Luxuries | €0.00 | €0.00 | €0.00 | €0.00 | ||||||||||||||
46 | Goals | €1,750.00 | €0.00 | €1,750.00 | €0.00 | ||||||||||||||
47 | Misc | €0.00 | €0.00 | €0.00 | €0.00 | ||||||||||||||
48 | |||||||||||||||||||
49 | |||||||||||||||||||
50 | |||||||||||||||||||
51 | |||||||||||||||||||
52 | |||||||||||||||||||
53 | |||||||||||||||||||
54 | |||||||||||||||||||
55 | |||||||||||||||||||
56 | |||||||||||||||||||
57 | |||||||||||||||||||