shopify_orders.csv2,140 rows
| order | date | customer | total |
| #5521 | 03/11/2026 | Apex Retail | $1,240.00 |
| #5522 | 2026-11-03 | orion mart | 1.240,00 |
| #5523 | 03/11/2026 | Bluebay Co | $860.50 |
| … | … | … | … |
QuickBooks · Invoice 1187Oct
Bill toAPEX RETAIL PVT LTD
Amount$1,240.00
Due61 days ago
StatusUnpaid
stock_FINAL_v3.xlsx1,212 rows
| SKU | item | on hand | sold 90d |
| BS-500 | Basmati 5kg | 18 | 312 |
| OL-1L | Olive oil 1L | -12 | 182 |
| TP-200 | Tea 200g | 96 | 0 |
Re: Re: FW: updated numbers
Use this one, the other was wrong 🙏
stock_FINAL_v4.xlsxsales_oct (1).csv
WhatsApp · Store manager
Monday report kab tak? MD is asking09:42
2 date formats
same customer, 2 names
stock can't be negative
which file is final?
0rows in 3 systems
copy-pasted by hand every Monday
SalesStockCollections
SalesNov 2026 · all regions · updated 07:02
Net sales$1.24M▲ 6.1%
Gross margin18.4%▲ 0.8 pt
Orders2,140▲ 4.3%
Overdue$186K12 accounts
Net sales by month$K
AprMayJunJulAugSepOctNov$1.24M
Sales by region
EMEA$468K
Americas$412K
APAC$360K
Summary: Sales up 6.1% on October, led by EMEA. Margin held at 18.4%.
Stock1,212 SKUs · 2 warehouses · updated 07:02
Stock value$412K▼ 3.2%
Days of cover38target 30
No sale 90d14$27K tied up
Out this week3reorder now
Slow stock · value tied upno sale 90 days
Tea 200g$6.8K
Ghee 1L$5.2K
Cashew 500g$4.2K
11 more$10.8K
Reorder nowon hand · sold/week
Olive oil 1L0 · 14
Basmati 5kg18 · 24
Atta 10kg9 · 11
Summary: $27K sits in 14 items with no sale in 90 days. 3 fast sellers run out this week.
CollectionsReceivables · as of 15 Nov 2026
Overdue$186K12 accounts
Avg days late41▲ 6 days
Collected Nov$318K▲ 9%
Top 2 owe$73K39% of overdue
Overdue by age$K
1–30 d31–60 d61–90 d90+ d
$54K$59K$48K$25K
Late payersowed · days late
Apex Retail$42K · 61d
Orion Mart$31K · 48d
10 more accounts$113K
Summary: $73K of the $186K is with two customers. Call Apex Retail first.