All guides
Reports and decks

Updated 4 min read

Do the books match the bank?

Two exports in, the exceptions out: a reconciliation table, a chart, a one-page PDF for the bookkeeper and a five-slide deck, all from one thread with the Accountant.

Lena asks for a chart of what was recorded against what reached the bank, per customer. The Accountant replies with a horizontal bar chart of Recorded as paid against Identified in bank export for five customers, with no bank bar for Tischlerei Nachbar.
Screenshots in this guide come from a demo account for an invented joinery, Hoffmann Tischlerei.

End of the month at Hoffmann Tischlerei, and Lena wants one answer: does what the books say customers paid in August match what actually reached the bank? She has two exports, the payments she recorded and the bank statement for the same weeks. Brigitte Sauer, the bookkeeper, needs a summary, and on Monday the team meets.

This is one thread with the Accountant, four messages long. Every picture below is the real reply.

Two files in, the exceptions out

Lena attached both CSV files to one line: reconcile them and show me anything that doesn't match.

A thread with the Accountant headed by the request to reconcile August's recorded payments with the bank export. The reply's How I got this is open and lists recorded-payments.csv and bank-statement.csv. Under it a table titled 2 recorded payments do not reconcile: Familie Brandt recorded 2,100.00 euros, bank 2,050.00, gap 50.00; Tischlerei Nachbar recorded 1,500.00, bank 0.00, gap 1,500.00; total gap 1,550.00 euros. A spreadsheet, august-payment-reconciliation-2026.xlsx, is attached.

Three customers matched, Familie Wagner, Architekturbüro Lenz and Café Ostend, each arriving two days after the recorded date. Two did not: Familie Brandt paid fifty euros short, and a recorded payment from Tischlerei Nachbar never showed up in the bank at all. That is €1,550 the books can't account for, and the working is attached as a spreadsheet.

The table in the reply was not typed by the Accountant. It wrote a short program that read both files, and the program printed the table. The app draws it from those numbers, so what you read is what was computed.

How I got this

Every reply starts with a quiet line, Done in 48s, that opens to the steps it took. Beside it, How I got this opens to what the reply drew on: the files it read, the web pages it looked at, the colleagues it asked. Here it is the two CSVs, and pressing one opens it beside the thread.

The line stays with the reply after a reload, so a week later you can still see which files a number came from.

Ask for the picture

Lena asks for a chart of what was recorded against what reached the bank, per customer. The Accountant replies in 27 seconds with a horizontal bar chart titled Brandt and Nachbar account for the August reconciliation gap: a black bar for Recorded as paid and a blue bar for Identified in bank export for Architekturbüro Lenz, Café Ostend, Familie Wagner and Familie Brandt, and only a black bar for Tischlerei Nachbar. A source line under it names August payment reconciliation.

The chart is drawn in the thread, not left as a file to download. The same program computed the bars from the same two files, and the line under it says where the figures came from. A chart, a table or a row of headline numbers in a reply is part of the reply: it doesn't clutter the Files screen.

One page for the bookkeeper

Next: a one-page PDF for Brigitte, with the chart, the two exceptions and what she should chase this week.

The top of the PDF's first page as the thread shows it: the heading Zahlungsabgleich August 2026, a line reading Hoffmann Tischlerei, Für Brigitte Sauer, 21. Oktober 2026, and a German summary of the 1,550.00 euro difference, Brandt provisionally matched and Nachbar with no August payment.

The PDF came back in German. Nobody asked for that. Brigitte is German, and the Accountant wrote the document in her language. If you want English, say so in the next line.

Documents like this one are written as a page and then rendered on A4 by the platform. Before replying, the Accountant looks at the rendered pages and fixes what is wrong, such as a table running off the page or a chart over the footer. The reply then shows the first page, so you can read it before you open it.

The same numbers as slides

The last line asked for five slides for Monday's team meeting, with speaker notes.

Lena asks for five slides for Monday's team meeting with speaker notes. The Accountant replies in 47 seconds under the heading August exceptions need verification, not automatic chasing, with three numbers: August reconciliation gap 1,550 euros, Brandt difference 50 euros, Nachbar unmatched record 1,500 euros. It attaches august-payment-reconciliation-team-meeting-2026-10-26.pptx, 43 KB, and shows slide 1: Hoffmann Tischlerei, and the title August payments: verify two exceptions.

A deck comes as two files: a PowerPoint you can open and edit, and a PDF of the same slides. The reply shows slide 1. Charts in the PowerPoint are real PowerPoint charts, not pictures of charts.

The deck carries the business's name. You can give it the business's own look in Settings, under Your business, in Logo and colour: the logo then sits on the title and closing slides and the colour replaces the house accent. The AI Employees never draw a logo themselves and never take one from your website.

What runs underneath

Everything past the first question ran as a program the Accountant wrote, in an isolated sandbox with no network. It sees the files named for that run, files the person asking could already open, and nothing else in the account.

The limits, as the code sets them today:

  • a program runs for at most 30 seconds
  • at most 5 files in and 5 files out per run, 25 MB in total
  • each person can run 20 of these an hour
  • Python with pandas, numpy, openpyxl, python-docx and python-pptx, and nothing can be installed

The sandbox stays with the thread for ten minutes of quiet, which is why the chart, the PDF and the deck each started from the two CSVs already there instead of asking for them again.

Where the files end up

The spreadsheet, the PDF and the deck are ordinary files: on the Files screen with everything else. The spreadsheet and the PDF open in the document panel beside the thread; the deck downloads. To send the PDF to Brigitte, ask the Assistant: once a mailbox is connected, the email waits on a card you approve, with the file attached.

For receipts and supplier invoices rather than bank exports, see Receipts in, books out.

Try it on your own business.

One subscription covers all five AI Employees and everything in these articles.

No password. We email you a link, and it signs you in.