✓ Closed FY 2026  ·  Month 6 of 12
Net Sales
$687,937
Budget: $799,265
▼ -14.0% vs budget
Gross Margin
32.8%
Budget: 32.2%
▲ +0.6 pts vs budget
Net Income
$34,680
Budget: $5,057
▲ +586% vs budget
YTD Net Income
($75,636)
FY Budget: $80,242
▼ Behind pace
Revenue vs. Budget — 6-Month Trend
Revenue Mix by Segment
Net Income Trend — 6 Months
AR Aging — March 2026
$1,295,232
Total Outstanding Receivables
AP Aging — March 2026
$654,848
Total Accounts Payable
Gross Margin % by Segment
Gross Margin % Trend vs. Budget
Income Statement Summary — March 2026
Line ItemThis MonthYTDYTD Budget
Net Sales$687,937$4,416,365$4,497,590
Purchases($209,473)($1,358,782)($1,440,840)
Labor($162,519)($1,025,297)($1,044,875)
Labor Burden($90,485)($559,555)($556,498)
Sub-Contractor——($187,500)
Gross Margin$225,460$1,432,223$1,267,877
Total Expenses($196,744)($1,241,327)($1,248,384)
Other Income$5,964$34,323$34,560
Net Income (Loss)$34,680($75,636)$53,853
Analysis
Monthly P&L comparison with budget and prior period trends
Net Sales
—
Gross Margin %
—
Net Income
—
YTD Net Income
—
Income Statement Comparison
Select a month above to load data.
Segment Performance
AR Aging
No data
AP Aging
No data
Exports
Generate professional financial reports for analysis, comparison, and distribution.
Income Statement

Monthly P&L with revenue, costs, and profitability breakdown.

Comparative Income Statement

P&L side-by-side with prior year, budget, or prior month with variances.

Segment Margin Report

Gross margin and profitability by business segment.

Budget vs. Actual

YTD performance against budget with monthly breakdown and variances.

AR Aging Report

Accounts receivable outstanding by aging bucket.

AP Aging Report

Accounts payable outstanding by aging bucket.

Master Billing

Period
Category
Label
DateLabelCategory Start InvEnd InvCount SubtotalTaxTotal
Month-End Close
Complete each step in order. All fields can be edited before final save.
1
Select Month
2
P&L Data
3
Segments
4
AR / AP Aging
5
Review & Save
Step 1 — Select Month & Upload Files
Sage 300 Exports — Upload All Four
📄
Trial Balance (PDF)
Microsoft Print to PDF from Sage
📋
AR Aging Report
Sage 300 Excel export
📋
AP Aging Report
Sage 300 Excel export
📊
Segments Spreadsheet
SEGMENT / REVENUE / LABOR / BURDEN
Auto-filled from uploads
TB → P&L fields & materials per segment  •  AR/AP → aging buckets  •  Segments → revenue, labor & burden per segment
Step 2 — P&L Summary

Enter key line items from your Sage 300 P&L export for the month. All figures in USD.

Revenue
Positive = unbilled increased; negative = decreased
Enter as negative number
Net Sales: $687,937
Cost of Sales
Other
Net Income: $34,680
Step 3 — Segment Entry

Upload the Segments spreadsheet in Step 1 to auto-fill revenue, labor & burden. Materials are pulled automatically from the Trial Balance. Gross margin is calculated automatically.

Segment Revenue ($) Labor ($) Burden ($) Materials
from TB		 Gross Margin $ GM %
Totals
Step 4 — AR / AP Aging

Enter aging bucket totals from your Sage 300 aging reports.

Accounts Receivable
Total AR: $1,295,232
Accounts Payable
Total AP: $654,847
Step 5 — Review & Save

Review all entries before saving. Use the Edit buttons to go back and make changes.

P&L Summary
AR Aging
Segment Summary
AP Aging
Admin
Import historical data and annual budget. Use the Download Template buttons to get the correct format.
Database Status
Checking database…
Prior Year Import
Upload the Sage 300 actual FYE Excel export. All 12 months are parsed automatically. Existing months will be overwritten.
Annual Budget Import
Upload the Sage 300 forecast FYE Excel export. All 12 months are parsed automatically. Existing budget rows will be overwritten.