Automate Business Excel

Who it's for

Administrative managers at manufacturing SMBs who manage production progress on shared Excel files over the network. When the file hits 50,000 rows it takes over 3 minutes to open, macros crash and nobody knows who changed what. Traceability is zero, frustration is maximum.

Sales reps and area managers who update weekly sales reports by copying data from the CRM, the ERP, and distributor emails. Every Friday they lose 3-4 hours aligning the numbers — hours taken away from actual selling.

Purchasing managers and logistics teams who track supplier orders on spreadsheets with colour-coded columns for status. When a supplier calls about an urgent matter, finding the right order takes 10 minutes of searching through tabs and filters.

Controllers and CFOs at companies with 20-200 employees who produce the monthly management report for the board by pulling data from 4-5 different systems, importing it into Excel, reworking it and formatting it. The process takes 2-3 days at month-end, and the figures shown are already 48 hours old.

Owners of service businesses (engineering firms, agencies, consultancies) who manage project progress, hours logged per client and deadlines on sheets shared via Google Drive or SharePoint — with the constant risk of losing changes or working from outdated versions.

Problems it solves

Untraceable manual entry errors. In an Excel file shared by 5 people, any cell can be modified by anyone with no change log. A typing error on a production cost can propagate through dozens of linked formulas before being caught — often only when the month's margin comes out inexplicably negative.

Files that become unusable as the company grows. A spreadsheet that works fine at 500 rows starts slowing down above 10,000 and becomes unstable above 50,000. Growing companies periodically have to discard months of structure and start over — or keep working on a system that crashes twice a day.

No real-time visibility. Data in Excel is static: it shows the situation as of the last manual update. In an operational context that changes every hour (orders, stock levels, deadlines), having data that is 24 hours old means making decisions on incomplete information.

No granular access control. Excel has no proper permission system: either you can see the whole file, or you can't. There is no way to let a warehouse worker edit only the quantity column without also giving them access to purchase prices or margins.

Recurring manual reporting. Every week or month, someone in the company spends hours copying data from Excel, reworking it, formatting it and sending it to management. This process adds no value — it only takes time away from more productive activities.

No integration with other systems. Excel is an island. Data entered there must be manually re-entered into the ERP, the CRM, or the accounting software. Every manual transfer is an opportunity for error.

Key features

Automatic source data import. The system connects to your existing software (ERP, e-commerce, banking, management systems) and imports data automatically at defined frequencies — hourly, daily, or in real time via API. No copy-paste, no CSV files to download and re-upload.

Structured data entry forms. Instead of free cells, the system guides the user through validated fields: drop-down lists for categories, numeric value checks, mandatory fields. Format errors are blocked at the point of entry, not discovered weeks later.

Centralised calculation engine. Calculation rules (margins, commissions, production costs, prices) are defined once in the system and applied uniformly to all data. No duplicate formulas in different cells that can diverge because a change was made in only one place.

Real-time dashboards and reports. Reports are generated automatically from the data in the system: nobody has to open Excel, select data, copy-paste and format. Charts update in real time and are available to all authorised users from a browser or mobile app.

Permission and role management. Each user accesses only the data and functions relevant to their role. The warehouse worker sees stock levels but not purchase prices. The sales rep sees their own customers but not their colleagues'. The administrator has full visibility with a log of every change.

Complete history and audit trail. Every change is recorded with date, time and the responsible user. If a figure changes unexpectedly, you can trace exactly when it happened and who changed it — a feature essential for processes subject to GDPR or Legislative Decree 231/01 compliance checks.

Automatic notifications and alerts. The system can send emails or push notifications when specific conditions occur: a stock level below the minimum threshold, an overdue order, a margin below target, an upcoming payment deadline. Nobody has to manually check sheets to find anomalies.

Formatted exports. When an Excel file is still needed (to send to the accountant, for a board presentation), the system automatically generates a formatted, up-to-date file with one click — with no manual work.

Approval workflows. For processes requiring multiple levels of sign-off (a purchase order above a certain amount, a credit note, a price list change), the system automatically manages the approval flow with notifications to the responsible parties and a log of decisions.

Automatic backups and disaster recovery. Data is automatically saved to certified cloud infrastructure, with daily backups and the ability to restore any previous version. No risk of losing months of data because of a failed disk or a corrupted file.

Digital signature integration. For documents requiring formal approval (contracts, orders, minutes), the system can integrate with qualified digital signature services compliant with the eIDAS Regulation, eliminating the need to print and scan.

Mobile app for field data entry. For those working outside the office (technicians, sales reps, warehouse staff), the mobile app allows data to be entered directly from a smartphone, even offline, with automatic synchronisation when the connection is restored.

Typical workflow

Monday morning, 8:00. You open the dashboard in your browser — not an Excel file to hunt for in a shared folder. You immediately see the status of last week's orders, critical stock levels, and payment deadlines for the next 7 days. Data is updated in real time from the ERP.

8:30. A supplier calls to confirm a delivery. You search for the order in the system: you find it in 10 seconds using the search bar, see the status, attached documents and previous correspondence. You update the order status with one click. The system automatically notifies the warehouse.

10:00. The production manager wants to know how many units of a component are available. Instead of calling you, they check their own screen independently — with the permissions you set, they can see only their department's stock, not purchase prices.

Late morning. A customer order arrives. You enter it into the system via a guided form: select items from the catalogue, quantities, delivery terms. The system automatically calculates the total, applies agreed discounts and generates the order document as a PDF. Warehouse stock is automatically decremented.

14:00. The sales rep on the road enters a new contact from their smartphone. The data goes directly into the system, with no emails to process or sheets to update afterwards.

End of day. The system has already generated the daily report and emailed it to management. Nobody had to open Excel, copy data or format tables. The report shows the situation updated to the last minute of the day.

End of month. The board report is generated automatically in 2 clicks. Data is aggregated by the system without manual intervention. The CFO spends the afternoon on strategic analysis instead of copy-paste.

Integrations

ERP systems (Zucchetti, TeamSystem, SAP Business One, Dynamics 365). The system reads and writes data to your existing ERP via API or direct database connection, eliminating double data entry between the spreadsheet and the management system.

Accounting software (Fatture in Cloud, Aruba, accountant's systems). Accounting entries, issued invoices and received payments are automatically imported to feed margin and cash flow reports without manual intervention.

E-commerce platforms (WooCommerce, Magento, Shopify, custom). Online orders are imported in real time, stock levels are automatically updated after each sale, and sales data feeds commercial reporting.

CRM platforms (Salesforce, HubSpot, Pipedrive). Pipeline data, contacts and deals in the CRM are synchronised to feed forecast and commercial performance reports without manual copy-paste.

Banking institutions (PSD2 / open banking). Bank transactions are automatically imported for reconciliation with issued invoices and real-time cash flow monitoring.

Digital signature tools (DocuSign, Yousign, FirmaOggi). Documents produced by the system can be sent directly for digital signature, with automatic notification upon signing and archiving of the signed document.

Microsoft 365 / Google Workspace. For those who do not want to abandon Excel or Sheets entirely, the system can automatically generate updated files in SharePoint or Google Drive folders, eliminating only the manual production work.

Notification systems (SMTP email, Slack, Teams, SMS). Automatic alerts are sent through the channels already used in the company: email, Slack messages, Teams notifications, SMS for urgent matters.

Custom software vs off-the-shelf

The fundamental difference is not between Excel and software: it is between a manual process that depends on people's discipline and a system that enforces the rules automatically, regardless of who is working that day and their level of experience. Custom software is not a luxury — it is the elimination of a quantifiable operational risk.

Timeline, budget and process

Phase 1 — Analysis and mapping (2-3 weeks). The Graffico team analyses your existing Excel processes, identifies critical pain points and designs the architecture of the replacement system. A shared specification document is produced before a single line of code is written.

Phase 2 — Core development (4-8 weeks). Core features are developed: database, data entry forms, calculation logic, user interface. At the end of this phase you already have a working system on a test environment.

Phase 3 — Integrations and testing (2-4 weeks). Integrations with existing systems are developed and systematic testing is conducted with real users. Feedback is incorporated before go-live.

Phase 4 — Data migration and go-live (1-2 weeks). Historical data is migrated from the old Excel to the new system. Go-live happens with dedicated support to ensure operational continuity.

Indicative budget: Projects of this type typically start at €8,000-15,000 for simple systems (one process, one department, no complex integrations) and reach €30,000-60,000 for complex systems with multiple integrated modules. ROI is measured on the savings in manual hours: for a company with 5 people losing 3 hours per week on Excel processes, the investment pays back in an average of 8-14 months. No subsequent annual licence fees.