Document Download

SQL ACCOUNTING USER GUIDE        UPADTE ON 17/06/15

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 taughts or report any problems you experienced.

SQL Accounting Training Handbook SBE

This handbook contains all the guides to help you get started using SQL Accounting software.

Download SQL Accounting Training Handbook


GST Compliance with SQL Account Handbook

This handbook contains the guide to GST Compliance with SQL Account

Download GST Compliance with SQL Account Handbook


Getting Started

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.

Learn how to clone master data

1.02.2 Restore Database

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

Learn how to restore database

1.02.3 Network Setting

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

Learn how to setup your network for SQL Account and SQL Payroll

1.02.4 Step to Uninstall Existing SQL

Step to Uninstall Existing SQL.

Learn how to uninstall existing SQL

1.02.5 Reset Password Form & Step to Reset

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

Learn how to reset password

1.02.6 How to Register Your New Company and Change Company Address

How to register your new company?

Learn 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

Learn how to change Panasonic 1121 driver to Epson

1.02.8 Import UBS Guide   New !! 17/06/15

This is how to migrate UBS data to SQL Accounting


General Ledger

3.05 Opening Bank Reconciliation

How do I key in Opening Bank Reconciliation?

Learn how to key in opening bank reconciliation


3.06 Guide to Check GST Claimable & GST Payable not tally with GST03   New !! 17/06/15

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   New !! 17/06/15

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


Customer

4.03 Customer Payment Guide (Local & Multi Currency)

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

Learn how to key in customer payment


4.04 Customer Payment Listing Commission

How do I set the commission calculation to my requirement?

Learn how to set commission calculation to your requirement


4.07 Customer Contra and Supplier Contra  New !! 17/06/15

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


Sales

6.02 Cash Drawer Kick Out

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

Learn how to set up cash drawer


Stock

8.01 Costing Method

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

Learn how to assign or change costing method


Tools

9.03 Set Running No by Date/Year Format   New !! 17/06/15

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


9.09 Advance Currency Module    New !! 17/06/15

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

9.12 Analyse Data Integrity

What is Analyse Data Integrity and how to use it.

Learn how to do analyse data integrity


9.13 Year End Steps

How to year end process?

Learn how to do year end process


Report

10.01 How to Load Report Template

How to load report template file into SQL Accounting?

Learn how to how to load report template file

10.02 Guideline to Create SUM Variable for Tax Column

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

Learn how to create SUM variable for tax column

10.03 How to Disable Query in Report

How to disable query for deleted field in report designer?Learn how to disable query in report

10.04 How to do Rounding Report

How to do Rounding in Report Design ?

Learn how to do rounding in report design?

10.05 How to drag XML Report

How to Load XML Report into SQL?

Learn 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

Learn how to add FromDocNo and FromDocDate variable

10.07 Show GST No In Report

This is how you show GST no in report

Learn how to show GST no in report


Grid Layout

12.01 Reset/Delete Layout

This guide shows how to reset/delete grid layout.

Learn how to reset/delete layout


Additional Module

13.01 Landing Cost

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

Learn how to key in landing cost

13.02 Serial No Module

How to use Serial No Module in SQL Accounting?

Learn how to use serial no module

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.

Learn how to use job order & purchase order

13.04 Barcode

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

Learn how to report design Goods Received Note barcode


13.05 Supplier Payment Interbank GIRO    New !! 17/06/15

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.

Learn how to solve database shutdown error

14.02 How to do Patch File using SQL Diagnosis Utility

This is how to do patch file with SQL Diagnosis.

Learn how to patch file with SQL Diagnosis


Miscellaneous

15.01 Text Import Utility Guideline

This is how to use Text Import utility.

Learn how to use Text Import utility


GST

1. Setup

How to setup software for GST?

Learn how to setup GST

2. Maintain Tax

How to maintain tax?

Learn how to maintain tax

3. Stock Tax

How to set stock tax codes?

Learn how to set stock tax codes

4. Customer GST

How to assign tax code to customer and supplier?

Learn how to assign tax code to customer and supplier

5. Tax Invoice

What are the compulsory information to display in tax invoice?

Learn about tax invoice

6. GST-03

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

Learn how to process GST-03 report

7. GST-03 Drill Down

How to drill down GST-03 details?

Learn how to drill down GST-03

8. GAF

How to print GAF report?

Learn how to print GAF report

10. Inclusive GST Cents

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

Learn about GST cents inclusive

11a. Input & Output Tax Ledger Report

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

Learn how to print input & output tax ledger report

11b. Tax Code in Chart of Account

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

Learn how to assign tax code in Chart of Account

13. Delivery Order 21 Days Rules

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

Learn about delivery order 21 Days rules

14a. 21 Days Rules Deposit

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

Learn about 21 days rules deposit

14b. Refundable & Non-Refundable Deposit

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

Learn about refundable & non-refundable deposit

15.16.17 Bad Debt Relief Recover

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

Learn about bad bebt relief recover

20. Gift Deemed Supplies

This is how deemed supplies work in SQL Accounting.

Learn about Gift Deemed Supplies

21. RSA

This is how Recipient Self-Accounting (RSA) tax code is used.

Learn how to use Recipient Self-Accounting (RSA) tax code

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

Learn how margin scheme works

23. GST Tap

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

Learn how to generate TAP file for GST return submission

24. Bank Charge With GST

How to handle Supplier bank charge with tax amount?

Learn how to handle Supplier bank charge with tax amount

25. GST03 Adjustment

How to do GST-03 Adjustment in SQL Accounting?

Learn how to do GST-03 Adjustment in SQL Accounting

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?

Learn how to enter credit noted for sales rebate & incentive

27. Cash Book Simplified Invoice

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

Learn how to enter supplier simplified invoice

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.

Learn how imported goods GST treatment

29. GST Payment to RMCD

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

Learn how to make GST payment to RMCD

30. 5Cents Rounding for Sales & Purchase

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

Learn how to do 5cents rounding for sales & purchase

31. Promotional/Sample Item for GST

How to key in promotional/sample item into system?

Learn how to key in promotional/sample item into system

32. Self Billing

How do I key-in self billing?

Learn how to key-in self billing

33. De-Register GST

How do I de-register GST in SQL Accounting?

Learn how to de-register GST in SQL Accounting

34. Industries Code (MSIC)

How do I assign my industries code?

Learn how to assign industries code

35. How to Submit GST03 Tap Online

First accounting software in Malaysia to show GST 03 submission online

Learn how to submit GST03 Tap online

36. Input Entry For ATS

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

Learn how to input entry for ATS

37. GST Tax Code - TX-N43

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

Learn when and how to use TX-N43

38. GST Tax Code - TX-RE

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

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

Learn how mixed supplies (partial exemption) works

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 New !! 16/07/15


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

42. Realised Gain Loss Foreign Exchange   

This guide shows how you can process GST with Net Realised Exchange Gain/Loss.


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 New !! 16/07/15

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-09 Adjustment Before & After GST Return   New !! 16/07/15

How to do GST-09 Adjustment Before & After GST Return


47. Message Prompt: "Attempt to Store Duplicate Value.." while Processing GST Return   New !! 16/07/15

Process New GST Return BUT get message prompt above?


48. Message Prompt: "Please enter G/L Code" while Processing GST Return   New !! 16/07/15

Process New GST Return BUT get message prompt above?


GST  Document