Most Malaysian SMEs already hold the numbers they need to run the business. Sales by customer, stock by location, invoices overdue: it is all in SQL Account, AutoCount or a similar package. The difficulty is getting it out. In many firms someone exports to Excel at month end, rebuilds the same pivot tables and sends round a file that is out of date by the time anyone reads it.
Codech's Insights service is built for that gap. We connect to the accounting data you already have, keep a regularly refreshed view of it, and give owners and managers dashboards and plain-language answers on sales, stock and receivables.
Why this is worth looking at now
Two trends make this a sensible moment to look again at how you report.
First, accounting software vendors are reaching further into the smallest businesses. AutoCount, for example, has launched PalmPOS, which it positions as an affordable e-invoicing option for micro SMEs (The Sun). As more sales are captured digitally at the counter and for e-invoicing, the data held in these systems becomes more complete, and more worth using.
Second, the conversation among SMEs has moved from trying AI to getting a return from it. The 2026 SME AI Summit, for instance, was framed around two aims: bringing costs down and selling more (as described by Ken Holdings). Reporting is where both show up. You cannot cut costs you cannot see, or chase sales you are not measuring.
The questions owners actually ask
Insights is designed around questions, not charts. These are typical of what a distribution or trading business wants to know.
Sales
- Which customers bought less this quarter than last, and by how much?
- Which products earn the best margin after discounts?
- How are this month's sales tracking against the same month last year?
Stock
- Which items have not moved in 90 days, and what are they worth at cost?
- Which fast movers are close to running out at each warehouse?
- Where are write-offs happening most often?
Receivables
- Who owes us money past 60 days, and how much in total?
- Which customers have started paying later than they used to?
- What cash should come in over the next four weeks if customers pay on their usual pattern?
In a spreadsheet process, each of these can take hours, because someone has to export, clean and combine data before answering. Once the data is connected and modelled, the same question can be answered from a dashboard or by typing it in plain language.
What it looks like in practice
Illustrative example only, not a client result. Picture a Klang Valley distributor with three sales staff, two warehouses and around 400 active customers. Today the finance executive spends the first days of each month exporting sales, stock and debtor reports and combining them for the owner's review.
With Insights in place:
- The owner opens a sales dashboard on Monday morning and sees last week's sales by customer and product, set against the same week last year.
- The sales manager asks, "Which customers in Penang have not ordered in 45 days?" and gets a list to call.
- The finance executive works from an ageing view that updates daily, and spends month end chasing payments instead of building the report.
The business, figures and names in this example are invented to show how the service works.
How it works
1. Connect to your accounting data
We start from the system you use. Depending on the product, the version and how it is hosted, we read data through its database, an API or scheduled exports. We confirm the right method for your setup during the assessment rather than assume it. Our integrations page lists the systems we commonly connect to.

2. Clean and model it
Accounting data needs some shaping before it answers business questions: product codes grouped into categories, customers mapped to sales staff and regions, returns and credit notes treated consistently. We agree these rules with you, so the numbers match how you think about the business.
3. Build the views you will use
We build a small set of dashboards around the questions above, then add a plain-language question box so managers can ask follow-up questions without learning a reporting tool. Each answer shows the figures it is based on, so it can be checked.
4. Refresh and review
Data refreshes on a schedule that suits the business, often daily. In the first weeks we compare dashboard figures with your existing reports, so both tell the same story before anyone relies on them.
What Insights does not do
It is worth being clear about the limits.
- It does not replace your accounting system or your accountant. Your books stay where they are.
- It cannot fix data that is never captured. If stock transfers are not recorded, reports on stock by location will be wrong.
- Plain-language answers depend on the data model. Questions outside it are flagged rather than guessed.
- It shows what has happened and what the pattern suggests. Decisions on pricing, credit or purchasing remain yours.
Where it fits with other work
Insights works well alongside Document AI: when supplier invoices are read and entered automatically, the purchasing side of your data is more complete and more current, and the reports built on it improve too. For distribution businesses in particular, our distribution page covers the wider set of problems we see in that sector.

What we need from you
A first Insights project needs less from your team than most owners expect:
- Access. Read-only access to the accounting data, or a person who can set up scheduled exports.
- Your current reports. The spreadsheets you already use each month, so we can match their logic and check our figures against them.
- Your top questions. Five to ten questions you wish you could answer faster. These shape the first dashboards.
- A named reviewer. One person, often from finance, who checks the numbers in the first weeks and tells us when something does not match.
Is it right for your business?
Insights tends to suit firms that:
- Use SQL Account, AutoCount or a similar package as their main record.
- Have someone spending regular time each month assembling reports.
- Have an owner or manager who wants to see sales, stock or receivables more often than once a month.
It is less suited to businesses whose records are mostly on paper, or where the accounting system is updated only at month end. In those cases, the first step is usually getting data captured on time, and we will say so.
Next step: if this sounds familiar, an AI audit is a structured way to review your data, your reporting needs and whether Insights is the right place to start.
Codech Solutions builds AI agents, document automation and business insights for SMEs in Malaysia and Hong Kong.
Frequently asked questions
Does Insights work with SQL Account and AutoCount?
Insights is designed to read data from the accounting package an SME already uses, including SQL Account and AutoCount. The connection method depends on the product, version and hosting, so we confirm it for your setup during the assessment.
Do we have to stop using Excel?
No. You can keep Excel for one-off analysis. Insights removes the need to rebuild the same monthly reports by hand, because the figures refresh on a schedule.
Will Insights change the data in our accounting system?
No. We work from read-only access or scheduled exports. Your books stay in your accounting system and remain under your accountant's control.
How do we know the dashboard figures are right?
In the first weeks we compare dashboard figures with your existing reports, with a named reviewer on your side, before anyone relies on them. Each plain-language answer shows the figures it is based on.
Will Insights increase sales or cut costs on its own?
No. Insights shows what is happening in your sales, stock and receivables sooner and more clearly. What you do with that information, and the results, depend on your decisions.
