๐Ÿ’ฑ Conversion Rate: 1 USD = XCG All amounts shown in USD

Import Financial Data

Upload CSV files to analyze. Data is stored locally in your browser.

๐Ÿ“Š

Click to upload or drag and drop CSV files

CSV Columns:
Date (2-Jan format) โ€ข Year (2024) โ€ข Product (was Memo) โ€ข Client (was Name) โ€ข Supplier (was Account) โ€ข Qty โ€ข Sales Price โ€ข Amount
Date column uses day+month name format (e.g., 2-Jan, 15-Mar) combined with Year column | Channel assigned per client in ๐Ÿท๏ธ Channels tab

๐Ÿ“Š KPI Summary

๐Ÿ† Top Clients by Region

Transaction Preview

No data imported yet

Upload a CSV file to view your financial transactions

Import data to generate reports

๐Ÿท๏ธ Channel Assignment

Assign sales channels to clients for tracking and reporting. Channels are automatically applied during CSV import.

Loading channel assignment interface...

All Transactions

No data imported yet

๐ŸŽฏ Sales Targets

Set and track sales targets by client, supplier, product, region, channel, and time period

๐Ÿ“Š Total Targets

0
Active targets

โœ… Achieved

0
0% of total

โš ๏ธ At Risk

0
Need attention

๐Ÿ”ด Behind

0
Below target

๐Ÿ’ฐ Total Target Amount

XCG 0
0% achieved

No targets set yet

Click "Add Target" to create your first sales target

๐Ÿ” Data Quality Dashboard

Validate data integrity, detect duplicates, and identify issues

Import data to validate quality

Upload a CSV file to analyze data quality

๐Ÿ“Š Financial Metrics & Ratios

Key financial ratios and health scorecard for Caribbean OTC businesses

Import data to view financial metrics

Upload a CSV file to calculate key financial ratios

๐Ÿ’ต Cash Flow & Liquidity

Cash runway calculator and receivables aging for seasonal cash management

Import data to analyze cash flow

Upload a CSV file to calculate runway and receivables aging

๐Ÿ๏ธ Tourism Season Intelligence

Caribbean tourism seasons, event impacts, and seasonal revenue analysis

Import data to analyze tourism impact

Upload a CSV file to see how seasons and events affect your sales

๐Ÿ“Š Margin Analysis by Dimension

Compare profitability across regions, channels, and customers

Import data to analyze margins

Upload a CSV file to see margin analysis by region, channel, and customer

๐Ÿ’Ž Customer Lifetime Value (CLV)

Identify high-value customers and assess churn risk

Import data to analyze customer lifetime value

Upload a CSV file to see CLV analysis, customer segmentation, and churn risk assessment

๐Ÿ๏ธ Regional Cross-Comparison

Compare performance across Curaรงao, Aruba, Sint Maarten, Bonaire

Import data to compare regional performance

Upload a CSV file with regional data (Country/Region column) to see cross-island comparison

๐Ÿ”ฎ Scenario Modeling (What-If Analysis)

Strategic planning and revenue forecasting

Import data to run scenario analysis

Upload a CSV file to see baseline metrics and run what-if scenarios

โš ๏ธ Customer Concentration Risk

Analyze customer dependency, Pareto distribution, and diversification risks

Import data to analyze concentration risk

Upload a CSV file to see customer concentration metrics

๐Ÿ“Š Statistical Analysis

Descriptive Statistics

Load sales data to see statistics

Trend Analysis

Seasonality Index

Moving Averages

Anomaly Detection

Load data to detect anomalies

Revenue Forecast

๐Ÿ’ฐ Budget vs Actual

Budgeted Revenue

ANG 0

Actual Revenue

ANG 0

Variance

ANG 0

Performance

0%

Budget by Month

Budget by Account

๐Ÿ“ˆ Period Comparisons

Current Period

ANG 0

Previous Period

ANG 0

Change

ANG 0

Trend

โ†’

Revenue Trend Comparison

Variance Waterfall