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

✨ AI Powered Finance Tracker Pro

Want the quickest way forward? Just watch the video 👇

Full Setup Walkthrough — Finance Tracker Pro AI

From purchase to dashboard in under 2 minutes

0:30
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

Give Google Permission

The first time you interact with the sheet, Google will ask you to authorize the script. Click Continue, select your Google account, then Allow. This only happens once.

3

Get Your AI Activation Key

After purchase, you'll receive a license key to activate AI features. Check the PDF from Etsy or your confirmation email for your unique key.

4

Activate Your Key in the Menu

In your Google Sheet, go to ✦ Enhance Finance → AI License → Enter License Key in the menu bar. Paste your key and click OK.

5

Sign the AI Disclosure

A disclosure dialog will appear explaining how the AI features work. Read through it, scroll to the bottom, and accept. This is a one-time step — you won't see it again.

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

Download Your Bank Statement as CSV

Log into your bank's website and download your transactions as a .csv 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 CSV.

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

7

Paste Your CSV into the Input Statements Tab

Open your downloaded CSV 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.

8

Click "Process Transactions"

Hit the big Process Transactions button on the Input Statements tab. The sheet reads your CSV, organizes the data, and sends it to the Transactions tab — cleaned up and ready for sorting.

9

Click "Sort with AI"

Head to the Transactions tab and click the Sort with AI button. Claude AI analyzes every transaction, identifies the real merchant name behind vague bank codes (like "SBUCKS 220930" → Starbucks), and assigns the correct category from 60+ options. Hundreds of transactions sorted in seconds.

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.

Standard Finance Tracker Pro

Want the quickest way forward? Just watch the video 👇

Full Setup Walkthrough — Finance Tracker Pro

Manual categorization and dashboard overview

0:30
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.

2

Give Google Permission

The first time you interact with the sheet, Google will ask you to authorize the script. Click Continue, select your Google account, then Allow. This only happens once.

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

Download Your Bank Statement as CSV

Export your transactions as a .csv from your bank's website. Look for it under "Account Activity," "Statements," or "Transaction History." Any bank that offers CSV export is supported.

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

4

Paste Your CSV into the Input Statements Tab

Open your CSV file, select all (Ctrl+A / Cmd+A), and copy it. Go to the Input Statements tab and paste 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. Only data inside the white area will be processed.

5

Click "Process Transactions"

Hit the big Process Transactions button on the Input Statements tab. Your data gets organized and sent to the Transactions tab, ready for categorizing.

6

Categorize Your Transactions

On the Transactions tab, you'll see your bank's raw descriptions (like "SBUCKS 220930"). For each transaction, type the real merchant name (e.g., "Starbucks") and assign a category from 60+ options (e.g., "Coffee & Snacks"). Once you've categorized a merchant, the sheet remembers it forever — that merchant also gets added to a searchable dropdown list.

7

Click "Auto Categorize" for Future Imports

Next time you import transactions, click the Auto Categorize button. Any merchant you've already categorized will be sorted automatically. You only need to handle new merchants — the rules you set carry forward forever.

8

Explore Your Dashboards

Your Monthly Dashboard and Annual Dashboard automatically populate as transactions are categorized. Head to the Budget tab to set your income, expense, spending, and savings goals.

✨ AI Powered Annual Budget

Want the quickest way forward? Just watch the video 👇

Full Setup Walkthrough — Annual Budget AI

AI sorting and yearly budget planning in action

0:15
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

Give Google Permission

The first time you interact with the sheet, Google will ask you to authorize the script. Click Continue, select your Google account, then Allow. This only happens once.

3

Get Your AI Activation Key

After purchase, you'll receive a license key to activate AI features. Check the PDF from Etsy or your confirmation email for your unique key.

4

Activate Your Key in the Menu

In your Google Sheet, go to ✦ Enhance Finance → AI License → Enter License Key in the menu bar. Paste your key and click OK.

5

Sign the AI Disclosure

A disclosure dialog will appear explaining how the AI features work. Read through it, scroll to the bottom, and accept. This is a one-time step — you won't see it again.

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

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.

7

Use AI Merchant Insights

Click the Merchant Insights AI button to get a deeper look at your spending patterns. The AI analyzes your budget data and surfaces insights about where your money is going — helping you spot trends and make smarter decisions.

✨ Powered by AI

Standard Annual Budget

Want the quickest way forward? Just watch the video 👇

Full Setup Walkthrough — Annual Budget

Budget planning and tracking guide

0:15
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

Give Google Permission

The first time you interact with the sheet, Google will ask you to authorize the script. Click Continue, select your Google account, then Allow. This only happens once.

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

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.

Categorization
Best Practices

Enhance Finance comes pre-loaded with 60+ 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. It may take a few seconds to load the first time. Here's everything inside it.

🤖

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?
Just a free Google account. The entire system runs inside Google Sheets — no additional software, extensions, or downloads 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 as the file format. If your bank doesn't offer CSV directly, try selecting Excel or delimited text — these often work too.
Which banks are supported?
Any bank that lets you download transactions as a CSV file. TD, RBC, Scotiabank, BMO, CIBC, Chase, Bank of America, Wells Fargo, Capital One, and many more. If your bank exports a CSV, 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 sort button isn't working. What should I do?
First, make sure you've authorized the script — Google Sheets will ask you to grant permission the first time you use the AI button. If you're still having trouble, try refreshing the page and clicking the button again. If the issue persists, reach out to us and we'll sort it out quickly.
Does this work outside the US and Canada?
The spreadsheet itself works with any bank CSV 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