← All articles

How to Track Receivables from Suki: Utang Tracker Guide

How to Track Receivables from Suki: Utang Tracker Guide

Every peso your suki owes you on lista is a peso that is not in your cash register — and for many sari-sari stores and carinderias, unpaid utang quietly eats the profit that should be funding restock. Here is how to track receivables properly so goodwill does not turn into a cash flow hole.

Why utang is a silent cash flow killer

Extending utang to suki feels normal — it is how relationships work in a barangay-based business. But every unpaid lista is inventory you already paid for, sitting in someone else’s pocket instead of your cash drawer.

The danger is that receivables do not feel like a problem day to day. Sales still happen, the store still looks busy, but your cash keeps shrinking because it is tied up in IOUs instead of turning back into stock. If you want to understand this pattern more deeply, read our guide on cash flow 101 for small business.

The hidden cost of utang

Every unpaid lista is stock you already paid for

Sitting in someone else’s pocket instead of turning back into cash on your shelf.

The problem with tracking utang in a notebook

Most sari-sari stores still use a notebook or a “libro” taped near the counter. It works until it doesn’t:

  • Pages get torn, wet, or lost
  • Handwriting is hard to read, especially when someone else is tending the store
  • No running total per suki, so you don’t know who owes how much until you flip through pages
  • No due dates, so “paayos ng bayad” becomes vague and easy to forget
  • Easy for entries to go missing or get disputed

A notebook records that utang happened. It does not tell you, at a glance, who is overdue and by how much. That is the gap a simple lista spreadsheet fills.

Notebook / libro

Pages tear or get lost, no running total, no due dates, easy to dispute or forget.

Lista spreadsheet

Auto totals per suki, clear due dates, overdue flags, and a lookup that takes two seconds.

What to track for every borrower

Whether it’s a suki buying rice on credit or a regular customer running a tab at your carinderia, track these fields for every transaction:

  • Borrower name — full name or a nickname you’ll recognize weeks later
  • Amount — the exact peso value of the utang
  • Date given — when the credit was extended
  • Due date — when payment is expected, even if informal
  • Balance — running total per person, updated after each payment
  • Status — paid, partial, or overdue

A spreadsheet lets each suki have their own row or tab, so their total balance updates automatically as you log new utang or payments. No more manual addition, no more guessing.

Set credit limits and terms before you say “sige”

Sari-sari stores that survive on utang usually have unspoken rules that never get enforced. Make them explicit instead:

  • Set a maximum utang amount per suki (e.g. ₱500 or ₱1,000, depending on your daily sales)
  • Agree on a payment schedule — weekly, on sahod day, or end of month
  • Explain the limit kindly but clearly: “Hanggang ₱500 lang po muna, para di rin kayo mabigatan pag bayad”
  • Apply the same rule to everyone, even long-time suki, to avoid awkward exceptions

Clear terms protect the relationship. Vague terms are what lead to resentment later, on both sides.

Following up without losing the suki

Chasing payment feels uncomfortable, but a polite, consistent system is kinder than surprise confrontations. Some approaches that work in Philippine small business settings:

  • Send a friendly reminder a day or two before the due date, not after
  • Use a soft opener: “Paalala lang po sa balance ninyo, pwede na ba pag-ayos?”
  • Offer partial payment as an option instead of all-or-nothing
  • Keep a written record (even a screenshot of your spreadsheet) so there’s no “hindi ko naaalala” dispute

Consistency matters more than firmness. Suki who see that you track everything are more likely to prioritize paying you back on time.

Aging your receivables: know what’s overdue

Once you have a lista system, group balances by how overdue they are:

  • Current — not yet due
  • 1–7 days late — gentle reminder stage
  • 8–30 days late — firmer follow-up, consider pausing new utang
  • Over 30 days late — high risk, stop extending credit until settled

This is called aging your receivables, and it turns a vague feeling of “maraming umuutang” into a clear list of who needs follow-up today.

Current

Not yet due — keep serving normally.

1–7 days late

Gentle reminder stage — a friendly nudge.

8–30 days late

Firmer follow-up — consider pausing new utang.

Over 30 days late

High risk — stop extending credit until settled.

Worked example: how utang ties up your cash

Suppose your carinderia sells ₱3,000 worth of food a day, and on average ₱600 of that (20%) goes on utang to regular suki.

  • In one month, that’s roughly ₱18,000 in unpaid receivables if collection is slow
  • If your ingredient costs are 60% of sales, you need about ₱10,800 in cash just to restock what you already sold on credit
  • Without that cash, you either dip into savings, borrow, or cut back on stock — even though your “sales” numbers look fine

One month of slow utang collection

Unpaid receivables tied up₱18,000
Cash needed just to restock₱10,800

This is exactly why tracking receivables matters as much as tracking sales. For a clearer view of how utang affects your bottom line, pair your lista with a simple profit and loss statement.

When to stop extending utang

Saying no is hard, but it protects your business. Consider pausing credit when:

  • A suki’s balance exceeds your set limit
  • They are more than 30 days overdue with no partial payment
  • Your own cash on hand is too low to restock comfortably
  • You notice a pattern of promises without follow-through

You can still be kind: “Bawiin muna po natin yung balance bago dagdagan, para di rin po kayo lugmok sa utang.” Protecting your cash flow is not unkind — it keeps your store open for everyone, including that suki. If you’re weighing whether to formalize lending further, our guide on how to run a lending business in the Philippines covers structured credit terms in more detail.

A simple lista system that beats a notebook

A basic spreadsheet template can replace your notebook entirely:

  • One tab per suki, or one master list sorted by name
  • Columns for date, item or amount, due date, payment received, and running balance
  • Color-coding or a status column for overdue accounts
  • Automatic totals so you always know your total receivables at a glance

This turns “sino pa may utang sa akin” from a guessing game into a two-second lookup.

Frequently asked questions

How do I politely refuse a suki who wants to add more utang?

Be warm but clear about the limit: explain that it’s for their own good too, so their balance doesn’t grow too big to pay back. Referring to a fixed store policy (“Patakaran po namin, hanggang ₱500 lang muna”) makes it feel less personal.

Should I charge interest or penalties on late utang?

Most sari-sari stores and carinderias don’t charge interest — it can strain relationships. Instead, focus on clear due dates, credit limits, and consistent follow-up. If you’re formalizing lending as a separate business line, interest terms make more sense there.

What’s the easiest way to start tracking receivables today?

Skip the notebook and set up a simple spreadsheet with borrower name, amount, date, due date, and balance columns. Update it daily after closing, and review overdue accounts weekly so nothing slips through.

Stop losing track of who owes you

Get a ready-to-use utang and receivables tracker built for sari-sari stores, carinderias, and small sellers in the Philippines — works in Excel and Google Sheets, no formulas to build yourself.

Shop business spreadsheets →