Month-End Journal Closing Worksheet - ERRM

Use this worksheet when completing month-end journal closing for a company that uses Enhanced Real-time Revenue Management (ERRM).

The worksheet gives you a place to track month-end steps, record report totals, compare balances, and note differences that need review.

Download the PDF worksheet:

Download Month-End Journal Closing Worksheet — ERRM

For the full month-end close workflow, see RFMS Month-End Close: Steps, Reports, and Reconciliation.

When to Use This Worksheet

Use this worksheet during month-end close when you need to:

• run and review ERRM month-end reports;
• record report totals;
• compare report totals to journal or General Ledger balances;
• document differences that need review;
• keep a printed or saved record of the month-end review.

This worksheet is intended to be printed or filled out digitally while you work through month-end reports in RFMS.

Before You Begin

Before using the worksheet:

• Confirm that your company uses ERRM.
• Confirm the month and year being closed.
• Confirm the store or Combine selection to use for reporting.
• Use the same report date, store, and Combine selection when comparing report totals to journal or General Ledger balances.
• Complete required posting before final balance comparison, including outstanding A/P, job costing, and inventory adjustments for the month being closed.
• Follow your company’s accounting close procedures before making journal entries or corrections.

Reports to Run Before Using the Worksheet

Before completing the worksheet, run the month-end reports your company uses to review and reconcile month-end balances.

For companies using ERRM, this usually includes:

Review Area	Report
Bank or cash activity	Check register or bank reconciliation reports
Accounts Receivable	Month-End A/R and Customer Deposits Report
Accounts Payable	Month-End A/P Report
Inventory	Month-End Inventory Balance Report
Accrued Inventory	Month-End Accrued Inventory
Accrued Labor	Month-End Accrued Labor
Unbilled accounts receivable	Month-End Unbilled A/R
Work in Progress material	WIP Material
Work in Progress Material percent billed	WIP Material Percent Billed
Work in Progress labor	WIP Labor
Work in Progress labor percent billed	WIP Labor Percent Billed
Booked orders not job costed	Month-End Booked Not Job Costed
Sales and material cost review	Job Cost Analysis Report
Sales/use tax or GST, if applicable	Tax reports or GST Report
Payroll, if applicable	Payroll month-end reports

Use the worksheet to record report totals, compare balances, and document differences that need review.

For details about how ERRM report records are included in or removed from each report, see Reference: Month End Reports for ERRM Users.

If a Balance Does Not Match

If a report total does not match the journal or General Ledger balance, record the difference on the worksheet and review the related month-end troubleshooting steps.

Before making corrections, confirm that:

• the same accounting period or report date was used;
• the same store or Combine selection was used;
• all required transactions were posted;
• the correct account code or journal balance is being compared;
• no activity was posted after the report was run.

For detailed troubleshooting, see RFMS Month-End Close: Troubleshooting Balance Mismatches.

Tax Reporting

The attached checklist includes a reminder to enter sales tax liability during Preliminary Close Journal. It does not cover every tax reporting workflow.

If your company reports sales/use tax, review your sales/use tax balances as part of month-end close. Run the applicable tax reports before completing final close, and save or print the tax reports with your month-end documentation.

If your company reports GST, run the GST Report as part of month-end review. Review GST collected and GST paid according to your company’s accounting process, and save or print the report with your month-end documentation.

Complete the tax review that applies to your company’s accounting setup. You do not need to complete both sales/use tax and GST review unless your company’s accounting process requires it.

Related articles

• RFMS Month-End Close: Steps, Reports, and Reconciliation
• RFMS Month-End Close: Troubleshooting Balance Mismatches
• Reference: Month End Reports for ERRM Users
• Month-End Inventory Balance Report — ERRM
• Month-End A/R Report
• Month-End A/P Report
• General Ledger
• System Option - Setup Sales Tax Accounting
• Postings to the General Ledger
• Balancing the General Ledger