Learn how to use and master SQL Accounting Software
Browse and download all of our SQL Accounting User Guide in PDF format.
Getting Started
|
|
SQL Accounting Training Handbook SBE
This handbook contains all the guides to help you get started using SQL Accounting software.
|
|
|
GST Compliance with SQL Account Handbook
This handbook contains the guide to GST Compliance with SQL Account
|
|
|
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 Existing SQL
Step 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.
|
|
|
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
|
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
|
|
|
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.
|
|
|
6.02 Cash Drawer Kick Out
This is a step-by-step guide to setting up cash drawer for SQL Accounting.
|
|
|
8.01 Costing Method
This is a guide to show how Costing Method works in SQL Accounting.
|
Tools
|
|
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.12 Analyse Data Integrity
What is Analyse Data Integrity and how to use it.
|
|
|
9.13 Year End Steps
How to year end process?
|
|
|
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
|
|
|
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
|
|
|
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.04 Barcode
This is a step-by-step guide to report designing Goods Received Note barcode.
|
|
|
13.05 Supplier Payment Interbank GIRO
This is a step-by-step guide on how to use supplier payment interbank GIRO feature.
|
|
|
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.
|
|
|
15.01 Text Import Utility Guideline
This is how to use Text Import utility.
|
|
|
15.02 SQL Accounting User Manual - GST
This is our SQL Accounting User Manual with GST
|
Goods and Services Tax (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.
|
|
|
21. RSA
This is how Recipient Self-Accounting (RSA) tax code is used.
|
|
|
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?
|
|
|
25. GST03 Adjustment
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?
|
|
|
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 incurred
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. 5 Cents Rounding for Sales & Purchase
How to turn on 5 cents 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.
|
