Skip to content
The title slide and first slides of the Daily Spending Allowance Calculator template

Daily Spending Allowance Calculator

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
7
Style
Bold
Difficulty
Beginner
Updated
November 16, 2026

Every slide (7)

Overview

Overspending tends to start around mid-month, when the paycheck feels distant and the total feels large. This calculator turns the month into a daily number. You list money in, bills and the savings you will move, and the sheet divides what remains by the days in the month. That figure is what you can spend today without borrowing from the end of the month.

Purchases go on the Daily Log tab, one per row, each with a date. The Month View tab then lists every day with its allowance, what you spent and a running balance, and highlights days where the balance goes negative. KPIs show the daily allowance, the pool for the month and how many days ran over. Sample rows follow a $3,850 month with 15 days logged.

Useful for

  • Stop front-loading spending early in the month
  • Check each morning how much today allows
  • See how many days ran over the allowance

What's included

  • 4 tabs: Setup, Daily Log, Month View, How to use
  • Setup: a table
  • Daily Log: a table
  • Month View: a table with 5 summary figures
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Setup tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I calculate a daily spending allowance?

Subtract bills and savings from take-home pay and divide the remainder by how many days the month has. This sheet does the division for you.

What does the balance column show?

The allowance earned through that day minus everything logged through that day. A positive balance means you are under the allowance.

What if the month has 31 days?

Add a row with 31 in the Month View table. The allowance divides by the count of day rows, so it adjusts automatically.

  • #budget
  • #daily-spending-allowance-calculator
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More budget templates

See all 61

Also in Finance

All finance templates
Get this template

Preparing your template…