Financial dashboard
The closed months, against budget. Pick a month to see its detail.
Revenue vs. budget
Fiscal year, by monthRevenue mix
By segmentNet income trend
Fiscal year, by monthAging
At the month's closeGross margin by segment
Target 30%Gross margin trend
Against budgetIncome Statement Summary
| Line item | This month | YTD | YTD budget |
|---|
Monthly analysis
The month's P&L line by line, with YTD, against budget, the prior year or the prior month.
AR aging
AP aging
Report exports
Each report opens in a new tab, ready to print or save as PDF.
Options
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
Every invoice batch by date and segment. The category is what the close wizard uses to prefill segment revenue.
| Date | Label | Category | Start Inv | End Inv | Count | Subtotal | Tax | Total |
|---|
AR analysis
No snapshot yet
AP analysis
No snapshot yet
Close a month
Complete each step in order. All fields can be edited before final save.
Optional — upload Sage files instead
Not needed when Prefill works. An upload overrides the prefilled numbers, so use these as a cross-check or when Sage has no data for the month.
Enter key line items from your Sage 300 P&L export for the month. All figures in USD.
Upload the Segments spreadsheet in Step 1 to auto-fill revenue, labor & burden. Materials fill automatically from Sage (Prefill in Step 1) or from an uploaded Trial Balance. Gross margin is calculated automatically.
| Segment | Revenue ($) | Labor ($) | Burden ($) | Materialsfrom Sage | Gross Margin $ | GM % |
|---|---|---|---|---|---|---|
| Totals |
Enter aging bucket totals from your Sage 300 aging reports.
Review all entries before saving. Use the Edit buttons to go back and make changes.
Dashboard admin
Import historical data and the annual budget, or reopen a closed month.
Database status
Closed months
Reopening deletes the saved close so it can be closed again through the wizard. Sage data is never touched.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.