Reconcile two totals with AI
Compare a CSV export with a statement or a second export. The result identifies the difference, the rows that might explain it and the amount still outstanding.
Reconcile two totals with AI when a spreadsheet and a statement disagree and you need to show somebody why. With reconcile-two-totals you can ask for the amount of the gap, the evidence for each proposed explanation and the number still outstanding.
Suppose an export contains a fee on the first day of the next statement period. Its amount may explain the difference, although the fee belongs in the account and should stay in the file. Checking the dates first keeps an innocent difference from turning into an unnecessary edit.
What it does
- Compare money out over the same period, account and currency.
- Look for a row whose amount matches the discrepancy.
- Check candidates for duplication using the date, amount and description.
- Test whether recording one value with the opposite sign explains the gap.
- Read the source row and the remaining difference beside each finding.
Install and use
- Install the skill in your agent and use a deterministic calculation tool, such as a spreadsheet formula or a local script you can inspect. No bank connection is needed.
- Give both sources, their date ranges and the meaning of each total. Try “Compare this export with the statement’s money-out figure and cite the rows you use.”
- Check the proposed explanations against the originals. If two rows fit equally well, ask to see both before drawing a conclusion.
FAQ
Source
Made by FolioFlux. Original skill: reconcile-two-totals, published on GitHub under the MIT licence.
View on GitHub