Productivity · LinkedIn · 🇧🇷 Brazil
Setting up a monthly bank reconciliation routine with AI
A finance professional describes how to use ChatGPT to cross-check a bank statement against the general ledger and flag differences.
- Profession
- Accountant, Financial Analyst
- Source
- pt.linkedin.com ↗
- Country
- 🇧🇷 Brazil
- Report date
- July 26, 2026
- Verified on
- October 24, 2026
What they did
He tested a ChatGPT mode that takes files and runs tasks in steps to compare the bank statement with the general ledger, and Codex to turn the comparison into a routine that repeats every month.
How it went
The author concludes that the tool cuts time spent on repetitive tasks but does not replace professional judgment. The account gives no numbers.
Good to know
Bank statements contain sensitive banking data: use an authorized corporate environment or anonymize first. Review every discrepancy flagged.
The prompt
I'm going to send you the bank statement for [month] and the ledger for account [code] (anonymized data). Compare entry by entry by date and amount, list what doesn't match in a table and suggest the likely cause of each difference. Don't change anything, just flag.
Replace what is in [brackets]. Prompt written by us from the account, not a literal copy of the source. Do not paste other people’s personal data (privacy laws such as LGPD and GDPR apply).
Summary in our own words. Results as stated in the original account; we have not tested or audited them. Read the source ↗ Found a mistake?
Similar cases
01Testing AI with technical accounting questions before trusting it
The president of CRC-RS says he tested ChatGPT with technical questions in the field and found the answers satisfactory.
02One week to find an apartment in San Francisco
A new hire used Claude and ChatGPT to list property managers and filter listings by price and area.
03Private chef and ski trip arranged during a dog walk
Paul Metcalfe gives spoken instructions and ChatGPT requests quotes, reads replies and summarizes the options.
04A 5-day meal plan that becomes a grocery cart
With the Instacart plugin, the author asked for a plan with no fish or pork and got the list already in the cart.
05A morning summary of school emails with ready-made replies
A mother created a Gmail label and an agent that summarizes the folder and drafts replies for her to edit.
06Recipes picky kids will eat, organized by Codex
Beth Gebhard asked for recipes from a favorite site; the agent filtered them, rated them and created a spreadsheet and a Drive folder.
07Estimating how long your AI plan will last before it runs out
A dev published an open calculation to estimate how many tokens fit into the Pro/Max plans.
08Sending AI summaries and research straight to your Kindle
A developer built a Go MCP in minutes that lets Claude or Codex send texts to a Kindle.