CaptainYi
← Back to Tools

Sales Analytics Dashboard

Live

Merges Xero and Excel sales data into consolidated management reports by channel and SKU.

This page shows simulated demo data for illustration purposes only.

AUD 284,500

Total Revenue

1,847

Total Orders

Wholesale

Top Channel

+12.4%

MoM Growth

Revenue by Channel

Wholesale52%
Retail25%
Online15%
Export8%
DescriptionChannelUnits SoldRevenue (AUD)% Share
Beef Striploin 250gWholesale1,840AUD 52,44018.4%
Atlantic Salmon FilletRetail920AUD 38,64013.6%
Chicken Breast (kg)Wholesale3,120AUD 31,20011.0%
Tomato Passata 3kgOnline2,340AUD 23,4008.2%
Jasmine Rice 25kgExport410AUD 22,5507.9%
Heavy Cream 600mlRetail1,680AUD 18,4806.5%

Private Repository

This tool's source code is private. Contact me for technical details.

Tech Stack

PythonXero APIpandasopenpyxlFastAPIDocker
Contact me to learn more →