Learning dashboard
SQL calculations active
Database overview
Automated overview of sales, tax and cash-flow data from the SQLite database.
Overview example
48.9 %
Overall margin rate calculated from sales.
CA HT61 900 €
Overdue balances36 040 €
Overview
Learning database · Overall view
Key metrics
Calculations
Additional ratios
Outstanding balances as a share of gross revenue.
Largest customer's share of revenue excluding VAT.
Gross margin as a share of revenue excluding VAT.
Attention point
Overdue balances exceed 20% of gross revenue.
Customer portfolio
The largest customer represents less than 30% of revenue excluding VAT.
Visualization
Activity and customer portfolio
Revenue excluding VAT by month
TrendTop customers by revenue excluding VAT
ConcentrationDetails
Reading the ratios
Outstanding balances as a share of gross revenue.
Largest customer's share of revenue excluding VAT.
Gross margin as a share of revenue excluding VAT.
Attention point
Overdue balances exceed 20% of gross revenue.
Customer portfolio
The largest customer represents less than 30% of revenue excluding VAT.
Additional data
VAT and customer receivables
VAT overview
Tax| Metric | Amount |
|---|---|
| VAT collected | 12 380 € |
| Deductible VAT | 4 480 € |
| Net VAT payable | 7 900 € |
Invoices with outstanding balances
Credit management| Customer | Invoice | Outstanding balance |
|---|---|---|
| Gamma Industrie | #4 | 18 000 € |
| Nova Pharm | #8 | 6 440 € |
| Delta Export | #5 | 5 600 € |
| Alpha Distribution | #2 | 3 000 € |
| Omega Services | #6 | 3 000 € |
Comments generated from calculations
SQL resultsThe comments below are generated from metrics calculated from the SQLite database.
Comment
VAT collected exceeds deductible VAT: net VAT payable is €7,900.
Comment
Customer overdue balances represent 48.5% of gross revenue.
Comment
The largest customer accounts for 24.2% of revenue excluding VAT.
Comment
The overall margin rate is 48.9%.