What's inside
- Weekly, biweekly, twice-a-month or monthly pay, with weekend paydays moved to the Friday before (optional)
- Up to 30 bills (monthly on a due day, or yearly in a given month) and up to 12 every-paycheck amounts like groceries, gas and savings
- Plan tab: every paycheck with its bills, leftover and running balance, and red rows wherever your balance would dip below zero
- View tab: pick any paycheck and see exactly which bills it pays, in due-date order
- Months tab: pay vs bills each month, and the months that bring a third paycheck
- Change any single paycheck (a bonus, overtime, a smaller check) and everything after it updates
- Sample file: $2,150 every other Friday, 11 bills. Every bill covered on time; lowest balance $912; 2 months with a third paycheck
Checked, not just designed: 3,776 formulas, zero errors, and paydays, due dates, every bill's paycheck, each paycheck's totals and the running balance were regenerated independently in 6 scenarios, including February due dates on the 30th and 31st.
Works in Excel 2019 or newer, Excel 365 and Google Sheets. Not financial advice.