What these reports are for
Kanpla's four new export types give your finance team a structured, reconciliation-ready view of everything that happens across your canteen operations — from the moment an order is placed to the moment it becomes an invoice line.
💡 Where to find them: In Kanpla Administration, go to Statistics → Data Export → Create Export (+). Under Type, select any of the four Sales Report export types described in this article.
These exports are designed to answer three core finance questions:
What was the total revenue? Across all orders, channels, and locations in the period.
What needs to be invoiced? Billable orders and billable subsidy portions not yet settled that flow into accounts receivable.
What was the discount impact? How much revenue was reduced by promotions, or exceptions.
Key concepts: Credit, Billing, Discounts, Total
Before diving into the columns, it helps to understand the four commercial components these exports are built around. Together they always sum to the total sales figure.
The Formula
Total Sales = Credit Sales + Billing Sales − Discounts Applied
Credit Sales
Orders paid for directly by the end user via card, app wallet, or credit. This is immediate, settled revenue — cash in the door. You don't need to follow up with an invoice for this portion.
Billing Sales
Revenue that will be invoiced to a company or location rather than collected directly from the end user. This covers two scenarios: orders where the entire payment is handled via invoice, and orders where a subsidy or allowance means the company picks up part of the cost on the user's behalf. In both cases, this portion is contractually owed but not yet collected — it feeds directly into your accounts receivable process.
Discounts Applied
The total value of discounts deducted from orders — discount, promotions, or exceptions. This is a negative contribution to revenue. Monitoring it over time helps you control discount leakage and validate promotional spend.
Total Sales
The complete picture — combines credit, billing, and discounts. This is the figure that should reconcile with your period revenue report, regardless of how individual orders were settled.
⚠️ Important: All four exports use billed_date as their primary date dimension. Using order_date will cause mismatches between the exports and your accounting periods.
The four export types
The exports come in two dimensions: Sales vs. Billing and Aggregated vs. Detailed (row granularity). Pick based on what you're trying to answer.
Sales exports — full picture of all orders
Sales exports include every order, regardless of how it was paid. They give you the most complete view of commercial activity for a period.
Sales Total — Aggregated gives you one row per order, with totals split into credit, billing, and discounts. This is your fastest route to period revenue summaries and management reporting.
Sales Total — Detailed gives you one row per product or discount line within each order, adding product, discount, and tax metadata. Use it for VAT audits, margin analysis, and drill-down diagnostics when aggregated totals look off.
Billing exports — invoice-method orders only
Billing exports are scoped to orders that will result in an invoice — either because the full order is billed to a company, or because a subsidy or allowance means the company covers part of the cost on the user's behalf. They are designed for AR and invoice operations.
Billing Total — Aggregated gives you one row per billable order, including orders with partially subsidised amounts that flow to a company invoice. This is the billing-ready dataset for AR preparation and invoice run operations.
Billing Total — Detailed gives you one row per billable product or discount line. Use it as invoice backup, for client dispute resolution, and for tax scrutiny on billed lines specifically.
At a glance
Export type | Scope | Row grain | Best for |
Sales Total — Aggregated | All orders | 1 row per order | Period revenue summary, management reports |
Sales Total — Detailed | All orders | 1 row per product/discount line | VAT audits, product margin, discount analysis |
Billing Total — Aggregated | Invoice-method + billable subsidies | 1 row per billable order | AR prep, invoice run, client billing packs |
Billing Total — Detailed | Invoice-method + billable subsidies | 1 row per billable line | Invoice backup, disputes, tax scrutiny |
How to get to your totals
Each export type is designed around a specific set of questions. Below is a step-by-step breakdown of which columns to sum to get the numbers your finance team needs most.
Cash received in the bank
Sum the credit sales column to see the total revenue paid directly by end users via card, wallet, or app. This money has already been collected and should reconcile with your payment processor statement (e.g. Adyen). No invoicing or AR follow-up is needed for this portion.
Total sales to be invoiced
Sum the billing sales column to see the total revenue that will be charged to companies or locations via invoice. This includes both fully invoiced orders and the billable portion of orders where a company subsidy or allowance covers part of the cost on the user's behalf — for example, when a company pays for a fixed daily meal allowance and the remainder is paid by the user. This is your accounts receivable figure for the period — earned but not yet collected. Use it to prepare your invoice run and track what is outstanding.
Use the payment method column to differentiate between orders that are fully invoiced and orders that have a billable portion due to a subsidy. Looking to create an invoice for subsidies only? Then filter for payment method hybrid-billing and sum the billing sales column.
Total discounts given
Sum the discounts column to see the total value of discounts, promotions, and exceptions deducted in the period. This is typically a negative number. Use it to monitor discount leakage, verify promotional budgets, and understand the net impact on revenue.
Total revenue for the period
Sum the total sales column to get the complete revenue figure for the period — combining credit sales, billing sales, and discounts in one number. This equals Step 1 + Step 2 minus Step 3, so you can use it as a cross-check before signing off on your management report.
💡 Tip: Use the excl_vat variants for net revenue reporting and incl_vat for gross figures (e.g. customer-facing invoices). The vat column gives the VAT portion in isolation for tax filings.