View source for Generate Payment Voucher / Journal Entry...

''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.
<br />
::[[File:Generate PVJV_01.jpg |600px]]
<br />

==Overview of the Process Flow==
::[[File:Generate PVJV_02.jpg |600px]]
<br />

==Configure Payroll Accounting (1 time setup)==
:1. At Generate Payment Voucher / Journal Entry, click on '''Configure Payroll Accounting'''.
::[[File:Generate PVJV_03.jpg]]
<br />

===Step 1 SQL Account GL Code===
:1. Click on '''Load From File'''.
::[[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.
: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]]
:4. Click Remove File button if you wish to load the new chart of account.
<br />

===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.
::[[File:Generate PVJV_06.jpg]]
2. Example of the account mapping:
::{| class="wikitable"
|-
! Payroll !! Account !! Acc Type
|-
| Wages || Salary || P&L 
|-
| Allowance || Allowance || P&L
|-
| Overtimes || Overtimes || P&L
|-
| Commission || Sales Commission || P&L
|-
| Claim || Petrol, Toll, other expenses claims || P&L
|-
| Paid Leave || Salary || P&L 
|-
| Director Fees || Director Fees || P&L
|-
| Bonus || Bonus || P&L 
|-
| Advance Paid || Salary || P&L 
|-
| Loan || Loan || B/S 
|-
| Deduction || Salary || P&L 
|-
| CP38 || Salary || P&L 
|-
| Unpaid Leave || Salary || P&L 
|-
| Advance Deduct || Salary || P&L 
|-
| Employee EPF (Accrual) || EPF Accrual || B/S
|-
| Employer EPF (JE) || Employer EPF || P&L 
|-
| Employee SOCSO (Accrual) || SOCSO Accrual || B/S
|-
| Employer SOCSO (JE) || Employer SOCSO || P&L
|-
| PCB || Income Tax (PCB) Accrual || B/S
|-
| Adjustment || Salary || P&L
|-
| Payment Method || Bank Account || B/S
|}
<br />

===Step 3 Posting Method===
:1. Generate posting entry by '''Payment Voucher''' or by '''Journal Entry'''.
:2. Group by '''Employee''' (available in payment voucher), '''Branch''', '''Department''', '''HR group''', or '''Category'''.
:3. Tick to '''With Project Code''' to post the entry with project code.
:4. OPTIONAL: Generate Journal Entry for Employer EPF, SOCSO Accrual. '''(by default is untick)'''. For some company might charge the Employer EPF and SOCSO accrual in next month. 
::[[File:Generate PVJV_07.jpg]]

==See also==
* [[Save GL Account To File]]
* [[Import Payment Voucher / Journal Entry]]