Month-End Checklist (U.S.)
Use the following checklists to perform month-end processes specific to the United States.
Employees
- Print reports – Various reports can assist in verifying and reconciling your
payroll information for the month. Print the following reports:
- Union Detail Report screen – This report lists union fringes and deductions by pay period or check date. Go to .
- Utilization Report (U.S.) screen – This report lists employee utilization by company. Go to .
- EEO Report (U.S.) screen – This report lists EEO categories by job category for permanent employees. Go to .
- Payroll Insurance Report: Payroll Insurance Report - Summary screen or Payroll Insurance Report - Detail screen – This report lists insurance paid per employee based on earnings. Select either the summary or detail version of the report. Go to .
- State/Province Earnings and Tax Report by Month Screen – This report lists state or provincial earnings and taxes for a selected month. Use the report to review employee taxes and earnings for the month. Go to .
- State Unemployment Tax Report by Month screen – This report lists SUTA, SDI, and SUI taxable wages, tax liability, and withholdings by employee for a selected month. Use the report to review employee unemployment taxes for the month. Go to .
- Local Earnings and Tax Report by Month screen – This report lists local earnings and taxes for a selected month. Use the report to review employee earnings and taxes for the month. Go to .
- Employment Status Report screen – This report lists employee status changes. Use this report to determine if there are new hires to report. Go to .
- Greenshades Electronic Filing (U.S.) screen, if required. Go to .
- Paid Time Off by Code screen – Use this report to determine if any PTO adjustments need to be made. Go to .
- Generate PTO Period End Adjustments screen – Use this screen to create a journal entry to adjust the liability paid time off accrued. Go to .
Vendors
- Generate Recurring Vendor Invoices screen – Generate any recurring vendor invoices for the month, if you haven't done so already. Go to .
- Purchase Order Line Detail screen – Use the Purchase Order Line Detail report to confirm that all open purchase orders should still be open. Go to .
- Enter Purchase Order screen – Close any open purchase order that needs to be closed by setting Invoicing Complete and Receiving Complete to Yes. Go to .
- Subcontracts Screens – Use the Subcontract Detail By Vendor report or the Subcontract Detail By Project report to confirm that all open subcontracts and subcontract change orders still should be open. Select to include the change order details. Go to .
- Enter Subcontract screen – Close any open subcontract that needs to be closed by setting Invoicing Complete to Yes. Go to .
- Enter Subcontract Change Order screen – Close any open subcontract change order that needs to be closed by setting Invoicing Complete to Yes. Go to .
- Compare open vendor invoices to the trial balance:
- Open Vendor Invoices by Division screen report for the accounts payable account and division. Go to .
- Trial Balance screen report and compare the accounts payable accounts to the open vendor invoices. Go to .
Customers
- Generate Customer Finance Charges screen – Generate customer finance charges, if needed. Go to .
- Customer Statements screen – Use customer statements to review outstanding balances and to notify customers of their balances. Go to .
- Compare open customer invoices to the trial balance:
- Open Customer Invoices by Division screen report for the division. Go to .
- Trial Balance screen report and compare the accounts receivable accounts to the open customer invoices. Go to .
- Review and write off any invoices for small amounts or that are uncollectible.
Equipment
- Compare equipment usage to the trial balance:
- Equipment Usage Detail Report screen specifying the posting date and select both active and inactive equipment in the report criteria. Go to .
- Trial Balance screen and compare the general ledger accounts for equipment usage to the equipment usage. Go to .
- Compare the equipment cost to cost transactions:
- Equipment Cost Detail Report screen specifying the posting date and select both active and inactive equipment in the report criteria. Go to .
- Cost Type Transactions Report screen and compare the general ledger accounts for equipment cost to the equipment cost. Go to .
Materials
- Create Inventory Count Sheets screen – Go to .
- Print Inventory Count Sheets screen – Print the count sheets and physically count all the items in inventory. Write the item counts on the count sheets. Go to .
- Enter Inventory Counts screen – Enter the written counts from the count sheets into ProContractor. Go to .
- Review and compare the counts:
- Inventory Count Sheets Posting Journal – Review the inventory count entry. Go to .
- Inventory Missing Count Report – Review items included on the count sheet but not counted. Go to .
- Inventory Count Variance Report – Review differences between the expected quantities and the actual quantities. Go to .
- Post Inventory Count Sheets screen – Update the count entries based on the reports and post the counts. Go to .
- Inventory to General Ledger Reconciliation screen – Print the Inventory to General Ledger Reconciliation report to review inventory and purchase order transactions that may cause the inventory value to differ from the general ledger. If needed, verify that purchase orders are closed and then create journal entries for inventory. Go to .
Projects
- Units Complete Worksheet screen – Print the worksheet and give to personnel in the field to complete. Go to .
- Management Report screen – Print the Management Report to review the percent complete numbers for active projects. Go to .
- Update work in progress information – Use the Update Work In Progress screen to update the WIP numbers for each project, using information recorded on the Units Complete Worksheet. Go to .
- Bonding Report screen – Run the Work In Progress report for active projects to get over/unbilled amounts. Go to .
- Compare the project costs and billings to the project cost account. Do the
following:
- Project Reconciliation Summary by Division screen report specifying the posting date and select both active and inactive projects in the report criteria. Go to .
- If you are using divisions on cost codes in projects, Project Reconciliation Detail by Division screen report specifying the date range and select both active and inactive projects in the report criteria. Go to .
- Print the Cost Type Transactions Report screen and compare the general ledger accounts for project cost to the project cost. Go to .
- Trial Balance screen and compare the revenue amounts from the Project Reconciliation Summary report to the revenue accounts on the Trial Balance. Go to . If the reports do not match, run the Project Reconciliation Detail by Division screen report to review more detailed information. Go to .
- If needed, Project screen – Set the status of completed projects to inactive to close the project in ProContractor. Go to .
Financial
- Generate Recurring Journal Entry screen – If you haven't already done so, generate any recurring journal entries for the month. Go to .
- Create Journal Entry screen – Create any month end journal entries needed (Project WIP, Inventory Reconciliation, Bank Account Fees, and so on). Go to .
- Sales & Use Tax Report screen – Print the Sales & Use Tax Report and pay any amounts owed. Go to .
- Bank Reconciliation screen – Reconcile your bank statement to the transactions in ProContractor. Go to .
- Bank Reconciliation Report screen – Go to .
- Compare the check register to the trial balance:
- Select the appropriate account and Check Register screen. Go to .
- Trial Balance screen and compare it to the Check Register. Go to .
- Compare the account transactions to the trial balance:
- Account Transactions Report screen. Go to .
- Trial Balance screen and compare the Activity this Period column to the Account Transactions Report. Go to .
- Print reports – Various reports can assist in verifying and reconciling your
financial information for the month. Print the following reports and compare
them with each other:
- Trial Balance screen – Run the report with the Sort and Subtotal by Account Type checkbox selected. Go to .
- Balance Sheet screen – Go to .
- Income Statement - Common Size screen – Go to , , or .
Administration
- Verify that all posting groups have been posted.
- Fiscal Periods screen – Fiscal Period Setup (update the Closed Through Period End date). Go to .