{"count":5,"reports":[{"validations":[{"rule":"R1","description":"Bank net transfer ≈ sum of payslip net pay (±2%)","passed":true,"detail":"bank=3994.74 vs payslips=3994.74 (Δ 0.00%)"},{"rule":"R2","description":"Employer-IKA ratio consistent with the register (flagged, not failed, when no register is present)","passed":true,"detail":"payslip-derived 26.00% vs register 26.00% (Δ 0.00pt)"},{"rule":"R3","description":"Payment date present and consistent across documents","passed":true,"detail":"payment_date=2026-01-31"},{"rule":"R4","description":"Register-reported employee count matches the payslips present","passed":true,"detail":"payslips=3; no register headcount to cross-check"}],"analysis_engine":"deterministic-finance-engine","event":{"employee_count":3,"register_gross_total":5500,"period":"2026-01","bank_net_total":3994.74,"gross_total":5500,"register_employer_ika_total":1430,"employer_cost_total":6930,"register_employer_cost_total":6930,"linked_docs":["doc-bank-001","doc-register-001","doc-payslip-001","doc-payslip-002","doc-payslip-003"],"employer_ika_total":1430,"tax_withheld_total":625.26,"cost_gap_pct":35.8,"event_id":"evt-archon-demo-ike-2026-01","hidden_total":2935.26,"cost_gap_amount":1430,"register_employee_count":null,"company":"ARCHON DEMO IKE","employees":[{"employer_cost":2268,"gross":1800,"employee_id":"EMP-001","name":"Nikos Papadopoulos","tax":199.56,"net":1312.44,"employer_ika":468,"employee_ika":288},{"employer_cost":1890,"gross":1500,"employee_id":"EMP-002","name":"Eleni Georgiou","tax":169.5,"net":1090.5,"employer_ika":390,"employee_ika":240},{"employer_cost":2772,"gross":2200,"employee_id":"EMP-003","name":"Dimitris Alexiou","tax":256.2,"net":1591.8,"employer_ika":572,"employee_ika":352}],"employee_ika_total":880},"db_mode":"aws-dynamodb","generated_at":"2026-06-29T13:09:16.469Z","executive_summary":"For 2026-01, ARCHON DEMO IKE's finance close links sales, purchases, bank movement, and payroll controls into one reviewable run.\n\nThe evidence-backed payroll control is material: the bank confirmation shows EUR 3994.74 in net salary transfers to 3 employees — the figure most owners treat as \"payroll cost.\"\n\nThat figure is misleading. The true employer cost for the month is EUR 6930.00. Employer social-security (IKA) contributions of EUR 1430.00 — about 35.8% on top of the net salaries — never appear on the bank confirmation.\n\nIncluding withheld employee IKA and income tax, the bank confirmation understates real payroll cash commitment by EUR 2935.26. Budget against the fused figure, not the bank transfer.","business_intelligence":{"pnl":{"revenue":47200,"cogs":1072.45,"grossProfit":46127.55,"grossMarginPct":97.73,"operatingExpenses":15430,"ebitda":30697.55,"ebitdaMarginPct":65.04,"lines":[{"label":"Net revenue","amount":47200,"note":"Sales invoices, POS, and e-commerce settlement."},{"label":"Purchases / COGS","amount":-1072.45,"note":"Supplier ledger, vendor invoices, and bank outflows."},{"label":"Gross profit","amount":46127.55,"note":"97.7% blended margin."},{"label":"Payroll true cost","amount":-6930,"note":"Gross payroll plus employer social-security contributions."},{"label":"Rent, marketing, admin","amount":-8500,"note":"Recurring non-payroll operating expenses."},{"label":"EBITDA","amount":30697.55,"note":"65.0% operating margin."}]},"cash":{"openingBalance":52000,"closingBalance":79497.55,"netMovement":27497.55,"runwayMonths":5.15,"movements":[{"label":"Opening bank balance","amount":52000,"direction":"balance"},{"label":"Customer collections","amount":44000,"direction":"in"},{"label":"Supplier payments","amount":1072.45,"direction":"out"},{"label":"Payroll net transfers","amount":3994.74,"direction":"out"},{"label":"Payroll taxes / social-security gap","amount":2935.26,"direction":"out"},{"label":"Rent, marketing, admin","amount":8500,"direction":"out"},{"label":"Closing bank balance","amount":79497.55,"direction":"balance"}]},"sales":{"actual":47200,"goal":46500,"attainmentPct":101.51,"weightedMarginPct":66.18,"performance":[{"owner":"Nikos Papadopoulos","segment":"AI Engineering","actual":18500,"goal":17000,"marginPct":68},{"owner":"Eleni Georgiou","segment":"Data & Analytics","actual":12300,"goal":13000,"marginPct":64},{"owner":"Dimitris Alexiou","segment":"Advisory","actual":9800,"goal":10500,"marginPct":71},{"owner":"Sofia Marinou","segment":"Managed Services","actual":6600,"goal":6000,"marginPct":58}]},"purchases":{"total":1072.45,"categories":[{"category":"AI model API","vendor":"Anthropic PBC","amount":300.07,"sharePct":27.98,"risk":"watch"},{"category":"Cloud platform","vendor":"Google Cloud EMEA","amount":256.3,"sharePct":23.9,"risk":"watch"},{"category":"Cloud infrastructure","vendor":"Amazon Web Services","amount":246.48,"sharePct":22.98,"risk":"watch"},{"category":"Utilities (power)","vendor":"Public Power Corporation","amount":184.2,"sharePct":17.18,"risk":"watch"},{"category":"Tolls & travel","vendor":"Attiki Odos AE","amount":85.4,"sharePct":7.96,"risk":"low"}]},"workingCapital":{"receivables":9000,"payables":256.3,"vatPayable":7800,"cashConversionGap":16543.7},"brief":"ARCHON DEMO IKE generated EUR 47200 revenue in 2026-01, reaching 101.5% of the sales goal. The month is profitable: EBITDA is EUR 30698 after true payroll cost, with a 65.0% margin. Every document type is present and cross-linked: payroll reconciles across the bank transfer, register, and payslips, and the only item to watch is supplier concentration in ai model api.","alerts":[{"title":"Profitability is positive","detail":"EBITDA margin is 65.0% after full payroll cost.","severity":"good"},{"title":"Sales goal gap","detail":"Total sales are EUR -700 below monthly goal.","severity":"watch"},{"title":"Supplier concentration","detail":"AI model API is 28.0% of purchase spend.","severity":"risk"},{"title":"Payroll reconciled across documents","detail":"Bank transfer plus employer social-security contributions and withheld amounts tie out to the register; EUR 2935 is only visible once the documents are correlated.","severity":"watch"}]},"citations":[{"id":"SRC-REV","title":"Revenue basis","claim":"P&L revenue is shown net of tax and reconciled from sales documents.","source":"sales_ledger_202601.xlsx","evidence":"€47,200 net revenue, 101.5% goal attainment"},{"id":"SRC-COGS","title":"Purchase basis","claim":"COGS and supplier concentration come from the purchase ledger and bank outflows.","source":"vendor_invoices_202601.pdf","evidence":"€1,072 COGS; AI model API is 28.0%"},{"id":"SRC-CASH","title":"Cash basis","claim":"The account statement reconciles collections, supplier payments, payroll transfers, and closing balance.","source":"bank_confirmation_202601.pdf","evidence":"€79,498 closing cash, 5.2 months runway"},{"id":"SRC-PAY","title":"Payroll control basis","claim":"Employer payroll cost must use the payroll register and payslips, not only the bank transfer.","source":"payroll_register_202601.pdf + employee payslips","evidence":"€6,930 true cost vs €3,995 bank net"}]},{"validations":[{"rule":"R1","description":"Bank net transfer ≈ sum of payslip net pay (±2%)","passed":true,"detail":"bank=5956.67 vs payslips=5956.67 (Δ 0.00%)"},{"rule":"R2","description":"Employer IKA ratio within Greek statutory band (~22.29% of gross, ±1pt)","passed":true,"detail":"employer_ika/gross = 22.29% (expected ~22.29%)"},{"rule":"R3","description":"Payment date present and consistent across documents","passed":true,"detail":"payment_date=2026-05-31"},{"rule":"R4","description":"Employee count consistent (register vs payslips)","passed":true,"detail":"payslips=5, event=5"}],"analysis_engine":"deterministic-finance-engine","event":{"employee_count":5,"period":"2026-05","bank_net_total":5956.67,"gross_total":7450,"employer_cost_total":9110.62,"linked_docs":["doc-bank-001","doc-register-001","doc-payslip-001","doc-payslip-002","doc-payslip-003","doc-payslip-004","doc-payslip-005"],"employer_ika_total":1660.62,"tax_withheld_total":460,"cost_gap_pct":27.88,"event_id":"evt-eleftheria-foods-ae-2026-05","hidden_total":3153.95,"cost_gap_amount":1660.62,"company":"Eleftheria Foods AE","employees":[{"employer_cost":2323.51,"gross":1900,"employee_id":"EMP-001","name":"Georgios Papadopoulos","tax":175,"net":1461.47,"employer_ika":423.51,"employee_ika":263.53},{"employer_cost":2017.79,"gross":1650,"employee_id":"EMP-002","name":"Maria Nikolaou","tax":120,"net":1301.14,"employer_ika":367.79,"employee_ika":228.86},{"employer_cost":1773.21,"gross":1450,"employee_id":"EMP-003","name":"Dimitrios Vlachos","tax":80,"net":1168.88,"employer_ika":323.21,"employee_ika":201.12},{"employer_cost":1589.77,"gross":1300,"employee_id":"EMP-004","name":"Eleni Georgiou","tax":55,"net":1064.69,"employer_ika":289.77,"employee_ika":180.31},{"employer_cost":1406.34,"gross":1150,"employee_id":"EMP-005","name":"Sofia Ioannou","tax":30,"net":960.49,"employer_ika":256.34,"employee_ika":159.51}],"employee_ika_total":1033.33},"db_mode":"aws-dynamodb","generated_at":"2026-06-28T09:21:03.752Z","executive_summary":"For 2026-05, Eleftheria Foods AE's finance close links sales, purchases, bank movement, and payroll controls into one reviewable run.\n\nThe evidence-backed payroll control is material: the bank confirmation shows EUR 5956.67 in net salary transfers to 5 employees — the figure most owners treat as \"payroll cost.\"\n\nThat figure is misleading. The true employer cost for the month is EUR 9110.62. Employer social-security (IKA) contributions of EUR 1660.62 — about 27.9% on top of the net salaries — never appear on the bank confirmation.\n\nIncluding withheld employee IKA and income tax, the bank confirmation understates real payroll cash commitment by EUR 3153.95. Budget against the fused figure, not the bank transfer.","business_intelligence":{"pnl":{"revenue":47200,"cogs":1072.45,"grossProfit":46127.55,"grossMarginPct":97.73,"operatingExpenses":17610.62,"ebitda":28516.93,"ebitdaMarginPct":60.42,"lines":[{"label":"Net revenue","amount":47200,"note":"Sales invoices, POS, and e-commerce settlement."},{"label":"Purchases / COGS","amount":-1072.45,"note":"Supplier ledger, vendor invoices, and bank outflows."},{"label":"Gross profit","amount":46127.55,"note":"97.7% blended margin."},{"label":"Payroll true cost","amount":-9110.62,"note":"Gross payroll plus employer social-security contributions."},{"label":"Rent, marketing, admin","amount":-8500,"note":"Recurring non-payroll operating expenses."},{"label":"EBITDA","amount":28516.93,"note":"60.4% operating margin."}]},"cash":{"openingBalance":52000,"closingBalance":77316.93,"netMovement":25316.93,"runwayMonths":4.39,"movements":[{"label":"Opening bank balance","amount":52000,"direction":"balance"},{"label":"Customer collections","amount":44000,"direction":"in"},{"label":"Supplier payments","amount":1072.45,"direction":"out"},{"label":"Payroll net transfers","amount":5956.67,"direction":"out"},{"label":"Payroll taxes / social-security gap","amount":3153.95,"direction":"out"},{"label":"Rent, marketing, admin","amount":8500,"direction":"out"},{"label":"Closing bank balance","amount":77316.93,"direction":"balance"}]},"sales":{"actual":47200,"goal":46500,"attainmentPct":101.51,"weightedMarginPct":66.18,"performance":[{"owner":"Nikos Papadopoulos","segment":"AI Engineering","actual":18500,"goal":17000,"marginPct":68},{"owner":"Eleni Georgiou","segment":"Data & Analytics","actual":12300,"goal":13000,"marginPct":64},{"owner":"Dimitris Alexiou","segment":"Advisory","actual":9800,"goal":10500,"marginPct":71},{"owner":"Sofia Marinou","segment":"Managed Services","actual":6600,"goal":6000,"marginPct":58}]},"purchases":{"total":1072.45,"categories":[{"category":"AI model API","vendor":"Anthropic PBC","amount":300.07,"sharePct":27.98,"risk":"watch"},{"category":"Cloud platform","vendor":"Google Cloud EMEA","amount":256.3,"sharePct":23.9,"risk":"watch"},{"category":"Cloud infrastructure","vendor":"Amazon Web Services","amount":246.48,"sharePct":22.98,"risk":"watch"},{"category":"Utilities (power)","vendor":"Public Power Corporation","amount":184.2,"sharePct":17.18,"risk":"watch"},{"category":"Tolls & travel","vendor":"Attiki Odos AE","amount":85.4,"sharePct":7.96,"risk":"low"}]},"workingCapital":{"receivables":9000,"payables":256.3,"vatPayable":7800,"cashConversionGap":16543.7},"brief":"Eleftheria Foods AE generated EUR 47200 revenue in 2026-05, reaching 101.5% of the sales goal. The month is profitable: EBITDA is EUR 28517 after true payroll cost, with a 60.4% margin. Every document type is present and cross-linked: payroll reconciles across the bank transfer, register, and payslips, and the only item to watch is supplier concentration in ai model api.","alerts":[{"title":"Profitability is positive","detail":"EBITDA margin is 60.4% after full payroll cost.","severity":"good"},{"title":"Sales goal gap","detail":"Total sales are EUR -700 below monthly goal.","severity":"watch"},{"title":"Supplier concentration","detail":"AI model API is 28.0% of purchase spend.","severity":"risk"},{"title":"Payroll reconciled across documents","detail":"Bank transfer plus employer social-security contributions and withheld amounts tie out to the register; EUR 3154 is only visible once the documents are correlated.","severity":"watch"}]},"citations":[{"id":"SRC-REV","title":"Revenue basis","claim":"P&L revenue is shown net of tax and reconciled from sales documents.","source":"sales_ledger_202601.xlsx","evidence":"€47,200 net revenue, 101.5% goal attainment"},{"id":"SRC-COGS","title":"Purchase basis","claim":"COGS and supplier concentration come from the purchase ledger and bank outflows.","source":"vendor_invoices_202601.pdf","evidence":"€1,072 COGS; AI model API is 28.0%"},{"id":"SRC-CASH","title":"Cash basis","claim":"The account statement reconciles collections, supplier payments, payroll transfers, and closing balance.","source":"bank_confirmation_202601.pdf","evidence":"€77,317 closing cash, 4.4 months runway"},{"id":"SRC-PAY","title":"Payroll control basis","claim":"Employer payroll cost must use the payroll register and payslips, not only the bank transfer.","source":"payroll_register_202601.pdf + employee payslips","evidence":"€9,111 true cost vs €5,957 bank net"}]},{"validations":[{"rule":"R1","description":"Bank net transfer ≈ sum of payslip net pay (±2%)","passed":true,"detail":"bank=5956.67 vs payslips=5956.67 (Δ 0.00%)"},{"rule":"R2","description":"Employer IKA ratio within Greek statutory band (~22.29% of gross, ±1pt)","passed":true,"detail":"employer_ika/gross = 22.29% (expected ~22.29%)"},{"rule":"R3","description":"Payment date present and consistent across documents","passed":true,"detail":"payment_date=2026-05-31"},{"rule":"R4","description":"Employee count consistent (register vs payslips)","passed":true,"detail":"payslips=5, event=5"}],"analysis_engine":"deterministic-finance-engine","event":{"employee_count":5,"period":"2026-05","bank_net_total":5956.67,"gross_total":7450,"employer_cost_total":9110.62,"linked_docs":["doc-bank-001","doc-register-001","doc-payslip-001","doc-payslip-002","doc-payslip-003","doc-payslip-004","doc-payslip-005"],"employer_ika_total":1660.62,"tax_withheld_total":460,"cost_gap_pct":27.88,"event_id":"evt-eleftheria-foods-ae-2026-05","hidden_total":3153.95,"cost_gap_amount":1660.62,"company":"Eleftheria Foods AE","employees":[{"employer_cost":2323.51,"gross":1900,"employee_id":"EMP-001","name":"Georgios Papadopoulos","tax":175,"net":1461.47,"employer_ika":423.51,"employee_ika":263.53},{"employer_cost":2017.79,"gross":1650,"employee_id":"EMP-002","name":"Maria Nikolaou","tax":120,"net":1301.14,"employer_ika":367.79,"employee_ika":228.86},{"employer_cost":1773.21,"gross":1450,"employee_id":"EMP-003","name":"Dimitrios Vlachos","tax":80,"net":1168.88,"employer_ika":323.21,"employee_ika":201.12},{"employer_cost":1589.77,"gross":1300,"employee_id":"EMP-004","name":"Eleni Georgiou","tax":55,"net":1064.69,"employer_ika":289.77,"employee_ika":180.31},{"employer_cost":1406.34,"gross":1150,"employee_id":"EMP-005","name":"Sofia Ioannou","tax":30,"net":960.49,"employer_ika":256.34,"employee_ika":159.51}],"employee_ika_total":1033.33},"db_mode":"aws-dynamodb","generated_at":"2026-06-28T08:14:15.190Z","executive_summary":"For 2026-05, Eleftheria Foods AE's finance close links sales, purchases, bank movement, and payroll controls into one reviewable run.\n\nThe evidence-backed payroll control is material: the bank confirmation shows EUR 5956.67 in net salary transfers to 5 employees — the figure most owners treat as \"payroll cost.\"\n\nThat figure is misleading. The true employer cost for the month is EUR 9110.62. Employer social-security (IKA) contributions of EUR 1660.62 — about 27.9% on top of the net salaries — never appear on the bank confirmation.\n\nIncluding withheld employee IKA and income tax, the bank confirmation understates real payroll cash commitment by EUR 3153.95. Budget against the fused figure, not the bank transfer.","business_intelligence":{"pnl":{"revenue":47200,"cogs":1072.45,"grossProfit":46127.55,"grossMarginPct":97.73,"operatingExpenses":17610.62,"ebitda":28516.93,"ebitdaMarginPct":60.42,"lines":[{"label":"Net revenue","amount":47200,"note":"Sales invoices, POS, and e-commerce settlement."},{"label":"Purchases / COGS","amount":-1072.45,"note":"Supplier ledger, vendor invoices, and bank outflows."},{"label":"Gross profit","amount":46127.55,"note":"97.7% blended margin."},{"label":"Payroll true cost","amount":-9110.62,"note":"Gross payroll plus employer social-security contributions."},{"label":"Rent, marketing, admin","amount":-8500,"note":"Recurring non-payroll operating expenses."},{"label":"EBITDA","amount":28516.93,"note":"60.4% operating margin."}]},"cash":{"openingBalance":52000,"closingBalance":77316.93,"netMovement":25316.93,"runwayMonths":4.39,"movements":[{"label":"Opening bank balance","amount":52000,"direction":"balance"},{"label":"Customer collections","amount":44000,"direction":"in"},{"label":"Supplier payments","amount":1072.45,"direction":"out"},{"label":"Payroll net transfers","amount":5956.67,"direction":"out"},{"label":"Payroll taxes / social-security gap","amount":3153.95,"direction":"out"},{"label":"Rent, marketing, admin","amount":8500,"direction":"out"},{"label":"Closing bank balance","amount":77316.93,"direction":"balance"}]},"sales":{"actual":47200,"goal":46500,"attainmentPct":101.51,"weightedMarginPct":66.18,"performance":[{"owner":"Nikos Papadopoulos","segment":"AI Engineering","actual":18500,"goal":17000,"marginPct":68},{"owner":"Eleni Georgiou","segment":"Data & Analytics","actual":12300,"goal":13000,"marginPct":64},{"owner":"Dimitris Alexiou","segment":"Advisory","actual":9800,"goal":10500,"marginPct":71},{"owner":"Sofia Marinou","segment":"Managed Services","actual":6600,"goal":6000,"marginPct":58}]},"purchases":{"total":1072.45,"categories":[{"category":"AI model API","vendor":"Anthropic PBC","amount":300.07,"sharePct":27.98,"risk":"watch"},{"category":"Cloud platform","vendor":"Google Cloud EMEA","amount":256.3,"sharePct":23.9,"risk":"watch"},{"category":"Cloud infrastructure","vendor":"Amazon Web Services","amount":246.48,"sharePct":22.98,"risk":"watch"},{"category":"Utilities (power)","vendor":"Public Power Corporation","amount":184.2,"sharePct":17.18,"risk":"watch"},{"category":"Tolls & travel","vendor":"Attiki Odos AE","amount":85.4,"sharePct":7.96,"risk":"low"}]},"workingCapital":{"receivables":9000,"payables":256.3,"vatPayable":7800,"cashConversionGap":16543.7},"brief":"Eleftheria Foods AE generated EUR 47200 revenue in 2026-05, reaching 101.5% of the sales goal. The month is profitable: EBITDA is EUR 28517 after true payroll cost, with a 60.4% margin. Every document type is present and cross-linked: payroll reconciles across the bank transfer, register, and payslips, and the only item to watch is supplier concentration in ai model api.","alerts":[{"title":"Profitability is positive","detail":"EBITDA margin is 60.4% after full payroll cost.","severity":"good"},{"title":"Sales goal gap","detail":"Total sales are EUR -700 below monthly goal.","severity":"watch"},{"title":"Supplier concentration","detail":"AI model API is 28.0% of purchase spend.","severity":"risk"},{"title":"Payroll reconciled across documents","detail":"Bank transfer plus employer social-security contributions and withheld amounts tie out to the register; EUR 3154 is only visible once the documents are correlated.","severity":"watch"}]},"citations":[{"id":"SRC-REV","title":"Revenue basis","claim":"P&L revenue is shown net of tax and reconciled from sales documents.","source":"sales_ledger_202601.xlsx","evidence":"€47,200 net revenue, 101.5% goal attainment"},{"id":"SRC-COGS","title":"Purchase basis","claim":"COGS and supplier concentration come from the purchase ledger and bank outflows.","source":"vendor_invoices_202601.pdf","evidence":"€1,072 COGS; AI model API is 28.0%"},{"id":"SRC-CASH","title":"Cash basis","claim":"The account statement reconciles collections, supplier payments, payroll transfers, and closing balance.","source":"bank_confirmation_202601.pdf","evidence":"€77,317 closing cash, 4.4 months runway"},{"id":"SRC-PAY","title":"Payroll control basis","claim":"Employer payroll cost must use the payroll register and payslips, not only the bank transfer.","source":"payroll_register_202601.pdf + employee payslips","evidence":"€9,111 true cost vs €5,957 bank net"}]},{"validations":[{"rule":"R1","description":"Bank net transfer ≈ sum of payslip net pay (±2%)","passed":true,"detail":"bank=5956.67 vs payslips=5956.67 (Δ 0.00%)"},{"rule":"R2","description":"Employer IKA ratio within Greek statutory band (~22.29% of gross, ±1pt)","passed":true,"detail":"employer_ika/gross = 22.29% (expected ~22.29%)"},{"rule":"R3","description":"Payment date present and consistent across documents","passed":true,"detail":"payment_date=2026-05-31"},{"rule":"R4","description":"Employee count consistent (register vs payslips)","passed":true,"detail":"payslips=5, event=5"}],"analysis_engine":"deterministic-finance-engine","event":{"employee_count":5,"period":"2026-05","bank_net_total":5956.67,"gross_total":7450,"employer_cost_total":9110.62,"linked_docs":["doc-bank-001","doc-register-001","doc-payslip-001","doc-payslip-002","doc-payslip-003","doc-payslip-004","doc-payslip-005"],"employer_ika_total":1660.62,"tax_withheld_total":460,"cost_gap_pct":27.88,"event_id":"evt-eleftheria-foods-ae-2026-05","hidden_total":3153.95,"cost_gap_amount":1660.62,"company":"Eleftheria Foods AE","employees":[{"employer_cost":2323.51,"gross":1900,"employee_id":"EMP-001","name":"Georgios Papadopoulos","tax":175,"net":1461.47,"employer_ika":423.51,"employee_ika":263.53},{"employer_cost":2017.79,"gross":1650,"employee_id":"EMP-002","name":"Maria Nikolaou","tax":120,"net":1301.14,"employer_ika":367.79,"employee_ika":228.86},{"employer_cost":1773.21,"gross":1450,"employee_id":"EMP-003","name":"Dimitrios Vlachos","tax":80,"net":1168.88,"employer_ika":323.21,"employee_ika":201.12},{"employer_cost":1589.77,"gross":1300,"employee_id":"EMP-004","name":"Eleni Georgiou","tax":55,"net":1064.69,"employer_ika":289.77,"employee_ika":180.31},{"employer_cost":1406.34,"gross":1150,"employee_id":"EMP-005","name":"Sofia Ioannou","tax":30,"net":960.49,"employer_ika":256.34,"employee_ika":159.51}],"employee_ika_total":1033.33},"db_mode":"aws-dynamodb","generated_at":"2026-06-28T08:10:45.097Z","executive_summary":"For 2026-05, Eleftheria Foods AE's finance close links sales, purchases, bank movement, and payroll controls into one reviewable run.\n\nThe evidence-backed payroll control is material: the bank confirmation shows EUR 5956.67 in net salary transfers to 5 employees — the figure most owners treat as \"payroll cost.\"\n\nThat figure is misleading. The true employer cost for the month is EUR 9110.62. Employer social-security (IKA) contributions of EUR 1660.62 — about 27.9% on top of the net salaries — never appear on the bank confirmation.\n\nIncluding withheld employee IKA and income tax, the bank confirmation understates real payroll cash commitment by EUR 3153.95. Budget against the fused figure, not the bank transfer.","business_intelligence":{"pnl":{"revenue":47200,"cogs":1072.45,"grossProfit":46127.55,"grossMarginPct":97.73,"operatingExpenses":17610.62,"ebitda":28516.93,"ebitdaMarginPct":60.42,"lines":[{"label":"Net revenue","amount":47200,"note":"Sales invoices, POS, and e-commerce settlement."},{"label":"Purchases / COGS","amount":-1072.45,"note":"Supplier ledger, vendor invoices, and bank outflows."},{"label":"Gross profit","amount":46127.55,"note":"97.7% blended margin."},{"label":"Payroll true cost","amount":-9110.62,"note":"Gross payroll plus employer social-security contributions."},{"label":"Rent, marketing, admin","amount":-8500,"note":"Recurring non-payroll operating expenses."},{"label":"EBITDA","amount":28516.93,"note":"60.4% operating margin."}]},"cash":{"openingBalance":52000,"closingBalance":77316.93,"netMovement":25316.93,"runwayMonths":4.39,"movements":[{"label":"Opening bank balance","amount":52000,"direction":"balance"},{"label":"Customer collections","amount":44000,"direction":"in"},{"label":"Supplier payments","amount":1072.45,"direction":"out"},{"label":"Payroll net transfers","amount":5956.67,"direction":"out"},{"label":"Payroll taxes / social-security gap","amount":3153.95,"direction":"out"},{"label":"Rent, marketing, admin","amount":8500,"direction":"out"},{"label":"Closing bank balance","amount":77316.93,"direction":"balance"}]},"sales":{"actual":47200,"goal":46500,"attainmentPct":101.51,"weightedMarginPct":66.18,"performance":[{"owner":"Nikos Papadopoulos","segment":"AI Engineering","actual":18500,"goal":17000,"marginPct":68},{"owner":"Eleni Georgiou","segment":"Data & Analytics","actual":12300,"goal":13000,"marginPct":64},{"owner":"Dimitris Alexiou","segment":"Advisory","actual":9800,"goal":10500,"marginPct":71},{"owner":"Sofia Marinou","segment":"Managed Services","actual":6600,"goal":6000,"marginPct":58}]},"purchases":{"total":1072.45,"categories":[{"category":"AI model API","vendor":"Anthropic PBC","amount":300.07,"sharePct":27.98,"risk":"watch"},{"category":"Cloud platform","vendor":"Google Cloud EMEA","amount":256.3,"sharePct":23.9,"risk":"watch"},{"category":"Cloud infrastructure","vendor":"Amazon Web Services","amount":246.48,"sharePct":22.98,"risk":"watch"},{"category":"Utilities (power)","vendor":"Public Power Corporation","amount":184.2,"sharePct":17.18,"risk":"watch"},{"category":"Tolls & travel","vendor":"Attiki Odos AE","amount":85.4,"sharePct":7.96,"risk":"low"}]},"workingCapital":{"receivables":9000,"payables":256.3,"vatPayable":7800,"cashConversionGap":16543.7},"brief":"Eleftheria Foods AE generated EUR 47200 revenue in 2026-05, reaching 101.5% of the sales goal. The month is profitable: EBITDA is EUR 28517 after true payroll cost, with a 60.4% margin. Every document type is present and cross-linked: payroll reconciles across the bank transfer, register, and payslips, and the only item to watch is supplier concentration in ai model api.","alerts":[{"title":"Profitability is positive","detail":"EBITDA margin is 60.4% after full payroll cost.","severity":"good"},{"title":"Sales goal gap","detail":"Total sales are EUR -700 below monthly goal.","severity":"watch"},{"title":"Supplier concentration","detail":"AI model API is 28.0% of purchase spend.","severity":"risk"},{"title":"Payroll reconciled across documents","detail":"Bank transfer plus employer social-security contributions and withheld amounts tie out to the register; EUR 3154 is only visible once the documents are correlated.","severity":"watch"}]},"citations":[{"id":"SRC-REV","title":"Revenue basis","claim":"P&L revenue is shown net of tax and reconciled from sales documents.","source":"sales_ledger_202601.xlsx","evidence":"€47,200 net revenue, 101.5% goal attainment"},{"id":"SRC-COGS","title":"Purchase basis","claim":"COGS and supplier concentration come from the purchase ledger and bank outflows.","source":"vendor_invoices_202601.pdf","evidence":"€1,072 COGS; AI model API is 28.0%"},{"id":"SRC-CASH","title":"Cash basis","claim":"The account statement reconciles collections, supplier payments, payroll transfers, and closing balance.","source":"bank_confirmation_202601.pdf","evidence":"€77,317 closing cash, 4.4 months runway"},{"id":"SRC-PAY","title":"Payroll control basis","claim":"Employer payroll cost must use the payroll register and payslips, not only the bank transfer.","source":"payroll_register_202601.pdf + employee payslips","evidence":"€9,111 true cost vs €5,957 bank net"}]},{"validations":[{"rule":"R1","description":"Bank net transfer ≈ sum of payslip net pay (±2%)","passed":true,"detail":"bank=5956.67 vs payslips=5956.67 (Δ 0.00%)"},{"rule":"R2","description":"Employer IKA ratio within Greek statutory band (~22.29% of gross, ±1pt)","passed":true,"detail":"employer_ika/gross = 22.29% (expected ~22.29%)"},{"rule":"R3","description":"Payment date present and consistent across documents","passed":true,"detail":"payment_date=2026-05-31"},{"rule":"R4","description":"Employee count consistent (register vs payslips)","passed":true,"detail":"payslips=5, event=5"}],"analysis_engine":"deterministic-finance-engine","event":{"employee_count":5,"period":"2026-05","bank_net_total":5956.67,"gross_total":7450,"employer_cost_total":9110.62,"linked_docs":["doc-bank-001","doc-register-001","doc-payslip-001","doc-payslip-002","doc-payslip-003","doc-payslip-004","doc-payslip-005"],"employer_ika_total":1660.62,"tax_withheld_total":460,"cost_gap_pct":27.88,"event_id":"evt-eleftheria-foods-ae-2026-05","hidden_total":3153.95,"cost_gap_amount":1660.62,"company":"Eleftheria Foods AE","employees":[{"employer_cost":2323.51,"gross":1900,"employee_id":"EMP-001","name":"Georgios Papadopoulos","tax":175,"net":1461.47,"employer_ika":423.51,"employee_ika":263.53},{"employer_cost":2017.79,"gross":1650,"employee_id":"EMP-002","name":"Maria Nikolaou","tax":120,"net":1301.14,"employer_ika":367.79,"employee_ika":228.86},{"employer_cost":1773.21,"gross":1450,"employee_id":"EMP-003","name":"Dimitrios Vlachos","tax":80,"net":1168.88,"employer_ika":323.21,"employee_ika":201.12},{"employer_cost":1589.77,"gross":1300,"employee_id":"EMP-004","name":"Eleni Georgiou","tax":55,"net":1064.69,"employer_ika":289.77,"employee_ika":180.31},{"employer_cost":1406.34,"gross":1150,"employee_id":"EMP-005","name":"Sofia Ioannou","tax":30,"net":960.49,"employer_ika":256.34,"employee_ika":159.51}],"employee_ika_total":1033.33},"db_mode":"aws-dynamodb","generated_at":"2026-06-28T07:41:00.627Z","executive_summary":"For 2026-05, Eleftheria Foods AE's finance close links sales, purchases, bank movement, and payroll controls into one reviewable run.\n\nThe evidence-backed payroll control is material: the bank confirmation shows EUR 5956.67 in net salary transfers to 5 employees — the figure most owners treat as \"payroll cost.\"\n\nThat figure is misleading. The true employer cost for the month is EUR 9110.62. Employer social-security (IKA) contributions of EUR 1660.62 — about 27.9% on top of the net salaries — never appear on the bank confirmation.\n\nIncluding withheld employee IKA and income tax, the bank confirmation understates real payroll cash commitment by EUR 3153.95. Budget against the fused figure, not the bank transfer.","business_intelligence":{"pnl":{"revenue":47200,"cogs":1072.45,"grossProfit":46127.55,"grossMarginPct":97.73,"operatingExpenses":17610.62,"ebitda":28516.93,"ebitdaMarginPct":60.42,"lines":[{"label":"Net revenue","amount":47200,"note":"Sales invoices, POS, and e-commerce settlement."},{"label":"Purchases / COGS","amount":-1072.45,"note":"Supplier ledger, vendor invoices, and bank outflows."},{"label":"Gross profit","amount":46127.55,"note":"97.7% blended margin."},{"label":"Payroll true cost","amount":-9110.62,"note":"Gross payroll plus employer social-security contributions."},{"label":"Rent, marketing, admin","amount":-8500,"note":"Recurring non-payroll operating expenses."},{"label":"EBITDA","amount":28516.93,"note":"60.4% operating margin."}]},"cash":{"openingBalance":52000,"closingBalance":77316.93,"netMovement":25316.93,"runwayMonths":4.39,"movements":[{"label":"Opening bank balance","amount":52000,"direction":"balance"},{"label":"Customer collections","amount":44000,"direction":"in"},{"label":"Supplier payments","amount":1072.45,"direction":"out"},{"label":"Payroll net transfers","amount":5956.67,"direction":"out"},{"label":"Payroll taxes / social-security gap","amount":3153.95,"direction":"out"},{"label":"Rent, marketing, admin","amount":8500,"direction":"out"},{"label":"Closing bank balance","amount":77316.93,"direction":"balance"}]},"sales":{"actual":47200,"goal":46500,"attainmentPct":101.51,"weightedMarginPct":66.18,"performance":[{"owner":"Nikos Papadopoulos","segment":"AI Engineering","actual":18500,"goal":17000,"marginPct":68},{"owner":"Eleni Georgiou","segment":"Data & Analytics","actual":12300,"goal":13000,"marginPct":64},{"owner":"Dimitris Alexiou","segment":"Advisory","actual":9800,"goal":10500,"marginPct":71},{"owner":"Sofia Marinou","segment":"Managed Services","actual":6600,"goal":6000,"marginPct":58}]},"purchases":{"total":1072.45,"categories":[{"category":"AI model API","vendor":"Anthropic PBC","amount":300.07,"sharePct":27.98,"risk":"watch"},{"category":"Cloud platform","vendor":"Google Cloud EMEA","amount":256.3,"sharePct":23.9,"risk":"watch"},{"category":"Cloud infrastructure","vendor":"Amazon Web Services","amount":246.48,"sharePct":22.98,"risk":"watch"},{"category":"Utilities (power)","vendor":"Public Power Corporation","amount":184.2,"sharePct":17.18,"risk":"watch"},{"category":"Tolls & travel","vendor":"Attiki Odos AE","amount":85.4,"sharePct":7.96,"risk":"low"}]},"workingCapital":{"receivables":9000,"payables":256.3,"vatPayable":7800,"cashConversionGap":16543.7},"brief":"Eleftheria Foods AE generated EUR 47200 revenue in 2026-05, reaching 101.5% of the sales goal. The month is profitable: EBITDA is EUR 28517 after true payroll cost, with a 60.4% margin. Every document type is present and cross-linked: payroll reconciles across the bank transfer, register, and payslips, and the only item to watch is supplier concentration in ai model api.","alerts":[{"title":"Profitability is positive","detail":"EBITDA margin is 60.4% after full payroll cost.","severity":"good"},{"title":"Sales goal gap","detail":"Total sales are EUR -700 below monthly goal.","severity":"watch"},{"title":"Supplier concentration","detail":"AI model API is 28.0% of purchase spend.","severity":"risk"},{"title":"Payroll reconciled across documents","detail":"Bank transfer plus employer social-security contributions and withheld amounts tie out to the register; EUR 3154 is only visible once the documents are correlated.","severity":"watch"}]},"citations":[{"id":"SRC-REV","title":"Revenue basis","claim":"P&L revenue is shown net of tax and reconciled from sales documents.","source":"sales_ledger_202601.xlsx","evidence":"€47,200 net revenue, 101.5% goal attainment"},{"id":"SRC-COGS","title":"Purchase basis","claim":"COGS and supplier concentration come from the purchase ledger and bank outflows.","source":"vendor_invoices_202601.pdf","evidence":"€1,072 COGS; AI model API is 28.0%"},{"id":"SRC-CASH","title":"Cash basis","claim":"The account statement reconciles collections, supplier payments, payroll transfers, and closing balance.","source":"bank_confirmation_202601.pdf","evidence":"€77,317 closing cash, 4.4 months runway"},{"id":"SRC-PAY","title":"Payroll control basis","claim":"Employer payroll cost must use the payroll register and payslips, not only the bank transfer.","source":"payroll_register_202601.pdf + employee payslips","evidence":"€9,111 true cost vs €5,957 bank net"}]}],"activity_count":10,"activity":[{"activity_id":"ask-20260713092508-0c4k7xtq","summary":"Answered finance question: What is the true payroll cost versus the bank statement?","created_at":"2026-07-13T09:25:08.541Z","details":{"source_ids":["SRC-REV","SRC-COGS","SRC-CASH","SRC-PAY"],"report_generated_at":"2026-06-29T13:09:16.469Z","question":"What is the true payroll cost versus the bank statement?","answer":"True payroll cost is €6,930, while the bank statement shows only €3,995 in net salary transfers. The missed amount is €2,935 this month, driven by employer social-security contributions and withheld payroll obligations that do not appear on the bank transfer line.","report_event_id":"evt-archon-demo-ike-2026-01"},"db_mode":"aws-dynamodb","kind":"ask"},{"activity_id":"intake-20260713092508-7rgdp9db","summary":"4/4 uploaded finance documents classified","created_at":"2026-07-13T09:25:08.023Z","details":{"coverage":["bank","sales","purchases","payroll"],"accepted":4,"files":[{"name":"bank_confirmation_202601.pdf","size":19,"type":"application/octet-stream","kind":"bank","confidence":0.96},{"name":"sales_ledger_202601.xlsx","size":19,"type":"application/octet-stream","kind":"sales","confidence":0.94},{"name":"vendor_purchases_202601.xlsx","size":19,"type":"application/octet-stream","kind":"purchases","confidence":0.93},{"name":"payroll_register_202601.pdf","size":19,"type":"application/octet-stream","kind":"payroll","confidence":0.97}],"received":4,"ready_for_close":true},"db_mode":"aws-dynamodb","kind":"intake"},{"activity_id":"ask-20260713092309-aq5vtdt1","summary":"Answered finance question: What is the true payroll cost versus the bank statement?","created_at":"2026-07-13T09:23:09.065Z","details":{"source_ids":["SRC-REV","SRC-COGS","SRC-CASH","SRC-PAY"],"report_generated_at":"2026-06-29T13:09:16.469Z","question":"What is the true payroll cost versus the bank statement?","answer":"True payroll cost is €6,930, while the bank statement shows only €3,995 in net salary transfers. The missed amount is €2,935 this month, driven by employer social-security contributions and withheld payroll obligations that do not appear on the bank transfer line.","report_event_id":"evt-archon-demo-ike-2026-01"},"db_mode":"aws-dynamodb","kind":"ask"},{"activity_id":"intake-20260713092308-eshx7as1","summary":"4/4 uploaded finance documents classified","created_at":"2026-07-13T09:23:08.583Z","details":{"coverage":["bank","sales","purchases","payroll"],"accepted":4,"files":[{"name":"bank_confirmation_202601.pdf","size":19,"type":"application/octet-stream","kind":"bank","confidence":0.96},{"name":"sales_ledger_202601.xlsx","size":19,"type":"application/octet-stream","kind":"sales","confidence":0.94},{"name":"vendor_purchases_202601.xlsx","size":19,"type":"application/octet-stream","kind":"purchases","confidence":0.93},{"name":"payroll_register_202601.pdf","size":19,"type":"application/octet-stream","kind":"payroll","confidence":0.97}],"received":4,"ready_for_close":true},"db_mode":"aws-dynamodb","kind":"intake"},{"activity_id":"ask-20260709025338-ljd73q2a","summary":"Answered finance question: What is the true payroll cost versus the bank statement?","created_at":"2026-07-09T02:53:38.546Z","details":{"source_ids":["SRC-REV","SRC-COGS","SRC-CASH","SRC-PAY"],"report_generated_at":"2026-06-29T13:09:16.469Z","question":"What is the true payroll cost versus the bank statement?","answer":"True payroll cost is €6,930, while the bank statement shows only €3,995 in net salary transfers. The missed amount is €2,935 this month, driven by employer social-security contributions and withheld payroll obligations that do not appear on the bank transfer line.","report_event_id":"evt-archon-demo-ike-2026-01"},"db_mode":"aws-dynamodb","kind":"ask"},{"activity_id":"intake-20260709025338-afz15yer","summary":"4/4 uploaded finance documents classified","created_at":"2026-07-09T02:53:38.071Z","details":{"coverage":["bank","sales","purchases","payroll"],"accepted":4,"files":[{"name":"bank_confirmation_202601.pdf","size":19,"type":"application/octet-stream","kind":"bank","confidence":0.96},{"name":"sales_ledger_202601.xlsx","size":19,"type":"application/octet-stream","kind":"sales","confidence":0.94},{"name":"vendor_purchases_202601.xlsx","size":19,"type":"application/octet-stream","kind":"purchases","confidence":0.93},{"name":"payroll_register_202601.pdf","size":19,"type":"application/octet-stream","kind":"payroll","confidence":0.97}],"received":4,"ready_for_close":true},"db_mode":"aws-dynamodb","kind":"intake"},{"activity_id":"ask-20260709024833-fu49fumw","summary":"Answered finance question: What is the true payroll cost versus the bank statement?","created_at":"2026-07-09T02:48:33.207Z","details":{"source_ids":["SRC-REV","SRC-COGS","SRC-CASH","SRC-PAY"],"report_generated_at":"2026-06-29T13:09:16.469Z","question":"What is the true payroll cost versus the bank statement?","answer":"True payroll cost is €6,930, while the bank statement shows only €3,995 in net salary transfers. The missed amount is €2,935 this month, driven by employer social-security contributions and withheld payroll obligations that do not appear on the bank transfer line.","report_event_id":"evt-archon-demo-ike-2026-01"},"db_mode":"aws-dynamodb","kind":"ask"},{"activity_id":"intake-20260709024832-rioekvel","summary":"4/4 uploaded finance documents classified","created_at":"2026-07-09T02:48:32.730Z","details":{"coverage":["bank","sales","purchases","payroll"],"accepted":4,"files":[{"name":"bank_confirmation_202601.pdf","size":19,"type":"application/octet-stream","kind":"bank","confidence":0.96},{"name":"sales_ledger_202601.xlsx","size":19,"type":"application/octet-stream","kind":"sales","confidence":0.94},{"name":"vendor_purchases_202601.xlsx","size":19,"type":"application/octet-stream","kind":"purchases","confidence":0.93},{"name":"payroll_register_202601.pdf","size":19,"type":"application/octet-stream","kind":"payroll","confidence":0.97}],"received":4,"ready_for_close":true},"db_mode":"aws-dynamodb","kind":"intake"},{"activity_id":"ask-20260629225600-5lhlzx2a","summary":"Answered finance question: What is the true payroll cost versus the bank statement?","created_at":"2026-06-29T22:56:00.355Z","details":{"source_ids":["SRC-REV","SRC-COGS","SRC-CASH","SRC-PAY"],"report_generated_at":"2026-06-29T13:09:16.469Z","question":"What is the true payroll cost versus the bank statement?","answer":"True payroll cost is €6,930, while the bank statement shows only €3,995 in net salary transfers. The missed amount is €2,935 this month, driven by employer social-security contributions and withheld payroll obligations that do not appear on the bank transfer line.","report_event_id":"evt-archon-demo-ike-2026-01"},"db_mode":"aws-dynamodb","kind":"ask"},{"activity_id":"intake-20260629225559-zjhxz6r3","summary":"4/4 uploaded finance documents classified","created_at":"2026-06-29T22:55:59.971Z","details":{"coverage":["bank","sales","purchases","payroll"],"accepted":4,"files":[{"name":"bank_confirmation_202601.pdf","size":19,"type":"application/octet-stream","kind":"bank","confidence":0.96},{"name":"sales_ledger_202601.xlsx","size":19,"type":"application/octet-stream","kind":"sales","confidence":0.94},{"name":"vendor_purchases_202601.xlsx","size":19,"type":"application/octet-stream","kind":"purchases","confidence":0.93},{"name":"payroll_register_202601.pdf","size":19,"type":"application/octet-stream","kind":"payroll","confidence":0.97}],"received":4,"ready_for_close":true},"db_mode":"aws-dynamodb","kind":"intake"}]}