Copilot Money Alternative: Build the Same Workflow in Google Sheets

Copilot Money is a good product. The iOS app is well-built, the AI categorization is among the better attempts in the category, and the charts render fast. If you’ve tried it and liked it, that’s a fair signal it fits your habits.

This post is for people who like the workflow but not the recurring cost, the Apple-only mobile footprint, or the idea of streaming bank credentials through a third party. The equivalent workflow exists in Google Sheets, and the rest of this post walks through how to build it.

What Copilot Money does well

Worth being clear about what you’d be replacing.

Daily balance view. Today’s cash, today’s spending, the month’s running total. Data freshness is the headline.

AI categorization. New transactions get a category automatically, learning from your past corrections. After a month of training, accuracy is high for most users.

Net-worth snapshot. One screen: cash, investments, real estate, liabilities. Live valuations for stocks; Zillow-style estimates for property.

Cash-flow trend. A 12-month strip showing income vs spending. Useful for seeing whether the last quarter was tighter than the one before.

Subscription detection. Flags recurring charges, including the ones you forgot. The one feature most former users miss out loud.

These are all reproducible in Sheets. Two of them (daily auto-sync and Zillow-style valuation) need a workaround rather than a direct equivalent.

What $95 a year buys

Copilot Money is $95/year on the annual plan, or roughly $13/month if billed monthly. The annual is the typical purchase, so call it about $95 a year.

Over time, the math:

A Copilot user on the monthly plan is heading toward roughly $4,700 over a 30-year horizon. The annual plan trims about $60/year off that, which adds up.

Whether $95/year is fair value depends on how often the app gets used. For software opened daily, the per-day cost is small. For software checked once a month, the math shifts, and some users find that a 15-minute weekly habit in a spreadsheet covers the same ground.

The Sheets workflow at a glance

Three tabs cover most of what Copilot does.

1. Transactions. One row per transaction. Date, payee, category, amount, account, notes.
2. Category Spending. A pivot or SUMIFS-based summary. Monthly totals per category, plan vs actual.
3. Net Worth. Account balances entered manually or pasted from statements. Assets minus liabilities, with a monthly snapshot row.

A fourth optional tab, Subscriptions, catches the recurring-charge use case (covered below).

Setup takes about 90 minutes if you build from scratch, or 5 minutes if you start from a pre-built template. Ongoing maintenance is 10 to 15 minutes a week, which is roughly the time most Copilot users spend reviewing and correcting categorizations anyway.

Tab 1: Transactions

A few mechanics worth knowing.

Negative for outflows. Keep amounts signed (negative for spending, positive for income). It makes every downstream formula simpler.

One Account column. If you track multiple cards and a checking account, this is how the Net Worth tab knows where balances should land.

Paste from CSV weekly. Most major banks let you export a date-range CSV in under a minute. A weekly paste covers the manual-entry burden without daily friction. If you want that paste to feel closer to an automated feed, the Tiller alternative walkthrough covers the same CSV-into-Sheets loop in more depth.

You can also enter rows on your phone. Google Sheets on iOS and Android is functional but generic, and pretending it matches Copilot’s tap-to-categorize UX would be dishonest.

Tab 2: Category Spending without AI

The trick that closes most of the gap with Copilot’s AI: a small lookup table.

Build a Rules sheet with two columns.

In the Transactions tab, the Category column becomes a formula instead of free text:

=IF(B2="", "",
  IFERROR(
    INDEX(Rules!$B$2:$B$50,
          MATCH(1,
                ARRAYFORMULA(ISNUMBER(SEARCH(Rules!$A$2:$A$50, B2))
                             * (Rules!$A$2:$A$50 <> "")),
                0)),
    "Uncategorized"))

B2 is the payee. SEARCH returns a number when a rule string appears in the payee and an error otherwise, ISNUMBER turns that into TRUE or FALSE, and the * (Rules!$A$2:$A$50 <> "") factor is doing quiet but essential work: SEARCH treats an empty rule cell as a match for everything, so without that guard the blank rows below your rules list would “match” every payee and unmatched transactions would come back blank instead of “Uncategorized”. Bounded ranges (rows 2 to 50) rather than whole columns keep that guard honest, so extend both if the rules list grows past 50. Anything that matches nothing lands in “Uncategorized” for you to look at on Friday.

To auto-categorize new pasted rows without dragging the formula down, wrap the same lookup in BYROW at the top of the column. MATCH will not iterate row by row inside a plain ARRAYFORMULA, so BYROW with a LAMBDA is what makes the column self-maintaining:

=BYROW(B2:B, LAMBDA(payee,
  IF(payee="", "",
    IFERROR(
      INDEX(Rules!$B$2:$B$50,
            MATCH(1,
                  ARRAYFORMULA(ISNUMBER(SEARCH(Rules!$A$2:$A$50, payee))
                               * (Rules!$A$2:$A$50 <> "")),
                  0)),
      "Uncategorized"))))

It’s not AI. It’s pattern matching with a small list you grow over time. After a few weeks of corrections, most rules tables cover the majority of recurring transactions. Unlike AI categorization, every decision is auditable, so you can always see the rule that fired.

The Monthly Budget Template (Premium tier) rolls the categorized rows into an actual-vs-planned view per category, with a subscriptions count on the same screen, which is the pre-built version of this tab.

Tab 3: Net Worth in Sheets

Copilot’s Net Worth screen is one of its better features. The Sheets version is more manual but more transparent.

A second tab, Net Worth History, stores one row per month with the totals frozen. That’s how you build the trend chart. It’s a single cell-copy at month-end - the kind of thing you do while waiting for coffee.

The Net Worth Tracker is this structure pre-built, with a history sheet, depreciation handling for vehicles, and a dashboard. $29 once.

The Net Worth Tracker (Premium tier) dashboard: the same assets-minus-liabilities snapshot Copilot shows, plus the month-over-month trend from the history sheet.

The subscription tab

Copilot’s subscription detection is a quietly useful feature. The Sheets version is a tab with Service, Amount, Frequency, Next charge, Last reviewed, Cancel link. Populate it once by scanning two months of statements. After that, it runs itself - recurring charges, by definition, don’t change month to month.

Worth knowing that Copilot’s value here is mostly in the initial discovery, not in ongoing maintenance.

The one feature Sheets cannot replicate

Copilot has daily, automatic transaction sync. Sheets does not. You can paste a weekly CSV, but you cannot have a phone notification at 8:47 pm that says “Uber $24.10 categorized as Transportation.”

Two ways to think about whether that matters.

It matters if you check daily. Some people genuinely review their finances every day, often for a few minutes after dinner. Daily sync is the right tool for them. The spreadsheet, with a weekly rhythm, will feel slow.

It matters less than people expect. Many people open finance apps two or three times a week, often skipping a week here and there. At that frequency, the difference between auto-sync and a weekly CSV paste is small. A weekly review may even land harder, because a batch of transactions invites reflection in a way a single push notification doesn’t.

Neither framing is wrong. They describe different users.

Setup time and ongoing cost

Setup from scratch. About 90 minutes. Build the three tabs, write the formulas, paste 60 to 90 days of historical CSV, run the categorization pass. Most of the time is in the historical clean-up, not in the formulas.

Setup from a template. About 5 to 15 minutes. Copy to your Drive, paste historical transactions, set your account list. The Monthly Budget Template handles categorization and reporting; the Net Worth Tracker handles balances.

Ongoing weekly. 10 to 15 minutes. Friday or Sunday tends to stick; other days drift. Export CSV, paste, review Uncategorized rows, add a rule if a new merchant appeared.

Ongoing monthly. 5 minutes. Snapshot the Net Worth Total into the History sheet. Glance at the cash-flow chart.

Total: about 50 minutes a month, or roughly the same as actively using Copilot if you review its categorizations.

Migrating from Copilot

If you’ve been on Copilot and want to try the spreadsheet workflow without losing your data, the path is short.

1. In Copilot, export transactions as CSV. The app supports a CSV export of all transactions or a date-range subset.
2. Open the Monthly Budget Template (or a blank Sheet with the structure above).
3. Paste the CSV into the Transactions tab. Column order may need a one-time rearrangement.
4. Run a categorization pass. Most categories will map cleanly; a handful (Copilot’s “Other” or its custom categories) will need light remapping into the template’s category list.
5. Snapshot your current balances into the Net Worth tab.
6. Run both tools in parallel for one month. At month-end, compare what each captured and decide whether to keep Copilot, the Sheet, or both.

Most people who do this find the transition takes a weekend afternoon. The friction is the habit change, not the tool change.

Comparison: Copilot vs Sheets vs FinancialAha template

The pattern: Copilot wins on automation and polish; Sheets wins on cost, ownership, and flexibility. The FinancialAha templates sit between - structure built, you bring the data.

When Copilot still wins

Five profiles where switching is the losing trade.

iPhone-first users who check daily. If you open finance apps the way other people check the weather, the polish gap between Copilot and a spreadsheet is the whole story.

Households with 5+ accounts and 200+ monthly transactions. Manual entry at that volume is genuine work. Auto-sync is what you’d be paying for.

Users who want passive review. Some people want their finances mostly out of mind, with a weekly notification rather than an active habit. Copilot’s notifications-and-categorize model fits that. Sheets doesn’t.

Users who value the live investment view. Copilot’s portfolio screen with live position values is smoother than GOOGLEFINANCE in a sheet.

Users on the annual plan who use it daily. At $95/year for daily use, per-day cost is about 26 cents. That’s the cost-per-glance math you’d be giving up.

If two or more of these fit, the spreadsheet probably costs less and delivers less.

When the spreadsheet wins

Android users. Copilot is Apple-only on mobile. A spreadsheet is the more honest answer.

Non-US bank users. Copilot’s account coverage is largely US-focused. Sheets is currency-agnostic.

Users uncomfortable with bank aggregators. Both Copilot and most alternatives use Plaid-style sync. If that’s a no for you, manual entry is the only path.

Users who want portable data. A Google Sheet is yours, exports cleanly, and lives in your Drive indefinitely. App data lives where the app lives.

Users who want categorization they can audit. A rules table is readable; AI categorization mostly is not.

Users who want a one-time cost. $29 once is less than one year of Copilot.

Templates that fit this

Three options framed by what you’re trying to do.

• “I just want to see where my money goes each month.” Monthly Budget Template at $29 once. Covers transactions, categories, planned vs actual, monthly dashboard. Most of Copilot’s daily-balance and category-spending value, rebuilt.
• “I want to track net worth and account balances over time.” Net Worth Tracker at $29 once. Cash, investments, retirement, real estate, vehicles, liabilities, with a monthly history sheet and dashboard.
• “I want both, and I want them to share categories.” Buy both. They use the same category list and link cleanly, which is something Copilot does inside one app and we do across two files that you own.

All three work the same way: copy to your Drive, paste data, no setup beyond your preferences. One-time purchase, no subscription, no aggregator.

Related

• Tiller Alternative: Google Sheets Budgeting Without the Subscription
• YNAB Alternative in Google Sheets: The Method, Mapped Cell by Cell
• Aspire Budgeting Alternative: Maintained Templates with Real Updates
• Lunch Money Alternative: Self-Hosted Spreadsheet Workflow - another app rebuilt as a sheet you keep
• Rocket Money Alternative: Subscription + Budget in a Spreadsheet - the subscription-audit workflow without the app