Reconcile supplier statements in Vista — by forwarding an email
Set up a one-time Workflow Notifier so Vista quietly sends Statement Zen your open AP position. Then just forward supplier statements to reconcile them, math-verified, in minutes. No connection to your ERP, nothing to install.
Everyone else asks an AI to guess your balance. We prove it — or we tell you we can’t.
The query builder below is free to try, no account needed. Connecting it to Statement Zen — so it can actually reconcile statements — needs a free account and a quick log in first.
1. Build your Workflow Notifier query
Enter your company number(s) and we’ll generate the exact query — and the Vista screens to paste it into. It runs entirely in your browser; nothing is sent anywhere.
- 1Tell us your companies
- 2Set it up in Vista
Enter the company number you run AP in. Multiple companies? Separate them with commas — e.g. 1, 1,2 or 1,4,7.
Why do we ask for this?
Vista often holds several companies — including test or dummy companies, and entities you don’t reconcile supplier statements for. The query you paste decides which companies’ AP position gets sent to Statement Zen. By entering only the companies you actually reconcile, you keep test data and irrelevant entities out, and send exactly what matters — nothing more.
Your personalised Vista setup will appear here
Enter your company number above and we’ll generate the exact screens to copy into Vista.
2. The two-minute setup
Sign up & log in
Before anything touches Vista: create a free Statement Zen account (no card required) and log in. Everything from here on — generating the query, wiring up the Notifier, and getting your unique forwarding address — happens inside your dashboard, most of it walked through automatically by the Connect Vista wizard shown further down this page.
Create your free account →Generate your query
Enter the Vista company number(s) you run accounts payable in (above), then copy the two boxes it produces — a Select box and a From / Where box, customised to your companies and ready to paste.
Create the Notifier Query
In Vista, open WF Notifier Queries and add a new query. Paste the ① Select box into the Select field and the ② From / Where box into the From / Where Clause field. Save it — that gives you a query with one output column called [Feed].
Set up the email (Job Manager → Email tab)
Create a WF Notifier Job pointing at that query. On the Email tab: To = your unique Statement Zen address. Don't have one yet? Create a free account, then click Connect Vista from Home → Connections to generate it. Format = Plain Text, and set the Header field to the [Feed] token so the AP feed becomes the email body. No Subject line needed — the unique address is how Statement Zen links the feed to your account. Invite teammates from the dashboard and they can forward statements too — no separate setup needed.
Create your free account →Set the schedule (Job Manager → Info tab)
On the scheduling tab, set Query Type = WF Notifier Query and choose how often it runs — daily, or weekdays only, works well. Pick a start time, set the start date, and save. That’s it — you only do this once and never touch it again.
Forward your statements
From now on, when a supplier emails you a statement, forward it to your unique Statement Zen address (the same one from the email setup step above). Statement Zen reconciles it against the AP position your notifier sends — and posts the verified result to your Statements dashboard, usually within minutes.
It never touches Vista
The notifier only reads your open AP position and emails it out. Statement Zen never logs in, never writes back, and can’t change anything in Vista or Trimble Construction One. It only ever reads what you choose to send.
3. What you’ll see once you’re signed in
Once you’re logged in, click Connect Vista from Home → Connections. This guided wizard walks you through the exact steps above and, on the last step, hands you your unique forwarding address — nothing to copy from this page by hand.
Connect Vista (Trimble) — preview
0 - Plain Texttype this yourselfyour unique Statement Zen addresstype this yourselfRevealed on the last step, once you confirm you've set the query up in Vista.
[Feed]type this yourselfThis token expands the query's Feed column into the email body.
What Statement Zen does for Vista AP teams
Vendor statement reconciliation automation for Viewpoint Vista and Trimble Construction One, built on the principles that matter to an AP team.
Proves it — or tells you it can’t
Statement Zen doesn’t guess. It does the maths: Opening balance + every signed movement = Closing balance, to the cent. When that equation closes, the result is proven and you can trust it without re-checking. When it doesn’t close, it tells you exactly why.
Abstains rather than be wrong
A wrong figure you trust is worse than no answer at all — that’s the one that becomes a late-night hunt three weeks later. Statement Zen refuses to hand you a confidently wrong number. It proves it, or it abstains. Never a silent wrong answer.
About one-twentieth the cost of doing it by hand
One supplier statement, reconciled by hand, is about half an hour — call it $20–25 of an AP team member’s time. Statement Zen does the same statement for around $1. Your first 25 every month are free. That’s reconciliation at roughly one-twentieth of what it costs today.
Can’t touch your ERP — by design
There is no connection to Vista by Viewpoint or Trimble Construction One. Your AP position is sent by Vista’s own Workflow Notifier — an outbound email you configure once. Statement Zen never logs in, never reads your database, and cannot change a single thing in your system.
Gets smarter automatically
Every statement it can’t reconcile today becomes a training signal. The system diagnoses the gap, tests a fix, and ships it — automatically, at no cost to you. Statements that abstain today may reconcile on their own next month.
Live in ten minutes, no IT required
The setup is one paste into Vista’s Workflow Notifier — something an AP administrator does in under ten minutes. No software to install, no API integration, no IT security review, no vendor onboarding. The enterprise tools that do this take three months and six figures to stand up.
What accounts payable statement reconciliation actually costs you today
Use your own numbers. The maths is the same for every Vista AP team.
By hand
~$20–25
per statement
Half an hour of an AP team member’s loaded time, every statement, every month. Forty statements? That’s two and a half days of your month, gone.
Statement Zen
~$1
per proven statement
First 25 every month are free. Paid plans from $99/100 statements · $299/300 · $899/1,000. You only pay for statements we mathematically prove.
The difference
~1/20th
the cost
You’re swapping a $20 job for a $1 one, and getting that half-hour back every single time. Proven, not guessed.
The enterprise AP automation tools that do this start at six figures a year, take three months to onboard, require your IT team, and still hand you a best guess a human has to check. Statement Zen is free to start, live in ten minutes, never touches your ERP — and proves it instead of guessing.
Statement Zen vs enterprise reconciliation tools
How supplier statement reconciliation automation for Construction One compares to the conventional enterprise stack.
Cost to start
Time to set up
ERP connection required
Touches your ERP
How it verifies numbers
When it’s uncertain
Gets smarter over time
AP team setup needed
Frequently asked questions
Real questions from Vista and Trimble Construction One AP teams.
Does Statement Zen connect to, read from, or change my Vista data?
No. Statement Zen never connects to Vista by Viewpoint or Trimble Construction One. Your AP position is sent to Statement Zen by Vista's own Workflow Notifier — an outbound-only email Vista sends on a schedule you control. Statement Zen receives that email and the supplier statement you forward. It never logs in to Vista, never reads your database directly, and cannot write, modify, or delete anything in your ERP. Your Vista system and your accounting data remain exactly as secure as they are today.
Which Vista versions does Statement Zen support — Vista, Vista by Viewpoint, or Trimble Construction One?
All three names refer to the same product. Trimble acquired Viewpoint in 2018 and rebranded Vista by Viewpoint to Trimble Construction One. Statement Zen works with all versions: legacy Vista, Vista by Viewpoint, and Trimble Construction One. The Workflow Notifier SQL query this page generates is compatible with all of them.
How does the Vista Workflow Notifier work with Statement Zen?
You paste a one-time SQL query into Vista’s Workflow Notifier (Workflow Query Manager + Job Manager). The query reads your open AP position — posted invoices, unapproved invoices, and batch-stage items — and emails that data as a pipe-delimited feed to your unique Statement Zen address, created when you connect (Home → Connections → Connect Vista), on a schedule you set (daily works well). Statement Zen uses that AP position to match against incoming supplier statements. You configure this once and never touch it again.
How do I reconcile a supplier statement in Vista by Viewpoint?
Set up the Workflow Notifier once using the query generator on this page. After that, whenever a supplier emails you a statement, forward it to your unique Statement Zen address (the same one your notifier emails to). Statement Zen reads the statement, proves the closing balance using Opening balance + Σ(signed movements) = Closing balance to the cent, matches every line to your Vista AP ledger, and posts a verified reconciliation report to your Statements dashboard — usually within minutes. No data entry, no upload screen.
What does it cost to reconcile vendor statements in Trimble Construction One with Statement Zen?
The first 25 reconciled statements every month are free. Paid plans are $99/month for 100 statements (Starter), $299/month for 300 statements (Pro), and $899/month for 1,000 statements (Business). You only pay for statements Statement Zen can mathematically prove — if a statement can’t be proven, it’s flagged for review and costs you nothing.
What happens when a supplier statement doesn't reconcile?
Statement Zen abstains rather than hand you a confidently wrong number. If it cannot mathematically prove the closing balance or cannot tie a line to your AP ledger, it tells you exactly why — which line is unmatched, which amount differs, or what the discrepancy is. That statement does not consume a credit. The principle: a wrong figure you trust is far more damaging than an honest 'I can't prove this one.'
How is Statement Zen different from AI tools that guess the reconciliation?
Most reconciliation tools use machine learning or large language models that produce a probability-weighted answer — they guess, and humans check. Statement Zen is deterministic: it proves Opening balance + Σ(signed movements) = Closing balance to the cent using arithmetic. There is no model to drift, no probability to interpret, and no confidence score to second-guess. If the maths closes, the result is proven. If it doesn’t, Statement Zen abstains. It never emits a confidently wrong number.
Do I need IT support or an ERP integration to set up Statement Zen for Vista?
No IT involvement and no ERP integration are required. The setup is a one-time paste of a SQL query into Vista’s Workflow Notifier — something an AP administrator can do in under ten minutes. There is no software to install, no API credentials to configure, no IT security review, and no vendor onboarding process. If you can use Vista’s Workflow Notifier, you can set this up yourself.
Still have a question?
Email your question to support@statementzen.com and we’ll reply with a real answer for your exact case. To reconcile a supplier statement, set up the notifier above first — then forward it and the full line-by-line result appears in your Statements dashboard within minutes.
Start reconciling today
Set up the notifier above, forward your first statement, and let Statement Zen prove your numbers. Free — 25 statements every month.
You only ever pay for statements we can mathematically prove. If we can’t prove it, it’s a free credit.