|
OUTLINE
|
|
|
Procedures for reconciling TAX accounts
to the Financial Controls in the Master Employee Record (MER).
|
|
|
At month end the following accounts in the Common
Departmental Financial System (CDFS) must be reconciled with the Financial
Controls in the MER. Each account is accumulated on a year to date (YTD)
basis in an element resident on the MER.
|
|
|
|
TITLE |
MER ELEMENT |
Federal -- Tax Wage Loss and No-wage
Loss
|
704
|
Provincial Tax
|
705
|
CPP -- Wage Loss and No-wage Loss
|
708
|
QPP
|
709
|
EI -- No-wage Loss
|
715
|
EI -- Wage Loss
|
716
|
Federal Gratuity Tax
|
729
|
Quebec Gratuity Tax
|
730
|
Parental Insurance Plan (PIP) |
761 |
|
|
PROCEDURES
|
|
|
MONTH END -- After the remittance of the
TAX accounts for week 4 and once interdepartmental settlement (IS) Creditor
initiated to charge Treasury Board for the employer's (ER) share has been
approved,
|
|
|
- ENSURE sufficient time for updating to CDFS.
|
|
|
- ENSURE all further postings for manual transactions to CDFS
match a PAC 30, processed in the applicable accounting month and approved.
|
|
|
- PRINT a detailed report for the above accounts for each pay
office from CDFS.
|
|
|
LOTUS SPREADSHEET -- A lotus spreadsheet
has been developed for this reconciliation between the MER and CDFS. It
includes the following information:
|
|
|
|
- Financial Control Figures (Current Month and To-date);
|
|
- CDFS Figures (Current Month and To-date);
|
|
|
|
|
|
|
|
|
|
- Employers Share Amounts (if applicable).
|
|
|
|
- IDENTIFY and INVESTIGATE all PAC 30s with no offsetting
document or PAC 30 and all documents with no offsetting PAC 30 or document
and LIST on Spreadsheet.
|
|
|
- CONTINUE investigations until the financial control (FC) totals
equal the CDFS totals (current and to-date).
|
|
|
- Finally SEPARATE reconciliation to verify if the Ledger to
date CDFS totals less the outstanding items equal "zero".
|