LEARN HOW TO USE AND MASTER SQL ACCOUNTING.
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 New !! 17/06/15
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 New !! 17/06/15
4.03 Customer Payment Guide (Local & Multi Currency)
How do I key in Customer Payment for both local and multi currency?
4.04 Customer Payment Listing Commission
How do I set the commission calculation to my requirement?
4.07 Customer Contra and Supplier Contra New !! 17/06/15
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.
9.03 Set Running No by Date/Year Format New !! 17/06/15
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?Learn how to disable query in report
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.
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.
This is a step-by-step guide to report designing Goods Received Note barcode.
13.05 Supplier Payment Interbank GIRO New !! 17/06/15
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.
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?
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?
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.
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 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
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
48. Message Prompt: "Please enter G/L Code" while Processing GST Return New !! 16/07/15
- GST List of Sundry Goods (With GST Or Zerp Rate)