Key takeaways
- One variety row drives kilos on hand and stock value.
- Record every delivery with sacks, price, and what was paid.
- Sell by the kilo with the actual price charged.
- Check available credit before extending lista.
A rice dealer buys by the sack and sells by the kilo, which is where the kilos go missing. Sacks arrive on credit, carinderias pay weekly, resellers take a hundred kilos at a special price, and the stall's notebook cannot say how much Sinandomeng is really left. BigasDesk PH gives each variety one row where sacks in, kilos sold, and kilos on hand are calculated from the purchase and sale records.
Set each variety once
A variety carries its grade, kilos per sack, buy price per sack, sell price per kilo, and opening sacks. Purchases and sales reference the variety ID.
Kilos on hand and stock value are calculated, so a stock count compares against a number rather than a memory.
Record sack deliveries with what you owe
Each delivery is a purchase row with the supplier, sacks, price per sack, amount paid, and due date. The balance shows what is still owed to the mill.
Supplier payables on the dashboard sit next to customer balances, which is the cash question every dealer faces before the next truck.
Sell by the kilo at the right price
A sale records the customer, variety, kilos, and price per kilo, so retail, carinderia, and reseller prices are all recorded honestly. Amount, payments, balance, and status are formula-driven.
Payments are recorded against the sale ID, so a partial payment from a carinderia leaves an exact balance.
Keep lista within limits
Customers carry a credit limit. CUSTOMER BALANCES totals sales, payments, balance, and available credit, so the stall knows before handing over another sack on credit.
A weekly pass through CHECKS catches sales to unknown customers, purchases of unknown varieties, and negative kilos from a missed delivery.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
BigasDesk PH Private Google Sheets Web App is designed for use with a Google account, Google Sheets, and Apps Script, using owner-only deployment by default.
No NFA or DA permit compliance, price-ceiling monitoring, weighing-scale calibration, milling or moisture records, official receipts, or tax filing.
Frequently asked questions
Can I sell the same variety at different prices?
Yes. Price per kilo is entered per sale; the variety's sell price is only the reference.
What about sacks sold whole?
Record the kilos in the sack, for example 50, at the per-kilo price agreed.
Does it track moisture or milling?
No. It tracks sacks, kilos, money, and credit; milling records stay with the mill.
Does this replace official records?
No. No NFA or DA permit compliance, price-ceiling monitoring, weighing-scale calibration, milling or moisture records, official receipts, or tax filing.
