CDMX template
Example cases for renters and families with local transport and utilities considerations.
Budget tables and templates for Mexican households
Practical, editable spreadsheet templates to record rent, groceries, transport, cash and card payments, and irregular expenses. Templates include example entries and guidance for different household sizes across major cities in Mexico.
What the tables include
The tables are structured spreadsheets designed for everyday use by families and individuals in Mexico. Each template separates fixed and variable expenses, and includes categories for rent, utilities, groceries, transport, education, health, and occasional spending such as celebrations and repairs. Templates provide sample entries drawn from anonymized household cases to illustrate realistic amounts and recording practices. Columns include date, payment method (cash or card), category tags, amount, and notes to capture context. Built-in summary sections compute monthly totals, averages, and highlight irregular expense patterns so users can plan for periodic costs.
Files are provided in formats compatible with Excel and Google Sheets. Each template includes brief instructions and a suggested cadence for updates. The design aims for simplicity so that tracking becomes a short weekly task rather than an added burden. Templates are adaptable to different income levels and household sizes; guidance notes explain how to customize categories and set realistic targets for savings and contingency funds.
How to use the templates
Start by choosing a template that matches your household profile, for example single person, couple, or family with children. Open the spreadsheet and replace example income entries with your actual monthly income. Record fixed costs first: rent, utilities, subscription services. Then add variable costs such as groceries and transport as they occur. Use the payment method column to track cash versus card expenses and review the totals weekly to spot overspending categories. The summary section updates automatically to show month-to-date totals and a projection for the month based on current spending pace.
To manage irregular expenses, create a separate sheet within the file labeled "Irregular" and allocate a monthly provision based on past occurrences, for example medical costs or school supplies. Periodically compare actual irregular spending with the provision and adjust future allocations. The templates include example provision rates for different cities and household sizes to help calibrate expectations without overpromising savings.
Templates by city and common use cases
Templates include variants with example data for Mexico City (CDMX), Monterrey, and Guadalajara to reflect differences in rent and transport costs. Each city template contains sample household cases: a single renter, a couple sharing expenses, and a family with school-age children. Use these cases to compare your spending patterns and to test small adjustments, for example reallocating part of grocery spending to a weekly meal plan or increasing a contingency fund to cover irregular medical costs. City-specific notes explain common local expenses such as public transport passes or typical utility tariffs.
All templates are editable. They are intended as practical starting points rather than rigid prescriptions. The site encourages users to adapt categories, rename tags, and adjust provisioning rates to match personal circumstances. Guides and walkthroughs accompany the templates and show step-by-step how to convert a template into a working monthly tracker.
Monterrey template
Adjustments for common Monterrey costs and sample provisioning for irregular expenses.
Guadalajara template
Templates that reflect local price patterns and typical household spending in Guadalajara.
How to obtain the tables
Tables and templates are available for download on this site as editable files. Each download page includes a short guide and an explanation of the categories used. If you need help selecting a template, review the sample cases for each city and household type under Cases. The templates are distributed for educational use and intended to be adapted for personal budgeting.
By using the templates you accept the site terms and privacy practices. See the Privacy Policy and Terms pages in the footer for details.