Overview

To perform month-closing activities, the complete payroll charge needs to be calculated, transfered and posted in the cost controlling and financial accounting.

The transfer of timesheet data of shop workers is usually applied for this case.

The import of external data is applied for fixed salary cases (other then hourly paid employee contracts).

During the process, make sure you review payroll results and wage type details and reconcile payroll entries.

Perform closing in payroll flowchart

Perform closing in payroll

(v.0)

Loading diagram...

Paths

PathManufacturing → Labor costs → Timesheets charge
In-app link EN code

e1cib/list/Document.WorkOutput

In-app link RU code

e1cib/list/Документ.ВыработкаСотрудников

How to register timesheets charge for shop workers

1. Click Expand by assignees and base documents to show lines by Work teams / Employees and Base documents, .

2. Find reference documents, select them, click Generate. The system will automatically:

  • Create a new Timesheets charge document.
  • Fill the document with data recorded in Base documents.
  • Apply relevant rates per work.
  • Fill profitability and cost data.
  • Allocate labor costs between team members based on the Labor participation rates.

3. Open the document created, check that the information filled in is correct, make the necessary changes, and post it.

Paths

PathProfitability & cost → Income and expenses → Post payroll expenses to accounting
In-app link EN code

e1cib/list/Document.PostingPayrollExpensesInFinancialAccounting2_5

In-app link RU code

e1cib/list/Документ.ОтражениеЗарплатыВФинансовомУчете2_5

How to fill in shop workers payroll data by timesheets charge

1. Click Create.

2. On the Main tab specify a period in the Month field, select a Company and a Currency, select the Accruals and taxes detailed by persons check box.

Specific case 1. If payroll accruals are registered in several currencies, we recommend using separate documents for each currency.

Specific case 2. If the company makes accruals for the period starting from the 25th day of the previous month and ending with the 25th day of the current month, we recommend using separate documents for two periods: 

  • Starting from the 25th day till the 31st day of the previous month.
  • Starting from the 1st day till the 25th day of the next month.

3. Go to the Accruals tab, click Fill and select Fill in by Employee output data. The system will automatically fill the tab with data recorded in all the Timesheets charge documents for the period.

4. Select the Allocate to production in the Accounting attributes column, click on the hyperlink Fill in accounting attributes, select the Allocation base type, select the Product cost element.


Note

The Allocation base type options:

  • by standard cost of works (selected by default)
  • by work duration

How to import non-production employee payroll data

1. Click Create.

2. On the Main tab specify a period in the Month field, select a Company and a Currency, select the Accruals and taxes detailed by persons check box.

3. Go to the Accruals tab, click Add to add new line.

Scenario: Import data from spreadsheet 

Go to the Accruals tab, Click the Import from file button.

  • Option 1: Import from clipboard.

Copy an Excel spreadsheet and paste the buffered data into an empty table in the uploading form. Paste only Full name and Amount data.

  • Option 2. Import from an external file.

Download an Excel template, fill it, and import the Excel file.

Click Next.

Review the uploaded draft and decide what to do with unmapped (unrecognized) data.

Click Import data.

4. Fill in the columns Business unit to which the employee refers, and Person.

5. Fill in the Accrual payroll kind and the Types of employee compensations columns, specify the amount Accrued.

6. Fill in the Refer to other expenses in the Accounting attributes column, click on the hyperlink Fill in accounting attributes, select the Line of business (if applicable), select the expense Item, select expence Dimention.

How to fill in payroll taxes data

Generate a payroll tax accruals:

1. Go to the Accruals tab, click Calculate taxes.

2. Select the Tax kind check box (relevant to company duty), specify the Rate, select the Change document lines: All option. The system will automatically fill in lines with data from Accruals tab. 

3. Check the calculation result and information filled in.

Calculate duties of a tax agent:

4. Go to the Accruals tab, click Calculate taxes.

5. Select the Tax kind check box (relevant to employee duty), specify the Rate, select the Change document lines: All option. The system will automatically fill in lines with data from Accruals tab.

6. Check the calculation result and information filled in.

Calculate deductions:

7. Go to the Deductions tab.

8. To record personal deductions (e.g. related to a damage in production), add lines and specify amounts and financial information manually.

How to reconcile payroll entries

1. Open the Post payroll expenses to accounting document

2. Click the Financial accounting entries button.

3. Check that the accounting data is correct and click Posting to financial accounting.

  • No labels