Can't ChatGPT or Claude do this?

No. General-purpose AI is great at "summarize this PDF," but it can't "reconcile 200 pages of POs with 200 pages of invoices, item by item." Two reasons: (1) Page limit: general AI can't process long documents at once — it forgets along the way. (2) Structure: accurately reading which cell is which item from a PDF layout requires a specialized engine. That's what "M10 Bolt" vs "M-10 Bolt" matching needs. The same goes for transcription: ask a general AI for an Excel file and it regenerates the workbook, breaking merged cells, formulas, and print settings. Totsugo is purpose-built for reconciliation and transcription — it writes only the values into your original template.

Can we verify the accuracy before committing?

Yes. When you get in touch we will walk you through checking the matching accuracy and speed on the documents you already work with. Pricing depends on your scale and the systems you connect, so we quote individually.

What if the AI misses something or gets it wrong?

Every match is displayed with its evidence — exactly which part of the left document was compared with which part of the right. AI never finalizes anything on its own: a human always makes the final call. If you spot a mistake, fix it on the spot and confirm with Enter. There is no "AI silently made a mistake somewhere" failure mode.

What types of documents are supported?

Invoices, purchase orders, receipts, delivery notes — virtually all standard business documents. AI understands even custom layouts. Faxed documents and PDFs with handwriting work as-is.

Does Totsugo also do transcription, not just reconciliation?

Yes. Totsugo transcribes PDF checksheets into your own Excel templates, and auto-creates freee invoice drafts from COREC order data. Excel transcription writes only the values into your original template, so merged cells, formulas, and print settings never break. In both cases AI drafts the work and a human reviews cell by cell, then confirms with Enter.

Do we need to change our workflow?

No. Just upload the PDFs you already use. No format changes or system integrations required.

How is my uploaded data handled?

All traffic is encrypted via SSL/TLS, and stored data is encrypted at rest. Your documents are never shared with third parties without your consent. See our Privacy Policy for details.

How long does setup take?

Create an account with your email, pick a plan, and you can start immediately. The whole flow is online and self-serve — no initial setup needed.

Excel Invoice Reconciliation: Complete Guide to VLOOKUP and Its Limitations

Excel is the go-to tool for invoice reconciliation. But after years of relying on VLOOKUP, many accountants discover its hidden limitations. This guide covers both the basics and the advanced challenges.

What is Invoice Reconciliation?

Definition

Invoice reconciliation is the process of matching invoices against source documents (purchase orders, delivery notes) to verify accuracy.

Step	What You Check	Why
1	Vendor name	Correct supplier
2	Items/quantities	What was ordered
3	Prices	Agreed amounts
4	Totals	Math accuracy
5	Dates	Timing correctness

Why It Matters

Risk	Consequence
Overpayment	Direct financial loss
Duplicate payment	Cash flow impact
Fraud	Legal exposure
Audit findings	Compliance issues

Basic Excel Reconciliation with VLOOKUP

Many accountants rely on VLOOKUP. Here’s the standard approach.

The Basic Formula

=VLOOKUP(A2, Sheet2!A:C, 3, FALSE)

Parameter	Meaning
A2	Lookup value (e.g., Invoice number)
Sheet2!A:C	Range to search
3	Column to return
FALSE	Exact match required

This works… as long as the data matches perfectly.

Step-by-Step Process

Step	Action	Time
1	Import invoice data	5 min
2	Import PO data	5 min
3	Add VLOOKUP formulas	10 min
4	Review errors	30+ min
5	Clean data	30+ min
6	Re-run formulas	10 min
Total	Per batch	90+ min

Other Excel Functions for Matching

Function	Use Case	Limitation
VLOOKUP	Vertical search	Left-to-right only
HLOOKUP	Horizontal search	Limited use
INDEX/MATCH	Flexible lookup	Complex formula
XLOOKUP	Modern replacement	Not in older Excel
COUNTIF	Count matches	No detail retrieval

When Excel Fails: The 5 Critical Limitations

Excel sees characters, not meaning. Here are the common failure points.

Limitation 1: The “Inc.” Problem

Invoice	PO Data	Result
ABC Inc.	ABC Corporation	#N/A
XYZ Ltd	XYZ Limited	#N/A

Humans know it’s the same company. Excel thinks it’s different. You waste time manually cleaning this up.

Limitation 2: The Invisible Space

Data A	Data B	Result
“Totsugo “ (trailing space)	“Totsugo”	#N/A
“ Totsugo“ (leading space)	“Totsugo”	#N/A

CSV exports often contain hidden spaces. Finding them is a nightmare.

Limitation 3: Format Variations

Variation	Data A	Data B	Result
Thousands separator	1,000	1000	#N/A
Character width	ＡＢＣ (full)	ABC (half)	#N/A
Case	abc	ABC	May fail

Limitation 4: 1-to-N Matching

Scenario	Challenge
1 invoice, 2 POs	VLOOKUP finds first only
Combined shipment	Must manually sum
Split delivery	Cannot auto-match

Limitation 5: Scale Problems

Volume	VLOOKUP Performance
100 rows	Fast
1,000 rows	Slow
10,000 rows	Very slow
100,000+ rows	May crash

The True Cost of Excel Limitations

Time Spent on Data Cleansing

Task	Time per Month	Annual
Removing spaces	30 min	6 hours
Standardizing names	1 hour	12 hours
Fixing formats	30 min	6 hours
Investigating #N/A	2 hours	24 hours
Total	4 hours	48 hours

Error Risk

Issue	Probability	Impact
Missed match	High	Unpaid invoices
Wrong match	Medium	Overpayment
Duplicate	Low	Double payment

Workarounds (That Still Have Limits)

Workaround 1: TRIM and CLEAN Functions

=VLOOKUP(TRIM(CLEAN(A2)), Sheet2!A:C, 3, FALSE)

Fixes	Doesn’t Fix
Spaces	Abbreviations
Non-printable chars	Typos

Workaround 2: SUBSTITUTE for Known Variations

=SUBSTITUTE(SUBSTITUTE(A2,"Inc.",""),"Corp.","")

Works When	Fails When
You know all variations	New variations appear

Workaround 3: Helper Columns

Create normalized versions of data for matching.

Original	Normalized
ABC Inc.	ABC
ABC Corporation	ABC

Problem: Maintenance overhead is high.

Beyond Excel: AI-Powered Matching

Stop wasting time on data cleansing.

How AI Handles Variations

Variation	Excel	AI
Inc. vs Corporation	❌ Fails	✓ Matches
Trailing spaces	❌ Fails	✓ Matches
Full/half-width	❌ Fails	✓ Matches
Typos	❌ Fails	✓ Matches
1-to-N	❌ Manual	✓ Auto

AI Accepts Data “As Is”

Totsugo’s AI automatically absorbs variations:

“Inc.” and “Corp.” = Match
Full-width/Half-width = Match
Typos = Contextual Match

The pre-processing you did in Excel is no longer needed. Just upload, and AI handles the rest.

Time Comparison

Task	Excel	AI
Data import	10 min	2 min (upload)
Data cleansing	90 min	0 min
Matching	30 min	Instant
Error review	60 min	10 min (exceptions)
Total	3+ hours	15 min

When to Stay with Excel

Excel still makes sense in some situations:

Situation	Recommendation
< 50 items/month	Excel may suffice
Perfect data quality	Excel works
No budget	Excel is free
One-time task	Excel is quick

When to Move to AI

Situation	Recommendation
100+ items/month	Consider AI
Frequent #N/A errors	AI recommended
Hours spent cleansing	AI saves time
Staff turnover	AI reduces dependency

Frequently Asked Questions

Q. Can AI work with my existing Excel files?

A. Yes. Upload your CSV or Excel files directly.

Q. Is AI matching 100% accurate?

A. No matching is 100%, but AI consistently outperforms VLOOKUP on varied data.

Q. What about my existing VLOOKUP workflows?

A. You can use AI alongside Excel. Export results back to Excel.

Q. How long does it take to learn?

A. Most users are productive within 10 minutes.

Summary

Method	Strength	Weakness
Excel VLOOKUP	Free, familiar	Demands perfect data
Excel with cleanup	Handles some issues	Time-consuming
AI matching	Handles all variations	Subscription cost

Stop wasting time on data cleansing. Let AI handle the messy reality of business data.

👉 Try AI Matching with Totsugo