Drop your Horizon CSVs and supplier statements. Lyne matches every line, flags genuine queries, and recognises invoices already paid in Stacked — so AP stops chasing what isn't a problem.
How Lyne works
Once a month — drop the 4 Horizon CSVs. Run statement_rec_pack_v5_2.sql in SSMS, save each result as CSV (Sheet 1 / 2 / 4 / 5), drag them into the Horizon-data box. Four pills go green; the box collapses to a single line.
Drop your supplier statements as they arrive. PDF or XLSX. Lyne auto-detects format (Ingram, VOW, Westcoast, Videnda, Change Org plus any onboarded ones) and matches every line.
Click any supplier in the sidebar to see what matched, what's in query, what's still open. Settled invoices appear with a teal Paid in Stacked pill — those are normally fine, the supplier is just slow to clear them off the statement.
Use the Action queue card on this page to send query emails or missing-invoice requests in batches. Recent sends are logged so chases don't fall through the cracks.
Mark each supplier reconciled when the difference is €0. The green Reconciled · signed badge only appears when the math is clean. Anything else gets Marked — review needed in amber.
Generate the report at month-end — that's the audit-ready evidence pack with a tab per status: matched / mismatch / GRNI / on-statement-not-open / only-in-Stacked / paid-in-Stacked.
Each upload is fresh truth — yesterday's marks persist, but Lyne will prompt you to re-confirm if the new data shows new unmatched lines on a previously-reconciled supplier. The Tie-Out tab is admin/monthly close-prep — most users never need it.
Horizon data · admin / monthly
Run statement_rec_pack_v5_1.sql, save each result as CSV, drop here.
Drop PDF or XLSX statements from suppliers. Format auto-detected.
No statements loaded yet.
Reconciled
—
of active portfolio
Open exposure
—
awaiting statements
Awaiting statement
—
A/B suppliers without a statement
Statements loaded
—
files dropped this session
Action queue
Send these out — turn unmatched lines into supplier responses.
Queries to send
0
No queries flagged
Missing-invoice requests
0
No stmt-only lines
✉ Emails sent
0
No emails yet
Complete reconciliation
Generates a full Excel report — cover sheet with portfolio KPIs, plus matched / mismatch / GRNI / only-on-statement / only-in-Stacked detail tabs. Hand to the accountant as month-end evidence.
Reconciliation status mix
Drop Horizon CSVs and statements to populate
€ reconciled · last 3 months
No history yet — generate a complete reconciliation each month to build the trend.
Top suppliers by absolute difference
Drop Horizon CSVs and statements to populate
No supplier selected
Pick a supplier from the sidebar after dropping files on Overview
Supplier balance
—
what they say we owe
Stacked at cutoff
—
recon target
Difference
—
supplier − cutoff
Reconciling difference
Tick the statement back to Stacked, line by line.
Status
Supplier ref Stacked ref
Date
Cust Ref (PORD)
Statement
Horizon
Δ
All suppliers · 0
Supplier
Bucket
Status
Their balance
Stacked balance
Difference ↓
Drop Horizon CSVs and supplier statements on Overview to begin.
1Supplier details
Used by the missing-invoice / query report drafts on the Individual tab.
2Anchor invoices
Tell the app one to three lines that appear on this statement so it can detect the column layout. One is enough for a brand-new supplier with a single invoice — two or three boost confidence.
3Sample statement
Drop one sample statement
PDF, XLSX or CSV. The exact one the supplier sent — don't redact or edit it.
No file chosen yet.
All filled? Hit detect to test the layout.
4Detection report
Fill in the form on the left, drop a statement, then click Detect layout. The result lands here — counts, confidence, sample rows, and Save / Reject buttons.
Saved parsers
No saved parsers yet — onboard a supplier above to start the library.
Supplier categories
Suppliers are grouped A → D by importance, based on 12-month spend and balance.
A Top tier — biggest spend, must reconcile every monthB Material — reconcile monthlyC Smaller — reconcile when statement comes inD Low value / dormant — handle manually
A Onboarded
—/ —
B Onboarded
—/ —
C Onboarded
—/ —
D Onboarded
—/ —
—%
Drop the Horizon shortlist on Overview to populate
AllAlready onboardedNot yet onboardedLow confidence (<60%)A onlyB onlyC onlyD only
Supplier
Code
Class
Ccy
Parser
Confidence
Last test
Last reconciled
Action
No saved parsers and no shortlist loaded. Onboard a supplier or drop Sheet 1 on Overview.
Tie-Out data
· admin / monthly
Each month, drop your five Tie-Out CSVs here and Lyne does the rest.
The fastest way: open the folder where they live, click the first file,
hold Shift and click the last one so all five are highlighted,
then drag them onto this panel. They'll sort themselves into the right
slots automatically — you don't need to load them one by one.
Prefer to browse? Click Choose and pick all five (hold Ctrl
as you click each one).
Nominal balance · missingLedger total · missingPer-supplier · missingINR · missingNOMJ on 69 · missing
Tie-Out equation · period
Supplier ledger total (Σ TRADER.BASE_BALANCE)€0.00
Reconciled€0.00
Queried€0.00
Explained€0.00
Unaccounted€0.00
Sum of buckets€0.00
Balances
Structural reference · Finance admin only
Creditors Control 310 closing (NOMINAL_HISTORY)€0.00Supplier ledger total (Σ TRADER.BASE_BALANCE)€0.00Structural variance (nominal − ledger)€0.00
The variance is historical (intercompany / accruals / migration ghosts on nominal 310). It does not move month-to-month and is a separate Finance investigation, not part of the monthly rec.
Lines by bucket
AllReconciledQueriedExplainedUnaccounted
Supplier
Ref
Doc date
Value
Bucket
Source
Explanation
NOMJ direct postings to nominal 69
These postings hit Creditors Control without a supplier-ledger entry. Most common cause of Grid 1 ≠ Grid 2.
Date
Ref
Trader
Narrative
Value
Source rows
Re-confirm reconciled suppliers
Supplier
Was reconciled
Now
Action
Action queue
Email log
🏆
Milestone unlocked
Great progress.
Link to a Stacked ref
Type a new ref — invoice posted in Horizon after the SQL export