shopify_orders.csv2,140 rows
orderdatecustomertotal
#552103/11/2026Apex Retail$1,240.00
#55222026-11-03orion mart1.240,00
#552303/11/2026Bluebay 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
SKUitemon handsold 90d
BS-500Basmati 5kg18312
OL-1LOlive oil 1L-12182
TP-200Tea 200g960
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.