From raw numbers to business knowledge

A common first try: upload a spreadsheet of 5,000 sales rows and ask the AI what your strategy should be. The answer comes back vague. The AI can read the numbers, but it doesn't know why they are what they are. This lesson shows the four layers of knowledge, and what to add so the AI can help.

The mistake most people make

They paste raw numbers without saying what the columns mean, which rules apply, or why something unusual happened.

What was asked

“Here is our sales CSV for August. Why did our net margin drop from 18% to 11%?”

What the AI said

“Your total revenue in August was ₹42,50,000 and total expenses were ₹37,82,500. Margin fell because costs rose compared with sales. You should consider reducing operating expenses.”

What went wrong: The AI only restated the sums. It couldn't know that the business paid a year's factory insurance in advance in August. It also couldn't know a transport strike had pushed up cotton prices for a few weeks. The numbers didn't carry those reasons.

How it works: the Surat textile ledger

A textile merchant on Ring Road, Surat, writes in his bahi-khata: '₹85,000 received from Agarwal Sarees, Patna.' That is a fact. Agarwal Sarees pays ₹85,000 every other Thursday. That is a pattern. They sell bridal wear, stock up before the wedding season and pay once their own customers pay cash. That is context. The merchant also knows which Varanasi mills they buy from, which transporter they use, and what credit they get. That web of connections is the fourth layer. Facts alone tell you little; the reasons give them meaning.

The four layers

1. Facts

Single numbers, dates, customer names and invoice totals. On their own, they don't explain anything.

2. Patterns

What repeats: which products sell at weekends, which suppliers deliver late in the monsoon, which clients pay late.

3. Context

The reasons behind the patterns: your policies, payment terms, credit limits and local customs.

4. Connections

How people, products, suppliers and contracts link to each other. Written down, this is called a knowledge graph. Lesson 10 shows how to make one.

How to prepare material for the AI

Add a short note above the tableBefore you paste a table, write a few lines on what each column means and any one-off events in the period.

Say how things connectTell the AI: 'Vendor A supplies part X on 30-day credit. Vendor B supplies part Y against full advance.'

Give the earlier numbers tooPaste last period's figures beside this period's, so the AI compares like with like.

Numbers With Their Reasons

Help me understand a change in our numbers.

Here are the numbers:
"""
[Paste your figures, ledger excerpt or table here]
"""

Here is what was happening in the business at the time:
"""
[Your business, customer payment terms, and anything unusual this period]
"""

Work only from what I have pasted. Where you need a fact I haven't given, write [CHECK] and say what is missing.

Answer:
1. Which changes look like a lasting trend, and which look like a one-off?
2. Which customer or cost line explains most of the change?
3. Two questions I should ask my accountant or team this week.

The AI gets the numbers and the reasons together, so it can separate a one-off from a trend. It marks gaps instead of guessing.

Check your understanding

Why does the AI give shallow answers when you give it a spreadsheet and nothing else?

Show the answer

It can't see the reasons behind the numbers: your terms, your customs, and the one-off events of that period. Without them, it can only restate the sums.