What is AR Aging and what do hardware stores use it for?

AR Aging is an accounts-receivable report that groups what customers owe by how long it has been outstanding — for example not yet due, over 30 days, over 60 days, and over 90 days. Hardware stores use it to see who owes money and for how long, so they can prioritise collections and decide which customers can still buy more on credit. Debt over 90 days has a very high chance of turning into bad debt, so it should be dealt with before it reaches that point.

How much credit limit should you give a tradesperson?

The safe approach is to start with a small limit and expand it based on payment history, not based on how friendly the customer is or how big they say the job is. Set both a maximum limit and the number of credit days in the system, then let the system warn or block automatically when a sale would exceed the limit, because refusing based on pre-set conditions is far easier than refusing on the spot at the counter.

How should a quotation connect to the sales system?

A quotation should convert into a sales invoice in one click without re-keying any line items, because re-keying is where prices and quantities most often go wrong. The system should also keep a history of what was quoted to whom and for how much, so you never quote the same customer different prices on different occasions.

How Hardware Stores Sell on Credit Without Bad Debt

Home Articles Hardware Store Credit Sales

A hardware store that gives tradespeople no credit at all will lose all its regulars, because tradesmen and contractors work on the cash cycle they get from the project owner — not the cash in their pocket.

But a store that extends credit with no system in place will one day find hundreds of thousands of baht outstanding, with no idea who owes how much or for how long.

Why a paper ledger can't keep up

Most stores start with a notebook or an Excel file. That's fine when you have ten debtors, but it breaks down as you grow.

You don't know the real outstanding balance when the customer is at the counter — front-of-house staff can't tell how much this customer already owes, so they let another credit sale through anyway.
You don't know how old each debt is — the same total balance means something completely different when it's 15 days old versus 120 days old.
You chase by gut feeling — you chase whoever comes to mind, not whoever is the most overdue or owes the largest amount.
Customers dispute the balance — with no statement issued from the same system that recorded the sale, the numbers often don't match.

The most dangerous point is the first one — when front-of-house staff don't know the outstanding balance, selling on credit becomes a matter of not wanting to offend. The customers who owe the most are usually the ones who come in most often and are the friendliest, which makes them the hardest to say no to.

Three things a credit system must be able to do

1. Credit limits and terms the system enforces for you

Set for each customer how much they can owe at most and for how many days. When a sale would push them over the limit, the system must warn or block right at the sales screen — not leave it to staff to remember.

An overlooked benefit is that it helps your front-of-house staff. Telling a customer "the system shows you're over your limit, we'll need to clear it first" is far easier than saying "I think you already owe quite a lot" — and it doesn't damage the relationship.

2. AR Aging — the report that shows where your money is and how long it's been there

An accounts-receivable report should break debt down by age, not just show a total.

Debt age	What it means	What to do
Not yet due	Normal, within credit terms	Nothing needed
Over 30 days	Starting to slip, may just be forgetful	Send a polite reminder statement
Over 60 days	A warning sign, time to talk	Call to agree a payment date, pause new credit temporarily
Over 90 days	At risk of becoming bad debt	Stop credit sales, put an installment plan in writing

The real value of this report is that it turns debt collection into a routine task with a clear order of priority, instead of something you do when you happen to remember.

3. Statements issued from the same system that made the sale

The statement the customer receives must come from the same data recorded at the point of sale — showing the bill number, date, amount, and running outstanding balance. When customers see the full detail there are no arguments over numbers, and collection becomes a matter of paperwork, not of the relationship.

Retail and wholesale pricing in one system

A hardware store sells both to homeowners buying a single piece and to tradespeople buying by the box. If the system has only one price, staff have to apply a discount manually every time — which opens the door to both mistakes and fraud.

What it should be able to do:

Automatic quantity-based pricing — once the order reaches a set quantity it switches to the wholesale price on its own, with no manual discount.
Customer-specific pricing — for major contractors who have agreed a special rate, the system pulls that price automatically when you select the customer's name.
Per-bill profit visibility — so you know whether the wholesale price you gave still leaves an actual profit.

The last point matters more to hardware stores than to most other businesses, because some products carry very thin margins. Giving a wholesale price without checking the cost can quietly turn into selling at a loss — especially when the cost of each purchase round isn't the same.

Quotations — where the big jobs begin

Almost every construction job starts with a quotation. The store that can produce quotations quickly and accurately wins more work.

What makes the difference is that a quotation must convert into a sales invoice in one click, with no re-keying — because re-keying is where prices and quantities most often go wrong, and it's the source of arguments with the customer after delivery.

The system should also keep a history of what was quoted to whom and for how much, so you never quote the same customer different prices on different occasions — something customers remember more accurately than stores expect.

Checklist before choosing a system

Can you set a credit limit and number of credit days per customer, and does the system warn you right at the sales screen?
Is there an AR Aging report broken down by debt age?
Can you issue a statement for each individual customer?
Can you set automatic wholesale pricing by quantity, without applying discounts manually?
Can a quotation convert into a sales invoice without re-keying?
Can it issue full tax invoices?
Can you see the profit per bill at the time of sale?
If you unplug the internet, can you still sell and check outstanding balances?

A note on packages: the B2B feature group (credit sales, quotations, AR Aging and statements) in GutePOS is included in the Pro plan and up, while Starter and Standard don't support it — check this with every vendor, because many charge it as a separate monthly add-on.

Summary

Selling on credit isn't a risk when you have the data. The risk arises when you decide to extend credit without knowing how much that customer already owes and for how long.

The three things that change the game are credit limits the system enforces itself · AR Aging you can review every week · statements issued from the same system that made the sale. With all three in place, extending credit becomes a tool for growing sales instead of a hole your money disappears into.

Want to try GutePOS for hardware stores?

Retail and wholesale in one system, automatic wholesale pricing by quantity, quotations, a credit system, AR Aging, and full tax invoices (included in the Pro plan and up) — free 14-day trial.

See the hardware store solution