axmo: '1.0'
name: Start-up P&L from the general ledger
description: >-
  Actual P&L from a general-ledger export, against a budget by P&L line and cost centre. The P&L structure, the chart of
  accounts and the line signs are tables on the Setup sheet; the ledger and the budget are Excel Tables, so new rows are
  read on the next Update. The last month with actuals is found from the ledger itself: a month counts as closed once it
  has postings. Report C uses a filter (dropSet) to leave out the second quarter; report B shows every month. The budget
  is split equally to the accounts of each line only so that it totals; read it by line and above.
exportedAt: '2026-10-26T22:17:32.326Z'
dimensions:
  CostCentres:
    type: categorical
    layers:
      - Top_CostCentres
      - Cost Centre
    tree:
      All_CostCentres:
        - Sales
        - Product
        - Admin
  PL:
    type: categorical
    layers:
      - Top_PL
      - Total
      - Section
      - Group
      - Line
      - Account
    tree:
      All_PL: null
  Time:
    type: sequential
    sequentialType: axmo_time
    parameters:
      selected_levels:
        - month
        - quarter
        - half_year
        - year
      start: 2027-01
      end_mode: end_point
      end: 2027-06
series:
  Actual:
    type: calculated
    formula: IF(Month@ <= Month Actual Index, -GL Amount)
    description: Actual in P&L signs, EUR (income positive, costs negative); empty in months not closed.
    dimensions:
      - PL
      - CostCentres
      - Time
  Actual YTD:
    type: calculated
    formula: SUM(Actual[Year[0]/Month[$1:0]])
    description: Actual year to date, EUR.
    dimensions:
      - PL:
          rollUp: SUM
      - CostCentres:
          rollUp: SUM
      - Time:
          rollUp: LAST
  Budget:
    type: calculated
    formula: Budget Input * Sign
    description: Full budget in P&L signs, EUR.
    dimensions:
      - PL
      - CostCentres
      - Time
  Budget Input:
    type: input
    description: Budget by P&L line, cost centre and month, EUR, every line as a positive number.
    dimensions:
      - PL:
          rollUp: SUM
          splitDown: EQUAL
      - CostCentres:
          rollUp: SUM
      - Time:
          rollUp: SUM
  Budget to Date:
    type: calculated
    formula: IF(Month@ <= Month Actual Index, Budget)
    description: Budget for closed months only, EUR, so that it compares with the actual.
    dimensions:
      - PL
      - CostCentres
      - Time
  Budget YTD:
    type: calculated
    formula: SUM(Budget to Date[Year[0]/Month[$1:0]])
    description: Budget to date, year to date, EUR.
    dimensions:
      - PL:
          rollUp: SUM
      - CostCentres:
          rollUp: SUM
      - Time:
          rollUp: LAST
  Forecast:
    type: calculated
    formula: IF(Month@ <= Month Actual Index, Actual, Budget)
    description: Actual for closed months, budget for the months to come, EUR.
    dimensions:
      - PL
      - CostCentres
      - Time
  Forecast vs Budget:
    type: calculated
    formula: Forecast - Budget
    description: Forecast less full budget, EUR; positive is better than budget.
    dimensions:
      - PL
      - CostCentres
      - Time
  GL Amount:
    type: input
    description: Ledger amount as exported, EUR; debits positive, credits negative.
    dimensions:
      - PL
      - CostCentres
      - Time
  Month Actual Index:
    type: calculated
    formula: MAX(Month Index[Month WHERE not ISEMPTY(GL Amount[All_PL, All_CostCentres])])
    dimensions: []
  Month Index:
    type: calculated
    formula: Month@
    dimensions:
      - Time:
          rollUp: NONE
  Sign:
    type: input
    description: +1 for income lines, -1 for cost lines, set per P&L line and copied to its accounts.
    dimensions:
      - PL:
          rollUp: NONE
          splitDown: COPY
  Variance:
    type: calculated
    formula: IF(Month@ <= Month Actual Index, Actual - Budget to Date)
    description: Actual less budget to date, EUR; positive is better than budget.
    dimensions:
      - PL
      - CostCentres
      - Time
  Variance Pct:
    type: calculated
    formula: IF(Budget to Date <> 0, Variance / ABS(Budget to Date))
    description: Variance over the size of the budget to date; positive is better than budget.
    dimensions:
      - PL:
          rollUp: FORMULA
      - CostCentres:
          rollUp: FORMULA
      - Time:
          rollUp: FORMULA
dataSources:
  Accounts:
    sourceType: excel-range
    rangeRef: Setup!D1:E17
    shape: table
    hasHeaders: true
  Budget:
    sourceType: excel-range
    rangeRef: tblBudget
    shape: table
    hasHeaders: true
    columnLayout: dimension
    columnsDimension: Time
    bandStartMode: after
    bandStartColumn: Cost centre
    bandEndMode: end
  Ledger:
    sourceType: excel-range
    rangeRef: tblGL
    shape: table
    hasHeaders: true
  Signs:
    sourceType: excel-range
    rangeRef: Setup!G1:H10
    shape: table
    hasHeaders: true
  Structure:
    sourceType: excel-range
    rangeRef: Setup!A1:B17
    shape: table
    hasHeaders: true
dataLoaders:
  Accounts:
    type: dimensionGenerator
    source: Accounts
    target: PL
    sourceColumn: Account
    parentColumn: Line
  Load budget:
    type: seriesLoader
    source: Budget
    target: Budget Input
    loadMode: table
    valueColumn: _Value
    duplicateHandling: BLOCK
    dimensionMappings:
      PL:
        column: Line
      CostCentres:
        column: Cost centre
      Time:
        column: _HeaderDimElement
  Load ledger:
    type: seriesLoader
    source: Ledger
    target: GL Amount
    loadMode: table
    valueColumn: Amount
    duplicateHandling: SUM
    dimensionMappings:
      PL:
        column: Account
      CostCentres:
        column: Cost centre
      Time:
        column: Month
  Load signs:
    type: seriesLoader
    source: Signs
    target: Sign
    loadMode: table
    valueColumn: Sign
    duplicateHandling: BLOCK
    dimensionMappings:
      PL:
        column: Line
  P&L structure:
    type: dimensionGenerator
    source: Structure
    target: PL
    sourceColumn: Element
    parentColumn: Parent
outputRanges:
  A Month and YTD:
    cell: '''Actual Month''!A1'
    rowDef:
      blocks:
        - dimension: PL/Line
        - dimension: PL/Group
        - dimension: PL/Section
        - dimension: PL/Total
    colDef:
      blocks:
        - series: Actual_Month := Actual[All_CostCentres, Month[$(Month Actual Index)]]
          format: '#,##0'
        - series: Budget_Month := Budget to Date[All_CostCentres, Month[$(Month Actual Index)]]
          format: '#,##0'
        - series: Variance_Month := Variance[All_CostCentres, Month[$(Month Actual Index)]]
          format: '#,##0'
        - series: Variance_Pct_Month := Variance Pct[All_CostCentres, Month[$(Month Actual Index)]]
          format: 0.0%
        - series: Actual_YTD := Actual YTD[All_CostCentres, Month[$(Month Actual Index)]]
          format: '#,##0'
        - series: Budget_YTD := Budget YTD[All_CostCentres, Month[$(Month Actual Index)]]
          format: '#,##0'
    outputMode: table
    tableOptions:
      includeNonLeafs: true
  B Forecast:
    cell: Forecast!A1
    rowDef:
      blocks:
        - dimension: PL/Line
        - dimension: PL/Group
        - dimension: PL/Section
        - dimension: PL/Total
        - series: Actual := Actual[All_CostCentres]
          format: '#,##0'
          newLine: true
        - series: Forecast := Forecast[All_CostCentres]
          format: '#,##0'
        - series: Budget := Budget[All_CostCentres]
          format: '#,##0'
        - series: Forecast_vs_Budget := Forecast vs Budget[All_CostCentres]
          format: '#,##0'
    colDef:
      blocks:
        - dimension: Time/Month
        - dimension: Time/Quarter
        - dimension: Time/Half-Year
  C Cost centres:
    cell: CostCentres!A1
    rowDef:
      blocks:
        - dimension: PL/Line
        - dimension: PL/Total
        - dimension: CostCentres/Cost Centre
        - series: Actual
          format: '#,##0'
          newLine: true
        - series: Budget to Date
          format: '#,##0'
        - series: Variance
          format: '#,##0'
    colDef:
      blocks:
        - dimension: Time/Month
        - dimension: Time/Quarter
        - dimension: Time/Year
    dropSet:
      Time:
        - 2027-Q2
data:
  '''Inp-Budget''!A1:H14':
    values:
      - - Line
        - Cost centre
        - 2027-01
        - 2027-02
        - 2027-03
        - 2027-04
        - 2027-05
        - 2027-06
      - - Revenue
        - Sales
        - 60000
        - 62000
        - 64000
        - 66000
        - 68000
        - 70000
      - - Cost of sales
        - Product
        - 6000
        - 6150
        - 6300
        - 6450
        - 6600
        - 6750
      - - Cost of sales
        - Sales
        - 2000
        - 2050
        - 2100
        - 2150
        - 2200
        - 2250
      - - Personnel
        - Sales
        - 17100
        - 17100
        - 17100
        - 18000
        - 18000
        - 18000
      - - Personnel
        - Product
        - 28500
        - 28500
        - 28500
        - 30000
        - 30000
        - 30000
      - - Personnel
        - Admin
        - 11400
        - 11400
        - 11400
        - 12000
        - 12000
        - 12000
      - - Marketing
        - Sales
        - 9000
        - 9500
        - 10000
        - 10000
        - 10500
        - 11000
      - - General and admin
        - Admin
        - 6800
        - 6800
        - 6800
        - 6960
        - 6960
        - 6960
      - - General and admin
        - Product
        - 1700
        - 1700
        - 1700
        - 1740
        - 1740
        - 1740
      - - Depreciation
        - Admin
        - 1500
        - 1500
        - 1500
        - 1500
        - 1500
        - 1500
      - - Amortisation
        - Admin
        - 600
        - 600
        - 600
        - 600
        - 600
        - 600
      - - Financial income
        - Admin
        - 0
        - 0
        - 300
        - 0
        - 0
        - 300
      - - Financial costs
        - Admin
        - 240
        - 240
        - 240
        - 240
        - 240
        - 240
  '''Inp-GL''!A1:G199':
    values:
      - - Date
        - Month
        - Account
        - Cost centre
        - Amount
        - Document
        - Description
      - - '2027-01-01'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1022
        - Starter plan, Cust002
      - - '2027-01-03'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -891
        - SI-1005
        - Team plan, Cust043
      - - '2027-01-03'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1006
        - Starter plan, Cust049
      - - '2027-01-03'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -891
        - SI-1016
        - Team plan, Cust040
      - - '2027-01-03'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -1089
        - SI-1020
        - Team plan, Cust002
      - - '2027-01-04'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -1089
        - SI-1021
        - Team plan, Cust009
      - - '2027-01-06'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1003
        - Business plan, Cust012
      - - '2027-01-06'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1004
        - Starter plan, Cust019
      - - '2027-01-06'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -891
        - SI-1008
        - Team plan, Cust057
      - - '2027-01-06'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1010
        - Team plan, Cust024
      - - '2027-01-07'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1025
        - Team plan, Cust030
      - - '2027-01-07'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1029
        - Team plan, Cust048
      - - '2027-01-08'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1018
        - Starter plan, Cust003
      - - '2027-01-08'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1030
        - Team plan, Cust051
      - - '2027-01-09'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1014
        - Team plan, Cust025
      - - '2027-01-11'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1013
        - Business plan, Cust017
      - - '2027-01-11'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -441
        - SI-1023
        - Starter plan, Cust024
      - - '2027-01-12'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1009
        - Starter plan, Cust026
      - - '2027-01-12'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1034
        - Starter plan, Cust060
      - - '2027-01-15'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1001
        - Starter plan, Cust001
      - - '2027-01-15'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -891
        - SI-1032
        - Team plan, Cust009
      - - '2027-01-16'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1026
        - Starter plan, Cust016
      - - '2027-01-16'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -891
        - SI-1027
        - Team plan, Cust051
      - - '2027-01-16'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1031
        - Starter plan, Cust009
      - - '2027-01-17'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1024
        - Team plan, Cust053
      - - '2027-01-19'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -441
        - SI-1019
        - Starter plan, Cust049
      - - '2027-01-21'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1007
        - Business plan, Cust028
      - - '2027-01-21'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -441
        - SI-1028
        - Starter plan, Cust038
      - - '2027-01-23'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -6380
        - SI-1033
        - Enterprise plan, Cust028
      - - '2027-01-25'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1012
        - Business plan, Cust056
      - - '2027-01-25'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1015
        - Team plan, Cust018
      - - '2027-01-25'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -1089
        - SI-1017
        - Team plan, Cust027
      - - '2027-01-26'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1002
        - Team plan, Cust041
      - - '2027-01-26'
        - 2027-01
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1011
        - Business plan, Cust040
      - - '2027-02-01'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1039
        - Team plan, Cust003
      - - '2027-02-02'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1070
        - Business plan, Cust058
      - - '2027-02-03'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -539
        - SI-1046
        - Starter plan, Cust011
      - - '2027-02-03'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1060
        - Business plan, Cust014
      - - '2027-02-04'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1051
        - Business plan, Cust030
      - - '2027-02-05'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1040
        - Business plan, Cust026
      - - '2027-02-05'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -891
        - SI-1048
        - Team plan, Cust004
      - - '2027-02-06'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1053
        - Starter plan, Cust037
      - - '2027-02-07'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1041
        - Team plan, Cust037
      - - '2027-02-07'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -891
        - SI-1058
        - Team plan, Cust006
      - - '2027-02-07'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1065
        - Team plan, Cust006
      - - '2027-02-08'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1052
        - Starter plan, Cust022
      - - '2027-02-09'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1067
        - Business plan, Cust027
      - - '2027-02-10'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1068
        - Team plan, Cust011
      - - '2027-02-11'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1047
        - Team plan, Cust025
      - - '2027-02-11'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1050
        - Team plan, Cust012
      - - '2027-02-13'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1055
        - Team plan, Cust060
      - - '2027-02-13'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -441
        - SI-1064
        - Starter plan, Cust011
      - - '2027-02-14'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1066
        - Starter plan, Cust055
      - - '2027-02-15'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1057
        - Business plan, Cust011
      - - '2027-02-15'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1061
        - Team plan, Cust055
      - - '2027-02-16'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - 990
        - CN-11
        - Credit note, cancelled seat
      - - '2027-02-17'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -2160
        - SI-1072
        - Business plan, Cust007
      - - '2027-02-18'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1042
        - Business plan, Cust008
      - - '2027-02-18'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1043
        - Team plan, Cust017
      - - '2027-02-19'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1045
        - Starter plan, Cust042
      - - '2027-02-19'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1049
        - Starter plan, Cust060
      - - '2027-02-19'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -441
        - SI-1059
        - Starter plan, Cust019
      - - '2027-02-21'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -2640
        - SI-1056
        - Business plan, Cust004
      - - '2027-02-21'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1074
        - Team plan, Cust024
      - - '2027-02-22'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -441
        - SI-1069
        - Starter plan, Cust044
      - - '2027-02-23'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -539
        - SI-1054
        - Starter plan, Cust009
      - - '2027-02-23'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -2160
        - SI-1071
        - Business plan, Cust036
      - - '2027-02-24'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -539
        - SI-1062
        - Starter plan, Cust037
      - - '2027-02-25'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1063
        - Starter plan, Cust045
      - - '2027-02-25'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1073
        - Team plan, Cust017
      - - '2027-02-27'
        - 2027-02
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1044
        - Business plan, Cust059
      - - '2027-03-01'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -1089
        - SI-1090
        - Team plan, Cust043
      - - '2027-03-01'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -539
        - SI-1107
        - Starter plan, Cust003
      - - '2027-03-01'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -539
        - SI-1114
        - Starter plan, Cust001
      - - '2027-03-03'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1089
        - Team plan, Cust038
      - - '2027-03-04'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1079
        - Starter plan, Cust053
      - - '2027-03-04'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1116
        - Team plan, Cust033
      - - '2027-03-05'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1088
        - Starter plan, Cust023
      - - '2027-03-06'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -539
        - SI-1100
        - Starter plan, Cust036
      - - '2027-03-08'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1093
        - Starter plan, Cust044
      - - '2027-03-10'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -5800
        - SI-1084
        - Enterprise plan, Cust058
      - - '2027-03-11'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1117
        - Starter plan, Cust049
      - - '2027-03-12'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -539
        - SI-1085
        - Starter plan, Cust036
      - - '2027-03-12'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1086
        - Business plan, Cust057
      - - '2027-03-13'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -891
        - SI-1110
        - Team plan, Cust038
      - - '2027-03-16'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -891
        - SI-1081
        - Team plan, Cust001
      - - '2027-03-16'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -1089
        - SI-1094
        - Team plan, Cust052
      - - '2027-03-16'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -6380
        - SI-1099
        - Enterprise plan, Cust033
      - - '2027-03-16'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -539
        - SI-1113
        - Starter plan, Cust039
      - - '2027-03-17'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1082
        - Business plan, Cust020
      - - '2027-03-17'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -1089
        - SI-1092
        - Team plan, Cust009
      - - '2027-03-17'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1102
        - Team plan, Cust047
      - - '2027-03-18'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - 490
        - CN-12
        - Credit note, cancelled seat
      - - '2027-03-20'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1095
        - Starter plan, Cust025
      - - '2027-03-21'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1101
        - Business plan, Cust002
      - - '2027-03-21'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -539
        - SI-1108
        - Starter plan, Cust026
      - - '2027-03-22'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -1089
        - SI-1080
        - Team plan, Cust013
      - - '2027-03-22'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -1089
        - SI-1103
        - Team plan, Cust053
      - - '2027-03-23'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1096
        - Team plan, Cust048
      - - '2027-03-23'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -539
        - SI-1112
        - Starter plan, Cust037
      - - '2027-03-24'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -5800
        - SI-1109
        - Enterprise plan, Cust016
      - - '2027-03-24'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1111
        - Team plan, Cust025
      - - '2027-03-25'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1083
        - Team plan, Cust026
      - - '2027-03-26'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1091
        - Team plan, Cust007
      - - '2027-03-26'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -2160
        - SI-1104
        - Business plan, Cust013
      - - '2027-03-26'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -490
        - SI-1106
        - Starter plan, Cust021
      - - '2027-03-27'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1097
        - Team plan, Cust045
      - - '2027-03-27'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -990
        - SI-1098
        - Team plan, Cust024
      - - '2027-03-27'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -5800
        - SI-1105
        - Enterprise plan, Cust025
      - - '2027-03-28'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -2400
        - SI-1087
        - Business plan, Cust046
      - - '2027-03-28'
        - 2027-03
        - 4000 Subscription revenue
        - Sales
        - -2640
        - SI-1115
        - Business plan, Cust005
      - - '2027-01-05'
        - 2027-01
        - 4100 Services revenue
        - Sales
        - -6000
        - SI-1036
        - Onboarding project
      - - '2027-01-18'
        - 2027-01
        - 4100 Services revenue
        - Sales
        - -6000
        - SI-1035
        - Onboarding project
      - - '2027-01-19'
        - 2027-01
        - 4100 Services revenue
        - Sales
        - -2500
        - SI-1037
        - Onboarding project
      - - '2027-01-25'
        - 2027-01
        - 4100 Services revenue
        - Sales
        - -2500
        - SI-1038
        - Onboarding project
      - - '2027-02-07'
        - 2027-02
        - 4100 Services revenue
        - Sales
        - -1800
        - SI-1077
        - Onboarding project
      - - '2027-02-13'
        - 2027-02
        - 4100 Services revenue
        - Sales
        - -3200
        - SI-1078
        - Onboarding project
      - - '2027-02-14'
        - 2027-02
        - 4100 Services revenue
        - Sales
        - -2500
        - SI-1075
        - Onboarding project
      - - '2027-02-16'
        - 2027-02
        - 4100 Services revenue
        - Sales
        - -4400
        - SI-1076
        - Onboarding project
      - - '2027-03-07'
        - 2027-03
        - 4100 Services revenue
        - Sales
        - -6000
        - SI-1119
        - Onboarding project
      - - '2027-03-14'
        - 2027-03
        - 4100 Services revenue
        - Sales
        - -4400
        - SI-1118
        - Onboarding project
      - - '2027-01-02'
        - 2027-01
        - 5000 Hosting
        - Product
        - 5491.65
        - PI-5001
        - Cloud hosting, monthly bill
      - - '2027-02-02'
        - 2027-02
        - 5000 Hosting
        - Product
        - 5512.73
        - PI-5011
        - Cloud hosting, monthly bill
      - - '2027-03-02'
        - 2027-03
        - 5000 Hosting
        - Product
        - 5605.06
        - PI-5024
        - Cloud hosting, monthly bill
      - - '2027-01-07'
        - 2027-01
        - 5100 Payment fees
        - Sales
        - 209.5
        - BK-301
        - Card processor payout fees
      - - '2027-01-14'
        - 2027-01
        - 5100 Payment fees
        - Sales
        - 204.29
        - BK-302
        - Card processor payout fees
      - - '2027-01-21'
        - 2027-01
        - 5100 Payment fees
        - Sales
        - 213.98
        - BK-303
        - Card processor payout fees
      - - '2027-01-28'
        - 2027-01
        - 5100 Payment fees
        - Sales
        - 210.05
        - BK-304
        - Card processor payout fees
      - - '2027-02-07'
        - 2027-02
        - 5100 Payment fees
        - Sales
        - 268.01
        - BK-306
        - Card processor payout fees
      - - '2027-02-14'
        - 2027-02
        - 5100 Payment fees
        - Sales
        - 222.95
        - BK-307
        - Card processor payout fees
      - - '2027-02-21'
        - 2027-02
        - 5100 Payment fees
        - Sales
        - 265.29
        - BK-308
        - Card processor payout fees
      - - '2027-02-28'
        - 2027-02
        - 5100 Payment fees
        - Sales
        - 229.46
        - BK-309
        - Card processor payout fees
      - - '2027-03-07'
        - 2027-03
        - 5100 Payment fees
        - Sales
        - 327.17
        - BK-311
        - Card processor payout fees
      - - '2027-03-14'
        - 2027-03
        - 5100 Payment fees
        - Sales
        - 304.53
        - BK-312
        - Card processor payout fees
      - - '2027-03-21'
        - 2027-03
        - 5100 Payment fees
        - Sales
        - 321.15
        - BK-313
        - Card processor payout fees
      - - '2027-03-28'
        - 2027-03
        - 5100 Payment fees
        - Sales
        - 303.22
        - BK-314
        - Card processor payout fees
      - - '2027-01-27'
        - 2027-01
        - 6000 Salaries
        - Admin
        - 8900
        - JE-105
        - Payroll 2027-01
      - - '2027-01-27'
        - 2027-01
        - 6000 Salaries
        - Product
        - 21800
        - JE-103
        - Payroll 2027-01
      - - '2027-01-27'
        - 2027-01
        - 6000 Salaries
        - Sales
        - 13600
        - JE-101
        - Payroll 2027-01
      - - '2027-02-27'
        - 2027-02
        - 6000 Salaries
        - Admin
        - 8900
        - JE-112
        - Payroll 2027-02
      - - '2027-02-27'
        - 2027-02
        - 6000 Salaries
        - Product
        - 23108
        - JE-110
        - Payroll 2027-02
      - - '2027-02-27'
        - 2027-02
        - 6000 Salaries
        - Sales
        - 13600
        - JE-108
        - Payroll 2027-02
      - - '2027-03-27'
        - 2027-03
        - 6000 Salaries
        - Admin
        - 8900
        - JE-119
        - Payroll 2027-03
      - - '2027-03-27'
        - 2027-03
        - 6000 Salaries
        - Product
        - 23108
        - JE-117
        - Payroll 2027-03
      - - '2027-03-27'
        - 2027-03
        - 6000 Salaries
        - Sales
        - 16000
        - JE-115
        - Payroll 2027-03
      - - '2027-01-27'
        - 2027-01
        - 6100 Social charges
        - Admin
        - 2759
        - JE-106
        - Payroll taxes 2027-01
      - - '2027-01-27'
        - 2027-01
        - 6100 Social charges
        - Product
        - 6758
        - JE-104
        - Payroll taxes 2027-01
      - - '2027-01-27'
        - 2027-01
        - 6100 Social charges
        - Sales
        - 4216
        - JE-102
        - Payroll taxes 2027-01
      - - '2027-02-27'
        - 2027-02
        - 6100 Social charges
        - Admin
        - 2759
        - JE-113
        - Payroll taxes 2027-02
      - - '2027-02-27'
        - 2027-02
        - 6100 Social charges
        - Product
        - 7163.48
        - JE-111
        - Payroll taxes 2027-02
      - - '2027-02-27'
        - 2027-02
        - 6100 Social charges
        - Sales
        - 4216
        - JE-109
        - Payroll taxes 2027-02
      - - '2027-03-27'
        - 2027-03
        - 6100 Social charges
        - Admin
        - 2759
        - JE-120
        - Payroll taxes 2027-03
      - - '2027-03-27'
        - 2027-03
        - 6100 Social charges
        - Product
        - 7163.48
        - JE-118
        - Payroll taxes 2027-03
      - - '2027-03-27'
        - 2027-03
        - 6100 Social charges
        - Sales
        - 4960
        - JE-116
        - Payroll taxes 2027-03
      - - '2027-01-09'
        - 2027-01
        - 6200 Advertising
        - Sales
        - 1200
        - PI-5005
        - Google Ads
      - - '2027-01-14'
        - 2027-01
        - 6200 Advertising
        - Sales
        - 2750
        - PI-5002
        - Google Ads
      - - '2027-01-22'
        - 2027-01
        - 6200 Advertising
        - Sales
        - 2300
        - PI-5003
        - LinkedIn Ads
      - - '2027-01-24'
        - 2027-01
        - 6200 Advertising
        - Sales
        - 1900
        - PI-5004
        - LinkedIn Ads
      - - '2027-02-09'
        - 2027-02
        - 6200 Advertising
        - Sales
        - 2750
        - PI-5012
        - LinkedIn Ads
      - - '2027-02-18'
        - 2027-02
        - 6200 Advertising
        - Sales
        - 2300
        - PI-5014
        - LinkedIn Ads
      - - '2027-02-21'
        - 2027-02
        - 6200 Advertising
        - Sales
        - 1200
        - PI-5016
        - Newsletter sponsorship
      - - '2027-02-23'
        - 2027-02
        - 6200 Advertising
        - Sales
        - 2300
        - PI-5013
        - LinkedIn Ads
      - - '2027-02-24'
        - 2027-02
        - 6200 Advertising
        - Sales
        - 1900
        - PI-5015
        - LinkedIn Ads
      - - '2027-03-08'
        - 2027-03
        - 6200 Advertising
        - Sales
        - 2300
        - PI-5028
        - Newsletter sponsorship
      - - '2027-03-13'
        - 2027-03
        - 6200 Advertising
        - Sales
        - 2300
        - PI-5027
        - Newsletter sponsorship
      - - '2027-03-15'
        - 2027-03
        - 6200 Advertising
        - Sales
        - 1900
        - PI-5025
        - LinkedIn Ads
      - - '2027-03-15'
        - 2027-03
        - 6200 Advertising
        - Sales
        - 2750
        - PI-5026
        - LinkedIn Ads
      - - '2027-02-18'
        - 2027-02
        - 6300 Events
        - Sales
        - 3900
        - PI-5017
        - Trade fair stand, Milano
      - - '2027-03-09'
        - 2027-03
        - 6300 Events
        - Sales
        - 850
        - PI-5029
        - Customer breakfast
      - - '2027-01-01'
        - 2027-01
        - 6400 Rent
        - Admin
        - 4200
        - PI-5006
        - Office rent
      - - '2027-02-01'
        - 2027-02
        - 6400 Rent
        - Admin
        - 4200
        - PI-5018
        - Office rent
      - - '2027-03-01'
        - 2027-03
        - 6400 Rent
        - Admin
        - 4200
        - PI-5030
        - Office rent
      - - '2027-01-05'
        - 2027-01
        - 6500 Software
        - Admin
        - 380
        - PI-5007
        - Slack subscription
      - - '2027-01-05'
        - 2027-01
        - 6500 Software
        - Product
        - 640
        - PI-5008
        - Atlassian subscription
      - - '2027-01-05'
        - 2027-01
        - 6500 Software
        - Sales
        - 820
        - PI-5009
        - HubSpot subscription
      - - '2027-02-05'
        - 2027-02
        - 6500 Software
        - Admin
        - 380
        - PI-5019
        - Slack subscription
      - - '2027-02-05'
        - 2027-02
        - 6500 Software
        - Product
        - 640
        - PI-5020
        - Atlassian subscription
      - - '2027-02-05'
        - 2027-02
        - 6500 Software
        - Sales
        - 820
        - PI-5021
        - HubSpot subscription
      - - '2027-03-05'
        - 2027-03
        - 6500 Software
        - Admin
        - 380
        - PI-5031
        - Slack subscription
      - - '2027-03-05'
        - 2027-03
        - 6500 Software
        - Product
        - 640
        - PI-5032
        - Atlassian subscription
      - - '2027-03-05'
        - 2027-03
        - 6500 Software
        - Sales
        - 820
        - PI-5033
        - HubSpot subscription
      - - '2027-01-10'
        - 2027-01
        - 6600 Professional fees
        - Admin
        - 1350
        - PI-5010
        - Accounting services
      - - '2027-02-10'
        - 2027-02
        - 6600 Professional fees
        - Admin
        - 1350
        - PI-5022
        - Accounting services
      - - '2027-02-21'
        - 2027-02
        - 6600 Professional fees
        - Admin
        - 2800
        - PI-5023
        - Legal, employment contracts
      - - '2027-03-10'
        - 2027-03
        - 6600 Professional fees
        - Admin
        - 1350
        - PI-5034
        - Accounting services
      - - '2027-01-28'
        - 2027-01
        - 6800 Depreciation
        - Admin
        - 1500
        - JE-107
        - Depreciation, laptops and fit-out
      - - '2027-02-28'
        - 2027-02
        - 6800 Depreciation
        - Admin
        - 1500
        - JE-114
        - Depreciation, laptops and fit-out
      - - '2027-03-28'
        - 2027-03
        - 6800 Depreciation
        - Admin
        - 1500
        - JE-121
        - Depreciation, laptops and fit-out
      - - '2027-01-28'
        - 2027-01
        - 6900 Amortisation
        - Admin
        - 600
        - JE-901
        - Amortisation, capitalised software
      - - '2027-02-28'
        - 2027-02
        - 6900 Amortisation
        - Admin
        - 600
        - JE-903
        - Amortisation, capitalised software
      - - '2027-03-28'
        - 2027-03
        - 6900 Amortisation
        - Admin
        - 600
        - JE-905
        - Amortisation, capitalised software
      - - '2027-01-28'
        - 2027-01
        - 7000 Bank charges
        - Admin
        - 128.6
        - BK-305
        - Bank fees
      - - '2027-02-28'
        - 2027-02
        - 7000 Bank charges
        - Admin
        - 122.1
        - BK-310
        - Bank fees
      - - '2027-03-28'
        - 2027-03
        - 7000 Bank charges
        - Admin
        - 148.63
        - BK-315
        - Bank fees
      - - '2027-03-31'
        - 2027-03
        - 7100 Interest income
        - Admin
        - -365.4
        - BK-316
        - Interest on deposit, Q1
      - - '2027-01-30'
        - 2027-01
        - 7200 Interest expense
        - Admin
        - 210
        - JE-902
        - Interest on equipment loan
      - - '2027-02-30'
        - 2027-02
        - 7200 Interest expense
        - Admin
        - 210
        - JE-904
        - Interest on equipment loan
      - - '2027-03-30'
        - 2027-03
        - 7200 Interest expense
        - Admin
        - 210
        - JE-906
        - Interest on equipment loan
  Setup!A11:B17:
    values:
      - - Below EBITDA
        - Net result
      - - Depreciation and amortisation
        - Below EBITDA
      - - Depreciation
        - Depreciation and amortisation
      - - Amortisation
        - Depreciation and amortisation
      - - Financial result
        - Below EBITDA
      - - Financial income
        - Financial result
      - - Financial costs
        - Financial result
  Setup!A1:B10:
    values:
      - - Element
        - Parent
      - - Net result
        - All_PL
      - - EBITDA
        - Net result
      - - Gross profit
        - EBITDA
      - - Revenue
        - Gross profit
      - - Cost of sales
        - Gross profit
      - - Operating expenses
        - EBITDA
      - - Personnel
        - Operating expenses
      - - Marketing
        - Operating expenses
      - - General and admin
        - Operating expenses
  Setup!D11:E17:
    values:
      - - 6500 Software
        - General and admin
      - - 6600 Professional fees
        - General and admin
      - - 6800 Depreciation
        - Depreciation
      - - 6900 Amortisation
        - Amortisation
      - - 7000 Bank charges
        - Financial costs
      - - 7100 Interest income
        - Financial income
      - - 7200 Interest expense
        - Financial costs
  Setup!D1:E10:
    values:
      - - Account
        - Line
      - - 4000 Subscription revenue
        - Revenue
      - - 4100 Services revenue
        - Revenue
      - - 5000 Hosting
        - Cost of sales
      - - 5100 Payment fees
        - Cost of sales
      - - 6000 Salaries
        - Personnel
      - - 6100 Social charges
        - Personnel
      - - 6200 Advertising
        - Marketing
      - - 6300 Events
        - Marketing
      - - 6400 Rent
        - General and admin
  Setup!G1:H10:
    values:
      - - Line
        - Sign
      - - Revenue
        - 1
      - - Cost of sales
        - -1
      - - Personnel
        - -1
      - - Marketing
        - -1
      - - General and admin
        - -1
      - - Depreciation
        - -1
      - - Amortisation
        - -1
      - - Financial income
        - 1
      - - Financial costs
        - -1
namedStructures:
  tblBudget:
    kind: table
    range: '''Inp-Budget''!A1:H14'
    hasHeaders: true
  tblGL:
    kind: table
    range: '''Inp-GL''!A1:G199'
    hasHeaders: true