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. Supplier Handoff
- 6. 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
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.
Saved preferences exclude supplier names, file names, dates, values, and reviewer notes. Review remembered positions when a file layout changes.
Import unresolved items from an earlier statement
Choose a FileFreely carry-forward JSON for the same supplier, currency and amount basis. Download your register before changing the inputs if you want to keep this run’s notes and approvals.
No carry-forward file selected.
Choose both files to start.
4. Review reconciliation
Exceptions can be legitimate timing or allocation differences. Confirm suggested pairs only after checking both sources.
| Category | Reference | Statement | Ledger | Difference | Statement source | Ledger source | Evidence | Status | Review |
|---|
5. Supplier Handoff
Review the internal register and approve each item you want to share. Download the carry-forward file to review unresolved items at a later cutoff.
Internal action register
| Reference | Automated result | Action status | Carry-forward review | Review |
|---|
Supplier message
Only approved references and explicitly selected statement dates or amounts are included. Keep private information out of the wording you enter.
Edit message wording
6. Export
The Excel report includes the internal Action Register. The JSON contains matching evidence and status history, so keep it private. Notes, filenames and complete source documents are excluded from the JSON.
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.
Analytics preferences
Allow Google Analytics to count a page view. Your files and form fields stay outside the analytics frame.