The Scenario
You are a bookkeeper. Your client has 200 rows of bank transactions in a Google Sheet — date, description, and amount. Your job this week 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 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 sheet 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 Google Sheet 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 sheet. 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 with either the receipt ID or "no match." Two hundred rows in a fraction of the time it would take you to do it by hand.
What You Get
A reconciled transaction sheet 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 B 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 — payments Altoviz recorded but the bank never confirmed.
Fetch all Altoviz receipts from the last 60 days. Cross-reference them against the amounts in column B of my bank statement sheet. Write unmatched Altoviz receipts (those with no corresponding bank row) into the "Gaps" sheet 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 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 B. 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 — in one pass
The accountant wants everything in one workbook, not three separate exports.
Search Altoviz for a receipt matching each row in my bank statement 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 "Unmatched Receipts" sheet. Add a summary at the top of the main sheet: 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 sheet, 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 Google Sheets overview.