Month-end is when daily noise becomes management signal. Branch managers receive period-to-date production. Finance reconciles report totals to general ledger. Regulators receive formatted summaries from archived period extracts. Monthly report projects in Easytrieve aggregate larger datasets than dailies, use CONTROL hierarchies heavily, run less frequently but under higher scrutiny, and must survive audit years later. Programs read period control files, filter transactions between begin and end dates, SORT when upstream did not, produce summary REPORT with NEWPAGE on major breaks, and emit FINAL totals accountants foot by hand or spreadsheet. This tutorial explains period parameterization, summary versus detail monthlies, GL tie-out workflow, multi-entity consolidations, restatement reruns, archival naming, and differences from daily and year-end portfolios. Pair with control break processing pattern and reusable report framework for production-quality monthlies beginners can model in training assignments.
| Step | Producer | Easytrieve report |
|---|---|---|
| Period close | Finance close job | INIT reads PERIOD-CTL |
| Accruals | Adjustment postings | Included in period extract |
| Extract | Monthly transaction file | JOB INPUT driver |
| Report | Easytrieve REPORT | Management listing |
| Archive | Operations | GDG retained per policy |
12345678INIT-MONTHLY. PROC GET PERIOD-CTL MOVE CTL-PERIOD-ID TO RPT-PERIOD MOVE CTL-BEGIN-DATE TO PERIOD-START MOVE CTL-END-DATE TO PERIOD-END MOVE 'MONTHLY SUMMARY' TO RPT-TITLE MOVE CTL-PERIOD-ID TO RPT-ID END-PROC
JOB INPUT filters IF TRAN-DATE GE PERIOD-START AND TRAN-DATE LE PERIOD-END. Fiscal periods not equal calendar months use PERIOD-ID match on extract records instead of date range when close system stamps period id per transaction.
1234567891011121314SORT USING MONTH-EXTRACT GIVING SORTED-WORK KEY REGION ASCENDING PRODUCT ASCENDING END-SORT REPORT MONTHLY-SUMMARY JOB INPUT SORTED-WORK TITLE %STD-REPORT-HEADING LINE 'Period:' RPT-PERIOD CONTROL REGION NEWPAGE PRODUCT LINE PRODUCT PRODUCT-NAME SALES-AMT MASK MONEY-MASK SUM FOOTING PERFORM STD-FOOTING END-REPORT
Detail lines omitted—only subtotal and FINAL totals print when RUN-OPTION summary mode set. Detail monthly for auditors uses same extract with separate REPORT including transaction LINE—two REPORT blocks one JOB.
FINAL SALES-AMT on monthly must equal GL account balance for same period. Tie-out PROC reads GL-CONTROL file after REPORT, COMPARE difference DISPLAY. Nonzero difference blocks sign-off—finance investigates accrual timing or extract omission. Document tolerance—usually zero for revenue accounts. Tie-out counts as error-handling severity 4 for month-end even when daily jobs tolerate small drift.
Shorter, subtotal-focused, NEWPAGE per region, charts optional downstream from exported file. Emphasis on readability and comparison to prior month—INIT may READ PRIOR-PERIOD-TOTALS for variance LINE.
Strict layout per filing spec—field positions mandated. May require detail transaction appendix. Version stamp in TITLE mandatory. Retention and immutability after filing lock—restatements get new period version not silent overwrite.
When adjusting entries repost, finance reruns monthly extract and reports with RESTATE-FLAG Y in TITLE watermark. Archive both original and restated GDG generations. Easytrieve does not delete prior archive— operations manages catalog. INIT reads which PERIOD-VERSION to process from control file.
Holding companies run REPORT per legal entity then consolidation JOB INPUT combined work file with ELIMINATION-ADJ records. CONTROL ENTITY break shows entity subtotals before consolidated FINAL. Intercompany eliminations applied in PERFORM before LINE—advanced monthly pattern requiring accounting rules documentation in Library comments.
| Aspect | Daily | Monthly |
|---|---|---|
| Data window | One business date | Full period range |
| Volume | Smaller | Larger—SORT common |
| Audience | Operations | Management and finance |
| Retention | Days to months | Years |
| Sign-off | Informal scan | Formal GL tie-out |
Every day you get a short note about what you did that day. At month end the teacher makes a poster with gold stars for the whole month and totals how many stars each team earned. Monthly reports are that poster— the whole month counted together, not just yesterday.
1. Monthly reports typically aggregate:
2. Period parameter often comes from:
3. Management monthly summaries favor:
4. GL tie-out monthly compares:
5. Monthly JOB often runs: