A client tracker that suddenly shows an error in half its cells, and an email thread with a client that has gone back and forth so many times nobody remembers what's still missing: that's a normal week in a small bookkeeping or accounting office. If your practice already works in Google Sheets and Gmail, Gemini, Google's AI assistant, can help with both today. It can explain and fix a broken formula, turn a messy list into a clean table, summarize a long client thread and draft your reply. You stay the one who checks the numbers and clicks send.
This guide is for bookkeepers, accountants and office staff who have never used AI before, in the US first and in the UK. It sticks to organizing, understanding and comparing what's already in your files. Gemini doesn't decide anything about a client's taxes, books or money here: that judgment stays with you.
What you need before you start
- An eligible plan. Google's help for Gemini in Google Sheets says the feature requires an eligible Google Workspace or Google AI plan. Google Workspace is the business account a firm may use for its Gmail, Drive and Sheets. Google's personal AI plans are called Google AI Plus, Google AI Pro and Google AI Ultra; check which one includes the feature you want before you pay for anything.
- A real Google Sheets file. The same page says Gemini works best with native Google Sheets files. If a client sends you an Excel file, save it as a Google Sheets file first.
- The right kind of Gmail account. According to Gmail Help on Gemini and account types, "Access to Gemini features in Gmail varies based on account type." For a personal Gmail account without a paid plan, "availability is currently limited to the US for users with personal Gmail accounts without a paid plan." So if you're in the UK on a free personal account, you may need a paid plan or your firm's Workspace account for these Gmail features.
Client data: practice on made-up numbers first
Before you open a real client file, make a practice copy. Take your client tracker, replace every name with an invented one, change the amounts and delete anything like a Social Security number, a tax ID or a bank account number. Try every step in this guide on that copy first. You'll learn how Gemini answers without exposing anyone.
For real client work, use only your firm's approved Google Workspace account, and ask whoever manages it which edition you have and what its data terms are. In the Gemini app, for example, Google's privacy help for Gemini Apps says that on work or school accounts whose edition has enterprise-grade data protections, "Your chats and uploaded files in Gemini Apps won’t be reviewed by human reviewers" or used to improve generative AI models. In other editions, your chats may be reviewed by human reviewers and used to improve Google's products. So check your plan before you upload anything a client sent you.
Fix a formula error in Google Sheets
Google pitches this one directly at accounting teams: its own page on AI in accounting says Gemini in Google Sheets can create tables automatically and recommend formulas, and can take on data entry to reduce errors. Start with the classic headache: a formula that shows an error.
- Open your practice copy in Google Sheets.
- At the top right, click Ask Gemini. A side panel opens.
- In the panel, type what you need in plain English.
"The formula in cell D2 shows an error. Explain in plain words what's wrong, then suggest a corrected formula. Don't change any other cell."
Google's help covers fixing formula errors with Gemini as its own task, so you don't need to know why a formula broke to ask. Test the corrected formula on a few rows you can add up by hand before you copy it down the whole column.
Fictional example: Say you run a two-person bookkeeping practice in Tampa, Florida. Your tracker lists which clients have sent this month's bank statements, and the cell that counts the missing ones shows an error after a coworker added a column. On a copy with invented clients, a pool supply store and a taco truck, you ask Gemini what went wrong and get a suggested fix. You check the new count against the rows you can see, and only then repeat the fix in the real tracker.
Turn a messy list into a clean table
Many trackers start as a list someone typed in a hurry: client names in one column, notes everywhere else. Gemini in Sheets can create tables, which makes a list easier to sort, filter and read. Open the side panel and ask:
"Create a table from this sheet with these columns: Client, Document, Month received, Status. Use only the data in the sheet. If a value isn't there, leave the cell empty instead of guessing."
That last sentence matters: an invented date in a client tracker is worse than an empty cell. When the table appears, compare it with your original list: same number of rows, same clients, nothing new.
Summarize a long client thread in Gmail
Some client threads run for weeks: a question about receipts, a half answer, a forwarded message from the client's partner. Before you reply, you need to know where things stand.
Gmail Help on summarizing email puts it in one line: "At the top of the thread, click Summarize this email." Gmail then shows a short summary of the conversation, which Google calls an AI Overview. Two things to know:
- In Gmail settings, turn on Smart features in Gmail, Chat, and Meet and Smart features in Google Workspace, or the button won't do its job.
- These summaries support only some languages. If a client writes to you in another language, the summary may not appear.
Draft the reply, then make it yours
Once you know what's missing, Gemini can write the first draft. Google's help for Gemini in Gmail says it can "Create new emails or refine existing drafts for tone and clarity." On your computer, open Gmail, click Ask Gemini at the top right and describe the email you want:
"Draft a short, friendly reply to this thread. Thank the client for the receipts they sent, list the two items still missing as [missing item 1] and [missing item 2], and ask for them by [due date]. Don't promise anything about their taxes."
The words in square brackets are placeholders: you fill them in yourself, so the draft never holds a detail you didn't check. You can also paste a reply you wrote yourself and ask Gemini to make it clearer or more polite.
Fictional example: Say you're a sole practitioner in Bristol, England, and your firm uses a Google Workspace account. A café owner, invented for this example, has sent receipts in five separate emails over three weeks. You click Summarize this email, see that two supplier invoices are still missing and check that against the thread yourself. You ask Gemini for a reply and add "Use British English and a calm, understated tone." You set your office's real due date, cut a stiff sentence and send it yourself.
If you write the same request every month, our guide on how to ask clients for their documents each month with AI turns it into reusable templates.
Check every result before it reaches a client
Google's own help pages say not to rely on Gemini features as financial or other professional advice, and they warn that Gemini may suggest inaccurate information. Treat every answer as a draft from a fast new assistant who has never met your clients. Five quick checks:
- Formulas: test the fix on a few rows you can work out by hand.
- Tables: count the rows and spot-check a few values against the original.
- Summaries: reread the messages behind any date, amount or document the client says was already sent.
- Drafts: read every line out loud before you send; delete anything Gemini added that you didn't ask for.
- Decisions: anything about a client's taxes, books or money is your professional call, never the draft's.
On the radar: what comes next
None of these is needed for the steps above. Each comes with its maturity (stable means finished, beta means still being tested) and its risks.
- The AI function in Google Sheets (Google, beta): a function in your sheet that reads text in cells and, for example, sorts it into groups. Google's page on the AI function explains: "To help you detect patterns, Google Workspace with Gemini categorizes your data into groups." Risks: it doesn't have access to your entire spreadsheet or other files in your Drive, its responses are limited to text, and you can't undo or redo it, so try it on a copy.
- Building whole sheets with Gemini (Google, beta): Gemini can create new sheets or complete end-to-end tasks on existing ones, and it shows you a plan and a template outline to review first. Google's help on building spreadsheets adds that on personal accounts "you might be able to use Canvas and Build up to 3 times a month." Risk: it changes your sheet, so check the result line by line.
- The Google Workspace app in the Gemini app (Google, stable): a connection, meaning a permission that lets the Gemini app look into your Gmail, Docs and Drive. According to Gemini Apps Help on connected Workspace apps, it can "Summarize, get quick answers, and find information from Google Workspace services like Gmail, Docs, and Drive". Smart features must be on in Gmail settings, and on a work account your administrator enables it first. In the same app, Google's help on uploading files says up to 10 files can be uploaded in one prompt, subject to availability. Risk: Gemini reads the client messages and files you give it, so do this only on your firm's approved account.
- Integrations with Gemini in Workspace (Google, beta): connectors, permissions that let Gemini read another company's app. Gmail Help on integrations says "Integrations currently only support read actions, such as searching for or finding information." Risks: your Workspace administrator turns them on, and some need a paid subscription to the other app.
- The QuickBooks connector for Gemini (listed on the Google Workspace Marketplace, beta): its Marketplace listing says "This is the official QuickBooks connector, available for customers in the US." Risks: it needs access to your Google account, and your firm's or a client's financial data enters a Gemini conversation, so use it only if your firm's policy allows it. UK readers aren't covered by the listing.
Important notice
Client, employee or student data: it depends on the account
Only work with client, employee or student data in services approved by your organisation and covered by a data processing agreement. The GDPR (Article 28) requires that agreement when a provider processes data on your organisation's behalf. In Gemini, with a Google Workspace work or school account that has enterprise-grade data protections, your chats are not reviewed by human reviewers or used to improve generative AI models, and your organisation's Workspace agreement includes the Cloud Data Processing Addendum. With a personal Google Account and “Keep Activity” on, some of your chats may be reviewed by human reviewers and then kept for up to three years.
Always check the official source for your country
Always check every rule, deadline, rate or requirement against the official source or with the agency in charge. In the US: the Federal Register and the eCFR for federal regulations, the IRS for federal taxes, and your state's official websites. In the UK: legislation.gov.uk, plus HMRC's pages on GOV.UK for tax. In Ireland and the rest of the EU: EUR-Lex for EU law. Note which country or state the rule applies in and the date you checked it. AI may not know about the most recent changes.
AI can make up citations and references
AI can make up judgments, articles of law and references that look genuine. Check every citation in an official database: the CENDOJ search engine (Spain's General Council of the Judiciary) for case law, the BOE for Spanish legislation and EUR-Lex for EU legislation. If you cannot find the source, do not use the citation.
Keep going: courses for accountants
Gemini helps with the work inside Sheets and Gmail. If you'd like a step-by-step path with an AI assistant for invoices and accounting documents, the Claude for Accountants course starts there. You can also browse every course for accountants, or read our overview of Claude AI for accountants to compare the two assistants.



