Event Agency Cash Flow Crisis: Excel vs AI Financial Control

Excel vs integrated platform: Event Makers case study. €41K hidden liquidity gap, 50 spreadsheets, zero real visibility. SME financial intelligence solution.

Fogli Excel disorganizzati con evidenziato gap liquidità €41K, metafora gestione finanziaria PMI eventi inefficace
Real-world financial crisis case study of Event Makers agency: revenue decline from €410K to €315K, operating losses of €209K, and critical €41K cash flow discrepancy hidden in Excel spreadsheets. Demonstrates the tangible risks of manual financial tracking versus integrated cash flow management ...

Key Takeaways

Summary

Event Makers, a B2B corporate event agency in Verona, Italy, discovered a €41,000 cash gap between their Excel spreadsheets and actual bank balance in September 2025. The agency managed fifty interconnected Excel files manually updated monthly by an external accountant, which showed €123,000 in available cash when only €82,000 existed in the bank. The discrepancy resulted from client receivables stuck in 90-day payment delays that Excel displayed as collectible within 30 days, plus a disputed €15,000 wire transfer. Between 2023 and 2025, while revenue declined from €410,000 to €201,000, personnel costs surged from 36% to 54.7% of revenue, far exceeding the 40% industry benchmark for event agencies. Gross margin per event eroded from 28% to 19% as supplier costs increased 12-15% without corresponding client price adjustments. Client portfolio concentration reached critical levels with two clients representing 68% of total revenue, creating severe dependency risk. The core problem was not Excel's functionality but its passive nature requiring manual investigation of anomalies, cross-referencing of data, and daily monitoring that the entrepreneur and monthly accountant could not provide.

Event Makers: The Hidden Cash Gap in Spreadsheets

Fifty Excel files. Zero real visibility. How an event agency discovered too late that “compliant” numbers concealed a €41K gap


Paolo Rinaldi has managed Event Makers, a B2B corporate event agency in Verona, since 2018. When describing his financial control system, the answer is immediate: “Excel.” One spreadsheet for monthly budget, one for costs per event, one for margin per client, one for projected cash flow, one for year-over-year comparison. Fifty interconnected files, manually updated once a month by an external commercialista (Italian CPA and business advisor).

In September 2025, Paolo discovered that available cash in the bank account was eighty-two thousand euros, not the one hundred twenty-three thousand his budget Excel indicated. The forty-one thousand euro difference was not a transcription error. It was the sum of client receivables blocked by payment delays that Excel showed as “collectible within thirty days” but which in reality had been stuck for ninety days, plus a fifteen-thousand-euro wire transfer for a June event that the client had disputed for “non-conforming service” and would probably never arrive.

The problem was not the commercialista’s dishonesty or Paolo’s incompetence. The problem was that Excel, by its nature, shows what it’s told to show. It doesn’t automatically explore whether receivables entered as “collectible” are actually collected. It doesn’t investigate whether clients who always paid punctually have started delaying. It doesn’t cross-reference accounting balance with actual bank balance to highlight discrepancies. Excel is a passive tool. It waits for someone to manually update the data, and shows the result. Nothing more.

The Invisible Information Gap

Event Makers closed 2023 with four hundred ten thousand euros in revenue and an operating loss of two hundred nine thousand euros. In 2024 revenue dropped to three hundred fifteen thousand euros, the loss reduced to forty-six thousand euros. In 2025 revenue further declined to two hundred one thousand euros with an operating loss of forty-two thousand euros. The numbers seem to tell a story of gradual improvement: losses are reducing, the situation is under control.

But these aggregate numbers hide critical dynamics that Excel doesn’t spontaneously highlight. Personnel costs, which in 2023 represented thirty-six percent of revenue, rose to fifty-four point seven percent in 2025. This means that today over half of revenue is absorbed by salaries before considering any other costs. The benchmark for event agencies indicates a maximum sustainable incidence of forty percent.

Gross margin per event, which in 2023 averaged twenty-eight percent, dropped to nineteen percent in 2025. This erosion occurred gradually, event after event, without any automatic alert highlighting it. Audio-visual suppliers increased prices by fifteen percent, location costs grew by twelve percent, but client pricing remained unchanged because “the market won’t accept increases.” The result is insufficient margin to cover fixed costs.

Client portfolio concentration reached critical levels. Two clients represent sixty-eight percent of total revenue. When one of these two communicated in October 2025 the decision to reduce the 2026 event budget by fifty percent, Paolo suddenly realized that sixty thousand euros of projected revenue had evaporated. But this dependence was already present in 2024. Simply, no one was monitoring it with the necessary frequency.

What Excel Cannot Do

Excel’s fundamental problem is not lack of functionality. It’s possible to build complex spreadsheets with advanced formulas, automated macros, and dynamic charts. The problem is that Excel requires someone to actively decide what to search for, which data to cross-reference, which anomalies to investigate. And it requires that someone have the time and expertise to do this every day.

Paolo Rinaldi is not a professional CFO. He’s an entrepreneur who manages events, coordinates suppliers, maintains relationships with corporate clients. He doesn’t have the skills or time to build predictive dashboards, program automatic alerts when critical indicators exceed thresholds, or train machine learning models on client behavioral patterns. His commercialista updates Excel spreadsheets once a month with accounting data, but doesn’t have daily visibility on bank movements, actual payment delays, or granular margin composition by client.

The information gap is this: the difference between aggregate numbers that are correct from an accounting standpoint, and operational intelligence that identifies problems when they’re still solvable. Excel provides the former. An integrated financial intelligence platform provides the latter.

The Dashboard That Explores Instead of Waiting

The fundamental characteristic distinguishing an integrated platform like Mentally.ai Copilot from Excel is that it doesn’t wait for someone to tell it what to search for. It automatically explores data in depth, cross-references five different sources in real-time, identifies anomalous patterns through machine learning trained on three hundred thousand invoices from Italian SMEs.

The automatic Cassetto Fiscale (Italian Tax Drawer, the Revenue Agency’s digital document repository) scheduled every night downloads all active and passive invoices, receipts, tax documents. This data is instantly compared with actual bank movements. If an invoice shows as “collected” in the accounting system but the corresponding wire transfer is not present in the bank account, the dashboard immediately signals the discrepancy. Paolo would have discovered the forty-one thousand euro difference not in September when he manually checked, but the very day the discrepancy was created.

Predictive cash flow analyzes the actual payment behavior of each individual client. If client X has always paid at sixty days and suddenly starts paying at ninety, the algorithm identifies the trend and automatically updates liquidity forecasts. If client Y has reduced budgets by twenty percent in the last ninety days, the platform signals the risk of further reductions. These patterns are not visible looking at aggregate monthly numbers on Excel.

What-if scenarios allow investigating the impact of strategic decisions before making them. If Event Makers had access to this tool, Paolo could have simulated: “What happens if the main client reduces budget by fifty percent?” The answer would have been immediate: insufficient gross margin in three months, need to cut one employee or acquire thirty-five thousand euros in new revenue. With four months advance notice, both options were viable.

The Cost of Delayed Control

The difference between discovering a problem today and discovering it in four months is the difference between a manageable difficulty and an irreversible crisis. Event Makers discovered the liquidity discrepancy in September. If it had discovered it in May, it could have negotiated payment terms with suppliers, activated a receivables factoring at contained discount, or downsized the structure gradually. In September, with urgent payments to face and bank credit line already utilized at eighty-five percent, remaining options were drastically reduced.

Excel is not a wrong tool. It’s an inadequate tool for managing the financial complexity of a modern SME. An integrated platform that automates complete control, cross-references multi-source data in real-time, and uses machine learning to identify hidden patterns is no longer a luxury for large companies. It’s the minimum operational standard to satisfy the continuous monitoring obligations required by regulations on adeguati assetti (adequate organizational arrangements, per Italian Corporate Code).

Paolo today is completely rethinking his financial control system. Not because Excel provided wrong data, but because Excel showed only what it was asked to show. And no one had asked it to investigate whether receivables “to be collected” were actually collectible, whether historic clients were silently reducing budgets, whether margin per event was eroding month after month. The crisis was hidden in the spreadsheets, invisible until it exploded.


Replace Excel with Predictive Intelligence

Event Makers discovered a forty-one thousand euro liquidity difference when it was too late for preventive interventions. Your company can avoid the same mistake by replacing manual spreadsheets with an integrated platform that automatically explores data instead of waiting for monthly updates.

Mentally.ai Copilot eliminates the information gap between aggregate accounting numbers and daily operational reality. Automatic Cassetto Fiscale synchronized every night, instant invoice-bank movement comparison, ML predictive cash flow that identifies payment delays before they become critical, what-if scenarios to validate strategic decisions.

For service SMEs €3M-€30M (~$3.2M-$32M USD) revenue:

Trial: €1 for 15 days complete access
Plan: €99/month for 5 companies + unlimited users


Disclaimer: Case study based on real data from Italian SME in events sector. Company name, location, personal names and numerical values modified for privacy while maintaining proportions and trends unchanged.



Data and Statistics

€41K

50

54.7%

68%

90 days

19%

300K

15%

Frequently Asked Questions

Why can't Excel spreadsheets provide adequate financial control for SMEs?
Excel requires someone to actively decide what to search for, which data to cross-reference, and which anomalies to investigate daily. Most entrepreneurs lack the time and expertise to build predictive dashboards or program automatic alerts. Excel waits for manual updates and shows results passively, without spontaneously highlighting critical dynamics like margin erosion, client concentration risk, or discrepancies between accounting balances and actual bank movements. This creates an information gap between accounting-correct aggregate numbers and operational intelligence that identifies problems early.
What are the warning signs of financial deterioration in event agencies?
Key warning signs include personnel costs exceeding 40% of revenue (Event Makers reached 54.7%), gross margin per event dropping below sustainable levels (from 28% to 19%), excessive client portfolio concentration (two clients representing 68% of total revenue), and gradual pricing erosion where supplier costs increase but client pricing remains unchanged. These dynamics often occur gradually without automatic alerts, making them invisible in monthly aggregate Excel reports until they become critical.
How does client concentration risk impact event agency sustainability?
When too few clients represent the majority of revenue, a single decision can devastate cash flow. Event Makers had two clients representing 68% of total revenue. When one client reduced their 2026 event budget by 50%, €60,000 in projected revenue disappeared instantly. This concentration was already critical in 2024, but without frequent automated monitoring, Paolo only realized the vulnerability when the loss occurred. Sustainable event agencies should monitor client concentration continuously and maintain diversified revenue sources.
How much advance notice can early problem detection provide for SMEs?
Early automated detection can provide 4-6 months advance notice instead of discovering problems when options are exhausted. Event Makers discovered their liquidity discrepancy in September when their credit line was already 85% utilized, leaving drastically reduced options. If discovered in May through automated daily monitoring, they could have negotiated supplier payment terms, activated receivables factoring at contained discounts, or downsized gradually. This time difference separates manageable difficulties from irreversible crises.
What are what-if scenarios and how do they help event agencies?
What-if scenarios allow businesses to simulate the impact of strategic decisions before implementing them. For example, Paolo could have simulated the effect of his main client reducing budget by 50%, immediately revealing insufficient gross margin in three months and the need to either cut one employee or acquire €35,000 in new revenue. With four months advance notice from such simulation, both options would have been viable, whereas delayed discovery left few workable solutions.
What is the hidden cash gap problem that event agencies face with Excel spreadsheets?
The hidden cash gap occurs when Excel shows receivables as collectible within a certain timeframe, but actual cash doesn't match due to payment delays or disputed invoices. Event Makers discovered a €41,000 gap between what their Excel budget showed (€123,000 available) and actual bank balance (€82,000). This happened because Excel is a passive tool that displays only what it's told, without automatically verifying if invoices marked as collectible are actually collected or if clients are experiencing payment delays.
How does an integrated financial platform differ from Excel for cash flow management?
An integrated platform like Mentally.ai Copilot automatically explores data in depth rather than waiting for instructions. It cross-references five different sources in real-time, including automatic Cassetto Fiscale downloads that compare invoices with actual bank movements daily. The platform uses machine learning trained on 300,000 invoices to identify anomalous payment patterns, automatically updates liquidity forecasts based on actual client behavior, and signals discrepancies the same day they occur instead of months later during manual reviews.
What is predictive cash flow analysis and why is it important?
Predictive cash flow analysis examines the actual payment behavior of each individual client and identifies changing patterns automatically. If a client who normally pays at 60 days starts paying at 90 days, or reduces budgets by 20% over 90 days, the algorithm detects the trend and updates liquidity forecasts accordingly. This allows businesses to discover problems when they're still solvable, providing months of advance notice to negotiate payment terms, activate factoring, or adjust structure, rather than facing urgent crises with limited options.
What are adeguati assetti and how do they relate to financial control systems?
Adeguati assetti refers to adequate organizational arrangements required by Italian Corporate Code, which mandate continuous monitoring obligations for companies. An integrated financial platform that automates complete control, cross-references multi-source data in real-time, and uses machine learning to identify hidden patterns represents the minimum operational standard to satisfy these regulatory requirements. Excel alone cannot provide the level of continuous, automated monitoring that adeguati assetti regulations require.
What is the difference between accounting-correct numbers and operational intelligence?
Accounting-correct numbers show aggregate financial results that comply with accounting standards but may hide critical operational dynamics. Operational intelligence identifies problems when they're still solvable by analyzing granular patterns, cross-referencing multiple data sources, and detecting anomalies automatically. Event Makers had accounting-correct data showing gradual improvement in losses, but this masked unsustainable personnel cost ratios, margin erosion, and dangerous client concentration that only operational intelligence would have highlighted proactively.