CashFlow Pro: construction cash flow software for Viewpoint Vista
Numbers come straight out of Vista. No spreadsheet sits in the middle of it. The cash you are holding right now, what is due in, what you owe, and where every job stands.
CashFlow Pro is cash flow forecasting software for construction companies running Viewpoint Vista. It reads your Vista data and builds one view of it. Cash on hand, what you are owed, what you owe your vendors, and how each job is performing. You can run the forecast weekly or monthly, out to 24 months. SelectView Data Solutions builds and supports it.
At a Glance
What it is
A cash flow forecasting and financial visibility app for construction
Data source
Viewpoint Vista ERP
Forecast horizon
Up to 24 months, weekly or monthly
Main areas
Dashboard, Project Forecasting, Cash Flow In, Cash Flow Out, G&A
Built for
CEOs, CFOs, controllers, finance teams, IT leaders and project managers
On every screen
A worklist, analytics and an Excel export
Built by
SelectView Data Solutions
Why is cash flow so hard to forecast in construction?
Construction cash flow is hard to forecast because the money moves on contract terms, not on the calendar. A pay application can sit in approval for weeks. Retainage on a job you finished in March might not land until it closes out in November. Costs don’t wait for any of that. Your ERP knows every piece of it, which is the frustrating part. Vista stores the data – seeing it all in one place is the key. Most finance teams fill the gap with a spreadsheet. Somebody pulls the AR aging on Monday and somebody else pulls the AP aging. The payroll figures get keyed in by hand. Then the file goes around by email. By Wednesday there are four copies of it and nobody’s certain which one is live. The spreadsheet is usually right on the day it is built. What it can’t do is keep up. A customer pays two weeks early, a change order gets approved, a subcontractor finally invoices for work from last quarter. None of that reaches the forecast until somebody sits down and rebuilds the thing. During tight cash positions, the spreadsheet must be keyed and maintained. Once the crisis is averted, it no longer makes sense to spend time populating the spreadsheet – but you won’t see the next crisis coming. CashFlow Pro keeps the numbers tidy, up to date, and streamlined so that you always know what is going on.
What is CashFlow Pro?
CashFlow Pro takes financial data out of Viewpoint Vista and turns it into a working cash flow forecast. Receivables, payables, job financials and payroll all land in one place. From there, the app works forward to show what your cash position looks like over the coming weeks and months. Viewpoint Vista data is your starting point. With CashFlow Pro, you can modify when you expect receipts from customers, set payment dates for AP, and forecast monthly project revenue. At each step, you see the expected upcoming cash position. Most of the spreadsheet work a finance team does by hand goes away. There’s no weekly rebuild. Whatever you’re looking at is current as of the last sync, and the app tells you when that was. This is construction cash flow software, not a general finance tool with a construction label on it. Retainage, pay applications and over and under billing are part of how the forecast works. They aren’t things you adjust for afterward. There are five areas: a Dashboard, Project Forecasting, Cash Flow In, Cash Flow Out and G&A. Each one has a worklist you can genuinely work from, with analytics underneath it. There’s an Excel export too, for the people who prefer having a file.
What does CashFlow Pro show you?
Your cash position, receivables, payables, job financials and payroll costs each get their own page. The Dashboard is the summary you open first. The detail sits in the other four.
Area
What it shows
Dashboard
Cash today, the lowest cash week ahead, open AR to collect and bills to pay. Below that sits a chart and table of expected cash in, cash out and ending balance by week or month. You pick the bank accounts the starting cash comes from.
Project Forecasting
Every Vista job with contract amount, percent complete, earned, billed, over or under billed, received and cash flow to date. The analytics show forecast earned revenue by month, forecast profit and net project cash flow.
Cash Flow In
Every open invoice with due date, expected pay date, aging, retention and notes. The analytics show expected inflow by day, week or month, aging by customer, cash arriving in the next four weeks, and a collection focus list of your largest overdue invoices.
Cash Flow Out
Every open supplier invoice with due date, anticipated pay date, outstanding amount, retention held and pay terms. The analytics show outflow by day, week or month, aging by vendor, the next four weeks, and vendor concentration.
G&A
Your general and administrative costs, mainly payroll. The last four actual payroll weeks come from Vista. The next 13 weeks are forecast: headcount, hours, gross wages, employer burden and total labor cost. Forecast amounts can be edited by hand and filtered by department. Payroll taxes and deductions sit below.
Cash Flow In and Cash Flow Out both take custom entries, which matters more than it sounds. A receipt or a cost you know about but haven’t raised in Vista yet can go straight in. Maybe you have an equipment sale coming up. Maybe there’s a planned infusion of cash. The forecast picks it up without waiting for the ERP to catch up.
How does CashFlow Pro build the forecast?
The forecast starts from what Vista already knows, then lets you correct it. Expected payment dates come from each customer’s own history, not the terms printed on the invoice. That’s usually the bigger of the two differences. Override any date by hand if you know something the data doesn’t. The app keeps a record of the change.
Payment dates based on behavior, not terms
A customer on 30-day terms who has never once paid inside 50 shouldn’t be sitting in your 30-day bucket. CashFlow Pro dates the invoice from how that customer actually behaves. If you know something it doesn’t, change the date yourself. The history of what changed stays attached to the invoice.
Retainage kept on its own line
Retainage is money you’ve earned and can’t touch yet. The same is true in reverse for what you’re holding back from a subcontractor. CashFlow Pro keeps both on their own lines. Neither one quietly inflates a week where the cash isn’t actually due.
Your own starting cash
You pick which bank accounts the opening balance comes from. Anything you’d rather keep out of the picture stays out of it.
Things Vista hasn’t seen yet
Projects you’ve won but haven’t set up can be entered. So can any receipt or cost that lives outside the ERP. The forecast treats them the same as everything else.
Who in a construction company uses CashFlow Pro?
Different people want different things out of the same set of numbers. Leadership is interested in the cash position and not much else. Finance lives in the worklists, and project managers only really care about their own jobs. All of it comes from your Vista data, so nobody’s waiting on somebody else’s export.
Role
What they use it for
CEOs and owners
One view of cash and project health, without asking finance for a report first.
CFOs and controllers
Collections, vendor payments, payroll forecasting and the weekly cash position.
IT and technology leaders
Vista data in one place, instead of a queue of report requests.
Project managers
Contract value, billing, costs and profit on the jobs they run.
Finance and accounting teams
The AR and AP worklists they already work from every day.
What changes when the forecast stops being a spreadsheet?
The questions stay the same. What changes is how long it takes to answer them. Below is what a finance team normally does by hand, and where the same answer already sits in CashFlow Pro.
The question
By hand
In CashFlow Pro
How much cash will we hold in eight weeks?
Rebuild the workbook
The Dashboard chart
Which week ahead looks tight?
Read across the row
The lowest cash week, on the home page
Which overdue invoices do we chase first?
Sort the aging export
The collection focus list
Which jobs are underbilled?
Ask the controller
Project Forecasting, over and under billed column
What will payroll cost next quarter?
A separate workbook
The G&A 13-week forecast
Are we too exposed to one vendor?
Nobody checks
Vendor concentration, in Cash Flow Out
How does CashFlow Pro connect to Viewpoint Vista?
CashFlow Pro reads from your Viewpoint Vista database on a sync. The time of that last sync shows in the app, so you are never guessing how current a number is. Vista stays the system of record, and nothing is posted back into it. Everything on screen traces back to a Vista record. The AR worklist is your Vista invoices. The job list is your Vista jobs, and the payroll history is what Vista already paid out. Because none of it is retyped, there’s nothing to reconcile afterward and no argument about whose number is right. SelectView builds Power BI reporting on Viewpoint Vista data, and CashFlow Pro came out of that work. Knowing where things actually live in the Vista schema is most of the job with an app like this one.
What CashFlow Pro doesn’t do
CashFlow Pro is a forecasting and visibility app. There are a few things it deliberately leaves alone.
There’s no write-back to Vista
CashFlow Pro reads, and Vista stays the system of record.
It isn’t a billing system
Pay applications and AIA forms continue to be produced wherever you produce them today.
The payroll forecast runs 13 weeks
That 24-month horizon applies to the cash flow forecast on the Dashboard, not to G&A.
It’s built on Viewpoint Vista data
If your financials live somewhere else, have a conversation with us before booking a demo.
Frequently Asked Questions
What is cash flow forecasting?
Cash flow forecasting means working out how much cash a business will be holding at some point in the future. Start with what you’ve got today, add what you expect to collect, then subtract what you expect to pay. The arithmetic is the easy part. In construction the hard part is timing. When you actually get paid depends on pay applications, approvals and retainage. The terms printed on the invoice matter far less.
What is a 13-week cash flow forecast?
A 13-week cash flow forecast projects cash in and cash out a week at a time for the next quarter. It’s the standard short-term horizon in finance. Thirteen weeks is close enough that the numbers hold up, and far enough out that you can still do something about them. CashFlow Pro uses 13 weeks for the payroll forecast, and runs overall cash weekly or monthly out to 24 months.
Does CashFlow Pro work with Viewpoint Vista?
Yes. CashFlow Pro reads its data from Viewpoint Vista. Accounts receivable, accounts payable, job financials and payroll all come from your Vista database.
How far ahead can CashFlow Pro forecast?
Up to 24 months, shown weekly or monthly. The payroll forecast in the G&A area runs 13 weeks.
How does CashFlow Pro work out when a customer will pay?
It goes on how that customer is paid you before, not on the terms printed on the invoice. Any expected payment date can be changed by hand, and the app keeps a record of the change.
Does CashFlow Pro handle retainage?
Yes, on both sides. What you’re owed and what you’re holding back are tracked on separate lines. The forecast won’t count money as collectible or payable before it really is.
Can we add things that aren’t in Vista yet?
Yes. Projects you have won but have not set up can be entered by hand, and so can any receipt or cost that isn’t in Vista yet. They feed the forecast alongside everything pulled from Vista.
Is there a cash flow dashboard?
Yes. The Dashboard is the home page of CashFlow Pro. It shows cash today, the lowest cash week ahead, open AR to collect and bills to pay. Below that sits a chart and table of expected cash in, cash out and ending balance by week or month.
Can we get the numbers into Excel?
Yes. There’s an Excel export on every area.
Does CashFlow Pro change anything in Vista?
No. It reads from Vista and doesn’t write back. Vista stays the system of record.
Who is CashFlow Pro for?
Construction companies running Viewpoint Vista. It’s construction cash flow software, built around the way contractors actually get paid. It won’t suit a business that bills on a simple invoice cycle. In practice, owners and CEOs live on the Dashboard. Finance teams work the AR and AP worklists, and project managers stay in the job view.
Let’s look at your cash position
A demo on your own Vista data tells you more than demo data ever will. You’ll be looking at your own jobs, your own customers and your own cash position. Twenty minutes is usually enough to see whether the forecast agrees with what your controller already knows. The interesting part is where it does not. Tell us a bit about your setup and we’ll find a time.