Skip to content
The title slide and first slides of the Bills to Income Ratio Calculator template

Bills to Income Ratio Calculator

Spreadsheet template for Google Sheets and Excel

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

Every slide (6)

Overview

A bill can feel small until you compare it with income. This calculator divides each bill by your monthly income and shows the share beside it, with a colour scale that darkens as the share grows. The Ratios tab groups the bills by category, such as housing, transport and debt, and compares each group with a limit you type in yourself.

Categories over their limit are marked and highlighted, and the Summary counts them and charts every share against its limit. Sample rows describe a household earning $5,400 a month where rent alone is above a thirty percent limit. The limits are inputs, not rules, so change them to match what your household can carry. Use gross or take-home pay for every row, not a mix.

Useful for

  • Check whether rent is too large a share of pay
  • Compare debt payments with income before taking another loan
  • See which bill category pushes the total ratio up

What's included

  • 5 tabs: Summary, Income, Bills, Ratios, How to use
  • Summary: a dashboard with 6 summary figures
  • Income: a table
  • Bills: a table
  • Ratios: a table with 1 summary figures
  • 1 chart that update as you type
  • 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 Income 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 bills to income ratio?

Add your monthly bills and divide by monthly income. This sheet does it for the whole set and for each bill and category.

What is a good bills to income ratio?

There is no single answer. Lenders and counselors use different measures, so the Ratios tab lets you pick your own limit for each category.

Gross or net income for the ratio?

Either works if every row uses the same basis. Net pay reflects what you can spend, while gross pay matches how some lenders measure ratios.

  • #budget
  • #bills-to-income-ratio-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…