SQL

About SQL Accounting & Payroll

More than 210,000 companies are using SQL Accounting software to manage their daily business transactions.

SQL Account is trusted by businesses both locally and internationally. SQL account is the best accounting software that packed with a plethora of useful features that are tailored to enhance your business processes. Speed up your book-keeping procedure so that you can focus on other equally important aspects of your business.

SQL Account’s wide range of functions include data collection and analysis, customizable reporting to suit your business workflow , inventory, Commission calculation, e-Commerce solutions and SST processing. SQL Account is available in both cloud-based and desktop application.

We provides an abundance of resources to support you and your business throughout the use of our software. SQL accounting software comes with top quality support. Why depend on self-search or robot generated answers when you can get a qualified human to answer your questions.

SQL Accounting & billing & Inventory

Sales and Purchase

What’s unique?

Get the best estimation of profit before you send out your quotations! The profit estimator works by accessing the actual cost of the item. But you can also enter your desired profit amount or profit margin and we can compute what your selling price should be!

SQL Account’s backorder report makes it easier for you to do partial delivery. With this report, you can examine the levels of pending orders and be informed of the expected delivery date for delivery planning

The Multiple Pricing feature lets you set separate sales price for dealers and end-users in the easiest way possible. Our latest AI selling price assignment supports bulk qty pricing, priority following quotation, and also allows you to set pricing with limited time validity.

SQL Account’s report designs come with flexible grouping and filtering function. You can view the top/bottom 20 products , customer, agent and more using the Evolutionary flexible Mix & Match SQL Reporting with complete drill down to individual source functions

Do you want a report that displays the profit gained from sales? Do you want the profit to be grouped by items/invoice? SQL comes with a user definable data mining tool that allows you to pick the data that you want to analyze. For eg, items with a profit margin of less than 5%.

Are you still manually sending customer statements? With SQL Account bath email feature, you can automatically send out all statement of account to respective customers in just a few clicks. You can also set a password encryption for the documents sent.

Step it up by using Whatsapp to send your business documents! SQL Account is the first accounting software integrated with Whatsapp feature, now you can send Quotation, Invoice, Statement of account and many more documents to your clients via Whatsapp with a few simple clicks.

SQL Account comes with a variety of report formats for all documents. SQL also has a user friendly report designer tool. Now, you have the liberty of creating a report that you want anytime and anywhere!

Need a report?
Our sales module comes with a plethora of sales reports such as Sales Document Listing, Outstanding Sales Document Listing, Sales Picking List, Customer Price History, Profit and Loss by Document, Sales Analysis by Document and Yearly Sales Analysis.

Stock

What’s unique?

SQL stock costing with FIFO, weighted average, you can even backdate transactions and our system will automatically calculate the costing.

SQL has a smart automated stock reorder advice function. With this, you can generate a purchase order just by using a drag and drop function.

Track your inventory beyond the warehouse. Perform stock transfers between inter-branch, consignment, van sales & more.

set your stock item with multiple units of measurement, like unit, box, carton! You can even set different UOM for the product that you purchased and sold. For eg. You purchased a product in carton but sell it in unit.

assign your stock by category and view any stock report by filtering category or grouping by category for flexible reporting

Create your barcode and raise you invoice by scanning a barcode during your sales transaction, you can even print barcode sticker from SQL!

SQL Manufacturing comes with Job order function that can help you in your production material planning, configure accurate production cost calculation based on real time costing method, landing cost allocation method, manage work-in-progress for finished product and stock batch expiry control.

Need a report?
The stock module comes with Stock Document Listing, Stock Reorder Advice, Stock Physical Worksheet, Stock Card, Stock Month End Balance, Stock Aging and Stock Analysis by Document

Stock

What’s unique?

SQL Account will automatically set sales and service taxed in your invoice so that you nvr have to worry about forgetting to include tax in your invoice.

want an estimate figure for your sales tax? process SST-02 and check the estimation. You can make changes in this draft if you need to.

Completed SST report compliant to Royal Malaysia Custom Department. All sales, purchase, exported sales, exemption for sales and purchase will be populated by the system.

Need a report?
SST-02 report, SST Listing, advance filtering for SST listing. pivot table for SST Listing

Others Good Features

What’s unique?

Buy and sell from all over the world. SQL advance currency module (inclusive of Customer, Supplier, foreign currency bank account) automates all currencies transaction, has accurate gain loss calculation, and supports report comparison between local and foreign currencies.

Our software has extended our accounting functions by not only generating Profit & Loss by project and multiple years of retained earning by project, but also making it possible to Balance Sheet reports by project too.

Create combination of few product as packages, easy for invoice billing by single click.

Cost apportionment into product costing such us transportation cost apportionment into few product costing.

Do not limit your commission plan with us, we support a variety of commission scheme, e.g. partial payment partial commission, profit margin-based commission calculation, collection days with different commission rate, different group of items have different commission rate.

SQL Accounting is the best accounting software can cater from small business to large organisation. SQL Account has user defined fields that can be easily altered and customized. With user defined fields, you can create the perfect document that suit your business size and workflow.

Unique serial number for each product quantity, trace balance qty with serial number info, check serial number inquiry & stock balance listing by serial number.

Update all items pricing by increase or reduce, it can be update by group of product, adjust the group of product by increase percentage or value.

Tell us what you need, and we can make our system compatible with your business. This makes us the best accounting software. From purchase invoices that requires an approval to complex calculations-based functions, we do it all.

Need a report?
Stock Document Listing, Stock Reorder Advice, Stock Physical Worksheet, Stock Card, Stock Month End Balance, Stock Aging and Stock Analysis by Document all from the Stock Module.

Customer

What’s unique?

key in bulk invoices using fast entry listing screen or import data directly form Excel document. Speedy invoice generation with just 1 click.

A useful feature recommended by Tax Accountants. SSM Power Search opens the path for fast, real time connection to SSM Malaysia. This comes in handy when you need to search for a company’s registration number in your bill payments to ensure Tax Compliance.

Flexible and customizable customer ageing formula that was made to fit any business. Need a -precise calculation of Credit Terms, due date calculation, or rounding to next month end? Our formula can do it all.

Has your customer been holding an outstanding amount for an extended period of time? To prevent this, you can set not only credit limits in SQL system, but also an OVERDUE limit. With this, you can prevent creations of delivery orders & invoices for an overdue customer.

Having trouble managing invoices? Wondering why you have outstanding invoices even after receiving payment? SQL Account has a smart feature for you to knock off all invoices using FIFO, in 1 simple click.

Effectively manage your post-dated cheque and bounced cheque easily in SQL account. Our system will automatically reconfigure the accounting entry for your bounced cheques.

SQL Account is the only accounting software in Malaysia that integrate with real time CTOS financial data. It provides SQL Account users a financial standing overview of their customers and suppliers. Helping users make better business risk assessment.

Need a report?
Customer module has a wide range of reports such as Customer Document Listing, Customer Balance Report, Due Document Listing, Aging Report, Customer Statement, Customer Post Dated Cheque Listing, Customer Analysis by Document, and Customer Sales and Collection Analysis. Each of these reports have been proved to work well with multi-currency.

Supplier

What’s unique?
The features listed in the customer module are also applicable for supplier module. Below are the supplier module’s extra features:

Create multiple bank accounts for each supplier if necessary. You can select the bank of your choice for each payment that you make and generate e-banking giro integration.

Our supplier module contains an array of features like: fast entry for multiple invoices, flexible aging formula setting, advance credit limit & credit control, auto knock off invoice after payment, post-date cheque and bounced cheque management, and many more!

Need a report?
We provide a wide range of reports that are detailed and user-friendly at the same time. The supplier module comes with:  Supplier Document Listing, Supplier Balance Report, Due Document Listing, Aging Report, Supplier Statement, Supplier Post Dated Cheque Listing, Supplier Analysis by Document, and Supplier Sales and Collection Analysis. Each of these reports have been proved to work well with multi-currency.

General Ledger

What’s unique

Customizable date range comparison lets you view your financial report in eg 24 months or more. Flexible Calendar year vs financial year reporting. SQL Account also supports multiple project comparison

Create unlimited sub accounts and financial reports. View it in a summarize format or by sub account details

You can limit your employees’ access and control what they can do. For eg, Junior users are allowed to access cash book entry, but NOT documents with the selected keyword. For example, if the keyword is “director fees”, junior users will not be able to view the document

All our reports are built in with a smart drill down feature. Double click any figure in your financial reports, and you will able to see the detail of the source document

Use SQL consolidation account to evaluate group companies financial performance without any hassle

Need a report?
SQL Account provide a comprehensive range of financial reports such as G/L Document Listing, Journal of Transaction Listing, Transaction Summary Listing, Ledger Report, Trial Balance, Receipt and Payment report, Profit and Loss Statement, and Balance Sheet Statement.

Special Industries

What’s unique

  • Accountant set
  • Shipping, Freight and Forwarding
  • Property Management
  • Construction Company
  • Distributor, Wholesaler
  • Services Company
  • Motor Vehicle System
  • Transportation
  • Photocopier Meter Reading
  • Paper Industries
  • Pharmaceutical
  • Glass and Aluminum industries

Need an assist?
Contact us for more industries based solutions.

Unlimited monthly free accounting software training and responsive support team

No worries if you are unfamiliar with our system! We provide free accounting software training every month. Contact us to find out more! Our technical support team is fully trained and equipped to assist you via phone, email, and remote access.

SQL PAYROLL

What’s unique? SQL Payroll software is built from ground up around Payroll Process. You can easily process and print from one to hundreds of employee’s pay slip with just a few mouse click. What’s more is that you can virtually keep unlimited payroll history and have your data safe and sound with strong security and data protection.

SQL Payroll is so simple! Discover how you can go from payroll processing to printing pay slips in just a few steps.

SQL Payroll Feature
Sync Across All Devices

Everything you need to make your business grow super fast!

Monthly payroll process

What’s unique

Enjoy speedy payroll processing and view each earning breakdown with an intuitive screen display

Edit payroll processes anytime anywhere with SQL Payroll software. Experience accurate, real time recalculations of statutory contributions

SQL Payroll is compliant to all Malaysian statutory bodies like KWSP, LHDN and SOCSO. Our system saves you the trouble by auto calculating EPF, SOCSO, EIS, HRDF and PCB contribution. To ensure flawless calculations, our PCB calculator comes with the latest contributions rates.

Send individual payslips by batch with the batch email feature. Every e-mail sent comes with a password encryption to ensure utmost privacy and security

SQL Payroll software contains all necessary statutory report forms like EPF Borang A, SOCSO Borang 8A, PCB Income Tax CP39, and EIS Lampiran 1

Make salary payments via electronic submissions. More than 25 Malaysia banks including Maybank, Hong Leong Bank, Cimb bank, public bank can be used to perform bank giro on SQL Payroll Malaysia software.

Enter overtime, claims, allowances, bonus, leaves, tax benefits, and other deductions in advance and incorporate it later on into the final payroll for that particular month

Process multiple month ends by groups. You can process separate month end for different groups of employees. Eg, you can process the salaries for the sales group on the 25th of every month and the other groups on the end of every month.

Generate employee forms EA and employer form E and also perform e-submission with SQL Payroll software

Our wide variety of customizable reports and payslips allow you to create the ideal report that truly represents your corporate identity and business nature.

Need a report?
SQL Payroll software provides payslips, payroll summary, credit bank report, cheque listing, contribution info listing, and HRDF report

Need a government report?
We provide government reports like: EPF Borang A, Socso Borang 8A, Socso Borang 2, Socso Borang 3, EIS Lampiran 1, EIS Borang 1, EIS Borang 2, Income Tax CP 39, Income Tax CP 39 A, CP 22, CP 22 A, CP 8, CP 159, e-Data Praisi, Lampiran B (PCB Audit), Zakat Borang Skim Berkat, PCB 2, CP 8D (Borang E).

Leave Management

What’s unique

SQL Payroll HR software lets you manage multiple leave types for your employees. Including annual leave, unpaid leave, and medical leave. Create more leave types based on your business needs like compassionate leave, study leave and others.

By using leave group entitlement. You can set the number of leaves a group of employees are entitled to. You can create a group for managerial group, sales group, and contract worker group.

Checking your leave application has never been easier! Effortlessly view your applications using our calendar mode

SQL Payroll software design with simplified interface, you can set your unpaid leave formula as easy by select the numbers of calendar method (labour law compliance) as well as by custom days setting example 26 days.
Set your own unpaid leave formulas by selecting the day of unpaid leave taken on the calendar (compliant with labour law) and the customizable number of days.

Annual leave can be brought forward to the next year. All you have to do is set the maximum number of days and the system will do the rest.

Need a leave report?
SQL Payroll HR software consists of a complete and comprehensive set of leave reports such as leave application report, leave balance report, leave entitlement report, and yearly leave report.

SQL E Leave - payroll app apply leave anytime, anywhere

What’s unique

say goodbye to printing leave application forms. apply your leave with SQL E Leave mobile app anytime, anywhere. Enjoy the freedom of checking your leave status on your mobile and receive notification alert when your leave has been approved.

View your past payslips from an unlimited number of months on the e-leave app. you can check your salary details like wages, allowance, deduction, epf, socso and many more.

Have unlimited access when referring to your past records of EA forms for a seamless and smooth process of e-filing on LHDN.

Check leave pending approval, apply leave on behalf of your employees, and check daily attendance all on your mobile phone! Leave application and leave balance repots can also be generated

Others useful function

What’s unique

process adhoc payment interval such as bonus, commission, as separate payroll payment. These payouts are separated from the usual payroll process.

SQL Payroll HR software comes with appointment letter, confirmation letter, increment letter, assessment letter, termination letter and other letter formats that are necessary in any HR management system.

limit your employees access and process payroll by designated grouping. For example, manager level salaries can only process by HR manager. Regular HR staff only can view executive level salaries.

Manage employee loans with SQL Payroll software. SQL Payroll will auto deduct the loan from your wages based on the loan repayment rate and repayment period that you set. You can check your loan repayment history for reference.

SQL Payroll automatically calculates all necessary tax contribution for you. But you can always use our Income Tax calculator to double examine payroll entries that you recorded.

flexible data import / integration from any time attendance system in excel or csv format.

unlimited year payroll records can be store in SQL payroll, reprint previous EA Form or view previous year payroll information from any year. Especially useful when you are called for a PCB audit.

Set Payroll frequency to process bi-monthly or even weekly salary. Our system will automatically proportion the salaries accordingly.

SQL Payroll software ready with all malaysia government report EPF Borang A, SOCSO Borang 2, SOCSO Borang 3, SOCSO Borang 8A, EIS Borang 1, EIS Borang 1A, EIS Borang 2, EIS Borang 2A, EIS Lampiran 1, Income Tax CP39, CP39A, Income Tax CP 39A, Income Tax CP 22, Income Tax EA Form, Income Tax EC Form, Income Tax CP 8, CP 159, Income Tax e Data Praisi, Income Tax CP 8D Borang E, Income Tax Lampiran B (PCB Audit) Income Tax Lampiran 2 (PCB Audit), Income Tax PCB 2(II), Zakat Borang Skim Berkat, HRDF Report.

Instead of manually keying in an employee’s information, use a mykad reader to retrieve all the necessary information that is needed by every employer and populate the employee master form within seconds.

SQL Payroll can be integrated seamlessly with most time attendance systems. Sql Payroll calculates OT, Leaves, and allowances without any mistakes and minimal external interference.

Unlimited monthly free payroll software training and responsive support team

No worries if you are unfamiliar with our system! We provide free payroll software training every month. Contact us to find out more! Our technical support team is fully trained and equipped to assist you via phone, email, and remote access.

× How can I help you?