How to Create an Expense Report in Google Sheets

Manually tracking business expenses can feel like a chore, but a well-organized report is essential for budgeting, taxes, and getting reimbursed promptly. Fortunately, you don't need fancy, expensive software to get the job done. This guide will show you how to create a clean, functional, and automated expense report using nothing more than Google Sheets, covering both the quick template method and a build-from-scratch approach for full control.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Use Google Sheets for Expense Reports?

Before diving into the "how," it's worth understanding the "why." While dedicated accounting software has its place, Google Sheets offers a unique blend of simplicity, power, and accessibility that makes it perfect for many individuals, freelancers, and small teams.

• It’s Free: This is a big one. You get a powerful spreadsheet tool without any subscription fees.
• Cloud-Based and Collaborative: Your report is accessible from any device with an internet connection. Need your manager to approve it? Just share the link. No more emailing outdated versions back and forth.
• Completely Customizable: You are in complete control. You can add columns, create formulas, build summary dashboards, and tailor the report to your exact needs, job, or industry.
• Automations and Formulas: As you'll see, simple formulas can do all the heavy lifting for you, automatically calculating totals and summarizing your spending by category.

The Fast-Track: Using a Google Sheets Template

If you need an expense report right now and don't want to build it yourself, Google has a great pre-made template that works perfectly for most standard use cases.

Here’s how to find and use it:

Step 1: Open the Template Gallery From the Google Sheets homepage, look for the "Template gallery" at the top right of the screen. If you're already in a spreadsheet, you can get there by going to File > New > From template gallery.

Step 2: Select the "Expense Report" Template In the “Work” section of the gallery, you’ll find a template named "Expense report." Click on it to create a new spreadsheet based on this layout.

Step 3: Understand and Customize the Template The template is smartly designed with two main sections:

• The Summary: At the top, you have fields for your general information like company name, report purpose, and employee details. It also includes an auto-calculating summary that shows the total expense, any cash advances, and the final amount due.
• The Expense List: This is the main table where you’ll log each individual expense. It includes columns for Date, Account (Category), Description, and Amount. The cells in the "Amount" column are automatically added up in the summary section above.

Feel free to customize this template to your liking. You can easily add a "Payment Method" column if you track corporate vs. personal card payments, or change the currency format by selecting the Amount column and going to Format > Number > More Currencies.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

For Full Control: Build an Expense Report from Scratch

Building your own report is the best way to make sure it tracks exactly what you need in the way you need it. It also helps you understand how the spreadsheet works, giving you the confidence to tweak it later. Let’s build one together, step by step.

Step 1: Set Up Your Spreadsheet and Headers

First, open a new, blank Google Sheet. The foundation of any good expense report is a set of clear column headers. These are the categories you’ll use to organize each expense. Type the following headers into the first row (A1, B1, C1, and so on):

• Date: The date the expense occurred.
• Category: The type of expense (e.g., Meals, Travel, Software, Office Supplies).
• Description: A brief note about the expense (e.g., "Lunch with client Jane Doe" or "Monthly Adobe Subscription").
• Merchant: Where you made the purchase (e.g., "Starbucks," "Delta Airlines").
• Amount: The total cost of the item.
• Status: The reimbursement status (e.g., Pending, Approved, Reimbursed).
• Receipt: A link to a digital copy of the receipt.

Pro Tip: Make your headers stand out. Select the first row, make the text bold, and add a background color to make your report easier to read.

Step 2: Add Your Expense Data

Now, start filling in your expenses, with each charge getting its own row. To ensure our formulas work correctly later on, keep your data entry clean and consistent. For the 'Amount' column, just enter the numbers - don't add currency symbols yourself. We’ll style that in a moment.

To format the ‘Amount’ column as currency, click the column letter (E) to highlight the entire column, then go to Format > Number > Currency.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Making Data Entry Easier with Drop-Down Menus

Typing out categories like "Office Supplies" or statuses like "Pending" over and over is tedious and can lead to typos, which will break your summary reports. A better way is to use drop-down menus.

1. Click column letter B to highlight the entire "Category" column.
2. Go to the menu bar and click Data > Data validation.
3. In the sidebar that appears, under "Criteria," select "Dropdown."
4. Enter your expense categories, one by one. For example: "Travel," "Meals," "Software," and "Office Supplies."
5. Make sure "Show dropdown list in cell" is checked and click "Done."

Now, when you click on any cell in the Category column, a small arrow will appear, letting you select a category from the list. This keeps your data incredibly consistent. You can repeat this process for the "Status" column with options like "Pending," "Approved," and "Reimbursed."

Step 4: Calculating Totals with a Simple Formula

No report is complete without a total. Let’s add a running total that automatically updates every time you add a new expense.

In a clear spot, perhaps above your headers or in a top row, create a label like "Total Expenses:" Then, in the cell next to it, type the following formula:

=SUM(E2:E)

Let’s break that down:

• The = sign tells Google Sheets you’re entering a formula.
• SUM is a function that adds up a range of numbers.
• (E2:E) is the range of cells you want to add. This specific range is a neat trick: it tells Sheets to sum everything from cell E2 all the way to the very bottom of column E. This way, you don't have to update the formula as you add more rows.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 5: Summarizing Expenses by Category

Seeing your grand total is great, but knowing where your money is going is even better. We can create a small summary table that automatically calculates how much you've spent in each category using the powerful SUMIF function.

• First, create a summary area. Off to the side of your main grid (e.g., in column I), list your expense categories again: Travel, Meals, Software, and Office Supplies, each in its own row.
• Next, add the SUMIF formula. In the cell next to "Travel" (e.g., J1), enter this formula:

=SUMIF(B:B, I1, E:E)

Here’s what this formula is doing:

• SUMIF: This function adds up numbers only if a certain condition is met.
• B:B: This is the range to check your criteria against - our "Category" column.
• I1: This is the criterion. The formula looks for rows that match the value in cell I1 (which is "Travel").
• E:E: This is the sum_range - the column with the numbers to add up, our "Amount" column.

In plain English, the formula says: "Look at the entire 'Category' column (B:B), and if a cell matches the category in I1 ('Travel'), then add the corresponding amount from the 'Amount' column (E:E)."

You can drag the blue dot at the corner of this formula's cell down a few rows, and it will automatically adjust for your other categories, giving you a real-time spending breakdown.

Advanced Tips for a Polished Report

• Link Your Receipts: For easy reference, save your receipts to a folder in Google Drive. Then, get a shareable link for each receipt and insert it into the "Receipt" column by clicking Insert > Link. Now anyone viewing the report can quickly pull up proof of purchase.
• Visualize Your Spending: Highlight your category summary table, then go to Insert > Chart. Google Sheets will suggest a chart type, and a pie chart works great for this. Suddenly, your raw data becomes a powerful visual that shows where your budget is going at a glance.
• Sharing and Collaboration: To submit your report, go to the "Share" button at the top right. You can invite your manager via email and set their permissions to "Commenter" or "Editor" depending on what they need to do.

Final Thoughts

Creating an expense report in Google Sheets puts you in the driver’s seat. Whether you use a pre-built template for a quick start or build one from scratch, you have a flexible and powerful tool at your fingertips. By mastering simple features like drop-down lists and formulas like SUM and SUMIF, you can turn a tedious administrative task into an efficient, automated process.

Manually building reports like this is a great skill, but as your data grows, the process of exporting and wrangling information can start all over again. For those moments, we built Graphed, a platform that connects directly to your data sources—like QuickBooks, Stripe, or even a Google Sheet—and lets you build dashboards and get insights just by asking questions. Instead of manually pulling data, you can simply ask, "Show our team's expenses by category this quarter," and get an answer instantly, helping you focus on the insights instead of the process.