Learning dashboard
SQL calculations active
Database overview
Automated overview of sales, tax and cash-flow data from the SQLite database.
Overview example
43.6 %
Overall margin rate calculated from sales.
CA HT106 837 715 €
Overdue balances43 903 260 €
Overview
Overview globale
Key metrics
Local progress
0 / 18Your progress is stored in this browser.
Continue with exercise 1Recent activity
View exercisesNo completed exercise yet.
Calculations
Ratios and attention points
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
ConcentrationAdditional data VAT, customer receivables and SQL comments Show
VAT overview
Tax| Metric | Amount |
|---|---|
| VAT collected | 17 637 422 € |
| Deductible VAT | 10 772 322 € |
| Net VAT payable | 6 865 101 € |
Top 10 outstanding balances
Credit management| Customer | Invoice | Outstanding balance |
|---|---|---|
| Entreprise Fictive 038 | #4382 | 91 135 € |
| Entreprise Fictive 187 | #2751 | 85 104 € |
| Entreprise Fictive 168 | #4126 | 82 889 € |
| Customer Particulier 130 | #3621 | 82 174 € |
| Entreprise Fictive 026 | #109 | 79 997 € |
| Entreprise Fictive 182 | #680 | 76 612 € |
| Entreprise Fictive 096 | #309 | 74 663 € |
| Entreprise Fictive 024 | #1417 | 73 821 € |
| Entreprise Fictive 212 | #3140 | 73 043 € |
| Entreprise Fictive 078 | #3960 | 71 413 € |
Comments generated from calculations
SQL resultsComment
VAT collected exceeds deductible VAT: net VAT payable is €6,865,101.
Comment
Customer overdue balances represent 35.3% of gross revenue.
Comment
The largest customer accounts for 0.8% of revenue excluding VAT.
Comment
The overall margin rate is 43.6%.