Overview
Coins ERP+ users can post payroll to multiple fiscal periods. The Timecard Date determines the fiscal period for expenses posted to the General Ledger, Job Cost, Assets, and Workshops. This means that the Fiscal Date is determined at the point when timecards are entered.
This functionality is for the US and Canadian regions only.
PR Company Configuration
Other Tab
A field labeled Base Expense Fiscal Period on Timecard Date is found in Payroll > Company Setup > Company Configuration > Other tab, as shown in Other Tab. It lets you determine whether the Expense Fiscal Period Date should be based on the Timecard Date.
In addition, the layout labeled Timesheet Default on this screen has been renamed Timesheet Setup.
Other Tab
The Base Expense field can only be updated if there are no timecards entered for the unposted regular or adjusting period.
The Timecard Expense Fiscal Period Date is only set up when the Base Expense field is checked.
The Timecard Expense Fiscal Period Date calculates all timecards when the Base Expense field is checked; otherwise, it is empty for all timecards.
Significant Items Tab
A significant item labeled Accrued Payroll for the Accrued Payroll Pay is available on the General Pay Items layout in Payroll > Company Setup > Company Configuration > Significant Items tab, as shown in Significant Items Tab. It is only available only if the Base Expense Fiscal Period on Timecard Date field is checked. The item cannot be changed if there are employees with an already calculated payroll.
In addition, the Standard Labor Rate Contra Pay field on this screen has been relabeled as Standard Labor Rate Contra.
Significant Items Tab
PR Period Maintenance
If the Base Expense Fiscal Period on Timecard Date field in PR Company Configuration is checked, the Fiscal Period of Period Maintenance is only accessible if all employees are in START mode.
PR Checks Input
Timesheets Entry
Timesheets Entry sets up the Timecard Expense Fiscal Period Date if the Base Expense Fiscal Period on the Timecard Date field in PR Company Configuration is checked.
This field is calculated based on the value of the Timecard Date. It is not an updateable field and is calculated as demonstrated in the example below.
Example using Period Maintenance Fiscal Date value of 01/31/2014:
If the following G/L Period records exist:
12/31/2013 (Previous G/L Period)
01/31/2014 (Current G/L Period)
02/28/2014 (Next G/L Period)
Then the following calculations are:
Current G/L Period value = 01/31/2014 - Period Maintenance Value
Current Period date range = (Previous Period + 1) to Current Period, such as 01/01/2014 to 01/31/2014
Previous Period date comparison = < Previous Period, such as
< 12/31/2013Next Period date comparison = > Current Period, such as > 01/31/2014
Void Checks
Void Checks includes the expense Fiscal Period field on the selection screen, as shown in Void Checks Screen. This field is only accessible if the Base Expense Fiscal Period on Timecard Date field in PR Company Configuration is checked.
The default for this field comes from the Fiscal Period in Period Maintenance.
For all timecards created for the voided check, the Timecard Expense Fiscal Period Date should be set to the value entered for this field.
Void Checks Screen
Convert From Recurring Timesheets
The Convert from Recurring Timesheets function sets the Timecard Date when recurring timecards are created. It also sets the Expense Fiscal Period if the Base Expense Fiscal Period on Timecard Date field in PR Company Configuration is checked.
PR Costing Workbench
Batch Tab
If there are two GL batches for the Costing batch, both of them are displayed on the Batch tab of the Costing Workbench Summary screen only if the Payroll is posted, as shown in Batch Tab. This does not depend on the current state of the Base Expense Fiscal Period on Timecard Date field in PR Company Configuration.
Batch Tab
Transactions Tab
The Transactions tab on the Costing Workbench Summary screen includes the Fiscal Period field. This field is available for the batches with Payroll timecards spanning two fiscal periods regardless of the current state of the Base Expense Fiscal Period on Timecard Date field in PR Company Configuration.
For the example in Transactions Tab, it includes the Accrued Payroll entered for balance.
Transactions Tab
Batch Analysis Summary Report
The Batch Analysis Summary Report groups the Employee Cost records by fiscal period, as shown in Batch Analysis Summary Report. This includes totals by Fiscal Period and a Grand Total.
Batch Analysis Summary Report
Post Batch Report
The Post Batch Report groups the Employee Cost records by fiscal period, as shown in Post Batch Report. This includes totals by Fiscal Period and a Grand Total.
Post Batch Report
