Key takeaways
- One material row drives on hand, stock value, and margin.
- Record every weigh-in with supplier, kilos, and price.
- Sell by the kilo and record buyer payments against the sale.
- Use MATERIAL REPORT to decide what to buy more of.
A junk shop buys by the kilo from dozens of people a day and sells by the ton to one or two buyers a week. In between, cardboard piles up, copper is counted from memory, and the consolidator's payment arrives short with nobody sure why. ScrapKita PH gives every material one row where kilos bought, kilos sold, stock on hand, and margin are calculated from the weigh-in and sale records.
Price materials once
Each material carries a unit, a buy price, a sell price, and opening stock. Purchases and sales reference the material ID, so the report can total kilos and pesos per material.
When the consolidator changes the copper price, update the sell price on one row and quote from it.
Record every weigh-in
A purchase row records the supplier, material, kilos, unit price, and what was paid on the spot. Amount and balance are calculated, so a community drive paid later carries an honest payable.
Regular pickers get a supplier ID, which makes it possible to see who brings the most and who brings mixed loads.
Sell by the kilo, collect by the sale
Each delivery to a buyer is a sale row per material with kilos and unit price. Payments recorded against the sale ID leave a balance until the buyer settles.
The dashboard shows buyer receivables next to purchase cost, which is the cash question every yard owner asks on Friday.
Read the material report
MATERIAL REPORT totals kilos bought, purchase cost, kilos sold, sales amount, margin, and on hand per material. It shows whether bottles or metal actually carry the yard.
A weekly pass through CHECKS catches purchases pointing at unknown materials, sales to unknown buyers, and negative stock from a missed weigh-in.
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.
ScrapKita 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 DENR or LGU permit compliance, weighing-scale calibration, hazardous-waste handling guidance, price feeds, official receipts, or tax filing.
Frequently asked questions
Can I record purchases from walk-ins without registering them?
Yes. Create one Walk-in supplier ID and use it for occasional sellers; register regular pickers separately.
Does it handle mixed loads?
Record one purchase row per material from the same supplier and date; each row has its own kilos and price.
Does it calibrate or connect to the scale?
No. You enter the weighed kilos; the sheet computes amounts, stock, and margin.
Does this replace official records?
No. No DENR or LGU permit compliance, weighing-scale calibration, hazardous-waste handling guidance, price feeds, official receipts, or tax filing.
