Setup Guide + FAQ

Step-by-step instructions, video tutorials, and answers to common questions for every Enhance Finance product.

Back to Home

You'll Be Up and Running in Minutes

Every Enhance Finance product is designed for zero setup friction. Pick your product below for the full step-by-step walkthrough — from opening your sheet to seeing your first dashboard.

Choose Your Product

Pro & Pro AI Enhance Finance Pro

Want the quickest way forward? Just watch the video 👇

Full Setup Walkthrough — Enhance Finance Pro

From purchase to dashboard in under 60 seconds

1:00
Setup
1

Make a Copy of Your Google Sheet

After purchasing on Etsy, you'll receive a PDF with a link to your Google Sheet. Click the link — it will open a Make a Copy dialog. Save it to your Google Drive. This copy is yours forever.

💡 Don't see the email? Check your spam folder or visit your Etsy purchases page directly.

2

Install the Enhance Finance Add-On

All features run through the ✦ Enhance Finance menu in Google Sheets. To get it, install the Enhance Finance Google Workspace add-on. [Install Add-On — link coming soon]

💡 After installing, refresh your sheet. The ✦ Enhance Finance menu will appear in the menu bar next to File, Edit, View, etc. It may take a few seconds to load.

3

Give Google Permission

The first time you use the add-on, Google will ask you to authorize the script. Click Continue, select your Google account, then Allow. This only happens once.

4

Activate Your AI Key Pro AI only

After purchase, you'll receive a license key to activate AI features. In your Google Sheet, go to ✦ Enhance Finance → 🪪 AI License → 🔑 Enter License Key in the menu bar. Paste your key and click OK. A disclosure dialog will appear — read through it and accept. This is a one-time step.

💡 Check the PDF from Etsy or your confirmation email for your unique key. If you purchased the standard Pro version, skip this step — you don't need a license key.

You're all set — here's how to use it
5

Download Your Bank Statement

Log into your bank's website and download your transactions as a .csv or .xls file. Most banks have this under "Account Activity," "Statements," or "Transaction History." Works with TD, RBC, Scotiabank, BMO, CIBC, Chase, Bank of America, Wells Fargo, Capital One, and many more — any bank that exports to a spreadsheet file. PDF statements may require manual entry.

💡 Not sure how? Search "[your bank name] download CSV" — most banks have a guide for this.

6

Paste Your Data into the Input Statements Tab

Open your downloaded bank file, select all the data (Ctrl+A / Cmd+A), and copy it. Then go to the Input Statements tab in your sheet and paste it into the white area below the header. Cell B18 is the target, but anywhere in the white section works.

⚠️ Make sure you paste into the Input Statements tab — not the Transactions tab. The white area is where your data goes. Anything outside it won't be processed.

7

Process Your Transactions

Go to ✦ Enhance Finance → 📥 Process Transactions in the menu bar. The sheet reads your data, organizes it, and sends it to the Transactions tab — cleaned up and ready for sorting.

8

Sort Your Transactions

Pro AI: Go to ✦ Enhance Finance → 🤖 AI Features → 🔮 AI Sorting. Claude AI analyzes every transaction, identifies the real merchant name behind vague bank codes (like "SBUCKS 220930" → Starbucks), and assigns the correct category from 70+ options. Hundreds of transactions sorted in seconds.

Pro: On the Transactions tab, you'll see your bank's raw descriptions. For each transaction, type the real merchant name and assign a category from 70+ options. Once you've categorized a merchant, the sheet remembers it forever. Next time you import, use ✦ Enhance Finance → ⚡ Auto Categorize to sort any previously seen merchants automatically.

9

Log Your Transactions

Once you've reviewed and categorized everything, go to ✦ Enhance Finance → 📒 Log Transactions. This locks in your sorted data and updates all your dashboards.

10

Explore Your Dashboards

Your Monthly Dashboard, Annual Dashboard, and Merchant Insights are now fully populated. Browse category breakdowns, spending trends, and per-merchant analytics. Head to the Budget tab to set income, expense, spending, and savings goals for each month.

💡 Pro AI users: You can also use ✦ Enhance Finance → 🤖 AI Features to get AI-powered dashboard insights, merchant insights, and budget analysis.

Budget & Budget AI Enhance Finance Budget

Want the quickest way forward? Just watch the video 👇

Full Setup Walkthrough — Enhance Finance Budget

Budget planning guide

0:20
Setup
1

Make a Copy of Your Google Sheet

After purchasing on Etsy, you'll receive a PDF with a link to your Google Sheet. Click the link — it will open a Make a Copy dialog. Save it to your Google Drive.

2

Install the Enhance Finance Add-On

All features run through the ✦ Enhance Finance menu in Google Sheets. To get it, install the Enhance Finance Google Workspace add-on. [Install Add-On — link coming soon]

💡 After installing, refresh your sheet. The ✦ Enhance Finance menu will appear in the menu bar next to File, Edit, View, etc.

3

Give Google Permission

The first time you use the add-on, Google will ask you to authorize the script. Click Continue, select your Google account, then Allow. This only happens once.

4

Activate Your AI Key Budget AI only

Go to ✦ Enhance Finance → 🪪 AI License → 🔑 Enter License Key and paste your key. Accept the AI disclosure dialog. If you purchased the standard Budget version, skip this step.

You're all set — here's how to use it
5

Fill Out Your Budget

Everything lives in one tab — the Budget tab. Enter your income, expenses, spending, and savings for each month. The sheet projects your full year automatically so you can see exactly where you'll land financially.

💡 Every category falls into one of three types: Expenses (bills, rent, insurance — things you must pay), Spending (discretionary purchases — restaurants, clothes, entertainment), and Savings (money set aside for the future). When in doubt, ask: "Could I survive without this?" If yes, it's probably spending.

6

Use AI Budget Insights Budget AI only

Go to ✦ Enhance Finance → 📈 AI Budget Insights to get an AI-powered analysis of your budget. The AI highlights spending patterns and budget health — helping you spot trends and understand where your money is going.

✨ Powered by AI

Categorization
Best Practices

Enhance Finance comes pre-loaded with 70+ categories designed to cover the vast majority of everyday transactions. But your finances are unique — here's how to make the system work exactly the way you want.

Rename Categories to Match Your Life

The pre-loaded categories are starting points, not rules. If "Streaming Services" should be "Subscriptions" in your world, rename it. If you want "Dog Expenses" instead of "Pet Care," go for it. The sheet doesn't care what you call them — only that they're consistent.

Add Your Own Categories

Need a category that doesn't exist? Add it directly to the category list in the Categories column. Once added, it will appear in dropdowns across the entire sheet and all dashboards will include it automatically.

Keep It Broad Enough to Be Useful

A common mistake is creating too many hyper-specific categories. "Starbucks" and "Tim Hortons" don't need their own categories — that's what the Merchant Insights dashboard is for. Keep categories at the level of "Coffee & Snacks" and let the merchant view handle the rest.

Use the 3-Type System

Every category falls into one of three types: Expenses (bills, rent, insurance — things you must pay), Spending (discretionary purchases — restaurants, clothes, entertainment), and Savings (money set aside for the future). When in doubt about where a category belongs, ask: "Could I survive without this?" If yes, it's probably spending.

Don't Delete Pre-Loaded Categories

Even if you don't use a category right now, it's better to leave it in place. Removing categories can break dropdown references. If a category doesn't apply to you, just ignore it — it won't affect your dashboards unless transactions are assigned to it.

The ✦ Enhance Finance
Custom Menu

When you open your sheet, a custom ✦ Enhance Finance menu appears in the Google Sheets toolbar next to File, Edit, View, etc. This requires the Enhance Finance add-on to be installed. It may take a few seconds to load the first time. Here's everything inside it.

Not all menu items appear in every product. The menu adapts based on which version you purchased — Budget, Budget AI, Pro, or Pro AI.

📥

Core Workflow — Process, Auto Categorize, Log

These three functions are the heart of the Pro products. Process Transactions reads your pasted bank data and organizes it. Auto Categorize applies your saved rules to sort any previously seen merchants automatically. Log Transactions locks in your sorted data and updates all dashboards. Run them in order each time you import new bank data.

📋 Available on Pro and Pro AI only

🤖

AI Features

AI Sorting uses Claude AI to categorize every transaction in one click — no manual rules needed. AI Dashboard Insights generates a summary of your dashboard data. AI Merchant Insights gives you a deeper look at spending by merchant. AI Budget Insights analyzes your yearly budget and highlights patterns. All AI features require an active license key.

✨ Available on AI-powered products only

🤖

AI License

Manage your AI license key for one-click transaction sorting. Use Enter License Key to activate AI features after purchase, Check License Key Status to verify your license is active and see the expiration date, and Remove License Key if you need to transfer your license to a new copy of the sheet.

✨ Available on AI-powered products only

⚙️

Settings — Change Currency

Switch between over 30 global currencies including CAD, USD, GBP, EUR, AUD, and more. The currency switcher scans every tab in your spreadsheet and updates all currency formatting in one click — no need to manually find and replace symbols. The sheet defaults to CAD but you can change it at any time.

💬

Support

Quick links to everything you need, accessible directly from inside your spreadsheet. Leave a Review takes you to your Etsy review page. Setup, Tutorials & FAQ opens this guide. Contact & Feedback takes you to our contact page where you can reach us, request features, or report bugs. About Enhance Finance shows your product version, AI license status, and current currency setting.

⚠️

Danger Zone — Delete All Transactions

Clears all transaction data from the Transactions tab. This is permanent and cannot be undone — use it only if you want to start completely fresh. A confirmation dialog will appear before anything is deleted, so you won't accidentally wipe your data.

Frequently Asked
Questions

How do I access my product after purchasing on Etsy?
After purchase, Etsy will send you a download link containing a PDF with your Google Sheet link. Click the link and select File → Make a Copy to save it to your Google Drive. If you don't see the email, check your spam folder or visit your Etsy purchases page directly.
What do I need to use Enhance Finance?
A free Google account and the Enhance Finance Google Workspace add-on. The add-on provides the ✦ Enhance Finance custom menu where all features live. After installing the add-on, everything runs inside Google Sheets — no additional software required.
How do I download my bank statement as a CSV?
Log into your bank's online portal and look for an option to download or export transactions. It's usually under "Account Activity," "Statements," or "Transaction History." Select CSV or XLS as the file format — if it exports to a spreadsheet, it works. PDF statements may require manual entry.
Which banks are supported?
Any bank that lets you download transactions as a CSV or XLS file. TD, RBC, Scotiabank, BMO, CIBC, Chase, Bank of America, Wells Fargo, Capital One, and many more. If your bank exports to a spreadsheet, it works.
How does the AI transaction sorting work?
When you click "Sort with AI," the system sends your transaction descriptions to Claude AI, which analyzes each one and assigns the correct category and merchant name. No manual rules or training required. Only transaction descriptions (like "SKIP THE DISHES") are sent — never account numbers or balances.
What happens after the first year of AI access?
Renewal is completely optional — just $12/year if you want to keep using AI sorting. Your spreadsheet, dashboards, and budget tools are yours forever regardless. Even without renewal, everything continues to work — you just won't have the one-click AI sorting.
Do I need the AI version?
Not necessarily. The non-AI versions are fully functional — all dashboards, budgets, and tracking work automatically once transactions are categorized. The AI just saves you the time of categorizing manually. If you prefer hands-on control, the standard versions are great on their own.
Is my financial data secure?
Yes. Your data lives entirely in your own Google Sheet. We never store your financial information on external servers. The AI processes transaction descriptions only — not account numbers or balances. Read our full Privacy Policy →
Can I upgrade from a standard version to AI later?
Yes — contact us and we'll help you upgrade. You'll only pay the price difference between the products.
The AI sorting isn't working. What should I do?
First, make sure you've installed the Enhance Finance add-on and authorized the script — Google Sheets will ask you to grant permission the first time. Check that your license key is active via ✦ Enhance Finance → 🪪 AI License → 🔍 Check License Key Status. If you're still having trouble, try refreshing the page. If the issue persists, reach out to us and we'll sort it out quickly.
What currencies are supported?
Enhance Finance supports 34 currencies — you can switch between them anytime via ✦ Enhance Finance → 💱 Change Currency. The full list: CAD, USD, GBP, EUR, AUD, NZD, JPY, CNY, KRW, INR, BRL, MXN, CHF, SEK, NOK, DKK, PLN, ZAR, SGD, HKD, TWD, PHP, THB, IDR, MYR, AED, SAR, ILS, TRY, CLP, COP, ARS, NGN, and EGP. The currency switcher updates all formatting across your entire spreadsheet in one click.
Does this work outside the US and Canada?
The spreadsheet itself works with any bank CSV or XLS from any country. The AI sorting is built and tested for US and Canadian banks and works great with English-language transactions. Users in the UK, Australia, and New Zealand should see strong results too. For non-English transactions, the manual version is the better fit.
What is your refund policy?
We offer a 7-day money-back guarantee, no questions asked. If Enhance Finance isn't the right fit, message us through Etsy within 7 days of purchase and we'll issue a full refund.

Need Help With Anything?

Just reach out — we want to hear from you. Whether it's a question, a bug, or a feature idea, we're here.

Contact Us