Search TipsUS Payroll - Timesheet Posting
Pgm: PYTIMPST – Payroll Timesheet Posting; standard Treeview path: US Payroll > Timesheet > Timesheet Posting
Use this screen to post the information entered for the specified period in Timesheet Entry. Timesheets can be posted at any time during a pay cycle. If required, timesheets can be posted on a daily basis as there is the option to limit the posting of timesheets to a specific date range.
The posting of timesheets only posts the direct time charged to the job. It does not calculate or post workers’ compensation, public liability, or any other overhead type costs. These amounts are only calculated and posted during payroll processing and posting.
Timesheet Posting Report
Pgm: PYPRPSTREP – PY Print Posting Reports; standard Treeview path: US Payroll > Utilities > Print Posting Reports
The Timesheet Posting Report prints the details of the timesheets posted on the pay run/pay period/pay group selected for posting. The posting report sorts all entries by employee code and sub-sort by timesheet date. Each new employee is distinguished by a solid black line. Both hours and amount are totaled for each employee.
A G/L Posting Report and a Job Costing Posting Report are also generated to show the affected accounts and jobs.
Timesheet Posting – GL Interface
When posting timesheets the system posts the following transaction to the General Ledger:
Job/Phase/Category Cost / Expense DR XXX
CR Clearing Account CR XXX
Timesheet Posting posts the charge out rate for each timesheet entry line for the period indicated. The pay rate is used for the calculation of employee wages.
The manner in which the posting of timesheets interfaces with the General Ledger module is dependent on the ‘Subledger Summary’ box in the General Ledger (standard Treeview path: General Ledger > Setup > Maintain Accounts). Each account is flagged individually so that all or a portion of the interface may be sent in detail or summary.
If the ‘Subledger Summary’ box is unchecked, detailed employee information such as names and their wage related costs may be printed. Ensure that this box is set properly to achieve the desired interface results.
General Ledger Interface – ‘Subledger Summary’ box unchecked
Source Code: Employee Code
Source Desc: Employee Name
Reference: Pay run code / Year / Pay Period
Reference Desc: Pay run description
Post Date: Post Date
Reference Date: Timesheet Line Date
WM: Hard coded as 'HR'
General Ledger Interface – ‘Subledger Summary’ box checked:
Source Code: Blank
Source Desc: Blank
Reference: Pay run code / Year / Pay Period
Reference Desc: Pay run description
Post Date: Post Date
Reference Date: Period End Date
WM: Hard coded as 'HR'
Timesheet Posting – JC Interface
The manner in which timesheet posting interfaces with the Job Costing module is dependent on the “Job Summary By” option on the Company Profile screen. Job cost information can be transferred by Job/Cost Code/Category, Job by Employee, Job by Date, Employee by Date, or Timesheet. The choice of option affects what employee information is printed on the report, as shown below:
Job Cost Interface – Job by Employee or Timesheet or Employee by Date
Source Code: Employee Code
Source Desc: Employee Name
Reference: Pay run code
Reference Desc: Pay run code / Year / Pay Period
Post Date: Post Date
Reference Date: Timesheet Line Date
WM: 'HR' converted to WM on the Category
Job Cost Interface – Job/Cost Code/Category or Job By Date
Source Code: Blank
Source Desc: Blank
Reference: Pay run code
Reference Desc: Pay run code / Year / Pay Period
Post Date: Post Date
Reference Date: Period End Date
WM: 'HR' converted to WM on the Category