Lowyat.NET: Latest topics by WJ_Pan

How SMEs Track Customer Payments?

WJ_Pan — Sat, 22 Aug 2026 11:24:02 +0800

Many SMEs focus on increasing sales, but sometimes the real challenge comes from collecting payment.

A company can issue many invoices every month, but if payment records are not updated properly, it becomes difficult to know:

* Which customers still owe money
* Which invoices are overdue
* Whether payments are matched correctly
* Whether credit notes have affected the balance

This problem usually becomes more obvious when transaction volume increases.

Some businesses start with Excel or manual records, but checking bank payments, invoices, and customer balances one by one can become time-consuming.

Having a proper workflow for sales invoice, payment matching, and accounts receivable tracking can help businesses understand their cash position better.

Interested to know how other Malaysian SMEs manage this process. Do most companies here still use spreadsheets, or have you moved to accounting software?

Which POS Features Matter Most?

WJ_Pan — Thu, 20 Aug 2026 09:17:47 +0800

For retail businesses, I feel POS discussions sometimes focus too much on how fast the cashier can complete a sale.

Speed is important, especially when there is a queue or when you're facing high pressure environment, but stock accuracy seems equally important.

Imagine the cashier can scan and complete transactions quickly, but inventory is only updated manually later. After enough transactions, the quantity in the system may no longer match what is actually on the shelf.

For smaller Malaysian retailers, I think the practical features are probably things like:

fast barcode scanning and item search
automatic stock movement after sales
separate records for cash, cards and e-wallets
hold and recall bill
controlled refunds and voids
proper opening and closing of counter
easy payment reconciliation
simple sales and stock reporting

Offline operation could also be useful for shops where the internet connection isn't always reliable.

So I'm curious about people actually running retail businesses here.

If you had to choose, what matters more in a POS system: faster checkout, better stock accuracy, easier payment reconciliation, or better reporting?

How Do SMEs Manage Scattered Information?

WJ_Pan — Tue, 18 Aug 2026 10:01:21 +0800

Quite common for a growing SME to reach a stage where every department seems to have its own way of keeping information.

Sales may use Excel or WhatsApp, accounts use accounting software, warehouse has another stock file, while customer follow-ups are stored somewhere else.

At a smaller scale, this can probably still work. The problem starts when more people and transactions are involved.

One missed update can affect several departments. Sales may think stock is available while warehouse has different numbers. Accounts may be waiting for documents. Management ends up asking several people just to understand what is happening.

A connected ERP is one way businesses try to reduce this by linking sales, inventory, purchasing, invoicing and reporting.

But I don't think ERP automatically solves the problem either. If the workflow is messy or staff don't update transactions properly, the system can still produce unreliable information.

For smaller SMEs with straightforward operations, Excel + accounting software may still be perfectly sufficient. The problem probably becomes more serious once several departments need to work from the same data.

For those working in SMEs, at what point did using separate Excel files / WhatsApp / systems become difficult to manage?

When Is Excel Not Enough for Manufacturing?

WJ_Pan — Fri, 14 Aug 2026 13:04:56 +0800

Many SME manufacturers start production planning with Excel because it is simple and flexible.

But I'm curious where the practical limit is.

Once a factory has more products, BoMs, raw materials, work orders and production stages, there can be several files being updated by different departments.

Then the bigger problem may not be Excel itself, but keeping everything connected.

Sales may have the latest customer demand, production has its own schedule, purchasing has another material list, while the warehouse stock may not have been updated yet.

An MRP approach seems to solve this by connecting material requirements, manufacturing orders, work orders, inventory and production scheduling rather than maintaining each part separately.

I also don't think moving away from Excel necessarily means changing the whole factory at once. Starting with BoM, production orders and material control first sounds more practical for SMEs.

Anyone here working in manufacturing? At what point did spreadsheets become difficult to maintain, and what was the biggest problem — inventory, scheduling, costing, shop-floor tracking or something else?

Is a Basic POS Enough for Retail & F&B?

WJ_Pan — Tue, 11 Aug 2026 15:29:24 +0800

For many small retail shops and F&B businesses, POS starts as a simple cashier system.

But once the business becomes busier, I think the requirements change quite a lot.

A retail shop may need better barcode scanning, stock accuracy, promotions, returns and branch-level inventory. An F&B outlet may care more about quick billing, different payment methods, daily closing and sales reporting.

Then there are other things that aren't very obvious when first choosing a POS:

- Staff access and approval controls
- Refund and discount tracking
- Cash, card and e-wallet reconciliation
- Accounting integration
- Multi-outlet reporting
- Offline operation
- e-Invoice workflow

So maybe the better question isn't just “Which POS is fast?” but “Can the POS still support the business when operations become more complicated?”

For those here running retail, cafés, restaurants or multiple outlets, which POS features became important only after your business started growing?

Too Many Separate Systems Causing SME Problems?

WJ_Pan — Mon, 10 Aug 2026 13:00:08 +0800

A common problem for growing SMEs is that different departments slowly end up using different tools.

Sales may keep information in Excel or WhatsApp, accounts use accounting software, and warehouse staff maintain another stock record.

Nothing is necessarily wrong with using separate tools. The problem starts when the information doesn't connect.

Sales may confirm an order without seeing the latest stock quantity. Warehouse may update stock separately after delivery. Accounts may need to enter the transaction again when preparing the invoice. Management then has to combine information from several departments before getting a clear report.

For a small operation this may still be manageable. But once transaction volume and staff numbers increase, repeated data entry and inconsistent information can become a bigger operational issue.

One alternative is to connect sales, inventory, purchasing, accounting and customer information so that the same transaction can flow between departments.

It also doesn't mean every business needs to change everything immediately. Fixing the areas causing the most repeated work first may already make operations easier to control.

For SME owners here, how are you handling this currently?

Do you prefer one connected system, or several specialised systems that staff are already familiar with?

Can Better Workflow Improve SME Operations?

WJ_Pan — Fri, 07 Aug 2026 16:43:15 +0800

One thing I notice about growing businesses is that operations can become complicated quite quickly.

Sales may have their own Excel file, accounts another system, stock updates come through WhatsApp, while approvals depend on manually asking someone.

When problems appear, businesses often add another spreadsheet, report or system.

But sometimes the real issue is simply that the workflow isn't clear.

For example, who checks stock before confirming an order? Who approves special pricing? When should accounts issue the invoice? Who updates inventory after delivery? Who follows up when payment is overdue?

If these responsibilities aren't clear, even a better system may still leave staff confused.

It seems more practical to first map the actual process from sales → stock → delivery → invoice → payment, identify where work gets delayed or repeated, and decide who is responsible for each step.

After that, it should be much easier to decide what needs automation and what only needs a clearer internal process.

For SME owners here, do you find operational problems are usually caused more by the system being used, or by different departments not following the same workflow?

How Do Organisations Manage Membership Renewals?

WJ_Pan — Thu, 06 Aug 2026 14:50:39 +0800

**Title: How Do Malaysian Organisations Manage Membership Renewals?**

Many clubs, associations, gyms and training centres still manage members through Excel, WhatsApp, email and separate accounting records.

This may work when the member base is small. As the organisation grows, however, the admin team may spend more time checking membership status, preparing invoices, confirming payments, sending renewal reminders and answering repeated questions.

It seems that the bigger problem is often not the amount of work, but that the information is scattered across different places.

A more structured workflow could keep member details, membership plans, expiry dates, invoices, payment status and event registrations together. Members could also be given access to selected information, such as their renewal date or invoice status, without needing to contact the admin team.

However, putting everything online does not automatically solve the problem. The organisation still needs to decide how renewals work, when reminders should be sent, what members can access and which tasks still require staff approval.

For those managing a membership-based organisation, what normally causes the most difficulty: maintaining member records, tracking renewals, collecting fees or managing events?

Do you prefer keeping these processes manual, or would you automate some parts?

Can a Customer Portal Reduce SME Enquiries?

WJ_Pan — Tue, 04 Aug 2026 14:47:58 +0800

Many Malaysian SMEs still manage customer communication mainly through WhatsApp, email and phone calls.

This is convenient, but staff may end up answering the same questions repeatedly:

“Can resend the quotation?”

“Can send another invoice copy?”

“Has the order been delivered?”

“What is the current project status?”

As the business grows, these requests can take up a surprising amount of administrative time.

One possible approach is to provide customers with a secure portal where they can check selected information themselves. Depending on the setup, customers may be able to view quotations, orders, invoices, delivery updates, project progress or support tickets.

This could reduce repeated enquiries and make information easier to find. However, the business must still plan the access rules carefully. Customers should only see information relevant to their own account, and the records must be updated accurately.

It also depends on customer behaviour. Some customers may appreciate self-service, while others may continue asking through WhatsApp because it feels more convenient.

For those running an SME, how do you currently manage repeated document requests and status enquiries? Do you think customers would use a portal regularly?

Why SME Reports Often Don’t Match？

WJ_Pan — Sat, 01 Aug 2026 10:05:53 +0800

A common problem in Malaysian SMEs is that sales, warehouse and accounts may each have their own version of the business numbers.

Sales orders could be tracked through Excel or WhatsApp, stock movements recorded separately, and accounting figures updated only after invoices are prepared. At month end, someone still needs to collect everything, compare the numbers and correct any differences.

This creates a few practical problems:

Sales figures may not match accounting records, stock balances may be questioned, and management reports may already be outdated when they are finally ready.

A connected ERP can help by linking quotations, sales orders, deliveries, stock movements, purchases, invoices and accounting information. This reduces the need to enter or combine the same information repeatedly.

However, using an ERP does not automatically guarantee accurate reports. The company still needs proper workflows, clean opening data, correct product information and staff who update transactions consistently.

For a smaller company with straightforward transactions, Excel and accounting software may still be sufficient. A connected system becomes more relevant when several departments, branches or warehouses need to work from the same information.

For those managing an SME, how are your management reports prepared now? Are they generated directly from one system, or does someone still combine different Excel files every month?

How SMEs Manage Appointments Beyond WhatsApp

WJ_Pan — Thu, 30 Jul 2026 15:29:32 +0800

Many Malaysian SMEs still arrange customer appointments through WhatsApp, phone calls, shared calendars, or Excel.

This normally works when there are only a few bookings. It can become difficult once the business has more staff, services, branches, or appointment types.

The admin team may need to check available times repeatedly, confirm customer details, update different calendars, send reminders, and rearrange bookings manually. Customer enquiries can also get buried inside long WhatsApp conversations.

I have been wondering whether a proper online booking system actually makes this easier. Customers could choose from the available time slots, while the business manages staff schedules, appointment duration, buffer time, and reminders in one place.

It may also be useful if the booking can be connected to the next step. For example, a consultation may require a customer follow-up, while a maintenance appointment may need to be assigned to a technician.

However, I suppose the workflow still needs to be planned properly. Otherwise, the business may simply move the same manual problems into another platform.

For those running service-based businesses, how are you currently managing appointments? Are you still using WhatsApp and shared calendars, or have you moved to a proper booking system?

Excel or MRP for SME manufacturers?

WJ_Pan — Wed, 29 Jul 2026 14:56:05 +0800

Many small manufacturers in Malaysia still manage production using a combination of Excel files, paper job sheets, WhatsApp messages and separate inventory records.

This may work when the number of products and orders is still manageable. But as production volume increases, different departments may start working with outdated or incomplete information.

For example, production may only discover a material shortage after a job has already been scheduled. Purchasing may not know what needs to be ordered early enough, while management may have difficulty checking the actual status of each work order.

A connected MRP system can help organise Bills of Materials, raw-material requirements, manufacturing orders, production schedules, inventory movements and progress reporting.

However, software alone will not solve everything. The company still needs accurate product data, proper workflows and staff who update the system consistently. For a small and simple operation, Excel may also remain sufficient.

For those working in manufacturing, what does your company currently use? At what stage did Excel become difficult to manage?