The Scenario
You are a bookkeeper. Your client has 200 rows of bank transactions in an Excel workbook — date in column A, description in column B, amount in column C. Your job is to match each payment to an Altoviz receipt and flag any unmatched transaction for the accountant to review.
The end-of-quarter deadline is Friday at noon. It is Wednesday morning. The workbook is on SharePoint.
The bad version of this week:
- Open Altoviz → Receipts → search for a payment amount
- Check the date — does it match?
- If yes, paste the receipt ID into column D
- If no, write "no match" and move on
- Repeat 200 times
- Miss three matches because the bank rounds to two decimal places and Altoviz stores three
- Hand the accountant a workbook with 12 unexplained "no match" entries that turn out to be rounding differences.
The fast version is one prompt.
The Easy Way: One Prompt in SheetXAI
SheetXAI is an AI agent inside your Excel workbook that searches Altoviz for a matching receipt against each transaction row and writes the result back — matched ID or "no match" — without you touching each row manually.
Open the SheetXAI sidebar and type:
Search Altoviz for a receipt matching the amount and date in each row of my "Transactions" tab. Write the matching receipt ID into column D, or write "no match" if none is found.
SheetXAI works through every row, searches Altoviz by amount and date, and populates column D. Two hundred rows resolved without you touching a single one.
What You Get
A reconciled workbook with every row resolved:
- Receipt IDs in column D — for every row where a match was found in Altoviz
- "no match" in column D — for every row that needs the accountant's attention
- All 200 rows covered — no manual searching, no rows left blank because you ran out of time
The accountant only looks at the "no match" rows. Everything else is confirmed. That is the actual time saving — not the searching, but the triage.
What If the Data Is Not Quite Ready
Bank statement reconciliation always has edge cases. SheetXAI handles them in the same prompt.
When amounts differ by rounding
The bank records £1,234.56 and Altoviz has £1,234.560. Or the bank shows £99.99 and Altoviz has £100.00 after a rounding rule.
Search Altoviz for a receipt matching the amount in column C within a tolerance of £0.02 and the date in column A within 1 day. Write the matching receipt ID into column D, or "no match" if none found within tolerance. Flag any match made with tolerance in column E as "FUZZY MATCH."
When you need the unmatched receipts too
The accountant also wants to know which Altoviz receipts from the last 60 days have no corresponding bank transaction.
Fetch all Altoviz receipts from the last 60 days. Cross-reference them against the amounts in column C of the "Transactions" tab. Write unmatched Altoviz receipts (those with no corresponding bank row) into the "Gaps" tab with receipt ID, customer, amount, and date.
When the bank statement uses a different date format
The bank exported dates as "14/03/2026" but Altoviz stores them as ISO format. A direct date match fails.
Before matching, convert all dates in column A of the "Transactions" tab from DD/MM/YYYY format to ISO YYYY-MM-DD format. Then search Altoviz for a receipt matching the converted date and the amount in column C. Write the receipt ID or "no match" into column D.
When you need the full reconciliation output — matched rows, unmatched rows, unmatched receipts, and a summary count — all in one pass
The accountant wants everything in one workbook, not three separate tabs.
Search Altoviz for a receipt matching each row in the "Transactions" tab by amount and date. Write receipt IDs into column D for matches, "no match" for misses. Fetch all Altoviz receipts from the same period that have no matching bank row and write them into the "Gaps" tab. Add a summary at the top of the "Transactions" tab: total transactions, matched count, unmatched count, and total unmatched value.
The pattern: the full reconciliation picture — both directions — from one prompt.
Try It
Get the 7-day free trial of SheetXAI and open any bank statement or transaction workbook, then ask it to match each row against Altoviz receipts. The Altoviz integration is included in every plan. For related workflows, see how to pull outstanding invoices for aged-debt analysis or the Altoviz in Excel overview.