SQL Accounting (Tutorial English)

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.

Download the guide

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.

Download the guide

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.

Download the guide

1.02.2 Restore Database

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

Download the guide

1.02.3 Network Setting

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

Download the guide

1.02.4 Step to Uninstall, Reinstall, Upgrade Existing SQL

Step to Uninstall, Reinstall, Upgrade Existing SQL.

Download the guide

1.02.5 Reset Password Form & Step to Reset

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

Download the guide

1.02.6 How to Register Your New Company and Change Company Address

How to register your new company?

Download the guide

1.02.7 Change Panasonic 1121 Driver to Epson

This is how to change Panasonic 1121 driver to Epson.

Download the guide

1.02.8 Import UBS Guide

This is how to migrate UBS data to SQL Accounting.

Download the guide 

1.02.9 Account Book Registration in SQL

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

Download the guide 

1.02.10 Enlarging UI Screen in SQL

This guide shows how to enlarge UI screen in SQL.

Download the guide 

1.02.11 Backup Database

This guide shows how to backup SQL Database.

Download the guide

1.02.12 MYOB Migration – Master File

This guide shows how to migrate MYOB to SQL Account.

Download the guide 

 

GENERAL LEDGER

3.05 Opening Bank Reconciliation

How do I key in Opening Bank Reconciliation?

Download the guide 

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

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

Download the guide 

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.

Download the guide 

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

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

Download the guide 

3.09 Guide to Calculate Profit & Loss Percentage

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

Download the guide 

3.10 P&L Statement with Appropriation Account

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

Download the guide 

3.11 Trial Balance not Tally

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

Download the guide

3.12 Record Accumulated Depreciation for Fixed Asset

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

Download the guide 

3.13 Bank Reconciliation

A bank reconciliation is a process performed by a company to ensure that the company’s records are correct and that the bank’s records are also correct.

Download the guide 

3.14 Auto Posting Stock Month End Value to Maintain Stock Value

Version 748 & above added feature which allow system auto post the stock value from Maintain Month End value to GL Maintain Stock Value.

Download the guide 

CUSTOMER

4.03 Customer Payment Guide (Local & Multi Currency)

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

Download the guide 

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.

Download the guide 

4.03.02 Post-Dated Cheque & Bounced Cheque

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

Download the guide 

4.03.03 How to do Customer Payment Bounced Cheque in Forex

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

Download the guide

4.04 Customer Payment Listing Commission

How do I set the commission calculation to my requirement?

Download the guide

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

Download the guide

GST

1. Setup

How to setup software for GST?

Download the guide

2. Maintain Tax

How to maintain tax?

Download the guide

3. Stock Tax

How to set stock tax codes?

Download the guide

4. Customer GST

How to assign tax code to customer and supplier?

Download the guide

5. Tax Invoice

What are the compulsory information to display in tax invoice?

Download the guide

6. GST-03

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

Download the guide

7. GST-03 Drill Down

How to drill down GST-03 details?

Download the guide

8. GAF

How to print GAF report?

Download the guide

10. Inclusive GST Cents

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

Download the guide

11a. Input & Output Tax Ledger Report

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

Download the guide

11b. Tax Code in Chart of Account

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

Download the guide

13. Delivery Order 21 Days Rules

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

Download the guide

14a. 21 Days Rules Deposit

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

Download the guide

14b. Refundable & Non-Refundable Deposit

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

Download the guide

15.16.17 Bad Debt Relief Recover

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

Download the guide

20. Gift Deemed Supplies

This is how deemed supplies work in SQL Accounting.

Download the guide

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

Download the guide

23. GST Tap

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

Download the guide

24. Bank Charge With GST

How to handle Supplier bank charge with tax amount?

Download the guide

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?

Download the guide

27. Cash Book Simplified Invoice

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

Download the guide

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.

Read the guide

29. GST Payment to RMCD

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

Download the guide

30. 5Cents Rounding for Sales & Purchase

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

Download the guide

31. Promotional/Sample Item for GST

How to key in promotional/sample item into system?

Download the guide

32. Self Billing

How do I key-in self billing?

Download the guide

33. De-Register GST

How do I de-register GST in SQL Accounting?

Download the guide

34. Industries Code (MSIC)

How do I assign my industries code?

Download the guide

35. How to Submit GST03 Tap Online

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

Download the guide

36. Input Entry For ATS

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

Download the guide

37. GST Tax Code – TX-N43

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

Download the guide

38. GST Tax Code – TX-RE

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

Download the guide

39. Understanding of Mixed Supplies (Partial Exemption)

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

Download the guide

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

Download the guide

41. Set Tax Date in Purchase Invoice

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

Download the guide

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

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

Download the guide

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.

Download the guide

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

Read the guide

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

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

Download the guide

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

Process New GST Return BUT get message prompt above?

Download the guide

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

Process New GST Return BUT get message prompt above?

Download the guide

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.

Download the guide

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.

Download the guide

51. Account code for Output Tax Adjustment Error Message

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

Download the guide

53. GST Migration System for GST Past Document Opening Balance

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

Read the guide

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

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

Download the guide

 

 

-->