Payroll transactions occur on a regular basis. Staff receiving
a salary is paid on a monthly basis and staff who receives wages, may be
remunerated on a weekly, fortnightly basis, etc. The principles for salaries and
wages are the same, but salaried staff and staff receiving wages, may have
different allowances and deductions.
It is therefore recommended that you create a batch or journal for salaries and for each of the wage groups (weekly, fortnightly, etc. The reason for this is that you may need to post the transactions on a monthly, weekly or fortnightly basis to the ledger. As the nature of payroll transactions is repetitive of nature, it is recommended that the transactions be entered in a Repeating Batch in the Edit - Repeating Entries menu option. Once the salary calculations are finished, and the pay sheets are finalised, you only need to open the repeating transactions batch. You need to carefully check that the basic salary, wages and or allowances as well as any deductions and employers contributions, etc. is correct. If necessary, you need to change any amounts, or insert the transactions if there are new allowances and or deductions. If an allowance or deduction is not applicable to a month, you may simply delete the transaction from the batch.
A payroll journal would normally consist of 4 sections in which you may add columns to analyse the payroll for each of your pay groups:
The basic information on this spreadsheet or any other payroll report, the transactions can be entered in the repeating batch.
To Enter Payroll Transactions in the Repeating Batch:
Click on the Edit - Repeating Entries menu
option or press the
and
and
keys on your keyboard. The Batch Type selection screen will be displayed.
Select the Payroll Journal (Salaries or Wages batch or General Journal) in which
you wish to enter your payroll transactions and click on the
button. The
Batch Entry screen for the selected journal or batch (e.g. Payroll Jnl) is indicated as a Repeating Entries batch as follows:
If no contra account is displayed on the Batch
Type selection screen, you need to set the options for the batch. If you have
not yet set the salaries or wages batch up, or if your requirements should
change, click on the
speed button or icon. Note that for Salaries or Wages, the
Amount Entry field should be set to allow both debit and credit.
Enter the transactions in the repeating entry
batch. It is recommended that the following guidelines be followed when entering
transactions in the batch.
Click on the
speed button or icon or press the or press the
key on your keyboard. TurboCASH will create the balancing entry to the contra account (which
should be the salary control account). The description field will display
BALANCING ENTRY - Payroll Jnl or General Journal, etc. Note that the net
amount of the balancing entry should be equal to the total amount for the net
pay that you need to pay to each of the employees (by cheque, cash or bank
transfers).
Click on the
speed button to list the batch. It is recommended that this
list is retained and checked when the salary or wages payslips is finalised. You
may need to insert new transactions for new allowances or deductions and you may
have to edit amounts if it is changed for the specific pay period. Before
importing the transactions in this repeating batch in a normal batch.
Press the
key to exit or close this batch. When your payroll is finalised for the specific pay period, you may need
to edit the batch if the changes in your payroll are of a permanent nature. If
the changes are only of a temporary nature, (only apply to a specific period
(e.g. the amount for overtime for a month changes, or if a bonus or leave pay is
paid), you may edit these transactions after this batch is copied or imported into the batch in the Input Batch Entry
<F2> menu option.
Add a new Employee:
button of this help file to access the Web Sites of your Tax Authority
regarding Employees Tax issues.
It is therefore recommended that you create a batch or journal for salaries and for each of the wage groups (weekly, fortnightly, etc. The reason for this is that you may need to post the transactions on a monthly, weekly or fortnightly basis to the ledger. As the nature of payroll transactions is repetitive of nature, it is recommended that the transactions be entered in a Repeating Batch in the Edit - Repeating Entries menu option. Once the salary calculations are finished, and the pay sheets are finalised, you only need to open the repeating transactions batch. You need to carefully check that the basic salary, wages and or allowances as well as any deductions and employers contributions, etc. is correct. If necessary, you need to change any amounts, or insert the transactions if there are new allowances and or deductions. If an allowance or deduction is not applicable to a month, you may simply delete the transaction from the batch.
A payroll journal would normally consist of 4 sections in which you may add columns to analyse the payroll for each of your pay groups:
-
Basic salary or wage and any other columns to analyse the
allowances and any other remuneration payable to the staff receiving salaries
or wages These columns need to add up to the gross pay.
-
Deductions – columns for each of the deductions applicable to
the salaried staff or applicable to the staff receiving wages. These columns
need to add up to the total deductions.
-
Net pay – the amount that the staff will be taking home
(gross pay less the total deductions).
- Employer's Contributions – Any amount that the employer should contribute towards certain deductions deducted from an employee's salary or wage.
The basic information on this spreadsheet or any other payroll report, the transactions can be entered in the repeating batch.
To Enter Payroll Transactions in the Repeating Batch:
button. The
Batch Entry screen for the selected journal or batch (e.g. Payroll Jnl) is indicated as a Repeating Entries batch as follows:
- In the place of the alias *** Repeating Entries *** will be displayed on the title bar.
- The rows for the transactions are displayed in a light pink background colour.
speed button or icon. Note that for Salaries or Wages, the
Amount Entry field should be set to allow both debit and credit.-
Reference number - Use the employee number or personnel
number for transactions regarding the basic salary or wages and deductions.
This would be the basic information displaying on the pay sheet for an
employee. You may use a general or other reference number for transactions
regarding the employers' contributions.
-
Date - Select the date of the payroll. It is usually the last
day of the pay period or the pay date.
-
Group the transactions for each employee together as it will
make it easier to edit the transactions for each employee when the employee's
payslip changes from month to month. In the first row you would enter the
basic salary, and in the second row onwards any allowances. After entering the
salaries and allowances, you need to enter the deductions for the same
employee.
- Finally enter the employer's contributions (e.g. Unemployment Insurance Fund (UIF), National Insurance Contributions (NIC) for United Kingdom based users, Pension Schemes, Provident Funds, Medical Aids, etc.).
speed button or icon or press the or press the
speed button to list the batch. It is recommended that this
list is retained and checked when the salary or wages payslips is finalised. You
may need to insert new transactions for new allowances or deductions and you may
have to edit amounts if it is changed for the specific pay period. Before
importing the transactions in this repeating batch in a normal batch.![]()
Add a new Employee:
-
Select the row or transaction where you need to add the
employee (it is recommended that the employee's transactions be inserted
according to the Employee number in the reference column. Click on the
speed button or icon button to add new rows or lines and enter the basic salary,
allowances and deductions.
- Change the recalculated amounts for the employer's contributions.
-
Select the employee number and click on the
button to delete each transaction for the employee.
- Change the recalculated amounts for the employer's contributions.
-
Select the row or line and click on the
speed button or icon and enter the transaction.
- Change the recalculated amounts for the employer's contributions.
![]()
button of this help file to access the Web Sites of your Tax Authority
regarding Employees Tax issues.
taken from the