Trust Report

1. Save a separate copy for each Craft, of the PR Craft Full Details With Rates report

   1. 170

   2. 290

   3. 292

   4. 297

   5. 299

2. On tab 1-290-Balance Sheet of the Union Worksheet (that is copied each month from the prior month) enter in the GL Account dollar amounts using the saved GL Trial Balance report for the month being reported

3. [Optional] On the PR Full Details with Rates for each Craft, highlight each apprentice so they stand out; this helps differentiate the different Crafts as there are many pages of employees for 290

4. Export the + PR Industry Trust Fund Upload custom report, built by Silvertrek

   1. PRCo is always '1'

   2. PR Groups: always enter '1'

   3. Paid Month: month being reported currently

   4. Earn Codes: leave as default values

   5. Agreement ID: required field; run per Craft being reporting:

      1. Agreement 100: Journeymen

      2. Agreement 1150: PTO

      3. Agreement 200: Apprentice

      4. Agreement 800: Metal Workers

      5. Possibly others as time goes on, keep a wary eye out so none are missed during reporting

   6. Save the Export as an Excel Format Data Only (.xlsx) file

      1. Name the file: YYYYMM PR Industry Trust Fund Upload - Agreement 100

   7. Export this same report for all other necessary Agreement IDs

5. Login to the employer edge website (via Lastpass)

6. Import the exports saved from Vista

   1. Instructions to do the importing add here

7. Pause - compare import numbers to Vista's PR Craft Full Details with Rates numbers to ensure that the import files contained all correct information - do this with EVERY import that uses a custom report

   1. Add instructions to validate numbers here

National Pension

• Download and save +PR National Pension Fund Upload 

  • Leave parameters alone, except for Paid Month if that needs changed, change it to current month being rpeorted

  • Save as Excel Format Data Only

  • Open the saved Excel sheet and save as a .csv file

  • Open the .csv file

  • Delete the Header row (SSN, FirstName, LastName, Work Period, etc.) -- the import will fail if this is left on the file

  • Make Column A formatted as "Text"

  • Ensure the Employer ID is "0011515" (in second row) - usually this value loses its leading zeroes and those must be included

  • Scroll down thru the SSNs and look for any that are not 9 digits long; verify that EE's actual SSN number in Vista and fix on the .csv file

  • Save the file, close it, and attempt the import into the site

• Add Apprentice 1 and 2 hours to ITF hours under BTE01 Group

  • Find all AP 1 and 2 hours in the PR Craft Rates with Full Details PDF reports (review ALL reports) and sum them together into one amount

  • Add this amount to the BTE01 Group's ITF hours at the bottom of the section (do NOT add the employees themselves to this section)

  • Do NOT add any hours from PTO, Sick pay, or Holiday

401(k) Reporting

Union 290 – 401K Report

Due: 10^th of every month (online)

1. Download the PR 401K Census out of Viewpoint for the month you are reporting for.
   

2. Save a PDF version of the report in Dropbox

3. Download the GL Trial Balance, account number 2338 out of Viewpoint for the month you are reporting for. See example below of how to run the report.

4. Verify the GL matches the Census report.

5. Download and save + PR Union 401k Fund Upload report as a Excel Format Data Only (.xlsx) (do not check any formatting boxes)

   1. Save the report in the 401k folder here: Total Mechanical\Administrative\Employees\01. Union\290\YYYY\ .... \ as Data Only

   2. Open the spreadsheet and save as a CSV

6. Login to the site Employer Edge via Lastpass and:

   1. Click on “Enter reports”

   2. Select the 401-401K report

   3. Scroll down to bottom and click Upload Batch Reports

   4. Browse to the saved CSV report in Dropbox and Import

   5. Watch for any validation errors

      1. If errors: resolve and re-import until the file is accepted

   6. Verify your totals match the 401(k) Census Report

   7. Submit report (green button bottom of page)

      1. If needed, you have until end of business today to un-submit the report

   8. Prepare the reconciliation sheet and send to Total Mechanical for review and approval

      1. Link to the Reconciliation Sheet

      2. Send link directly to the 401(k) tab on the recon sheet to Total Mechanical with request for their review and approval

   9. Only proceed after approval has been given

   10. Complete the ACH through the website

   11. Download the reports out of zenith and save to the Union folder in Dropbox

   12. Give invoice to AP to enter into viewpoint as an EFT. Make sure to write down the date Zenith will take the money out of our account.