top of page
Search

Keeping Your Books With AI

Writer: E St Clair
E St Clair
Nov 13
4 min read

A step by step guide on using AI as a bookkeeper

You can turn a folder of statements into a full set of financial reports in about 30 minutes, with no accounting software. An AI agent is an assistant that can open your files, read them, and build reports for you. Think of it like handing a shoebox of receipts to a bookkeeper, except the shoebox is a folder on your computer.


What you need: a computer, an AI agent that can read folders (such as Claude), and your statements saved as PDF or CSV files.

My recommendation: use a paid version of your AI agent. Free versions usually limit how many files you can share and how much work the agent can do in one sitting, and a full year of statements can hit those limits fast.


Step 1: Create a folder your AI agent can access

Make one main folder on your computer or cloud drive and name it after your business and the year. Inside it, create a Statements folder with four subfolders. Your agent can only read what you put here, so this folder becomes your books.


Folder Structure My Business Books 2026

└── Statements

├── Bank Statements

├── Credit Card Statements

├── Loan Statements

└── Cash Transactions


Subfolder

What goes inside

Bank Statements

Monthly statements for every business checking and savings account

Credit Card Statements

Monthly statements for every business credit card

Loan Statements

Statements for business loans, lines of credit, and vehicle or equipment loans

Cash Transactions

A list of your Zelle, Cash App, Venmo, and cash transactions


For the Cash Transactions folder, a simple spreadsheet works. List the date, amount, who paid or got paid, and what it was for.


Step 2: Drop in your statements

Download every statement for your reporting period and save each one in its matching subfolder. For most businesses the period is January to December, which means 12 statements per account.

[ ] Download statements from your bank's website as PDF files, not screenshots or phone photos

[ ] Include every account the business uses, even the ones with little activity

[ ] Name each file so the month is obvious, for example 01 - Jan 2026-1234.pdf, where 1234 is the last 4 digits of the account

[ ] Check for gaps, a missing month means missing income or expenses in your report

Real life example: a lawn care owner with one checking account, one credit card, and one truck loan would have 36 files, 12 in each of three folders, plus one spreadsheet of Zelle and cash payments.


Step 3: Connect the folder and give your agent the prompt

Open your AI agent, connect or share your main folder with it, then copy and paste the prompt below. Swap in your business name and period.


Accessing this folder, I want you to generate/update my company's

financial report for [Business Name] for the period January to

December [Year].


Before you build the report, reconcile the statements as a checks

and balances step. For each account, confirm that the beginning

balance, plus money in, minus money out, equals the ending balance

on every statement, and that each month's ending balance matches

the next month's beginning balance. Flag any missing statements,

duplicate transactions, or amounts that do not tie out.


The report should include:

1. A title page

2. A table of contents

3. An executive summary

4. An executive breakdown listing my spending trends, the

transactions or categories I should pay attention to, and any

unusual spending in a category

5. My company's Profit and Loss Statement

6. My company's Balance Sheet

7. My company's Statement of Cash Flows

8. A reconciliation summary showing each account and whether it

tied out


If anything is missing or unclear, list your questions for me

before you finalize the report.


Reconciling is the checks and balances step. It works like balancing a checkbook, the agent proves its numbers match what the bank says before it builds your report.

The word "update" matters. Next month you can add new statements and run the same prompt, and the agent refreshes the report instead of starting over.


Step 4: Review your report

Your agent hands back one report with the parts below. Read the executive breakdown first, it tells you where to look.


Part of the report

What it tells you in plain English

Title page and table of contents

Makes the report easy to share with a lender, partner, or tax preparer

Executive summary

The big picture in a few sentences: how the business did this period

Executive breakdown

Spending trends, categories to watch, and unusual spending

Profit and Loss Statement

What you earned, what you spent, and what was left over

Balance Sheet

What the business owns, what it owes, and what is yours on one specific day

Statement of Cash Flows

Where your cash actually came from and where it went

Real life example of unusual spending: your fuel cost runs about $400 a month, then jumps to $1,100 in July. The report flags it so you can ask why. Maybe you took on more jobs, or maybe a personal charge slipped in.

Before you trust the numbers, do three quick checks:

1. Match the ending cash on the report to the ending balance on your last bank statement.

2. Scan the categories for anything filed in the wrong place, such as a personal purchase listed as a business expense.

3. Answer any questions the agent listed, then ask it to update the report.


Step 5: Keep it updated every month

Each month, drop the new statements into their folders and run the same prompt again. Ten minutes a month beats a full weekend of catch up in March.

Common questions

• Is my information safe? Only share the folder with an AI tool you trust, and read its privacy settings first. Give it access to this one folder, not your whole computer.

• What if I mix personal and business spending? Tell the agent which charges are personal so it can leave them out. A separate business account makes this much easier.

• Does this replace my accountant? No. AI can misread a statement or put a charge in the wrong category. Have your tax professional review the report before you use it for taxes or a loan.

• What if I am missing a statement? Your bank can provide past statements online or at a branch. The report is only as complete as the folder.



 
 
 

Comments


Miami Gardens Office

20535 NW 2nd Ave Ste 203
Miami, FL 33169

Orlando Satellite Office

1800 Pembrook Drive Ste 300
Orlando, FL 32810

Atlanta Satellite Office

13010 Morris Road - Suite 650
Alpharetta, Ga 30004

  • Twitter
  • Instagram
  • Facebook

(305) 651-4119 Office | (305) 760-2348 Fax​

© 2025 St Clair Financial Services

bottom of page