AI Accounting

ROLE

Lead Developer / Architect

YEAR

2025

TECHNOLOGY

Gemini API, Google Apps Script, HTML

SaaS-Free, DIY AI Accounting System

Fully Automated: Just Toss Receipts into G-Drive!

A DIY AI Accounting System for Solopreneurs & Freelancers Built with Google Sheets

Bookkeeping is a hassle, isn’t it?
You want to focus 100% on generating revenue and providing value to your clients, but end up battling a mountain of receipts at the end of the month…
I built this app for solopreneurs and freelancers just like you. It’s the AI accounting system anyone who has ever dealt with accounting has dreamed of at least once.

The concept is incredibly simple:
“Just upload your receipts and invoices to Google Drive! The AI will automatically book the entries and even generate your financial statements.”

No expensive monthly SaaS subscriptions, no clunky dedicated apps to install. It works entirely within the Google Sheets you already know and use.

Why did I build this?

When resources are limited, wasting hours every month on manual data entry is a huge loss. However, it’s crucial to know exactly where your company’s money is going and to have a real-time grasp of your business performance.
“Isn’t there a way to do this more easily, more intuitively, yet in real-time?”
That thought led to the development of this “Google Sheets × AI (Gemini)” combination.

How does it work? (It’s surprisingly easy)

Using it is almost like magic.

  1. Toss it into G-Drive: Simply upload photos of receipts taken with your phone or PDF invoices received via email into a dedicated Google Drive folder.
  2. AI Automates the Analysis: The latest AI (Gemini) instantly parses the documents. It reads the date, amount, and vendor, predicts the optimal “account category,” and lists them in your spreadsheet.
  3. Review and Click: All you have to do is open the spreadsheet and give a quick check to the journal entries proposed by the AI. If everything looks good, just click a button to approve!
  4. Auto-Updated Financial Statements: Approved data is instantly reflected in the database, automatically generating and updating your Profit & Loss (P/L) and Balance Sheet (B/S).

3 Core Strengths of This System

  • Zero Manual Entry: Say goodbye to typing dates and amounts on your keyboard. The AI does the typing for you.
  • 100% Google Sheets Based: Zero learning curve for new tools. It’s fully customizable, and sharing it with your tax accountant is as simple as sending a link.
  • God-Level Searchability: Once approved, the AI automatically renames your receipt files into a crystal-clear format like [Date] – [Vendor Name] and archives them. The headache of searching “Where is that expense?” completely disappears.

Highly recommended for:

  • Freelancers struggling with monthly bookkeeping.
  • Solopreneurs wanting to cut the fixed costs of accounting software.
  • Independent contractors who want to avoid pulling all-nighters right before tax season.
  • Anyone looking to streamline their business using technology (AI).

…In other words, I built it for myself!