Free Google Sheets Expense Tracker by Smarfle
A comprehensive expense tracker designed for small service businesses, featuring tabs for Expenses, Clients, and Jobs. Users can log expenses with details such as date, vendor, amount, category, and payment method. The dashboard provides a monthly spending overview, including totals for each category and alerts for missing receipts or potential duplicates. This template allows for easy tracking of costs associated with specific jobs and clients, ensuring accurate financial management.
Content article
Free Google Sheets Expense Tracker by Smarfle provides a comprehensive tool for service businesses to manage and log their expenses effectively.
In the "Start Here" tab, users are guided through the initial setup, which includes making a personal copy of the spreadsheet, clearing sample data, and configuring settings for categories, payment methods, and employees. This tracker is designed for small service businesses, enabling them to monitor expenditures related to specific jobs and clients. It emphasizes the importance of accurately recording expenses, such as noting that a cleaning crew can track consumables or an HVAC contractor can log parts bought for repairs.
The "Dashboard" tab presents an overview of spending, with the reporting month set to November 2026. The total spending for that month is reported at $283.50, while the year-to-date spending is $372.50. The dashboard also highlights that there is $106.50 owed across all dates, with an action list indicating two missing receipt rows and two possible duplicates. The monthly spending breakdown shows that in November 2026, office expenses amounted to $283.50, while in October 2026, vehicle repairs cost $89.00, and supplies accounted for $190.50 in April 2026.
Moving to the "Expenses" tab, the expense log details individual transactions. For instance, on November 1, 2026, a filter and gasket were purchased from Bay Parts for $106.50 using a personal card, which included $6.50 in tax. This expense is marked as reimbursable and is linked to Job ID J001. On November 2, 2026, a fuel expense of $75.00 was recorded from East Fuel, paid with a company card, while two entries from Fresh Supply on November 3, 2026, each for $42.00, are flagged as possible duplicates. Additionally, an office expense of $18.00 was logged on November 4, 2026, which has already been reimbursed.
The "Clients" tab lists two clients: Cedar Court, with a total cost of $124.50, and Seabrook Studio, which has incurred costs of $84.00. These totals reflect both direct client purchases and expenses associated with linked jobs.
In the "Jobs" tab, the job costs are associated with specific clients. Job ID J001, for a heat pump service linked to Cedar Court, has incurred expenses totaling $106.50. Meanwhile, Job ID J002, related to a move-out clean for Seabrook Studio, has a total cost of $84.00.
Lastly, the "Settings" tab allows users to customize their reporting settings. The report month is set to Fuel, with a receipt threshold established at $75.00. Categories include vehicle repairs, tools, supplies, subcontractors, insurance, licenses, software, advertising, meals, office, and other expenses. Payment methods listed are company card, personal card, cash, bank transfer, and check, while employees include Jordan Lane and Casey West.
This structured approach to expense tracking not only helps businesses maintain accurate financial records but also facilitates reimbursements and budget management through detailed reporting and analysis.