← back to notes
fintech

Spreadsheets at 2 AM? Let the AI Pull the Numbers

  • #fintech
  • #finance
  • #ai
  • #productivity

Financial analysts don't fear market crashes.

They fear the copy-paste Excel job at 2 AM.

The assistant who prepares the folder

Imagine walking into a big meeting.

On the table there's already a folder.

Inside: the latest numbers, last quarter's comparison, the three news items that matter, and a one-page summary.

You didn't prepare it.

Your assistant did.

You just walk in and think.

That's how I want analysts to use AI.

Not to make the decision.

To prepare the folder.

Meet Prakash

Prakash is a financial analyst.

Every month he:

  • Downloads several reports
  • Copies numbers into one spreadsheet
  • Calculates growth and ratios
  • Writes a summary for his manager

The analysis takes one hour.

The copying takes five.

Hand over the copying

AI assistants that can work with files are good at exactly the boring part: combining, cleaning, calculating, summarising.

Bad:
Analyse these reports.
 
Good:
Combine revenue and net profit from these three
quarterly CSVs into one table. Add quarter-on-quarter
growth. Flag any number that changed more than 20%.
Don't interpret the results, just prepare the table.

"Don't interpret, just prepare."

That keeps the AI on the folder, not the decision.

Always check the numbers

AI can misread a column.

It can mix up thousands and lakhs.

It can confidently round something it shouldn't.

So Prakash spot-checks:

  • A few random cells against the source
  • Totals against the original reports
  • Anything flagged as unusual

Five minutes of checking beats five hours of copying.

The judgment stays human

Once the table is ready, Prakash does the real job.

Why did margins fall?

Is this a one-off?

What should we tell the manager?

That's what he's paid for.

Not copy-paste.

Final thoughts

Nobody became an analyst to copy numbers between spreadsheets.

Let AI prepare the folder.

You bring the thinking.

And maybe, just maybe, go to sleep before 2 AM.