FileFreely Reconcile · Accounts payable

Supplier Statement Reconciliation

Compare a supplier statement with your accounts payable ledger. Find missing invoices, amount differences, duplicate references, and credits that need review.

Files and financial values stay in this browser. No accounting login or upload to a server.

1. Upload
2. Configure
3. Reconcile
4. Review
5. Export

Download sample files and see the finished Excel report · Recurring layout setup

1. Choose and preview your files

Select the data table from each file. This tool supports digital PDFs with selectable text. Scans require an OCR export first.

2. Confirm the scope and map columns

Supplier name Currency Reconciliation type Amount basis Statement cutoff Date scope

Use one supplier and one currency in both files. Open balances must be exported as of the cutoff. Document dates alone cannot reconstruct historical balances.

Both files cover the same supplier, currency, reporting scope, and amount basis.

Remember column positions and parsing preferences on this device.

Saved preferences exclude supplier names, file names, dates, values, and reviewer notes. Review remembered positions when a file layout changes.

Choose both files to start.

4. Review reconciliation

Exceptions can be legitimate timing or allocation differences. Confirm suggested pairs only after checking both sources.

Filter Search reference

Category	Reference	Statement	Ledger	Difference	Statement source	Ledger source	Evidence	Status	Review

5. Export

How to reconcile a supplier statement against a ledger

Compare the supplier’s invoice references and signed balances with an accounts payable export for the same supplier and cutoff. For an open-items statement, compare balances still outstanding as of that date. For a period statement, use ledger activity from the same dates. Review missing items before changing the ledger.

How does FileFreely handle duplicates?

If a reference appears more than once on either side, the report keeps all source rows for review. Suggested matches use the same signed amount and transaction type with dates within three days, and require confirmation.

What does an amount mismatch look like?

If the supplier lists INV-104 at $420 on PDF page 2 and the ledger lists it at $400 on row 18, the signed difference is +$20. The report shows both source locations and leaves the item open.

Can I reconcile a scanned PDF?

Use a digital PDF with selectable text, CSV, or XLSX for the statement. If you only need to export tables first, use PDF to Excel and CSV.