| Line 15: | Line 15: | ||
==Configure Payroll Accounting (1 time setup)== | ==Configure Payroll Accounting (1 time setup)== | ||
:1. At Generate Payment Voucher / Journal Entry, click on '''Configure Payroll Accounting'''. | :1. At Generate Payment Voucher / Journal Entry, click on '''Configure Payroll Accounting'''. | ||
::[[File:Generate PVJV_03.jpg | ::[[File:Generate PVJV_03.jpg]] | ||
<br /> | <br /> | ||
===Step 1 SQL Account GL Code=== | ===Step 1 SQL Account GL Code=== | ||
:1. Click on '''Load From File'''. | :1. Click on '''Load From File'''. | ||
::[[File:Generate PVJV_04.jpg | ::[[File:Generate PVJV_04.jpg]] | ||
:2. Select the [http://www.sql.com.my/w/index.php?title=Save_GL_Account_To_File...&action=edit&redlink=1 SQL Account file] (*.txt). Click Open. | :2. Select the [http://www.sql.com.my/w/index.php?title=Save_GL_Account_To_File...&action=edit&redlink=1 SQL Account file] (*.txt). Click Open. | ||
:3. After the SQL Account GL Code has loaded, the company name will be display and ladt saved date and time. | :3. After the SQL Account GL Code has loaded, the company name will be display and ladt saved date and time. | ||
::[[File:Generate PVJV_05.jpg | ::[[File:Generate PVJV_05.jpg]] | ||
:4. Click Remove File button if you wish to load the new chart of account. | :4. Click Remove File button if you wish to load the new chart of account. | ||
<br /> | <br /> | ||
| Line 29: | Line 29: | ||
===Step 2 GL Account Mapping=== | ===Step 2 GL Account Mapping=== | ||
1. After load the chart of accounts (in step 1), you are able to lookup and map the GL Account code to wages, allowance, overtime, bonus, etc accordingly. | 1. After load the chart of accounts (in step 1), you are able to lookup and map the GL Account code to wages, allowance, overtime, bonus, etc accordingly. | ||
::[[File:Generate PVJV_06.jpg | ::[[File:Generate PVJV_06.jpg]] | ||
2. Example of the account mapping: | 2. Example of the account mapping: | ||
==See also== | ==See also== | ||
* [[User Access Right Assignment (Acc)]] | * [[User Access Right Assignment (Acc)]] | ||
Revision as of 08:47, 10 July 2017
Menu: Payroll | Generate Payment Voucher/Journal Entry...
Introduction
- To generate the monthly payroll data converted into double entry and get post into SQL Account.
- It is available in SQL Payroll version 129 and above.
- It is available to import payroll data in SQL Account version 745 and above.
Overview of the Process Flow
Configure Payroll Accounting (1 time setup)
- 1. At Generate Payment Voucher / Journal Entry, click on Configure Payroll Accounting.
Step 1 SQL Account GL Code
- 1. Click on Load From File.
- 2. Select the SQL Account file (*.txt). Click Open.
- 3. After the SQL Account GL Code has loaded, the company name will be display and ladt saved date and time.
- 4. Click Remove File button if you wish to load the new chart of account.
Step 2 GL Account Mapping
1. After load the chart of accounts (in step 1), you are able to lookup and map the GL Account code to wages, allowance, overtime, bonus, etc accordingly.
2. Example of the account mapping: