SQL Account User Guide

Learn how to use and master SQL Accounting

If you have any feedback or suggestion, please help by emailing us your thoughts or report any problems you experienced.

Download all PDF

Note: Please refer the README file for topics with Wiki URL links.


SQL Account GST Case Study (Updated: 15/11/2016)

This guide helps you get started with GST with topics tackling various GST use case and scenario that you may encounter.

Download the guide

SQL Account User Guide

This is the full SQL Account User Guide set containing all guides to help you get started using SQL Accounting software with GST and it is suitable for new users.

Download the guide


1.02.1 Clone Master Data

SQL Clone database is to copy all maintenance file eg. chart of account, customer, supplier, stock group, stock item or even report & script from an existing database to a new empty database.

Download the guide

1.02.2 Restore Database

This is how to restore SQL Accounting data from existing database backup.

Download the guide


1.02.3 Network Setting

This is a step by step guide to SQL Account or Payroll network setting.

Download the guide

1.02.4 Step to Uninstall, Reinstall, Upgrade Existing SQL

Step to Uninstall, Reinstall, Upgrade Existing SQL.

Download the guide


1.02.5 Reset Password Form & Step to Reset

This is how you reset password form & the steps to do it.

Download the guide

1.02.6 How to Register Your New Company and Change Company Address

How to register your new company?

Download the guide


1.02.7 Change Panasonic 1121 Driver to Epson

This is how to change Panasonic 1121 driver to Epson.

Download the guide

1.02.8 Import UBS Guide

This is how to migrate UBS data to SQL Accounting.

Download the guide


1.02.9 Account Book Registration in SQL

This guide shows how to do account book registration in SQL.

Download the guide

1.02.10 Enlarging UI Screen in SQL

This guide shows how to enlarge UI screen in SQL.

Download the guide


1.02.11 Backup Database

This guide shows how to backup SQL Database.

Download the guide

1.02.12 MYOB Migration – Master File

This guide shows how to migrate MYOB to SQL Account.

Download the guide

3.05 Opening Bank Reconciliation

How do I key in Opening Bank Reconciliation?

Download the guide

3.06 Guide to Check GST Claimable & GST Payable not tally with GST03

Guide to Check GST Claimable & GST Payable not tally with GST03.

Download the guide


3.07 How to create Profit and Loss Statement for more than 12 Months

How to Create Profit and Loss Statement and Balance Sheet for more than 12 Months.

Download the guide

3.08 General Ledger Report's Ref1 (DocNo) appeared as <<New>>

What to do if General Ledger Report's Ref1 (DocNo) appeared as <<New>>?

Download the guide


3.09 Guide to Calculate Profit & Loss Percentage

This guide shows you how to calculate P&L percentage.

Download the guide

3.10 P&L Statement with Appropriation Account

This guide shows you how insert appropriation account for P&L.

Download the guide


3.11 Trial Balance not Tally

This guide shows you how to check if Trial Balance is not tally.

Download the guide

3.12 Record Accumulated Depreciation for Fixed Asset

This guide shows you how to record accumulated depreciation for fixed asset.

Download the guide


3.13 Bank Reconciliation

A bank reconciliation is a process performed by a company to ensure that the company's records are correct and that the bank's records are also correct.

Download the guide

3.14 Auto Posting Stock Month End Value to Maintain Stock Value

Version 748 & above added feature which allow system auto post the stock value from Maintain Month End value to GL Maintain Stock Value.

Download the guide

4.03 Customer Payment Guide (Local & Multi Currency)

How do I key in Customer Payment for both local and multi currency?

Download the guide

4.03.01 Open Bank Deposit

Open Bank Deposit can be done when you are banking in 2 or more cheques at a time in a same transaction slip.

Download the guide


4.03.02 Post-Dated Cheque & Bounced Cheque

This guide shows you how to insert post-dated/bounced cheque.

Download the guide

4.03.03 How to do Customer Payment Bounced Cheque in Forex

This guide shows you how to do bounce payment for different currency.

Download the guide


4.04 Customer Payment Listing Commission

How do I set the commission calculation to my requirement?

Download the guide

4.07 Customer Contra and Supplier Contra

If you have a customer who is also a supplier, you may want to offset the outstanding customer and supplier invoices.

Download the guide

6.02 Cash Drawer Kick Out

This is a step-by-step guide to setting up cash drawer for SQL Accounting.

Download the guide

8.01 Costing Method

This is a guide to show how Costing Method works in SQL Accounting.

Download the guide

8.02 Serial No Module

This is a guide to show how Serial No Module works in SQL Accounting.

Download the guide


8.03 Maintain Stock Item - Reorder Level & Reorder Qty

This is a guide to show how Stock Item's Reorder Level and Reorder Qty works in SQL Accounting.

Download the guide

8.04 Global Price Change

This is a guide to show how to do Global Price Change.

Download the guide


8.05 Stock Price Tag Module

This module enables you to set different pricing groups for different customer and supplier and is normally used to set different customer category with different pricing.

Download the guide

8.06 Stock Adjustment & Stock Take

This guide shows you how to do Stock Adjustment/Stock Take.

Download the guide


8.07 Barcode

This is a step-by-step guide to report designing Goods Received Note barcode.

Download the guide

8.08 Changing the label size (mm) measurement for the Bar Code Label

This is a step-by-step guide how to change the label size (mm) measurement for the Bar Code Label.

Read the guide

9.01 Customer One Cent Rounding

This guide shows you how one cent difference rounding work.

Download the guide

9.02 Set First Year Account for more than 12 Months

This guideline shows how to set first year account for more than 12 months.

Download the guide


9.03 Set Running No by Date/Year Format

This guide shows you how to set date format for Payment Voucher/ Official Receipt running no.

Download the guide

9.09 Advance Currency Module

This guide shows you what you can do with Advance Currency Module if you have foreign bank account.

Download the guide


9.10 Project Module

This guide shows how you can use Project module.

Download the guide

9.12 Analyse Data Integrity

What is Analyse Data Integrity and how to use it.

Download the guide


9.14 Maintain Acceptable Transaction Date

SQL can no need perform year end, it will auto doing cut off. Once account closed, if you wish to block the period to avoid your users changed the account figure, you may do this setting.

Download the guide

10.01 How to Load Report Template

How to load report template file into SQL Accounting?

Download the guide

10.02 Guideline to Create SUM Variable for Tax Column

How to create variable to SUM Amount, Local Amt , and Amt Include Tax?

Download the guide


10.03 How to Disable Query in Report

How to disable query for deleted field in report designer?

Download the guide

10.04 How to do Rounding Report

How to do Rounding in Report Design?

Download the guide


10.05 How to drag XML Report

How to Load XML Report into SQL?

Download the guide

10.06 Add FromDocNo and FromDocDate Variable in Report Design

This is how you add FromDocNo and FromDocDate variable.

Download the guide


10.07 Show GST No In Report

This is how you show GST no in report

Download the guide

10.08 Fast Report - Hide Zero

This is how to hide zero in Fast Report.

Download the guide


10.09 Fix Report Tax Rate show A instead of 6%

This is a guide to fix report tax rate show A instead of 6%.

Download the guide

10.10 Fast Report: Guide In Page Footer only display the Text Object in Last Page

Guide in page footer only display the text object in last page.

Download the guide


10.11 Fast Report: Report Print Count

This topic will teach you how to set the record count to 20 records.

Download the guide

10.12 Fast Report: Solving More Description more than 1 page

If More Description more than 1 page, first page will show blank.

Download the guide


10.13 Fast Report: Stop Position

Stop Position is set when you want to stop print the detail record.

Download the guide

10.14 Fast Report: Print Date Time

This is a guide to print date time on Fast Report.

Download the guide


10.15 Fast Report: Ledger Report Start New Page for New Group

Make ledger report to start new page for every new group.

Download the guide

12.01 Reset/Delete Layout

This guide shows how to reset/delete grid layout.

Download the guide

12.02 Save and Manage Layout

This guide shows how to call out hidden field, save the layout and assign to others users.

Download the guide

13.01 Landing Cost

What is Landing Cost and how it works in SQL Accounting.

Download the guide

13.02 Serial No Module

How to use Serial No Module in SQL Accounting?

Download the guide


13.03 Job Order & Purchase Order

Sales coordinator usually will input the Sales Order (SO) based on the customer PO received. Find out how the stock system is updated and how to analyse the materials/components needed to meet customer's order.

Download the guide

13.05 Supplier Payment Interbank GIRO

This is a step-by-step guide on how to use supplier payment interbank GIRO feature.

Download the guide

14.01 Fix Database Shutdown Error

This is how to solve database "shutdown" error during database backup.

Download the guide

14.02 How to do Patch File using SQL Diagnosis Utility

This is how to do patch file with SQL Diagnosis.

Download the guide


14.03 How to validate database with SQL Diagnosis Utility

This is how to validate database with SQL Diagnosis.

Download the guide

14.04 Performance & Speed Improvement for Domain Controller Service (Windows 2012 Server OS)

This is how to improve Windows 2012 speed & performance for SQL Account

Download the guide


14.05 Maintain 2 different version in 1 PC

This is how to maintain 2 different version in 1 PC.

Download the guide

15.01 Text Import Utility Guideline

This is how to use Text Import utility.

Download the guide

15.02 Import Export Guide

This is how to use Import Export utility.

Download the guide

16.01 Sample Recurring Company

This is a guide showing how a company with recurring activity can use SQL Account.

Download the guide

16.02 Photocopier Meter

This is a guide showing how a company doing photocopy service can use SQL Account.

Download the guide

1. Setup

How to setup software for GST?

Download the guide

2. Maintain Tax

How to maintain tax?

Download the guide


3. Stock Tax

How to set stock tax codes?

Download the guide

4. Customer GST

How to assign tax code to customer and supplier?

Download the guide


5. Tax Invoice

What are the compulsory information to display in tax invoice?

Download the guide

6. GST-03

This guide shows how to process GST return and generate GST-03 report.

Download the guide


7. GST-03 Drill Down

How to drill down GST-03 details?

Download the guide

8. GAF

How to print GAF report?

Download the guide


10. Inclusive GST Cents

This is how inclusive GST cents are handled in SQL Accounting.

Download the guide

11a. Input & Output Tax Ledger Report

This is how you generate and print input & output tax ledger report.

Download the guide


11b. Tax Code in Chart of Account

This is how tax code is entered into Chart of Account.

Download the guide

13. Delivery Order 21 Days Rules

This is how delivery order 21 days rules is implemented in SQL Accounting.

Download the guide


14a. 21 Days Rules Deposit

This is how 21 days rules deposit is implemented in SQL Accounting.

Download the guide

14b. Refundable & Non-Refundable Deposit

This is how you can enter refundable and non-refundable deposit in SQL Accounting.

Download the guide


15.16.17 Bad Debt Relief Recover

This is how bad debt relief recover is implemented in SQL Accounting.

Download the guide

20. Gift Deemed Supplies

This is how deemed supplies work in SQL Accounting.

Download the guide


22. Margin Scheme

Under the Margin Scheme, GST is accounted for on the margin (the difference between the price at which the price the goods were obtained and the selling price).

Download the guide

23. GST Tap

How to generate TAP file from SQL Accounting for GST return submission?

Download the guide


24. Bank Charge With GST

How to handle Supplier bank charge with tax amount?

Download the guide

26. Credit Noted for Sales Rebate & Incentive

What to do if the customer hit target or you give rebate for the particular customer after you bill all the invoices, for those non stock control related?

Download the guide


27. Cash Book Simplified Invoice

How to enter to SQL Accounting if supplier given simplified IV?

Download the guide

28. Import Goods Treatment

Purchased goods invoice from oversea will not incurred GST. It's only inccured when goods are discharged out from the port to forwarder warehouse or direct to the buyer.

Read the guide


29. GST Payment to RMCD

GST net payable will be generated every month or every 3 months depends on the company registered to GST.

Download the guide

30. 5Cents Rounding for Sales & Purchase

How to turn on 5cents rounding for sales cash sales and sales invoice?

Download the guide


31. Promotional/Sample Item for GST

How to key in promotional/sample item into system?

Download the guide

32. Self Billing

How do I key-in self billing?

Download the guide


33. De-Register GST

How do I de-register GST in SQL Accounting?

Download the guide

34. Industries Code (MSIC)

How do I assign my industries code?

Download the guide


35. How to Submit GST03 Tap Online

First accounting software in Malaysia to show GST 03 submission online.

Download the guide

36. Input Entry For ATS

Approved Trader Scheme (ATS) is a special scheme introduced to alleviate negative cash flow impact to business.

Download the guide


37. GST Tax Code - TX-N43

This guide shows when and how to use TX-N43.

Download the guide

38. GST Tax Code - TX-RE

This guide shows when and how to use TX-RE.

Download the guide


39. Understanding of Mixed Supplies (Partial Exemption)

A person who makes both taxable and exempt supplies is known as a mixed supplier.

Download the guide

40. The Adjustment of GST by Auto or Manual Input

The total GST payable on all goods and services shown on a tax invoice may be rounded off to the nearest whole cent (i.e. two decimal places).

Download the guide


41. Set Tax Date in Purchase Invoice

How to handle if you have processed GST-03 and later received a supplier invoice?

Download the guide

43. Fill in Part D: Declaration in GST-03

How to fill in Part D: Declaration in GST-03?

Download the guide


44. Guidance to Check GL Ledger with GST-03

This guide teaches you how to check & identify incorrect GST payable amount before submiting your GST-03.

Download the guide

45. Start A New Margin Scheme Database

Margin scheme allows a GST Margin Scheme registered person (GST MS registered person) who meets all the conditions to calculate and charge GST on the margin. (Note: Lampiran 07 Skim Margin report included.)

Read the guide


46. GST-03 Adjustment Before & After GST Return (Updated: 15/11/2016)

How to do GST-03 Adjustment Before & After GST Return.

Download the guide

47. Message Prompt: "Attempt to Store Duplicate Value.." while Processing GST Return

Process New GST Return BUT get message prompt above?

Download the guide


48. Message Prompt: "Please enter G/L Code" while Processing GST Return

Process New GST Return BUT get message prompt above?

Download the guide

49. Steps to do before submitting GST03

There are 3 reasons why after process GST03, GST Claimable and GST Payable ledger account amount does not equal zero.

Download the guide


50. This guide shows how you can generate a GST-03 draft.

There are 3 reasons why after process GST03, GST Claimable and GST Payable ledger account amount does not equal zero.

Download the guide

51. Account code for Output Tax Adjustment Error Message

This guide solves the Output Tax Adjustment error when process GST.

Download the guide


53. GST Migration System for GST Past Document Opening Balance

How to handle GST Past Document Opening Balance for Customer and Supplier.

Read the guide

54. GST Treatment: Imported Services (Updated: 15/11/2016)

GST on Imported Services (Sec 13) is accounted by way of the reverse charge mechanism.

Download the guide

1. SQL Account Bank Credit - Supplier Payment IBG

This is a guide showing how to use Interbank GIRO feature in SQL Account.

Download the guide