SQL Account User Guides
 
 

1. Get Started

    
SQL Accounting Training Handbook SBE
GST Compliance with SQL Account Handbook
SQL Accounting User Manual - GST
1.02.1 Clone Master Data
1.02.2 Restore Database
1.02.3 Network Setting
1.02.4 Step to Uninstall, Reinstall, Upgrade Existing SQL
1.02.5 Reset Password Form & Step to Reset
1.02.6 How to Register Your New Company and Change Company Address
1.02.7 Change Panasonic 1121 Driver to Epson
1.02.8 Import UBS Guide
 
 

2. General Ledger

    
3.05 Opening Bank Reconciliation
3.06 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
3.08 General Ledger Report's Ref1 (DocNo) appeared as <<New>>
3.09 Guide to Calculate Profit & Loss Percentage
 
 

3. Customer

    
4.03 Customer Payment Guide (Local & Multi Currency)
4.03.01 Open Bank Deposit
4.03.02 Post-Dated Cheque & Bounced Cheque
4.03.03 How to do Customer Payment Bounced Cheque in Forex
4.04 Customer Payment Listing Commission
4.07 Customer Contra and Supplier Contra
 
 

4. GST

    
1. Setup
2. Maintain Tax
3. Stock Tax
4. Customer GST
5. Tax Invoice
6. GST-03
7. GST-03 Drill Down
8. GAF
10. Inclusive GST Cents
11a. Input & Output Tax Ledger Report
11b. Tax Code in Chart of Account
13. Delivery Order 21 Days Rules
14a. 21 Days Rules Deposit
14b. Refundable & Non-Refundable Deposit
15.16.17 Bad Debt Relief Recover
20. Gift Deemed Supplies
21. RSA
22. Margin Scheme
23. GST Tap
24. Bank Charge With GST
25. GST03 Adjustment
26. Credit Noted for Sales Rebate & Incentive
27. Cash Book Simplified Invoice
28. Import Goods Treatment
29. GST Payment to RMCD
30. 5Cents Rounding for Sales & Purchase
31. Promotional/Sample Item for GST
32. Self Billing
33. De-Register GST
34. Industries Code (MSIC)
35. How to Submit GST03 Tap Online
36. Input Entry For ATS
37. GST Tax Code - TX-N43
38. GST Tax Code - TX-RE
39. Understanding of Mixed Supplies (Partial Exemption)
40. The Adjustment of GST by Auto or Manual Input
41. Set Tax Date in Purchase Invoice
43. Fill in Part D: Declaration in GST-03
44. Guidance to Check GL Ledger with GST-03
45. Start A New Margin Scheme Database
46. GST-03 Adjustment Before & After GST Return
47. Message Prompt: "Attempt to Store Duplicate Value.." while Processing GST Return
48. Message Prompt: "Please enter G/L Code" while Processing GST Return
49. Steps to do before submitting GST03
 
 

5. Sales

    
6.02 Cash Drawer Kick Out
 
 

6. Stock

    
8.01 Costing Method
8.02 Serial No Module
8.03 Maintain Stock Item - Reorder Level & Reorder Qty
8.04 Global Price Change
 
 

7. Tools

    
9.01 Customer One Cent Rounding
9.03 Set Running No by Date/Year Format
9.09 Advance Currency Module
9.12 Analyse Data Integrity
9.13 Year End Steps
 
 

8. Reports

    
10.01 How to Load Report Template
10.02 Guideline to Create SUM Variable for Tax Column
10.03 How to Disable Query in Report
10.04 How to do Rounding Report
10.05 How to drag XML Report
10.06 Add FromDocNo and FromDocDate Variable in Report Design
10.07 Show GST No In Report
10.08 Fast Report - Hide Zero
 
 

9. Grid Layout

    
12.01 Reset/Delete Layout
12.02 Save and Manage Layout
 
 

10. Additional Modules

    
13.01 Landing Cost
13.02 Serial No Module
13.03 Job Order & Purchase Order
13.04 Barcode
13.05 Supplier Payment Interbank GIRO
 
 

11. Troubleshooting

    
14.01 Fix Database Shutdown Error
14.02 How to do Patch File using SQL Diagnosis Utility
14.03 How to validate database with SQL Diagnosis Utility
 
 

12. Miscellaneous

    
15.01 Text Import Utility Guideline
15.02 Import Export Guide
 
 

13. Business Nature / Industries

    
16.01 Sample Recurring Company
16.02 Photocopier Meter