SQL Account Features

Fast. Stable. Feature Loaded.


General Ledger

What's unique?
  • Flexible Financial Reports
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
  • Unlimited level of GL Account
Create unlimited sub accounts and financial reports. View it in a summarize format or by sub account details
  • Advance security document lock * Special unique feature
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
  • Easy Drill down to source documents
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
  • Multiple companies consolidation account
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.

General Ledger
Customer

Customer

What's unique?
  • Fast entry multiple invoices in single interface
key in bulk invoices using fast entry listing screen or import data directly form Excel document. Speedy invoice generation with just 1 click.
  • Advance SSM number power search
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.
  • Customizable customer aging formula
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.
  • Advance Credit Limit & Credit Control
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.
  • Automated document knock-off feature by FIFO
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.
  • Post-dated Cheque and bounced cheque management
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.
  • CTOS * Special unique feature
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:
  • Bank Giro function for all banks
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.
  • Fast, accurate, user-friendly features
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. 

 

Supplier
Sales

Sales and Purchase

What's unique?
  • Profit Estimator
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!
  • Partial delivery with back order reports
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
  • Multiple Pricing & AI selling price assignment
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.
  • View Top selling product & customer
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
  • Itemize profit and loss document report
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%.
  • Batch email customer invoice / customer statement of account
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.
  • Whatsapp Integration
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.
  • Comprehensive and Customisable report format
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?
  • 100% accuracy for stock costing
SQL stock costing with FIFO, weighted average, you can even backdate transactions and our system will automatically calculate the costing.
  • Smart automate stock reorder advice
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.
  • Multiple Warehouse Management
Track your inventory beyond the warehouse. Perform stock transfers between inter-branch, consignment, van sales & more.
  • Multiple UOM
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.
  • Unlimited stock category
assign your stock by category and view any stock report by filtering category or grouping by category for flexible reporting
  • Barcode Generation
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
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
Tax

Sales and Service Tax

  • Automate sales and service tax for all documents.
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.
  • SST-02 draft
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.
  • SST-02 Report
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

  • Foreign Currency (with Advance currency bank)
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.
  • Project Accounting
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.
  • Item Template
Create combination of few product as packages, easy for invoice billing by single click.
  • Landing Cost
Cost apportionment into product costing such us transportation cost apportionment into few product costing.
  • Sales commission calculation * Special unique feature
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.
  • Unlimited user defined fields * Special unique feature
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.
  • Serial number
Unique serial number for each product quantity, trace balance qty with serial number info, check serial number inquiry & stock balance listing by serial number.
  • Global price changes for all items
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.
  • Customisable suite to your unique business policy
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.
Click here to view more customizations

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.

Other Features
Special Industry

Special Industries

  • 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.

Training