SQL Accounting User Guide

Learn how to use and Master SQL Accounting.

Browse and download all of our SQL Accounting User Guide in PDF format. If you have any feedback or suggestion, please help by emailing us your thoughts or report any problems you experienced.

Getting Started

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.

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.

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.

1.02.2 Restore Database

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

1.02.3 Network Setting

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

1.02.4 Step to Uninstall, Reinstall, Upgrade Existing SQL

Step to Uninstall, Reinstall, Upgrade Existing SQL.

1.02.5 Reset Password Form & Step to Reset

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

1.02.6 How to Register Your New Company and Change Company Address

How to register your new company?

1.02.7 Change Panasonic 1121 Driver to Epson

This is how to change Panasonic 1121 driver to Epson.

1.02.8 Import UBS Guide

This is how to migrate UBS data to SQL Accounting.

1.02.9 Account Book Registration in SQL

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

1.02.10 Enlarging UI Screen in SQL

This guide shows how to enlarge UI screen in SQL.

1.02.11 Backup Database

This guide shows how to backup SQL Database.

1.02.12 MYOB Migration – Master File

This guide shows how to migrate MYOB to SQL Account.


General Ledger

3.05 Opening Bank Reconciliation

How do I key in Opening Bank Reconciliation?

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

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

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.

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

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

3.09 Guide to Calculate Profit & Loss Percentage

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

3.10 P&L Statement with Appropriation Account

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

3.11 Trial Balance not Tally

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

3.12 Record Accumulated Depreciation for Fixed Asset

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


Customer

4.03 Customer Payment Guide (Local & Multi Currency)

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

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.

4.03.02 Post-Dated Cheque & Bounced Cheque

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

4.03.03 How to do Customer Payment Bounced Cheque in Forex

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

4.04 Customer Payment Listing Commission

How do I set the commission calculation to my requirement?

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.


Sales

6.02 Cash Drawer Kick Out

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


Stock

8.01 Costing Method

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

8.02 Serial No Module

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

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.

8.04 Global Price Change

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

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.

8.06 Stock Adjustment & Stock Take

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

8.07 Barcode

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


Tools

9.01 Customer One Cent Rounding

This guide shows you how one cent difference rounding work.

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.

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.

9.09 Advance Currency Module

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

9.10 Project Module

This guide shows how you can use Project module.

9.12 Analyse Data Integrity

What is Analyse Data Integrity and how to use it.

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.


Report

10.01 How to Load Report Template

How to load report template file into SQL Accounting?

10.02 Guideline to Create SUM Variable for Tax Column

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

10.03 How to Disable Query in Report

How to disable query for deleted field in report designer?

10.04 How to do Rounding Report

How to do Rounding in Report Design?

10.05 How to drag XML Report

How to Load XML Report into SQL?

10.06 Add FromDocNo and FromDocDate Variable in Report Design

This is how you add FromDocNo and FromDocDate variable.

10.07 Show GST No In Report

This is how you show GST no in report

10.08 Fast Report - Hide Zero

This is how to hide zero in Fast Report.

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

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.

10.11 Fast Report: Report Print Count

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

10.12 Fast Report: Solving More Description more than 1 page

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

10.13 Fast Report: Stop Position

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

10.14 Fast Report: Print Date Time

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

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

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


Grid Layout

12.01 Reset/Delete Layout

This guide shows how to reset/delete grid layout.

12.02 Save and Manage Layout

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


Additional Module

13.01 Landing Cost

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

13.02 Serial No Module

How to use Serial No Module in SQL Accounting?

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.

13.05 Supplier Payment Interbank GIRO

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


Troubleshooting

14.01 Fix Database Shutdown Error

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

14.02 How to do Patch File using SQL Diagnosis Utility

This is how to do patch file with SQL Diagnosis.

14.03 How to validate database with SQL Diagnosis Utility

This is how to validate database with SQL Diagnosis.

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

14.05 Maintain 2 different version in 1 PC

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


Miscellaneous

15.01 Text Import Utility Guideline

This is how to use Text Import utility.

15.02 Import Export Guide

This is how to use Import Export utility.


Business Nature / Industries

16.01 Sample Recurring Company

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

16.02 Photocopier Meter

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


GST

1. Setup

How to setup software for GST?

2. Maintain Tax

How to maintain tax?

3. Stock Tax

How to set stock tax codes?

4. Customer GST

How to assign tax code to customer and supplier?

5. Tax Invoice

What are the compulsory information to display in tax invoice?

6. GST-03

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

7. GST-03 Drill Down

How to drill down GST-03 details?

8. GAF

How to print GAF report?

10. Inclusive GST Cents

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

11a. Input & Output Tax Ledger Report

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

11b. Tax Code in Chart of Account

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

13. Delivery Order 21 Days Rules

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

14a. 21 Days Rules Deposit

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

14b. Refundable & Non-Refundable Deposit

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

15.16.17 Bad Debt Relief Recover

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

20. Gift Deemed Supplies

This is how deemed supplies work in SQL Accounting.

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

23. GST Tap

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

24. Bank Charge With GST

How to handle Supplier bank charge with tax amount?

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?

27. Cash Book Simplified Invoice

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

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.

29. GST Payment to RMCD

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

30. 5Cents Rounding for Sales & Purchase

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

31. Promotional/Sample Item for GST

How to key in promotional/sample item into system?

32. Self Billing

How do I key-in self billing?

33. De-Register GST

How do I de-register GST in SQL Accounting?

34. Industries Code (MSIC)

How do I assign my industries code?

35. How to Submit GST03 Tap Online

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

36. Input Entry For ATS

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

37. GST Tax Code - TX-N43

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

38. GST Tax Code - TX-RE

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

39. Understanding of Mixed Supplies (Partial Exemption)

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

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

41. Set Tax Date in Purchase Invoice

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

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

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

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.

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

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

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

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

Process New GST Return BUT get message prompt above?

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

Process New GST Return BUT get message prompt above?

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.

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.

51. Account code for Output Tax Adjustment Error Message

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

53. GST Migration System for GST Past Document Opening Balance

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

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

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


Interbank GIRO

1. SQL Account Bank Credit - Supplier Payment IBG

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