Online Expense Tracking Spreadsheet: How to Set It Up

How-to basics · Updated November 21, 2026

An online expense tracking spreadsheet is a shared workbook that records purchases, organizes them by category, and totals spending over time. In Excel for Microsoft 365, create it in Excel for the web or save an Excel workbook to OneDrive, then enter transactions in a table and use formulas to summarize them.

What an online expense spreadsheet does

At its simplest, the spreadsheet is a running record of money spent. Each row represents one transaction, and columns hold information such as the date, merchant, category, amount, and payment method. A summary can add up expenses by month or category, helping you see where money went without manually adding every receipt.

Online access adds convenience rather than automatic financial tracking. You can open a workbook in a browser, update it from different devices, and share it with people you choose. Unless you connect a separate, supported financial service or import transactions yourself, the spreadsheet will not automatically know about card purchases or bank activity. Manual entry or an import is still required.

A spreadsheet is useful for household spending, shared trip costs, or small-business expense records. It can also be adapted to track reimbursements. It is not, by itself, a bank statement, accounting system, or guarantee that a transaction is tax-deductible.

Set up the workbook in Excel

For a browser-based workbook, sign in to Microsoft 365, open Excel, and create a blank workbook. Save it in OneDrive so it is available online and can be shared. You can also create a workbook in Excel for Microsoft 365 on Windows and save it to OneDrive. The Excel for the web interface may arrange some commands differently, but the basic table and formula approach is the same.

  1. In row 1, add column headings: Date, Merchant, Category, Description, Payment method, Amount, and Month.
  2. Select the heading row and several empty rows below it, then choose Insert > Table. Confirm that the table has headers.
  3. Give the table a clear name, such as Expenses, using the Table Design tab’s Table Name box in desktop Excel. A descriptive name makes formulas easier to read.
  4. Enter one transaction per row. Use actual date values in Date and numeric values in Amount, rather than typing a currency symbol into the amount itself.
  5. Format the Date column as a date and Amount as currency or a suitable number format. Formatting changes how values appear; it does not change the underlying transaction.

For example, a row could record October 3, 2026; a grocery store; Groceries; weekly food shop; debit card; 42.60; and 2026-10. A separate grocery purchase belongs on another row, even if it happened at the same merchant. Keeping individual transactions lets you check entries against receipts and statements later.

Choose useful columns and categories

Start with the information you will actually use. Date, merchant, category, and amount are enough for a basic personal tracker. Description can explain an unusual purchase, while Payment method can help you compare the spreadsheet with a card or account statement. For work-related records, a Reimbursable? field and a Reimbursement status field may be helpful. Avoid collecting sensitive details such as full card numbers; they are not needed to total expenses.

Categories should be consistent and broad enough to remain manageable. A household might use housing, groceries, utilities, transport, health, dining, and entertainment. A small organization may need categories that match its internal reporting, but should agree on those labels before several people enter data. Otherwise, the same type of purchase may appear under slightly different names, such as Dining, Restaurants, and Meals, splitting the total across categories.

In Excel, a dropdown list can reduce spelling differences. Put the approved category names in a separate range, select the cells where categories will be entered, and use Data > Data Validation to define a list. The precise controls can differ in Excel for the web. A dropdown helps standardize entries, but someone still needs to maintain the approved list as needs change.

Use formulas to summarize spending

Excel Tables expand as you add rows, which helps keep the transaction log organized. The following examples assume the table is named Expenses and has columns named Amount, Category, and Month. In the sample data, the four October transactions are 42.60 and 83.15 for Groceries, 24.00 for Transport, and 60.70 for Utilities.

With transaction dates in column A and the Month helper column in G, enter this in G2 and let the table fill the formula down: =TEXT(A2,"yyyy-mm"). For a date of October 3, 2026, the displayed result is 2026-10. This helper makes it straightforward to group entries by month. Make sure the date in A2 is a real Excel date, not text that only looks like a date.

With the four example transactions in the Amount column of the Expenses table, use this formula in a summary cell to calculate all recorded expenses: =SUM(Expenses[Amount]). It returns 210.45, because 42.60 + 83.15 + 24.00 + 60.70 = 210.45. The table reference includes new entries added to the table.

With the same table layout, use this formula to total rows whose Category is Groceries: =SUMIFS(Expenses[Amount],Expenses[Category],"Groceries"). It returns 125.75, the sum of 42.60 and 83.15. With Month values such as 2026-10 in the table, this formula totals October: =SUMIFS(Expenses[Amount],Expenses[Month],"2026-10"). For the four sample rows, it returns 210.45.

Place summary totals in a clearly labeled area or on a separate Summary sheet. For a small tracker, a few category totals and a monthly total may be enough. More elaborate dashboards can be useful, but they also require more upkeep. Check formula ranges and sample results whenever you change column names or reorganize the workbook.

Build a routine for entering expenses

A tracker is only as complete as its entries. Choose a regular time to update it, such as after checking transactions every few days or once a week. Record the purchase date rather than the date you happened to enter it. If a receipt is not available, add a short note so you can identify the transaction when reviewing it.

Reconcile the log against account or card activity periodically. Look for missing purchases, duplicated imports, incorrect amounts, and refunds. Record a refund as a separate negative amount or use a clearly defined refund method, and use that same method consistently. If you use negative amounts, check that your totals and summaries treat them as reductions in spending.

For shared costs, agree in advance on who enters each transaction and whether the amount represents the full purchase or only one person’s share. For example, if one person pays 90 for a group meal and the tracker is meant to show actual card activity, record 90 once. If it is meant to track each person’s share, document the allocation instead. Mixing these two purposes can make totals misleading.

Share and protect the online workbook

Excel for the web supports working with files stored in OneDrive or SharePoint, and Microsoft 365 can allow collaborators to edit a shared workbook. Use the workbook’s Share controls to invite specific people or create a link with appropriate permissions. Choose view-only access when a person only needs to inspect totals; grant editing access only to people responsible for entering or maintaining data. Interface wording and available sharing options can depend on the account and organization.

Sharing is convenient, but an expense log can reveal shopping habits, travel, health-related purchases, or work activity. Share only the information necessary for the task. Protect the Microsoft account with a strong, unique password and multifactor authentication where available, and review who still has access when a project or household arrangement changes. Do not put bank credentials, full payment card numbers, or identity documents in the workbook.

For records that matter, keep a sensible backup or retain original receipts and statements according to your needs. OneDrive file history and recovery options can help with accidental edits, but they are not a substitute for checking that the correct file is being edited or keeping records required by an employer or organization. Avoid treating a shared spreadsheet as the sole formal record if a specific policy requires another system.

Spreadsheet versus expense-tracking apps

A spreadsheet offers flexible columns, visible calculations, and control over how categories and summaries work. It can be a low-cost choice if you already have access to Microsoft 365, and it is easy to adapt for an unusual tracking need. Its main trade-off is manual administration: users must enter or import activity, maintain formulas, and resolve inconsistent data.

Dedicated expense apps may offer bank connections, receipt capture, automatic categorization, or reimbursement workflows, depending on the provider and plan. Those features can save time, but availability, fees, privacy practices, and supported financial institutions vary. Automated categorization can also be wrong, so imported records still need review. Before connecting an account, read the service’s permissions and data-handling terms.

Google Sheets is another browser-based spreadsheet option, while accounting software may be more appropriate for formal business bookkeeping. The right choice depends on whether flexibility, automatic imports, collaboration controls, or accounting features matter most. A spreadsheet can complement another system, but duplicate records should be reconciled rather than assumed to match automatically.

Costs and practical limits

The cost of using Excel online depends on the Microsoft account, license, storage, and organizational setup available to you. Some people can use Excel for the web with a personal Microsoft account, while Microsoft 365 subscriptions and work or school accounts have different entitlements. Check Microsoft’s current plan details for the account you intend to use rather than assuming every feature or amount of storage is free.

A basic tracker does not need paid add-ins, macros, or a complicated dashboard. Keep the workbook small and understandable: clear labels, consistent categories, and a summary you can verify are more valuable than visual effects. If several people need controlled access, automated approvals, or detailed audit processes, compare the spreadsheet’s limits with a purpose-built service before relying on it.

Common problems and how to prevent them

  • Totals do not match: Check for omitted rows, text values in the Amount column, duplicate transactions, and filters that hide records. Confirm that the formula refers to the intended table or range.
  • Dates group incorrectly: Text dates may not behave like date values. Enter valid dates and use a consistent Month helper or date-based summary.
  • Categories multiply: Standardize spelling with a dropdown list and periodically review uncategorized or inconsistent entries.
  • Several people overwrite or duplicate entries: Agree on responsibilities, use one shared workbook, and communicate before replacing or importing a batch of data.
  • The sheet becomes too complicated: Remove unused fields and summaries. If you need formal approvals, accounting reports, or reliable automated imports, evaluate a system designed for those tasks.

A related misconception is that a spreadsheet automatically tracks spending just because it is online. Online describes where the file can be accessed and collaborated on; it does not inherently connect the workbook to a bank or card. Another is that a category total proves an expense is eligible for reimbursement or a tax treatment. The workbook can organize records, but rules depend on the relevant employer, institution, or jurisdiction.

Frequently Asked Questions

Can I track expenses online for free?
Possibly. Excel for the web may be available with a personal Microsoft account, but storage, features, and account terms can change. Check the current Microsoft offering for your account before choosing it as a long-term recordkeeping method.

Will an online Excel spreadsheet import bank transactions automatically?
Not by default. You can enter transactions yourself or import a file from a financial institution when the file format and workbook support it. Any imported data should be checked for duplicates, missing rows, and incorrect categories.

Can more than one person edit the same expense tracker?
Yes, when the workbook is stored in a supported OneDrive or SharePoint location and shared with suitable permissions. Give editing access only to people who need to change entries, and agree on how to avoid duplicate records.

What is the simplest way to total expenses by month?
Add a Month column derived from each transaction date, then use a summary formula such as SUMIFS against that column. Keep the month format consistent and verify the result against a small set of known transactions.

Is a spreadsheet suitable for business expenses or taxes?
It can help organize transaction details and receipts, but suitability depends on the business’s recordkeeping policies and applicable requirements. Do not treat a spreadsheet category as proof of eligibility; check with the relevant organization or a qualified tax professional.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.