Collections and statements for a hardware wholesaler.

How a building materials wholesaler in Kota Bharu stopped chasing payments from memory, and now starts every week knowing who owes what, and why.

accounts.yourcompany.my
HHHardware HQ
SearchCtrl K
Customers
Collections12
Statements
Payments2
Disputes3
Reports
RKRokiah · Accounts

Collections · Mon 5 Oct

Overdue41Promised9Disputed3
SQL Account synced 7:00 amSend 12 reminders
Overdue, oldest firstRM overdue
Teguh Renovation WorksRM 7,800
ZubirSupply on hold
Kedai Paip & Elektrik LeeRM 2,060
DevanCall on Thursday
Jaya Aluminium & GlassRM 5,520
Soon KeatPromised Thu 8 Oct
Bina Seroja ConstructionRM 18,750
Ah MengReminder 2 sent
Kedai Besi Ah HuatRM 2,480
DevanPart paid RM 2,000
Seng Fatt HardwareRM 8,400
Soon KeatPromised in 2 parts
Hardware Sri TunjongRM 1,950
ZubirPromise broken
34 more overdue accounts
Jaya Aluminium & Glass

Kota Bharu · 30 days · limit RM 20,000 · sales: Soon Keat

CallSend statement
Not dueRM 2,820
1–⁠30 days lateRM 2,140
31–⁠60 days lateRM 3,380
Total owedRM 8,340
Open invoices
INV-2441021 Jul · due 20 AugRM 3,38046 days late
INV-2489125 Aug · due 24 SepRM 2,14011 days late
INV-2502217 Sep · due 17 OctRM 2,820Disputed · with Soon Keat
What’s happened
September statement sent on WhatsAppRead the same day
Reminder sent for INV-24410RM 3,380, due 20 Aug
Customer replied“6 glass panels from 17 Sep came cracked. Will pay the rest on Thursday.”
Promise to pay recordedRM 5,520 on Thu 8 Oct · reminder the next working day if unpaid
Dispute sent to Soon KeatINV-25022 · cracked panels · call today
‹HHHardware HQ · AccountsBusiness account
Thursday 1 Oct
Good morning, Jaya Aluminium & Glass. Your September statement is attached. Balance: RM 8,340.
PDFStatement, September1 page · RM 8,340
Today
A friendly reminder: INV-24410 for RM 3,380 was due on 20 Aug. You can pay here, or reply if something isn’t right.Pay RM 3,380 online
6 glass panels from 17 Sep came cracked. Will pay the rest on Thursday.
Thank you. We’ve noted RM 5,520 on Thursday 8 Oct. Soon Keat from our sales team will call you today about the panels.
Message
9:16

On screen: Statements and polite reminders until it’s paid.A real project. The business isn’t named, and names and figures on the screens are changed.

Business
Hardware and building materials wholesaler, Kota Bharu
Team
About 35 staff: 4 sales, 3 in accounts
Customers
About 190 credit accounts: hardware shops and contractors
Works with
SQL Account, WhatsApp
First version
3–⁠4 weeks
Project size
Business system, from RM 15k
Before

How collections worked before.

190 credit accounts, an ageing printout once a month, and promises to pay on sticky notes.

  • The ageing report came out of SQL Account once a month, and was out of date the next day.

  • Statements were printed and posted. Some customers never opened them.

  • Reminders were phone calls, made when someone had time. Promises to pay were written on sticky notes.

What we built

Statements on the 1st. Reminders until it’s paid.

SQL Account stays your accounting system. The first version was statements and reminders. Bank matching was added later, as its own small project.

01Ageing by sales rep

Who owes what, by 30, 60 and 90 days, every morning.

The list comes from SQL Account by rep and customer, and over 90 days, supply is held until settled.

accounts.yourcompany.my

Ageing · as at Mon 5 Oct

By sales repBy customer186
SQL Account, 7:00 am
To collectRM 612,480186 credit customers · 41 overdue
Not dueRM 352,300
1–⁠30 daysRM 158,900
31–⁠60 daysRM 72,160
61–⁠90 daysRM 18,620
90+ daysRM 10,500
Sales rep1–⁠30 days31–⁠60 days61–⁠90 days90+ days
SKSoon Keat52 customers41,20018,9004,620–
ZBZubir47 customers38,60021,3006,1004,200
DVDevan39 customers30,10014,2603,6006,300
AMAh Meng48 customers49,00017,7004,300–
Total158,90072,16018,62010,500
2 customers are over 90 days. Supply is on hold until they pay, and their sales reps have been told.
02Monthly statements

A statement to every customer on the 1st.

It arrives on WhatsApp or email with what’s overdue and a way to pay, and accounts sees who read it.

accounts.yourcompany.my

September statements

Sent184Read152Not sent2
Thu 1 Oct, 8:00 am
HHHardware HQKota Bharu, KelantanStatement of accountAs at 30 September
ToJaya Aluminium & GlassPengkalan Chepa, Kota BharuTerms30 daysBalanceRM 8,340.00
DateReferenceDebitCreditBalance
1 SepBalance brought forward9,120.00
4 SepPayment · OR-11823,600.005,520.00
17 SepInvoice INV-250222,820.008,340.00
30 SepBalance due8,340.00
Not due2,820.00
1–⁠30 days2,140.00
31–⁠60 days3,380.00
61–⁠90 days0.00
90+ days0.00
Pay onlineScan, or tap the link in the message. Your payment is matched to these invoices.
03WhatsApp reminders

Polite reminders, and replies understood.

Reminders follow your schedule and wording, and AI records promises to pay and passes other replies to the right person.

‹HHHardware HQ · AccountsBusiness account
Today
Good morning, Seng Fatt Hardware. A friendly reminder: INV-24760 for RM 8,400 was due on 18 Sep. You can pay here, or reply if something isn’t right.Pay RM 8,400 online
Boss, can pay 4,000 this Thursday and the rest on the 22nd?
Thank you. We’ve noted RM 4,000 on Thursday 8 Oct and RM 4,400 on Thursday 22 Oct. We’ll send a reminder the day before each one.
Message
9:24
04Promises and disputes

Every promise followed up. Every dispute sent to sales.

Promises are kept in the customer’s own words, and a broken one is flagged the next morning.

accounts.yourcompany.my

Promises and disputes

This week9Disputes3
Read from WhatsApp replies
Promised this weekRM 46,3009 customers
Kept so farRM 21,1803 customers
Broken last week1Zubir to call today
Promises to pay 9From the customer’s own words
Jaya Aluminium & Glass“Will pay the rest on Thursday.”Thu 8 OctRM 5,520Due Thursday
Seng Fatt Hardware“Can pay 4,000 this Thursday and the rest on the 22nd”Thu 8 OctRM 4,000Due Thursday
Kontraktor Meranti“Transfer Monday morning, boss”Mon 5 OctRM 12,300Kept
6 more this week, including Kedai Besi Ah Huat’s part payment
Disputes, with the sales rep 3
Jaya Aluminium & GlassINV-25022 · cracked glass panelsSKSoon KeatRM 2,820Call today
Bina Seroja ConstructionINV-24990 · 20 bags of cement shortAMAh MengRM 3,150Credit note
Teguh Renovation WorksINV-23880 · price from an old quoteZBZubirRM 1,240Checking quote
05Added later · payments matched

Payments matched to invoices, even without a reference.

Accounts uploads the bank statement, and only the unclear payments wait for a person.

accounts.yourcompany.my

Payments · Mon 5 Oct

To match2All6
Send 4 to SQL Account
Received today RM 24,890 · 6 paymentsMatched RM 23,130 · to check RM 1,760
8:12Kontraktor MerantiTransfer · INV-24620, INV-2470112,300.00Matched
8:40Kedai Cat MewahTransfer · INV-249331,950.00Matched
8:55Kedai Besi Ah HuatTransfer · INV-24788 · RM 2,480 left2,000.00Part paid
9:05Elektrik WiraCheque 004512 · INV-248116,880.00Matched
10:02Transfer, ref 88213No name · Kedai Paip & Elektrik Lee?1,120.00Check
10:15Cash depositNo name, no reference640.00Ask sales
Kedai Paip & Elektrik Lee · INV-2451222 Jun · due 22 Jul · 75 days late · exactly RM 1,120.00
Same amount as their oldest invoice, and paid from this account in August
Not this oneMatch and send

Each part is a feature with its own fixed price, agreed before we start. See how this project was priced or get a fixed quote for yours →

Accounts, sales and the customer, on the same page.

The office works the list. Customers get a clear statement and a polite nudge.

  • RKAccounts · Rokiah

    Starts the day with the ageing, and handles only what needs a person.

  • Sales reps

    Get the disputes for their customers, and see who is on hold.

  • CKOwner · Chee Keong

    Sees who owes what, and who has promised, every morning.

  • Customers

    About 190 shops and contractors get a clear statement and polite reminders, with a way to pay.

Since the reminders went out on their own
  • No more statements in envelopes.
  • No more promises on sticky notes.
  • Every dispute reaches the sales rep the same morning.
Cost and timeline

Statements and reminders first, then bank matching.

A business system first, other features quoted separately. Statements and reminders were live in under a month; bank matching came later.

First phase · 3–⁠4 weeks

Statements and reminders

Added later · 3 weeks · quoted separately

Payments matched

Project sizeFrom RM 15kBusiness system · first 3 months of care included?How we price a project

Want to stop chasing payments by hand?

Questions about this system.

What did the first version cost?

Statements and reminders were a business system, from RM 15k, with a fixed price agreed before we started. Bank matching was quoted separately when the team was ready.

Will reminders upset our customers?

Reminders are polite, in your own words, and you choose who gets them. Customers you’d rather call yourself can be left out.

Which WhatsApp number do reminders come from?

Your company’s own WhatsApp Business number. Replies come back into the system, so the team sees them in one place.

Does it change anything in SQL Account?

No. SQL Account stays your accounting system. The ageing comes from it, and later, matched payments went back into it as receipts.

Can we start with statements only?

Yes. Statements on their own are a focused project, from RM 5k. Here, statements and reminders went first, and bank matching was added later.

Another question? Ask on WhatsAppWe reply within one working day.

Free consultation

Tell us how you work today.

We’ll show you what we’d build first and what it costs. Free, no obligation.

  1. 1

    Send us a message

    Pick what sounds familiar and a time. We reply within one working day.

  2. 2

    A free 30-⁠minute call

    On WhatsApp or Google Meet. We look at how you work today.

  3. 3

    A fixed price for every feature

    Your written quote within 3 working days of the call.

Your free consultation30 min
What takes the most time?Pick any
Pick a time
Send on WhatsApp

Or email sales@belcort.com · We reply within one working day.

More of what we’ve built for distributors