For Vista by Viewpoint · Trimble Construction One

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.

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.

  1. 1Tell us your companies
  2. 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

Step 1

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.

Step 2

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].

Step 3

Set up the email (Job Manager → Email tab)

Create a WF Notifier Job pointing at that query. On the Email tab: To = reconcile@statementzen.com, Format = Plain Text, and set the Header field to the [Feed] token so the AP feed becomes the email body. For the Subject, put a comma-separated list of the email addresses of everyone who’ll forward vendor statements to get them reconciled — e.g. “jane@acme.com.au, sam@acme.com.au”. That’s how Statement Zen links a forwarded statement to your account; add or remove people any time by editing the Subject in Vista, nothing else to regenerate.

Step 4

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.

Step 5

Forward your statements

From now on, when a supplier emails you a statement, forward it to reconcile@statementzen.com. Statement Zen reconciles it against the AP position your notifier sends — and emails the verified result back, usually within a minute.

Step 6

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.

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.

Statement ZenEnterprise tools
Cost to startFree (25 statements/month)Six figures a year
Time to set up~10 minutes3+ months of onboarding
ERP connection requiredNo — forward-only emailFull IT integration
Touches your ERPNeverDeep write-back access
How it verifies numbersProves with maths (OB + movements = CB)AI/ML probability estimate
When it’s uncertainAbstains — tells you why, costs nothingReturns a best guess
Gets smarter over timeYes — self-healing, automaticRequires vendor retraining cycles
AP team setup neededNo — AP admin does it aloneIT + vendor + project team

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 reconcile@statementzen.com 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 reconcile@statementzen.com. 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 emails back a verified reconciliation report — usually within a minute. No portal, 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 reconcile@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 we’ll send the full line-by-line result back in 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.

Free — 25 statements / month