BookByte

AI for Accounting

ChatGPT for Google Sheets: build a monthly expense summary

Month-end comes around. You have a long list of transactions in a spreadsheet, and you still can’t say what you spent on what.

By: Computatio · Last reviewed 2026-11-17

Quick answer: as of November 17, 2026, ChatGPT works inside Google Sheets and Excel as an add-on. In Sheets, install the ChatGPT add-on from OpenAI, then choose Extensions > ChatGPT > Open and sign in with your OpenAI account. Ask it to build a summary tab that totals each category with formulas. OpenAI says both add-ons are generally available on all ChatGPT plans. Then check that the summary’s grand total equals the sum of your transaction list, to the cent.

Your transactions are in a sheet, but your totals aren’t

You exported the month from your bank or your bookkeeping app. Now you have 80 rows and no answer to simple questions. How much went to software? Did rent go up? What was profit?

A list of transactions is not a summary. Someone still has to group it.

And building formulas feels like a second job

You know a SUMIFS formula could do it. You just don’t remember the syntax, and the last time you tried, one wrong range broke the whole tab. So you copy numbers by hand, or skip the summary.

What a wrong summary costs you

  • Wrong numbers drive decisions. You cut the wrong cost, or price a job off a profit figure that was never real.
  • Tax-time cleanup. Sole proprietors report income and expenses on Schedule C, line by line. If your categories don’t map to those lines, someone sorts it all again in March.
  • Records still matter later. The IRS says to keep income tax records for 3 years in most cases, and 6 years if you leave out income worth more than 25% of the gross income on your return. A summary is only useful if it ties back to those records.

Picture this instead

On the first of the month you paste last month’s export into one tab. You open the ChatGPT sidebar and paste one prompt. A minute later there’s a summary tab with income, each expense category, and net profit, all as live formulas. You spend your time checking the numbers, not building them.

What is ChatGPT for Google Sheets and Excel?

OpenAI launched ChatGPT for Excel in beta on March 5, 2026, and added Google Sheets in April. On May 5, OpenAI said both were generally available on all plans. It runs in a sidebar next to your sheet. You ask in plain words, and it builds or updates formulas, tables and tabs.

Two details matter for your books. OpenAI says the Excel version links its answers to the cells it used and asks permission before it edits, so you can review and undo. The Sheets add-on, published by OpenAI on the Google Workspace Marketplace, asks to view and manage the spreadsheets you install it in. That is real access to your data, so choose what goes in the file.

The 4-step method for a monthly expense summary in Google Sheets

  1. Start from clean data. Use an export from your bookkeeping app or a reconciled bank download, one row per transaction, with Date, Description, Category and Amount columns. Income positive, expenses negative. If your categories are a mess, sort them with AI first.
  2. Strip what ChatGPT doesn’t need. Delete account numbers and client names. Use “Client A” instead. Our guide to keeping financial data safe with AI lists what to remove.
  3. Open the sidebar. In Sheets: Extensions > ChatGPT > Open. In Excel, open the ChatGPT add-in from your add-ins.
  4. Paste the prompt below. Approve each change only after you read what it plans to do.
Prompt to copy:
Using the Transactions tab, create a new tab called “October summary.” List every unique value in the Category column. Next to each, add a SUMIFS formula that totals the Amount column for that category and for dates in October 2026. Add rows for total income, total expenses and net profit. Use formulas only, no typed numbers. Then add a check cell that subtracts the sum of the whole Amount column for October from net profit, and tell me if it isn’t zero. Do not change the Transactions tab.
Example (made-up data). A one-person design studio has 11 October rows.
Income: Client A $2,400, Client B $1,850, Client C $900. Total $5,150.
Expenses: design software $59.99, bookkeeping app $30.00, printer paper $42.18, coworking desk $350.00, client lunch $86.40, freelance illustrator $600.00, internet $79.99, business insurance $48.00. Total $1,296.56.
First result: the summary shows expenses of $1,216.57, and the check cell shows $79.99.
What went wrong: the internet row was tagged “Utilities ” with a trailing space, so it became its own category and the formula skipped it. After fixing the label, expenses total $1,296.56 and net profit is $3,853.44. The check cell reads zero.

How to check a ChatGPT expense summary before you trust it

  1. Tie the grand total. Net profit on the summary must equal the sum of the month’s Amount column. A check cell of zero is the goal.
  2. Count the categories. Look for near-duplicates (“Software” and “software”, or a trailing space). Each one hides money.
  3. Recalculate one category by hand. Filter the Transactions tab to that category and compare the total.
  4. Click into the formulas. Confirm the date range covers the whole month, and that no cell holds a typed number.
  5. Compare with your books. The totals should match the same month’s profit and loss report. If they don’t, find the difference before you use either number.

Will this sort my expenses into Schedule C lines?

It can, if you tell it the mapping. The 2025 Schedule C instructions list lines such as contract labor (line 11), insurance other than health (line 15), office expense (line 18), supplies (line 22), deductible meals (line 24b) and utilities (line 25). Ask ChatGPT to add a “Schedule C line” column next to your category list, then review every row yourself.

Record the full amount in your books, even when the deduction is smaller. Business meals, for example, are generally 50% deductible on the return. The $86.40 lunch stays $86.40 in the books; the limit is applied at tax time.

What ChatGPT in your spreadsheet can’t do

OpenAI says complex formulas and edge cases may still need manual work, so verify results before you rely on them. It only sees what’s in the sheet. It can’t tell you a charge was personal, find a missing receipt, or reconcile your bank account for you. You’re still responsible for your return.

Not a formula person? You don’t have to be. Your job is to read the plan, approve it, and run the five checks. For more spreadsheet tasks, see AI for Excel and Google Sheets bookkeeping.

A summary is only as good as the transactions under it. Want those handled?

Short on time? Want the monthly summary done for you? At Computatio, AI does the first pass and an accountant reviews and reconciles every account each month, then you get a clear profit and loss. Monthly Books is $500 a month.
Free download: 47 write-offs for the self-employed, a 42-page guide with the IRS rules behind each deduction. Free when you join the Computatio newsletter.

Sources

This guide is general information, not financial, tax or legal advice for your situation. We work hard to get it right, but we can make mistakes, and rules change. Check the official sources above before you act.