Stop losing receipts. Stop missing deductions. Stop paying your accountant to sort through your Gmail.
→ Get Started Free · Full Demo & Pricing
If you're a Canadian freelancer, every tax season looks something like this:
- Digging through 12 months of Gmail for Uber Eats and AWS receipts
- Googling "is this GST or HST" for the 40th time
- Guessing which T2125 line an Adobe subscription goes on
- Wondering if you actually claimed everything you were entitled to
LoonieLog is an AI agent that lives inside your Google Sheets. It hunts your receipts, applies CRA rules automatically, and logs everything — while you sleep.
| 📬 Hunts receipts | Scans your Gmail To_Log label and a Drive folder for new receipts — automatically |
| 🤖 Extracts structured data | Vendor, date, subtotal, GST/HST, PST/QST, total, currency — using AI |
| 🇨🇦 Applies CRA T2125 rules | Maps every expense to the correct line code: 8523 Meals, 9270 SaaS, 9281 Motor Vehicle… |
| 💸 Calculates deductions | 50% meals rule, ITC eligibility, PST non-recoverability — by province |
| 💱 Converts USD → CAD | Uses Bank of Canada Valet API rates — audit-proof for CRA |
| 🚩 Flags ambiguous expenses | Low-confidence receipts go to a Needs Review tab — nothing slips through |
| ⏰ Runs automatically | Daily trigger at 2am, or kick it off manually from the menu |
No Marketplace listing yet — install via Google Sheets copy link.
- Copy to Google Sheets — Free →
- Open your new sheet → click 🚀 LoonieLog in the menu bar
- Click ⚙️ Initialize Agent and follow the 3-step setup:
- Choose your AI model (Gemini 2.5 Flash — free, or Claude Sonnet 4.6)
- Enter your API key
- Select your province
- Done. Your first scan runs at 2am, or click
▶️ Run Now
- Everything lives in your Google Sheet and Drive — no external database
- AI providers receive only receipt content — no names, account numbers, or identifiers
- API keys stored in Google's encrypted
PropertiesService— never in the sheet - Full details: Privacy Policy
| Tab | What's in it |
|---|---|
| Expenses | Every processed receipt — 19 columns, auto-formatted |
| Needs Review | Low-confidence or ambiguous receipts flagged for your attention |
| Summary | YTD T2125 filing totals + category breakdown + current month snapshot |
| Audit Log | Append-only log of every action the agent takes |
| Settings | Your current config — AI model, province, last run time |
All monetary values stored in CAD. USD receipts converted at the Bank of Canada rate for the receipt date.
8521 Advertising · 8523 Meals & Entertainment · 8710 Interest & Bank Charges · 8810 Office Expenses · 8860 Professional Fees · 8910 Rent · 9200 Travel · 9220 Telephone & Utilities · 9270 Other Business Expenses · 9281 Motor Vehicle · 9936 CCA · WFH Home Office
All 13 Canadian provinces — correct GST, HST, PST, QST rates applied automatically.
| Model | Cost | Notes |
|---|---|---|
| Gemini 2.5 Flash | Free tier available | Recommended for most users |
| Claude Sonnet 4.6 | Pay-per-use | Higher accuracy on complex receipts |
Runtime → Google Apps Script (V8) — no Node.js, no npm, no external deps
AI → Gemini 2.5 Flash (Google AI) · Claude Sonnet 4.6 (Anthropic)
FX rates → Bank of Canada Valet API — free, CRA-accepted
Storage → Google Sheets + Drive + Apps Script PropertiesService
Hosting → GitHub Pages (this landing page)
Free to start — no credit card, no signup, works with your existing Google account.
Paid plans available for higher volumes and upcoming managed hosting. → See pricing
- Gmail receipt scanning
- Google Drive PDF/image scanning
- Gemini 2.5 Flash + Claude Sonnet 4.6 support
- USD → CAD conversion (Bank of Canada rates)
- CRA T2125 category mapping (all 13 provinces)
- ITC + GST/HST calculation
- License key activation
- Stripe billing (coming soon)
- Google Workspace Marketplace listing
- Managed Pro — no API key required
- One-click audit ZIP for your accountant
Built with 🍁 in Canada · Not affiliated with the CRA