Skip to content
Work with Pinoy AI Works

← Work & business

Everyday AI · Work & business

Manage sari-sari store capital, utang, and profit

Do you run a sari-sari store or home food sideline and struggle to separate store capital from family expenses and customer utang?

Listen to this guide

AI narration · English · Prompt text stays on the page

Try ElevenLabs ↗ · Affiliate link

A neighborhood store counter with glass jars and a wooden cash tray, shown in Pinoy AI Works artwork

What to do

  1. Estimate your daily gross sales, estimated product markup (usually 10% to 20%), store operating expenses (electricity for ref, ice, bags), and total outstanding utang.
  2. Paste the prompt below into ChatGPT, Gemini, or Claude.
  3. Apply the 3-can/3-envelope cash management rule to ensure your restocking capital is never spent on personal groceries or family emergencies.

Try this prompt

Provide your average daily sales and monthly electricity/bills to generate a foolproof cash flow envelope system.

Help me make a simple sari-sari store snapshot from only the figures I provide. Keep cash, inventory, customer utang and profit separate.

PERIOD
[DATE RANGE]

INPUT
Opening cash/capital for this period: ₱[AMOUNT / TO CONFIRM]
Cash sales collected: ₱[AMOUNT]
Sales made on customer utang: ₱[AMOUNT]
Old utang collected this period: ₱[AMOUNT]
Purchases/restocking paid: ₱[AMOUNT]
Other store expenses paid: [ITEM + AMOUNT / NONE]
Owner money added: ₱[AMOUNT / 0]
Owner withdrawals/personal use: ₱[AMOUNT / 0]
Customer utang still unpaid at period end: ₱[AMOUNT / TO CONFIRM]
Inventory value: [METHOD + AMOUNT / TO CONFIRM]

RULES
- Do not treat unpaid customer utang as cash received.
- Do not treat owner money added as sales or profit.
- Do not treat owner withdrawals as a business expense unless I explicitly classify them that way.
- Do not invent missing sales, stock cost, markup or collections.
- Do not claim true accounting profit if cost-of-goods/inventory information is insufficient.

OUTPUT
1. Cash movement table.
2. Customer-utang movement: new credit sales | collections | ending unpaid amount, with reconciliation warning if figures do not match.
3. Owner capital movements separately.
4. Expenses/restocking.
5. What profit figure can and cannot be calculated from my inputs.
6. “To confirm” figures needed for a more accurate profit calculation.
7. Simple next-period tracking template.

Show all arithmetic. If the records do not reconcile, report the difference instead of hiding it or forcing a profit number.
See a sample result

Illustrative example. Your answer may differ.

Result: Out of ₱3,500 daily sales: ₱2,900 goes immediately into Envelope A (Puhunan Pambili), ₱150 into Envelope B (Kuryente/Gastos), and ₱450 into Envelope C (Tubo/Arawang Sahod). Never mix personal grocery money with Envelope A.

Before you use it: Treat your own family as customers. If anyone takes a drink or snack for household consumption, log it and pay for it from personal funds so the store does not slowly go bankrupt.

Philippine notes

  • Uncontrolled "pautang sa kapitbahay" is the #1 reason neighborhood micro-stores close down within their first 12 months.
  • Wholesale rewards programs (like Puregold Tindahan ni Aling Puring) can add 2% to 4% back to net margins through points and cashback promos.