JSON Data Export for SMEs in Italy: TeamSystem Guide 2026

Explore JSON architecture for Italian SMEs: export management data, interoperability, and automation. Learn Python code insights and €74K ROI benefits.

Architettura JSON per interoperabilità software gestionale PMI italiane con connessioni tra ERP e sistemi cloud
Architectural diagram illustrating JSON integration between ERP management systems (TeamSystem, Zucchetti) and business intelligence tools for Italian SMEs. Shows data interoperability flows between accounting software, banking, and investor-ready automated presentations, highlighting data...

Key Takeaways

Summary

JSON (JavaScript Object Notation) is emerging as the standard interoperability protocol for the financial software stacks of Italian SMEs, addressing the issue of informational fragmentation among heterogeneous systems. Italian SMEs with revenues between €5 million and €50 million typically operate with fragmented software: legacy ERP systems like TeamSystem and Zucchetti that use proprietary formats, tax accounting based on XML for electronic invoices, multiple home banking systems using PDFs and CSV extracts, and business intelligence tools often limited to Excel with macros. JSON solves this problem by acting as an explicit data contract between systems, ensuring type safety, controlled versioning, automatic validation via JSON Schema, and auto-generated documentation. Unlike traditional CSV exports that present ambiguities regarding data types, non-standardized data formats, and encoding issues, JSON offers explicit types, dates in ISO 8601 format, hierarchical structures through nesting, contextual metadata, and native UTF-8 support. The reference architecture for a JSON-centric Composable Finance Stack involves the integration of presentation layers, analytics, AI, data transformation middleware, API layers, and legacy core ERPs, enabling end-to-end automation from transactional data to investor-ready presentations without manual intervention.

JSON Export for Italian SME Business Data: Interoperability Architecture Guide

How JSON enables the Composable Finance Stack ecosystem for CFOs, analysts, and strategic business advisors

Technical guide to JSON-centric implementation for SME financial software stacks: from TeamSystem to automated investor-ready presentations


Executive Summary for Decision Makers

This document explores how JSON (JavaScript Object Notation) is becoming the de facto interoperability protocol for Italian SME financial software stacks, with specific focus on three areas:

  1. JSON business data export: Data extraction architectures from legacy ERP systems (TeamSystem, Zucchetti) to cloud-native ecosystems
  2. JSON management software interoperability: Data contracts between heterogeneous systems (ERP, BI, AI, presentations)
  3. JSON automated presentations: End-to-end pipelines from transactional data to investor decks without manual intervention

Target audience: CFOs, finance analysts, commercialisti (Italian CPAs and business advisors) focused on strategic consulting (not tax-only compliance)

Unique angle of this document: While technical literature explains JSON generically, this paper defines architectural patterns specific to Italian SMEs, considering regulatory constraints (cassetto fiscale from Agenzia delle Entrate/Italian Revenue Agency, Codice della Crisi/Italian Crisis Code), technological constraints (TeamSystem predominance), and operational constraints (limited IT resources).


Part 1: JSON as Data Contract Layer in Modern Financial Stacks

1.1 The Problem: Information Fragmentation in Traditional SME Stacks

A typical Italian SME (€5-50M revenue) operates with a software stack composed of:

Layer Typical Software Native Data Format Export Method
Core ERP TeamSystem Studio/Azienda, Zucchetti Proprietary DB (MSSQL/Oracle) Manual CSV, batch XML
Accounting/Tax ERP integration + cassetto fiscale AdE XML electronic invoices XML SDI, CSV extracts
Banking Multiple online banking (3-5 banks average SME) PDF statements, OFX files Manual PDF/CSV download
Business Intelligence Excel macro-driven, Tableau/Power BI (10% of SMEs) XLSX, .hyper (Tableau) Manual periodic import
Presentations PowerPoint, Google Slides .pptx Office Open XML format Manual copy-paste
AI/Analytics ChatGPT, Claude, emerging platforms like Mentally JSON native JSON API calls

Fundamental problem: Each layer speaks a “different language” → integration requires repeated manual conversions → errors, data latency, impossible automation.

JSON-centric solution: Adopt JSON as universal interchange format between all layers, with legacy ERPs exporting JSON and modern systems natively consuming/producing JSON.

1.2 JSON as Explicit “Data Contract”

In distributed software architectures, a data contract defines the agreed data schema between producer and consumer systems, guaranteeing:

  1. Type safety: Consumer knows data structure and types in advance
  2. Versioning: Schema evolutions manageable without breaking changes
  3. Validation: JSON Schema (draft-07 standard) automatically validates payloads
  4. Documentation: JSON Schema is self-documenting (vs ambiguous CSV headers)

Concrete example: Export active invoices from TeamSystem

Traditional CSV approach:

Cliente,Fattura,Data,Importo,IVA
ACME SRL,2024-001,15/01/2024,10000,2200

Problems:

JSON contract approach:

{
  "invoices": [
    {
      "customer": {
        "legal_name": "ACME SRL",
        "vat_id": "IT12345678901",
        "pec": "acme@pec.it"
      },
      "invoice_id": "2024-001",
      "issue_date": "2024-01-15",
      "amounts": {
        "taxable": 10000.00,
        "vat": 2200.00,
        "total": 12200.00,
        "currency": "EUR"
      },
      "vat_rate": 0.22,
      "payment_terms_days": 60,
      "status": "issued"
    }
  ],
  "meta": {
    "export_timestamp": "2024-01-15T10:30:00Z",
    "record_count": 1,
    "schema_version": "1.2.0"
  }
}

Immediate advantages:

1.3 Reference Architecture: JSON-Centric Composable Finance Stack

Modern Italian SME stack diagram:

┌─────────────────────────────────────────────────────────────┐
│  PRESENTATION LAYER                                         │
│  ┌──────────────┐  ┌──────────────┐  ┌──────────────┐     │
│  │ PowerPoint   │  │ Gamma/Pitch  │  │ Tableau      │     │
│  │ (import JSON)│  │ (import JSON)│  │ (import JSON)│     │
│  └──────────────┘  └──────────────┘  └──────────────┘     │
└──────────────────────────┬──────────────────────────────────┘
                           │ JSON REST APIs
┌──────────────────────────┴──────────────────────────────────┐
│  INTELLIGENCE/ANALYSIS LAYER                                │
│  ┌────────────────────────────────────────────────────┐     │
│  │  AI Platform (e.g. Mentally, Claude, ChatGPT)      │     │
│  │  - ML analysis (pattern recognition)               │     │
│  │  - Predictive forecasting                          │     │
│  │  - Scenario generation                             │     │
│  │  Input/Output: Native JSON                         │     │
│  └────────────────────────────────────────────────────┘     │
└──────────────────────────┬──────────────────────────────────┘
                           │ JSON ETL pipelines
┌──────────────────────────┴──────────────────────────────────┐
│  DATA INTEGRATION LAYER (JSON normalization)                │
│  ┌──────────────┐  ┌──────────────┐  ┌──────────────┐     │
│  │ TeamSystem   │  │ Cassetto     │  │ Open Banking │     │
│  │ JSON export  │  │ Fiscale XML→ │  │ APIs         │     │
│  │ adapter      │  │ JSON convert │  │ (native JSON)│     │
│  └──────────────┘  └──────────────┘  └──────────────┘     │
└─────────────────────────────────────────────────────────────┘

Typical data flow scenario “Minibond investor pitch deck”:

  1. Data Sources (morning of day T):

    • TeamSystem export accounting status → JSON adapter → normalized financial data
    • Cassetto fiscale AdE download XML invoices → XML→JSON conversion → invoice dataset
    • Banks download account statements → OFX/CSV→JSON parser → bank movements
  2. Integration Layer (data merge):

    • Reconcile issued invoices vs bank receipts (match by amount/date/customer)
    • Output: financial_snapshot.json single consolidated file
  3. Intelligence Layer (AI analysis):

    • Input: financial_snapshot.json
    • Processing: ML calculates DSO (Days Sales Outstanding), DSCR (Debt Service Coverage Ratio), customer concentration, 24-month forecast
    • Output: analysis_results.json with multiple scenarios
  4. Presentation Layer (deck generation):

    • Input: analysis_results.json
    • Pitch.com API: POST /presentations/create with JSON payload
    • Output: Investor-ready 35-slide presentation in 5 minutes

Total time: 30 minutes automated vs 20+ hours manual workflow.


Part 2: JSON Business Data Export - Implementation Patterns

2.1 Technical Challenge: Legacy Non-JSON-Native ERPs

Problem: TeamSystem (98% of Italian manufacturing SMEs), Zucchetti, SAP B1 are built on pre-JSON architectures (1990s-2000s):

Solution: JSON Export Adapter Pattern

Three implementation approaches ordered by increasing complexity:

Approach Complexity Setup Cost Maintenance Ideal Use Case
1. Direct Database Query → JSON Low €500-1,500 (~$540-1,620 USD) Low SMEs with internal IT or tech-savvy commercialista
2. ETL Middleware (e.g. Zapier, Make) Medium €2,000-5,000 (~$2,160-5,400 USD) Medium SMEs without IT, limited budget, standard workflows
3. Platform API Integration (e.g. Mentally) High (vendor-managed) €0 setup + €78-150/month SaaS Zero (vendor-managed) SMEs focused on core business, outsource tech complexity

Approach 1: Direct Database Query → JSON

Prerequisites:

Python implementation example:

import pyodbc
import json
from datetime import datetime

# TeamSystem database connection
conn = pyodbc.connect(
    'DRIVER={SQL Server};SERVER=localhost;DATABASE=TeamSystem_Azienda;UID=user;PWD=pass'
)

# Customer ledger query
query = """
SELECT 
    c.RagioneSociale,
    c.PartitaIVA,
    f.NumeroFattura,
    f.DataEmissione,
    f.ImportoNetto,
    f.ImportoIVA,
    f.ImportoTotale,
    f.Scadenza
FROM 
    Clienti c
    INNER JOIN Fatture f ON c.CodiceCliente = f.CodiceCliente
WHERE 
    f.DataEmissione >= '2024-01-01'
ORDER BY 
    f.DataEmissione DESC
"""

cursor = conn.cursor()
cursor.execute(query)

# Convert results to JSON structure
invoices = []
for row in cursor.fetchall():
    invoice = {
        "customer": {
            "legal_name": row.RagioneSociale,
            "vat_id": row.PartitaIVA
        },
        "invoice_id": row.NumeroFattura,
        "issue_date": row.DataEmissione.isoformat(),
        "amounts": {
            "taxable": float(row.ImportoNetto),
            "vat": float(row.ImportoIVA),
            "total": float(row.ImportoTotale),
            "currency": "EUR"
        },
        "due_date": row.Scadenza.isoformat()
    }
    invoices.append(invoice)

# Export JSON file
output = {
    "invoices": invoices,
    "meta": {
        "export_timestamp": datetime.now().isoformat(),
        "record_count": len(invoices),
        "source": "TeamSystem_Azienda",
        "schema_version": "1.0.0"
    }
}

with open('invoices_export.json', 'w', encoding='utf-8') as f:
    json.dump(output, f, indent=2, ensure_ascii=False)

print(f"Exported {len(invoices)} invoices to invoices_export.json")

Advantages:

Disadvantages:

Approach 2: ETL Middleware (Zapier, Make, n8n)

Typical stack:

Make.com workflow example:

[Schedule: Daily 02:00]
    ↓
[TeamSystem FTP: Download CSV ledger]
    ↓
[CSV Parser Module]
    ↓
[JSON Formatter Module]
    ↓ apply schema transformation
[HTTP POST: Send to AI Platform API]
    ↓
[Google Drive: Backup JSON file]

Middleware pricing:

Advantages:

Disadvantages:

Approach 3: JSON-Native Platform Integration (Mentally, Fintech APIs)

Mentally.ai architecture example:

Mentally positions itself as an orchestration layer managing end-to-end integration complexity:

┌─────────────────────────────────────────────────────────┐
│  MENTALLY PLATFORM (SaaS)                               │
│  ┌───────────────────────────────────────────────────┐  │
│  │  DATA INGESTION LAYER                             │  │
│  │  ┌──────────────┐  ┌──────────────┐              │  │
│  │  │ TeamSystem   │  │ Cassetto     │              │  │
│  │  │ Connector    │  │ Fiscale AdE  │              │  │
│  │  │ (Native API) │  │ Connector    │              │  │
│  │  └──────────────┘  └──────────────┘              │  │
│  │  Auto-sync scheduled (nightly 02:00 AM)           │  │
│  └───────────────────────────────────────────────────┘  │
│                          ↓                               │
│  ┌───────────────────────────────────────────────────┐  │
│  │  NORMALIZATION ENGINE                             │  │
│  │  - TeamSystem DB → JSON schema transform         │  │
│  │  - AdE XML invoices → Normalized JSON            │  │
│  │  - Banking OFX → JSON transactions               │  │
│  └───────────────────────────────────────────────────┘  │
│                          ↓                               │
│  ┌───────────────────────────────────────────────────┐  │
│  │  ML ANALYSIS ENGINE                               │  │
│  │  - Pattern recognition (300K+ transactions)       │  │
│  │  - Anomaly detection                              │  │
│  │  - Forecasting (24-month horizon)                 │  │
│  └───────────────────────────────────────────────────┘  │
│                          ↓                               │
│  ┌───────────────────────────────────────────────────┐  │
│  │  JSON EXPORT API                                  │  │
│  │  GET /api/v1/financial-data                       │  │
│  │  Response: {                                      │  │
│  │    "financials": {...},                           │  │
│  │    "analysis": {...},                             │  │
│  │    "scenarios": [...]                             │  │
│  │  }                                                 │  │
│  └───────────────────────────────────────────────────┘  │
└─────────────────────────────────────────────────────────┘
                          ↓ JSON APIs
        ┌─────────────────┴─────────────────┐
        │                                    │
  ┌─────────────┐                   ┌────────────┐
  │ Gamma.ai    │                   │ Tableau    │
  │ (import     │                   │ (import    │
  │ JSON)       │                   │ JSON)      │
  └─────────────┘                   └────────────┘

Differentiating features:

Feature Mentally Platform Custom Scripts ETL Middleware
Setup time 0h (SaaS ready) 8-16h dev 4-8h config
TeamSystem integration ✅ Native certified ⚠️ Manual SQL ⚠️ CSV export
Cassetto fiscale sync ✅ Auto (AdE delegation) ❌ Manual download ⚠️ Semi-auto
ML predictive analysis ✅ Included (300K dataset) ❌ Not available ❌ Not available
JSON schema validation ✅ Automatic ⚠️ Manual implementation ⚠️ Basic
Scenario generation ✅ Simultaneous (5+ scenarios 30s) ❌ Not available ❌ Not available
Multi-format export ✅ JSON+CSV+PDF+PPTX ⚠️ JSON only ⚠️ Config dependent
Maintenance ✅ Zero (vendor SLA) ❌ High (in-house) ⚠️ Medium
Total cost 12 months €936-1,800 (~$1,010-1,945 USD) €0 license + €3K-5K labor €348-900 middleware + €1K-2K config

ROI Mentally vs alternatives (25-client commercialista firm):

Scenario A: Custom Scripts
- Setup: 16h × €80/h = €1,280 (~$1,380 USD)
- Maintenance: 2h/month × 12 × €80/h = €1,920 (~$2,075 USD)
- Total year 1: €3,200 (~$3,455 USD)

Scenario B: Make.com Middleware
- Setup: 6h × €80/h = €480 (~$520 USD)
- Subscription: €29/month × 12 = €348 (~$375 USD)
- Maintenance: 1h/month × 12 × €80/h = €960 (~$1,035 USD)
- Total year 1: €1,788 (~$1,930 USD)

Scenario C: Mentally Platform
- Setup: 0h = €0
- Subscription: €99/month × 12 = €1,188 (~$1,280 USD)
- Maintenance: 0h = €0
- Total year 1: €1,188 (~$1,280 USD)
- Added value: ML analysis, scenarios, automation

Recommendation by SME type:


Part 3: JSON Management Software Interoperability - Design Patterns

3.1 The “API-First” Mindset for SME Stacks

Fundamental paradigm shift:

Old mindset (pre-2020):

“I buy management software that does everything internally. Export reports when needed.”

New mindset (2024+):

“I compose my stack from best-of-breed tools. JSON integration is a primary requirement, not optional.”

Practical software purchasing implications:

Purchase Phase Key JSON-Centric Question Red Flag
RFP/Requirements “Does the software expose REST JSON APIs?” “We have weekly Excel export”
POC/Trial “Can I get sample JSON schema documentation?” “Contact support for export format”
Pricing “Are API calls unlimited or consumption-based?” “€500 setup fee to enable API”
Contract “Is API uptime SLA included in contract?” “API in beta, no guaranteed SLA”
Onboarding “Is OpenAPI/Swagger documentation available?” “PDF manual with cURL examples”

3.2 JSON Schema as Integration Contract

Problem: Two systems (ERP and BI tool) need to exchange “active invoices” data. Without a formal schema, each developer interprets data structure differently → runtime errors, silent bugs.

Solution: Define an explicit JSON Schema that acts as a “contract” between the two systems.

Example invoices JSON Schema (draft-07 standard):

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "$id": "https://example.com/schemas/invoices-v1.json",
  "title": "Active Invoices Schema",
  "description": "Issued invoices schema Italian SME - TeamSystem compliant",
  "type": "object",
  "required": ["invoices", "meta"],
  "properties": {
    "invoices": {
      "type": "array",
      "items": {
        "type": "object",
        "required": ["invoice_id", "issue_date", "customer", "amounts"],
        "properties": {
          "invoice_id": {
            "type": "string",
            "pattern": "^[0-9]{4}-[0-9]{3,6}$",
            "description": "Format: YEAR-PROGRESSIVE (e.g. 2024-001)"
          },
          "issue_date": {
            "type": "string",
            "format": "date",
            "description": "Issue date ISO 8601"
          },
          "customer": {
            "type": "object",
            "required": ["vat_id"],
            "properties": {
              "vat_id": {
                "type": "string",
                "pattern": "^IT[0-9]{11}$",
                "description": "Italian VAT ID"
              },
              "legal_name": {
                "type": "string",
                "minLength": 1,
                "maxLength": 200
              }
            }
          },
          "amounts": {
            "type": "object",
            "required": ["taxable", "vat", "total", "currency"],
            "properties": {
              "taxable": {
                "type": "number",
                "minimum": 0,
                "multipleOf": 0.01,
                "description": "Taxable amount (2 decimals)"
              },
              "vat": {
                "type": "number",
                "minimum": 0,
                "multipleOf": 0.01
              },
              "total": {
                "type": "number",
                "minimum": 0,
                "multipleOf": 0.01
              },
              "currency": {
                "type": "string",
                "enum": ["EUR", "USD", "GBP"],
                "default": "EUR"
              }
            }
          },
          "payment_status": {
            "type": "string",
            "enum": ["unpaid", "partially_paid", "paid", "overdue"],
            "description": "Collection status"
          }
        }
      }
    },
    "meta": {
      "type": "object",
      "required": ["export_timestamp", "record_count", "schema_version"],
      "properties": {
        "export_timestamp": {
          "type": "string",
          "format": "date-time"
        },
        "record_count": {
          "type": "integer",
          "minimum": 0
        },
        "schema_version": {
          "type": "string",
          "pattern": "^[0-9]+\\.[0-9]+\\.[0-9]+$",
          "description": "Semantic versioning"
        }
      }
    }
  }
}

Automatic validation advantages:

import json
import jsonschema

# Load schema
with open('invoice_schema.json') as f:
    schema = json.load(f)

# Load data to validate
with open('teamystem_export.json') as f:
    data = json.load(f)

# Validate
try:
    jsonschema.validate(instance=data, schema=schema)
    print("✅ Valid JSON - safe to import in BI tool")
except jsonschema.ValidationError as e:
    print(f"❌ Validation error: {e.message}")
    # Example error: "2024-1' does not match '^[0-9]{4}-[0-9]{3,6}$'"

Result: Data errors caught before import into BI tool → no corrupted dashboards, no incorrect investor reports.

3.3 JSON Schema Versioning: Evolving Without Breaking Changes

Scenario: After 6 months, you add a payment_method field (bank transfer, direct debit, card) to invoices. How do you avoid breaking existing integrations?

Best Practice: Semantic Versioning + Backward Compatibility

Change Type Example Semantic Version Bump Breaking Change?
Additive (new optional field) Add payment_method 1.0.0 → 1.1.0 (minor) ❌ No (consumers ignore field)
Additive (new required field) Add required pec_email 1.0.0 → 2.0.0 (major) ✅ Yes (old exports invalid)
Restrictive (tighter enum) payment_status now only [“paid”, “unpaid”] (was 4 values) 1.0.0 → 2.0.0 (major) ✅ Yes (existing values invalid)
Bug fix (typo correction) cutsomercustomer 1.0.0 → 1.0.1 (patch) ✅ Yes (field name changed)

Golden rule: Maintain backward compatibility for ≥12 months (e.g. support v1.x and v2.x in parallel) before deprecating old versions.


Part 4: JSON Automated Presentations - End-to-End Pipeline

4.1 Complete Architecture: From Database to Investor Deck

Complete real-world flow scenario “ExtraMOT minibond pitch deck”:

Morning of day T (09:00 AM): Advisor calls: “Investor meeting Thursday, need complete deck with business plan + forecast + DSCR + Centrale Rischi (Italian Central Credit Register).”

JSON-centric automated workflow:

PHASE 1: DATA COLLECTION (09:00-09:05 AM, automatic)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
├─ TeamSystem: API call GET /api/financials
│  Response: financial_data.json (accounting status)
│
├─ Cassetto Fiscale AdE: Download XML invoices via delegation
│  Conversion: XML → normalized_invoices.json
│
├─ Banks (3 current accounts): [Open Banking APIs](https://saluteimpresa.mentally.ai/en/resources/software/treasury-management-vs-ai-cfo-sibill-e-mentally-copilot-risolvono-problemi-diversi-per-pmi-italiane "Treasury Management vs AI CFO: Sibill e Mentally Copilot")
│  GET /transactions → bank_movements.json
│
└─ Centrale Rischi: Automatic report (third-party service)
   Download: central_credit_register.pdf → parse → ccr.json

PHASE 2: DATA CONSOLIDATION (09:05-09:10 AM, 5 min)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Platform (Mentally): Merge 4 JSON sources
├─ Reconcile: issued_invoices ↔ bank_movements (match receipts)
├─ Calculate: DSO (Days Sales Outstanding) PA vs private separately
├─ Calculate: Customer concentration (Herfindahl index)
└─ Output: consolidated_financial_snapshot.json

PHASE 3: AI ANALYSIS (09:10-09:15 AM, 5 min)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
ML Engine (trained on 300K+ Italian SME transactions):
├─ Input: consolidated_financial_snapshot.json
├─ Pattern Recognition: Seasonality, PA trends, anomalies
├─ Forecasting: 24-month cash flow (ML adaptive, not static Excel)
├─ Scenario Generation: Base / Worst (TOP client -40%) / Best
├─ DSCR Calculation: Current + Post-Minibond projection
└─ Output: comprehensive_analysis.json

PHASE 4: PRESENTATION GENERATION (09:15-09:20 AM, 5 min)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Presentation Layer (Pitch.com API integration):
├─ POST /api/presentations/create
│  Headers: {"Content-Type": "application/json"}
│  Body: comprehensive_analysis.json
│
├─ Pitch.com processing:
│  - Map JSON fields → slide templates
│  - Generate charts (cash flow line, DSCR bar, customer pie)
│  - Apply SME brand colors/logos
│
└─ Output: investor_deck_minibond.pptx (35 slides)

PHASE 5: DELIVERY (09:20-09:25 AM, 5 min)
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
├─ Export deck: Download investor_deck_minibond.pptx
├─ Export JSON: comprehensive_analysis.json (for advisor analysis)
├─ Automatic email → Advisor with attachments (deck + JSON)
└─ Automatic Google Drive backup

TOTAL ELAPSED TIME: 25 minutes
HUMAN INTERVENTION: 2 minutes (review + send email)

Vs traditional workflow (21+ hours):

Phase Traditional Method Time JSON Pipeline Method Time
Data extraction Manual CSV/PDF download from 4 systems 3h Automatic API calls 5min
Data consolidation Excel copy-paste + manual reconciliation 5h JSON merge engine 5min
Analysis Excel formulas, manual DSCR/DSO calculations 6h ML

Data and Statistics

€5-50M

3-5

10%

60 giorni

100%

80%

Frequently Asked Questions

What is JSON-centric architecture for SME business data?
JSON-centric architecture is a modern approach that uses the JSON (JavaScript Object Notation) format as a universal interoperability protocol among all financial software systems in an SME. It overcomes information fragmentation caused by legacy ERPs, tax software, online banking, and business intelligence tools that use incompatible data formats. JSON becomes the explicit data contract that ensures type safety, automatic validation, and auto-generated documentation, eliminating repetitive manual conversions that cause errors and latency in corporate data.
What concrete advantages does JSON offer compared to traditional CSV exports from ERP systems?
JSON offers significant advantages over CSV: explicit data types (numbers, ISO 8601 dates) without ambiguity, hierarchical structure with nesting for complex relationships, native UTF-8 support for accented characters, automatic validation through JSON Schema, and contextual metadata such as timestamps and versioning. For example, in an invoice export from TeamSystem, JSON eliminates common CSV problems such as decimal separator ambiguity, non-sortable date formats, and uncertainties about VAT field types. Additionally, JSON is self-documenting and allows schema evolution without breaking changes.
How does the Composable Finance Stack work for Italian SMEs?
The Composable Finance Stack is a layered software architecture that integrates legacy ERPs (TeamSystem, Zucchetti), tax systems (AdE tax portal), open banking, AI platforms, and presentation tools through JSON as the interchange format. The workflow includes: data extraction from heterogeneous sources with JSON conversion, integration and normalization in a Data Integration Layer, intelligent analysis via AI to generate forecasts and KPIs, and automatic generation of investor-ready presentations. A practical case is creating a minibond pitch deck in 30 automated minutes, compared to the 20+ hours required by traditional manual workflows.
What are the main ERP software systems used by Italian SMEs?
Italian SMEs predominantly use TeamSystem (present in 98% of manufacturing SMEs), Zucchetti, and SAP Business One. These legacy ERPs are built on pre-JSON architectures from the 1990s-2000s, based on relational databases like MSSQL and Oracle. Native exports are typically in Crystal Reports PDF format, batch CSV, or XML for electronic invoices. Most do not have modern REST JSON APIs, at best offering SOAP XML, creating the need to implement JSON Export Adapter Pattern to enable interoperability with modern cloud-native tools.
What is a data contract and why is it important in software architecture?
A data contract is an agreed-upon data schema between producer and consumer systems that defines the structure, types, and format of exchanged information. It ensures type safety (the consumer knows the structure and types in advance), manageable versioning without breaking changes, automatic payload validation through standard JSON Schema draft-07, and self-documentation. In Italian SME contexts, adopting JSON as an explicit data contract means eliminating typical CSV ambiguities (amount types, date formats, character encoding) and enabling automated data pipelines between ERP, tax systems, analytics, and presentations without error-prone manual interventions.
How do you integrate AdE tax portal data into a JSON-centric architecture?
Data from the Italian Revenue Agency tax portal is natively in XML format for electronic invoices through the Exchange System (SDI). To integrate them into a JSON-centric architecture, it's necessary to implement an XML-to-JSON converter in the Data Integration Layer. This adapter transforms SDI XML invoices into normalized JSON objects, maintaining all relevant data (customer details, amounts, VAT, dates) and making them compatible with the rest of the stack. Once converted, tax data can be easily reconciled with bank receipts and integrated into AI analysis or automated presentations.
How much time is saved with JSON automation in financial presentations?
JSON-based automation dramatically reduces production time for financial presentations. A concrete case is generating a pitch deck for minibond investors: with traditional manual workflow, over 20 hours are needed for data extraction from ERP, Excel consolidation, manual analysis, and PowerPoint slide creation. With an automated JSON-centric pipeline (ERP export, data integration, AI analysis, presentation generation via API), the same investor-ready deliverable of 35 slides is produced in approximately 30 minutes, with time savings exceeding 97% and complete elimination of manual transcription errors.
What are the main layers of a modern SME financial software stack?
A modern SME financial software stack consists of four main layers. The Presentation Layer includes tools like PowerPoint, Gamma, Pitch, and Tableau that import JSON. The Intelligence/Analysis Layer comprises AI platforms like Mentally, Claude, and ChatGPT for ML analysis, predictive forecasting, and scenario generation, operating natively in JSON. The Data Integration Layer normalizes data from heterogeneous sources through JSON adapters for TeamSystem, XML-to-JSON converters for the tax portal, and Open Banking APIs that are already JSON-native. At the base are traditional Data Sources: core ERP, accounting/tax systems, and multiple online banking platforms that are all normalized into JSON for interoperability.
How do you implement a JSON Export Adapter for legacy ERP systems?
A JSON Export Adapter for legacy ERPs like TeamSystem is implemented using three approaches of increasing complexity. The simplest approach involves direct queries to the ERP database (MSSQL/Oracle) with scripting that converts resultsets into JSON. The intermediate approach uses the ERP's native SOAP XML APIs with an XML-to-JSON transformation layer. The enterprise approach requires professional ETL middleware (Talend, Informatica) with certified ERP connectors. The choice depends on available IT resources, data volumes, and business criticality. All approaches produce JSON validated against a defined schema, ensuring data consistency to downstream consumer systems.