User Guide
1 SQL Account Modules
SQL Account is a centralize system to assist the business (or departments) to record and process daily documents from sales, purchase, stock, and bank. It also a tool for GST reporting to Royal Malaysia Customs Diraja (RMCD).

-
General Ledger, a general ledger accounting where records all transactions posted from various journal (eg. general, sales, purchase, bank), an entry for general journal and expenses payment (eg. sales person claims, water and electricity expenses). Bank reconciliation, cash flow statement and financial reports are available in this module.
-
Customer, a sales ledger accounting where monitor the outstanding and payment received from the customers. Customer report such as reminder letter, customer aging and analysis reports are available here.
-
Supplier, a purchase ledger accounting where monitor the outstanding and payment received from the customers. Customer report such as reminder letter, customer aging and analysis reports are available here.
-
Sales, a module to handle all the sales activities from quotation, sales order, delivery order, tax invoice, debit note and credit note. Advance sales reports in help business to identity the top sales of the products.
-
Purchase, a module to records all the purchase activities from purchase request, purchase order, goods receive, purchase invoice, purchase debit note, and purchase returns.
-
Production, a manufacturing data process. It helps to identify the materials required and planned based on the customer orders.
-
Stock, an inventory control, stock take adjustment and for monitor the stock movement from one location to another location. Stock aging to identify out the obsolete stock.
-
GST, a GST compliance accounting system. Readiness to process and submit the GST returns (GST-03) via TAP online, GAF and others GST reports.
2 Getting Started SQL Account System
2.1 How to set Financial Period & System Conversion Date
-
Tools | Options

-
Select General Ledger
-
Select Financial Start Period & System Conversion Date

My financial period starts on 1st January every year, I start using SQL from 1/1/2015.
Financial Start Period = 1/1/2015 System Conversion Date = 1/1/2015
My financial period starts on 1st January every year, I start using SQL from 1/4/2015.
Financial Start Period = 1/1/2015 System Conversion Date = 1/4/2015
2.2 Starting GST
This is to initiate setup of the GST Singapore Module in SQL Accounting System.
-
Go to GST | Start GST Now
-
Select Singapore

-
Select Singapore Flag and checked on acknowledgement

-
Set GST effective date for your company

-
Key in your company’s GST registration number

-
Select Finish

-
It will prompt you with this message, please log on again to complete the GST Profile setup

-
After logging in again, you should see a new drop-down list with GST functions, the GST setup is now complete.

2.3 Setting up Company Profile
Step 1: File | Company Profile

Step 2: Select Report Header

3 Master Data Creation
3.1 General Ledger (Maintain Chart of Account)
3.1.1 Creating a New Account
-
Select GL | Maintain Account | Select category (e.g. Fixed Assets) | New
-
Enter the GL Code and Description (alphanumeric characters are acceptable)
-
Check the Special Account Type if applicable, e.g. the account is belonging to Accumulated Deprn Account (Fixed Assets)
-
Click OK. Your new account is now created.


3.1.2 Creating a Sub Account
-
Point to the parent account (e.g. Cash at Bank)
-
Follow the same steps from 2.1.1 Create New Account
