MRR financials table

Series per row key: one_off (Net (gross − tax, after position discounts) of the one-off positions of the documents finalized in the month: one-time prices of subscription items, manual positions, setup fees, and discounts without a parent position (dunning fees are other operating income, not revenue); credit notes and cancellations count negative.), variable (Net (gross − tax, after position discounts) of the usage-based positions of the documents finalized in the month: usage quantities, metered measurements and percentage prices; credit notes and cancellations count negative.), mrr_bop, mrr_eop (MRR at the end of the previous / this month), accounted_mrr ("Accounted MRR": the recurring invoice positions' shares of the month by their service period, 30/360; null for a snapshot copy), billing_gap ("Differenz Vertrag zu Rechnung": mrr_eop − accounted_mrr, its causes under reasons.billing_gap), new, expansion, contraction, lost, resurrecting (movements), arr_eop (MRR × 12), revenue_churn_rate ((contraction + lost) / BoP), mom_growth ((EoP − BoP) / BoP), cash_collected ("Zahlungseingang") and its split by the invoice the money pays, adding up to it: cash_collected_this_month (invoices finalized in the same month), cash_collected_other_months (invoices of other months), cash_collected_unassigned (no finalized invoice: top-ups, prepayments, the part above the gross of an overpaid invoice), cash_collected_refund_returned ("Erstattung zurückgekommen": a negative refund matched from the bank account), cash_refunded ("Zahlungsausgang": refunds, chargebacks, payouts and return debit fees) and its split by kind, adding up to it: cash_refunded_refund ("Erstattungen"), cash_refunded_chargeback ("Rücklastschriften"), cash_refunded_payout ("Auszahlungen"), cash_refunded_return_fee ("Rücklastschrift-Gebühren": the bank fee of a return debit without a return case, not part of the invoice; all four null for a snapshot copy), cash_corrections ("Korrekturen": refunds entered by hand and cancelled by a counter-entry, no money moved, outside cash in and out; 0 over a range that holds both entries) with cash_corrections_reversed ("storniert") and cash_corrections_counter ("Gegenbuchung", negative; all three null for a snapshot copy), cash_net (by payment date, whatever month the invoice belongs to), cash_forecast ("Rechnungsprognose (brutto)": gross of the invoices the billing forecast expects in the month; null for elapsed months), receivables_eop (open amounts of finalized invoices at the month end; months after the current one carry the invoices open today forward). A value is null when the month has no data at all.

Total column per row key: flows are summed over the range, mrr_bop is the BoP of the first month, mrr_eop, accounted_mrr, billing_gap, arr_eop and receivables_eop are the value of the last month, rates are null. Totals are computed from the exact amounts and rounded once, so they can differ by a cent from the sum of the rounded cells.

Reason split of the movements: expansion and contraction (and new, lost, resurrecting for the detail view), each a map from reason (price_change, quantity_change, discount_start, plan_change, …) to a series aligned with months. Amounts are signed: contraction reasons are negative. billing_gap: the difference contract − invoice per cause (partial_month, billing_start_later, not_yet_billed (the next billing run will invoice it), not_billed (an elapsed month no run will invoice), upcoming_invoice, trial, credit_or_cancellation, billed_after_end, period_shift, price_mismatch, unknown); the causes of a month add up to the billing_gap cell.

Calculation time, effective scope and currency, finding counts.

German name of every key of reasons: the movement reasons (the one catalogue, the same names as the card "Ursachen der Bewegungen"; every reason is its own "davon" row, added and removed products are not netted) and the causes of billing_gap. "Sonstiges" only for a key outside the catalogue.