Corporate AI7 min read

How Can a Small Business Make a Budget With AI?

On this page

A small business can make a budget with AI by giving it last month's real income and costs, asking it to build a simple monthly budget in Excel or Google Sheets, and then asking it to explain every formula. AI is good at the layout, the formulas and "what if" questions. You supply the real numbers, and you check that the totals add up before you trust them.

This guide is for shop owners, salon and restaurant owners, consultants, online sellers and anyone running a small business in Kenya. You need no special software: a free AI chat tool and a spreadsheet are enough.

What you need before you start

A budget is only as good as the numbers in it. Gather these first:

  • Money in: your sales for the last three months, from your sales book, till, M-PESA statement or bank statement.
  • Money out: rent, stock, staff pay, transport, airtime and data, electricity, licences, loan repayments and anything else you pay regularly.
  • Irregular costs: annual licences, repairs, school fees if you take them from the business, and seasonal stock.

You do not need to give AI your statements. Add up the totals yourself and type in categories and amounts only. Customer names and phone numbers never go into a public AI tool. Kenya's Data Protection Act, 2019 applies to anyone in Kenya who keeps records of people's personal data, and that includes a small business. For more safe habits with free tools, read our guide to free AI tools for small businesses.

Which tools to use

Free route. Any free AI chat assistant can design the budget and write the formulas. You then type them into a spreadsheet. Microsoft offers Excel for free on the web with a Microsoft account, and Google Sheets opens with a Google account.

Built-in AI. Microsoft says Copilot in Excel can help when "updating budgets, creating financial models, or analyzing data", using tables, charts, PivotTables and formulas. It also says Copilot might not be included in your Microsoft 365 subscription. Google says Gemini in Sheets needs an eligible Google Workspace or Google AI plan. Both were true as of 15 November 2026, and plans change, so check what your plan includes before paying for anything. For step-by-step help, read how to use Copilot in Excel.

Six steps to a budget, with prompts

Each prompt follows the four Cs we teach at FuKazee: Clarity, Context, Constraints and Customisation. Replace the square brackets with your own figures.

1. Build the budget layout

I run a small [type of business] in [town], Kenya. Design a simple monthly budget for me in [Excel / Google Sheets]. Columns: category, budget for the month, actual, difference. Rows grouped as: money in (sales, other income), fixed costs, variable costs, loan repayments, and money I take out for myself. Give me the exact formulas for each total and the difference column, and tell me which cell each formula goes in. Explain each formula in one plain sentence. I only know basic spreadsheets.

Check: type a few easy numbers (100, 200, 300) and see if the totals are right before you add real figures.

2. Turn your real figures into a starting budget

Here are my average monthly figures for the last three months, in KES. Sales: [amount]. Rent: [amount]. Stock: [amount]. Staff: [amount]. Transport: [amount]. Electricity: [amount]. Airtime and data: [amount]. Loan repayment: [amount]. Put them into the budget layout from before. Then tell me my average monthly profit or loss, and which three costs take the biggest share of my sales, as percentages. Show the working.

Check: redo the profit sum with a calculator. If AI's number is different, ask it to show each step and find the mistake.

3. Plan cash flow week by week

Profit and cash are different. A business can make a profit on paper and still run out of money because rent is due before customers pay.

Using my budget below, make a 12-week cash flow plan. Context: rent of KES [amount] is due on the [date] of each month, stock is bought every [frequency], staff are paid on [date], and about [percentage] of my sales are on credit, usually paid within [number] days. Start with KES [amount] in hand. Show money in, money out and closing balance for each week. Highlight any week where the balance goes below KES [amount]. BUDGET: [paste]

Check: the weeks with heavy payments, such as rent and salaries, should show a dip. If they do not, a date is wrong.

4. Test "what if" scenarios

Using my cash flow plan below, show me three scenarios for the next three months: (1) sales fall by 20 percent, (2) my supplier raises stock prices by 10 percent, (3) I hire one more person at KES [amount] a month. For each, show the effect on monthly profit and the lowest cash balance. Then list two practical things I could do in each case. Keep the advice simple and realistic for a small business in Kenya.

Check: AI's suggestions are ideas, not advice. Ask yourself whether each one fits your customers and your town.

5. Find where the money leaks

Compare my budget and my actual figures for [month] below. List every category where actual spending was more than 10 percent above budget, with the difference in KES. Ask me three questions that would help me find out why. Do not guess the reasons. DATA: [paste]

Check: the questions often point to something you already suspected. Talk to your staff before changing anything.

6. Make it a monthly habit

Write me a 20-minute monthly checklist for reviewing my budget on the last Saturday of each month. Include updating actuals, checking the cash flow plan for the next month, one decision to make, and one question to ask my accountant. Plain English, numbered steps.

Check: put the date in your phone calendar. A budget you look at once a year does not help much.

How to check AI's maths

AI tools write fluent answers and still get sums wrong. These habits catch most mistakes:

  1. Use spreadsheet formulas, not AI totals. Let the spreadsheet do the adding. Use AI to write the formula, not to give you the answer.
  2. Test with simple numbers. Before real data, enter round numbers you can add in your head.
  3. Ask it to explain. "Explain this formula step by step" shows you whether the logic is right.
  4. Cross-check one total by hand every month.
  5. Watch the cell ranges. A common mistake is a total that stops one row short, such as SUM(B2:B9) when your last cost is in row 10.

What AI should not do with your budget

  • Do your tax. AI does not know your tax position and rules change. Ask KRA or a qualified accountant.
  • Make big decisions for you. Taking a loan, opening a second branch or cutting staff are your decisions. Use AI to test the numbers, then decide.
  • See customer data or full statements in a public tool. Type totals and categories, not names, phone numbers or transaction lists.
  • Invent figures. If you do not know a cost, write it down as a gap. Do not let AI fill it with a guess.

How FuKazee helps small businesses

FuKazee trains small business owners and their staff to use AI on everyday work, including turning scattered sales notes into a tidy sheet and testing a decision by asking AI to argue against it. We show the free version of each feature first, and you decide later whether a paid plan is worth it. Training runs on-site in Kenya by arrangement or live online, and one-to-one training is available for business owners. See AI training for small businesses, or read is AI training worth it for a small business in Kenya? Teams that work mostly in spreadsheets may prefer our Excel and AI training.

Questions people ask

Can AI make a budget for me without my numbers?

It can make a template, but a budget built on made-up numbers is not your budget. Give it your real totals from the last few months. Three months of figures give a fairer picture than one.

Is it safe to upload my M-PESA statement to ChatGPT?

We would not. A statement shows names, phone numbers and every transaction. Add up the totals by category yourself, or with a spreadsheet, and give AI only those totals.

Do I need Copilot or Gemini to do this?

No. A free AI chat tool can write the layout and formulas, and you type them into Excel for the web or Google Sheets. Built-in AI saves typing, but you need an eligible plan.

What is the difference between a budget and a cash flow plan?

A budget shows what you expect to earn and spend in a month. A cash flow plan shows when the money actually comes in and goes out, week by week. You need both, because bills arrive on fixed dates even when customers pay late.

Sources

All sources last checked 15 November 2026.

Where FuKazee fits in

FuKazee is a Nairobi training company that has trained more than 3,000 people since 2022. We help small business owners and their teams use AI on real work, starting with free tools. Tell us what your business does and what you want AI to help with. Email lead@fukazee.com

Want guided support instead?

Plan AI training around your team's real work. Answer a few quick questions about your sector, team size and goals, and we will recommend the right programme and format. Sessions are built on your workflows and include a usage policy.

Rodney MainaFounder & Director, FuKazee

Rodney has run FuKazee's training since 2022 and still teaches inside every programme line: corporate sessions, the postgraduate cohort and the KCSE examiner webinars. First Class Honours in Journalism and Mass Communication, University of Nairobi.