How to Track Outstanding Payments in Your Auto Parts Shop

Here’s a question: right now, without opening any book or asking anyone, how much money do customers and mechanics owe your shop?

If you can’t answer that within 30 seconds, you have an outstanding payments problem — not because the money is lost, but because you don’t have enough visibility to collect it systematically.

Outstanding credit is one of the biggest cash flow challenges for auto parts shops. The mechanic who picks up parts on account. The workshop that pays “at the end of the month.” The regular customer whose ₹5,000 balance has been “pending” for 4 months.

Why Outstanding Payments Accumulate

It starts innocently. A mechanic needs 3 oil filters urgently. He’ll pay next week. You let it go — it’s a regular customer, it’s a small amount.

Three weeks later, he’s picked up parts on account 4 more times. Now he owes ₹8,000.

You haven’t sent a formal reminder. The account isn’t in any system. It’s in a notebook, or maybe just in your head.

Then the mechanic switches to a different parts supplier — better credit terms, maybe a personal relationship. He’s gone. Your ₹8,000 is a difficult conversation that keeps getting postponed.

This happens at every auto parts shop. The volume and damage depends on how much credit you extend and how tightly you track it.

What You Need to Track for Every Outstanding Account

For each party who owes you money, you need to know:

1. Who they are — full name, phone number, GST (if registered)
2. Each transaction — date, invoice number, amount, items
3. Running balance — total outstanding at any point
4. Age of the debt — how long each outstanding amount has been due
5. Credit limit — the maximum you’re willing to extend
6. Payment history — do they usually pay on time? Have they bounced before?

Without this information at your fingertips, every collection effort is a guessing game.

The Outstanding Payments Funnel

Think of your outstanding accounts in age buckets:

Most shops don’t segment their outstanding amounts like this. They have a single “pending amount” figure and no systematic follow-up calendar.

When you look at a report that shows: “₹22,000 in the 60–90 day bucket from 3 customers,” it becomes immediately clear where to focus your collection energy.

Setting Up Systematic Follow-Up

Step 1: Enter every credit sale as a proper ledger entry

Every time a customer or mechanic takes goods on credit, raise an invoice — even if they don’t need a paper copy. The invoice creates a ledger record with a date, an amount, and a balance.

Shops that allow counter staff to “note it down and enter later” inevitably have missing entries. The discipline is: no goods leave without an invoice (or at minimum a digital entry).

Step 2: Set credit limits per customer

Your billing software should allow you to set a maximum credit limit for each customer. When a mechanic’s balance reaches ₹5,000 (his limit), the system warns you before you allow another credit sale.

Credit limits protect you from any single customer accumulating too much exposure.

Step 3: Use the outstanding report daily

Every morning, spend 3 minutes looking at your outstanding report. Who crossed their credit limit? Who’s been overdue more than 30 days? Who has a large balance you hadn’t noticed building up?

This 3-minute review is the single most effective thing you can do to prevent bad debt.

Step 4: Send WhatsApp reminders on a schedule

When an invoice crosses 15 days unpaid, send a WhatsApp message:

“Namaste [name], just a reminder that ₹[amount] from invoice [#] dated [date] is due. Please settle at your convenience. — [Shop Name]

This is not aggressive — it’s professional. It also creates a written record that you followed up.

Many shops feel awkward about payment reminders. The reality is that customers who pay on time expect to be reminded — it’s part of normal business. And customers who don’t intend to pay are a problem that reminder messages help identify early.

Step 5: Stop credit when limits are breached

This is the hardest but most important rule: when a customer exceeds their credit limit or is more than 45 days overdue, no more credit until they settle.

Enforcement feels uncomfortable. But extending credit to someone who is already overdue is usually making the problem worse, not better.

The Ledger Statement: Your Collection Tool

When a customer disputes how much they owe, or when you’re doing a monthly settlement, a ledger statement is your proof.

A ledger statement shows:

• Opening balance at the start of the period
• Each invoice (date, number, amount)
• Each payment received (date, amount, mode)
• Closing balance

Send it via WhatsApp or email. Ask the customer to confirm. This turns an informal “you owe me money” into a formal acknowledgment.

In Wrenchly, you can generate a ledger statement for any customer for any date range and share it directly via WhatsApp — without printing anything.

Age Analysis: Your Monthly Review

Once a month — ideally the 1st or 2nd of the month — run an age analysis report:

This report is your collection action plan for the month. K.P. Motors needs a phone call — ₹6,000 is over 60 days old.

What to Do About Very Old Outstanding Amounts

If 90–120 days overdue:

• Make a personal call. Be direct but professional: “We need to settle this by [date] to continue supply.”
• Offer a settlement plan if cash flow is their issue: “Pay ₹5,000 now and ₹5,000 next week.”
• Stop all supply until settled.

If 120+ days overdue with no response:

• Send a formal demand letter (WhatsApp message with the ledger statement attached)
• Consider whether the relationship is worth preserving
• If the amount is significant (₹20,000+), legal options: negotiable instruments act, cheque bounce if a cheque was issued

Prevention is far better: tighter credit limits, shorter credit periods, and earlier follow-up mean you rarely reach the 90+ day stage.

How Much Is Sitting in Outstanding?

Do this calculation: total outstanding amount ÷ monthly sales.

If your outstanding is less than 10% of monthly sales, you’re managing credit well.

If it’s 20–30%, you’re at risk — a few customers not paying could cause serious cash flow problems.

If it’s above 30%, outstanding credit is a crisis that needs immediate systematic action.

Wrapping Up

Outstanding payments don’t go away on their own. They either get collected with consistent effort, or they become bad debt that your shop quietly absorbs.

The difference between shops that recover 95% of credit sales and shops that recover 70% is systems — credit limits, age analysis, scheduled reminders, and the discipline to stop extending credit when limits are breached.

→ Wrenchly’s credit management module includes per-customer ledgers, age analysis reports, WhatsApp ledger statements, credit limit enforcement, and outstanding dashboards. Stop guessing, start collecting.

Related reading:

• Digital Hisaab: Stop Losing Money on Credit Customers
• How to Give Your CA Secure Access Without Sharing Passwords
• GSTR-3B for Automobile Dealers: 7 Common Mistakes