
Annual Report
Docs + Word6 pages
FeaturedFree
Commission pay swings, and budgets built on the average month fail in the weak ones. This sheet works the other way. Twelve months of pay history give a floor, the average of the three lowest months, and the budget must fit inside it. Bills, taxes set aside, savings and spending each take a share of the floor.
Good months then stand apart: the Pay History tab shows each month against the floor and the Summary adds up what landed above it. That extra is for goals, debt or a larger cushion, not for raising the lifestyle. Sample rows describe a sales rep with pay between $2,600 and $6,400; replace them with your own deposits. The tax line is an input to confirm with a tax professional.
Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.
Start on the Pay History tab: replace the sample rows with your own.
Keep the formula columns as they are; they fill in as you type.
Read the How to use tab for tips. For Excel, download the .xlsx file instead.
Base the plan on a low month, not the average, and treat anything above it as extra. This sheet averages your three lowest months into a floor.
One bad month can be a fluke. Three low months give a steadier floor that is still cautious. The formula needs at least three months of history.
No. Taxes is just a planned amount you choose, and a tax advisor can say how much to hold back.

Docs + Word6 pages
FeaturedFree
Excel
FeaturedFree
Sheets + Excel5 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel5 tabs
Free
Sheets + Excel6 tabs
FreeSheets + Excel6 tabs
Free
Sheets + Excel7 tabs
Free
Sheets + Excel7 tabs
Free
Sheets + Excel6 tabs
Free
Sheets + Excel6 tabs
FreeSheets + Excel5 tabs
Free
Sheets + Excel6 tabs
Free