The 13-week cash forecast, without an Excel model
Cash by week, refreshed every Monday from open items, plan and VAT.
of cash
by weekevery week
recalculatedsources
open items, plan, VATChallenge
For the investor, the company needed a 13-week cash forecast. It lived in an Excel model that was fed by hand every week.
Open items, plan and VAT came from different sources. Every update took time and was prone to errors.
Solution with Arc
Arc calculates cash for 13 weeks directly from the open items, the plan and the VAT dates of both entities.
Every Monday the new forecast is ready, with the items behind each week.
Result
The 13-week forecast is rebuilt every Monday, without an Excel model.
Management and the investor see every week when cash gets tight, and why.
How it runs with Arc
Your ERP has the data.
Arc does the work.
Live in 24 hours. Read-only access at the source, hosted in Germany, GDPR-compliant.
Book an intro callMore use cases
From Private Equity. See all use cases
Company details anonymised.