A guide for wineries in the Valle de Guadalupe and beyond
How do I automate my winery's reports?
A winery report can build itself once each number is entered a single time, in digital form, where it is taken, and one view connects those sources and refreshes through the day. Most wineries start with the report that costs the most hours by hand, and time it before and after the change.
What does automating a winery's reports mean?
Automating a winery report means the report assembles itself from data that already exists, with nobody copying numbers from one place to another. Whoever used to gather the numbers can spend that time reading them and deciding.
The reports a winery tends to build by hand are the harvest, ripeness by vineyard section, lot tracking and the finance numbers. Each one can be automated on its own, so there is no need to do them all at once.
Why do winery reports take so long to build by hand?
Winery reports take long because the numbers usually sit in several places that do not talk to each other. Someone has to visit each one, copy the data and reconcile it, and by the time the report is done the picture may already be old.
Where Monte Xanic's harvest numbers lived before the system
- In a production system.
- In Excel files.
- In paper notebooks out in the rows.
During harvest that delay costs more, because a picking decision can turn on a day or two. A report that arrives late can mean deciding on last week's data.
What are the steps to automate a winery report?
Automating a winery report usually goes in short steps: pick one report, find where each number comes from, change data entry so each number is recorded once, and connect it all to a view that refreshes itself. The order matters more than the tool.
Steps to automate a winery report
- Pick a report your team builds by hand often, and time how long it takes, with a clock, before you change anything.
- Write down where each number in it comes from: the production system, a spreadsheet, a field notebook or the lab.
- Change data entry so each number is recorded once, in digital form, where it is taken, whether at the lab bench or in the vineyard.
- Connect those sources to one view that refreshes through the day, tied to what the winery already knows, like its vineyard sections and its lots.
- For a few weeks, check the automated report against the hand-built one, and retire the manual version once the two agree.
- Time the automated report again, so you know what you saved in your own case.
How much time does automating a winery report save?
The time saved by automating a winery report depends on how much hand work it takes today and how many sources it pulls together. That is why it pays to measure each case, before and after, on the same report.
One measured case, at Monte Xanic. One finance workflow at Monte Xanic now takes about 97 percent less time: about an hour down to about two minutes. The hour was timed by hand before the build; the two minutes are the dashboard's refresh, and the view is refreshed through the day; about 97 percent is the distance between them. No Monte Xanic production, sales or financial figure appears here.
That figure comes from one workflow at one winery. Another report may save more or less time, depending on its sources and how much of it is built by hand today.
Which winery reports are worth automating first?
The best first candidate is usually the report built most often, from the most sources, that loses value when it arrives late. At many wineries that is the harvest report in season or the weekly finance report.
Signs a winery report is a good candidate for automation
- Someone rebuilds it by hand every week or every day.
- Its numbers come from two or more different places.
- When it is late, a decision gets made on stale data.
- The data is written on paper first and typed into a computer later.
What should you ask before hiring someone to automate your winery's reports?
Before you hire anyone to automate your winery's reports, find out who owns the data and the code, whether the system works with the sources you already have, and how the result will be measured. Two similar proposals can leave you with very different things.
Questions for comparing report automation proposals
- Are the data, the code and the accounts in the winery's name?
- Do I have to leave my production system or my spreadsheets, or does the new system connect to them?
- How often does the report refresh, and who checks that the numbers reconcile?
- How will the time saved be measured, before and after?
Cardon Digital builds custom software for wineries and other businesses, with reports that build themselves and the data in your name. See custom software
Sources
Every outside fact in this guide links to the page it comes from, read on the date the guide was last updated.
- Monte Xanic case history (opens in a new tab)Cardon DigitalWhere the harvest numbers lived, what changed, and the measured time of one finance workflow, with its basis.
Common questions about automating winery reports
Do I have to replace my production system to automate my reports?
Not necessarily. At Monte Xanic the production system, the spreadsheets and the notebooks still hold their numbers; what changed is that one view pulls them together on its own, and going to get them is no longer anyone's job.
Can a report that comes from paper notebooks be automated?
Yes, once the number starts being captured in digital form where it is taken, for example at the lab bench or in the vineyard. While the number lives only on paper, someone still has to type it in.
How often does an automated winery report refresh?
It depends on how it is designed and how often the data arrives. In the Monte Xanic case the view refreshes through the day, so a reading is current from the moment it is taken.
How do I start automating my winery's reports with Cardon Digital?
With the diagnostic, which is free: ten business days looking at your operation, and a written memo at the end that is yours, covering what is true, what is broken and what to build first.