Monthly spend against budget

Budgets only help if someone checks them. On the 1st of each month this totals last month's spending in your Expenses tab by category, compares each with its monthly budget on the Budget tab and emails finance the categories that went over.

Nothing is sent when every category stayed within budget.

Run every month on day 1 at 08:00.Run every month on day 1 at 08:00.

Spending sheetSet budgetSheet to blank.

Finance team's emailSet financeEmail to blank.

Last month's expensesRead the rows of budgetSheet. Save it as expenses.Google Sheets

Spend by categoryGroup the items in expenses.rows by Category, with the total Amount of each and save it as spend_by_category.

Monthly budgetsRead the rows of budgetSheet. Save it as budgets.Google Sheets

Spend next to budgetMatch spend_by_category with budgets.rows by Category and save it as compared.

Categories over budgetKeep each item in compared where item.total is greater than item["Monthly budget"] and save it as over_budget.

If over_budget isn't emptyIf over_budget isn't empty

Yes

Table of categories over budgetMake a table of over_budget Save it as table.

Email financeSend an email to financeEmail. Save it as sent. Subject: Categories over budget last monthtable.htmlGmail

No

No steps