SQL Accounting Software Features – E Stream MSC

SQL Accounting Software Features

SQL Accounting Software suitable for all range of businesses, choose from a range of desktop to online cloud accounting software.


More than 270,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.

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.

Sales
Stock

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 

Sales and Service Tax

SQL Account will automatically set sales and service taxed in your invoice so that you never 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

Tax
Other Features

Others Good Features

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

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.

Customer
Supplier

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.

General Ledger
Special Industry

Special 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

STEP 1: Scan QR Code to pay

SQL

STEP 2: Click here to email payment info