Expense Tracker For Mac Free

Download our Expense Tracking Template for Microsoft® Excel® | Updated 10/8/2020

Are you trying to make a budget and need a simple way to track your expenses? Are you planning a remodeling project for your house? Do you need to track your small business expenses? Do you want a simple budget tracker to monitor the status of your project? You may not need costly expense tracking software to track your expenses. Try our free expense tracking template.

Some Uses for the Expense Tracking Sheet

8 Easy, Free Expense Tracking Templates for 2021. Here are the 8 best expense tracker templates to help you manage your money, optimize cash flow, and plan for the future - all with free, flexible spreadsheets. Weekly Calendar Template for Mac. Daily Planner Template for Mac. Timeline Template for Mac. Business Budget Template for Mac. Personal Budget Tracker Template for Mac. Balance Sheet Template for Mac. Monthly Budget Calculator Template for Mac. Invoice Template for Mac. Expense Report Template for Mac. Free customizable iWork budget templates for Mac Numbers and Pages including weekly, bi-weekly, monthly and yearly personal budget templates and planners, paycheck budgets, and more.

Tracking remodeling expenses. For example, a kitchen remodel project (see reference below).
Track improvement and maintenance costs on your house or properties.
Track your small business expenses, and stay within your budget.
Track project expenses for small to medium-scale projects that also require budget tracking.

Expense Tracking Template

for Excel and Google Sheets

Download

⤓ Excel (.xlsx)⤓ Google Sheets

License: Private Use (not for distribution or resale)

'No installation, no macros - just a simple spreadsheet' - by Jon Wittwer

Description

This spreadsheet is a simple expense tracker or budget tracker. It lets you record your expenses sort of like a checkbook register (by date, including a description, etc.), but has separate columns for different expense categories for recording and totaling your expenses.

In the budget tracking chart, the totals are compared to your budget so you can see the % Spent and your remaining budget.

Using the Expense Tracking Template

I have tried to set up the spreadsheet so that it is easy to insert or delete columns, depending on how many different expenses you want to track. Listed below are some of the features or details to note as you are using the expense tracking sheet or the budget tracking chart.

The labels for the expense categories (e.g. 'Category X') are just labels so go ahead and change them to be what you want.
Conditional Formatting is used to highlight every other row, to allow you to easily insert or delete rows and still maintain easy readability of the expense list.
When inserting new rows, insert the new rows above the last empty row in the table (not directly above the Total row). This will help make sure the Totals update correctly (you should probably check to make sure you don't mess up the formulas, though).
Two of the columns are hidden - to make it easy to insert new expense categories. When inserting a new category, insert the new column to the left of the Other column and then copy/paste formulas in the header and total rows.
In the latest version, I changed the date format to the default * format so that dates will display as d/m/yyyy or m/d/yyyy depending on your computer's locale settings.

Income / Savings Tracking