Financial Reports
A 48-report library: statements, consolidated statements with NCI, cash flow, aging, job profitability, WIP, retainage, payroll, flux and control reports, exportable to CSV, XLSX and PDF.
Financial Reports is the report library for company books. It covers financial statements, consolidated statements, subledger and job reports, and control and audit reports, plus budgets, scenarios, the cash forecast, margin fade, a report builder and the period-end schedules that feed the statements. Open it from the company app launcher under Accounting > Financial Reports; it appears when your accounting access includes it.
- Who uses it
- Controllers, owners, accountants and auditors.
- When
- Month end, quarter end and on request.
- What it holds
- Report definitions and saved custom reports, budget versions and scenarios, cash forecast snapshots and job margin captures, debt and lease maturity schedules and the CECL policy.
Key workflow
- Run a statement. Balance sheet; income statement comparative or by month, quarter, entity, department or job; indirect cash flow; and equity roll-forward. Entity statements include Eliminations and Consolidated columns. The combined cash flow and equity roll-forward translate entities with different functional currencies instead of refusing them.
- Run consolidated statements. Once ownership is recorded under Fiscal Periods, the Consolidation group adds a consolidated balance sheet with equity split between the parent and the noncontrolling interest; a consolidated income statement showing net income, the part attributable to NCI and to the parent, then OCI and comprehensive income; a consolidated statement of cash flows (indirect method, intercompany flows eliminated, acquisitions net of cash acquired, NCI transactions in financing, and the effect of exchange rates on cash) and consolidated changes in equity with parent, AOCI and NCI columns, each tied to the consolidated balance sheet; a consolidation worksheet with each member, Eliminations, Consolidation adjustments and Consolidated columns, checked to net to zero; NCI and equity-method roll-forwards; and the intercompany reconciliation by entity pair. Without ownership rows, consolidated totals equal the combined statements.
- Run job and subledger reports. AR and AP aging as of a date, check register, cash requirements, job cost status and detail, committed cost, retainage by job, job profitability, WIP schedule, completed contracts, backlog roll-forward, sales tax liability and payroll register.
- Run control reports. Subledger reconciliation, integrity check, manual journal review, segregation-of-duties conflicts, access and SoD conflicts, vendor changes, PII reveals, close progress, reconciliation status, flux analysis (every variance with the threshold that applied, its explanation, preparer and reviewer) and the audit log.
- Budget and compare. Create a budget version blank, from another version (optionally through a scenario) or from a year’s posted actuals, or import it from CSV. Edit the grid by account, entity, department, job and cost code, and spread amounts evenly, by the prior year’s monthly pattern or by custom percents. Submit it; a user who did not edit it approves it, and an approved version can be locked. Budget vs actual and the income statement’s budget column use the approved version.
- Post period-end schedules. Post the CECL allowance (ASC 326-20) from aged AR, retainage receivable and contract assets, and the current-portion reclass of long-term debt and lease liabilities.
- Forecast cash and plan scenarios. The cash forecast covers 13 weeks or 12 months from the book balance of your bank accounts. Inflows come from open AR timed by each customer’s days to pay, retainage released after job completion and unbilled contract value; outflows from open AP, commitments, payroll, debt and leases; and audited manual lines with a reason. Every line names its source document and how its date and amount were derived. Scenarios overlay date shifts, percents and amounts on the budget or the forecast without changing either. Store a snapshot to compare it with what actually happened.
- Watch margin fade. Capture each job’s projected margin at a period end (from its WIP snapshot, else its forecast). The portfolio shows fade since the previous capture and since the first one, and flags a job once each time the change crosses the threshold in your settings.
- Build your own reports. The report builder saves definitions on GL detail, trial balance, cash, AP and AR open items, job cost and any library report, with a live preview, prior period, prior year or budget comparisons and versions. Role dashboards start from a preset layout and can be rearranged.
- Export. Export any report to CSV, XLSX or PDF. Exports are rate-limited per user and recorded in the audit log.
Controls
- Reports read posted data in the caller’s entity scope.
- Exports are audited.
- Anyone who created, imported, edited or submitted a budget version cannot approve it, and approved and locked versions refuse edits, enforced again by database triggers.
- Cash forecast snapshots and margin captures are append-only and hashed; manual forecast lines are voided with a reason, never edited.
Current boundaries
For the full procedure, exceptions and examples, read the Financial reports workflow guide.
API operations
57 operations · 29 read · 28 write · base path /rest/v1.0/companies/{company_id}/accounting
- GET
/budgetsList GL budgets - POST
/budgetsImport a GL budget from CSV - GET
/budgets/{id}Show a GL budget with its lines - DELETE
/budgets/{id}Delete a GL budget version - POST
/budgets/{id}/approveApprove a budget version - PUT
/budgets/{id}/cellsSet budget cells - GET
/budgets/{id}/gridBudget grid - POST
/budgets/{id}/lockLock a budget version - POST
/budgets/{id}/returnReturn a budget version - POST
/budgets/{id}/spreadSpread a budget line - POST
/budgets/{id}/submitSubmit a budget version - GET
/budgets/varianceBudget vs actual - POST
/budgets/versionsCreate a budget version - POST
/cecl_allowancePost the CECL allowance adjustment - POST
/current_portion_reclassPost the current-portion reclass - GET
/dashboardsMy accounting dashboard - PUT
/dashboardsSave my dashboard layout - DELETE
/dashboardsReset my dashboard - GET
/dashboards/widgetsDashboard widgets and presets - GET
/debt_schedulesList debt and lease schedules - POST
/debt_schedulesCreate a debt or lease schedule - DELETE
/debt_schedules/{id}Deactivate a debt or lease schedule - GET
/fpa/cash_forecastCash forecast - GET
/fpa/cash_forecast/adjustmentsList manual forecast lines - POST
/fpa/cash_forecast/adjustmentsAdd a manual forecast line - POST
/fpa/cash_forecast/adjustments/{id}/voidVoid a manual forecast line - GET
/fpa/cash_forecast/compareCompare cash scenarios - GET
/fpa/cash_forecast/days_to_payCustomer days to pay - GET
/fpa/cash_forecast/snapshotsList cash forecast snapshots - POST
/fpa/cash_forecast/snapshotsStore a cash forecast snapshot - GET
/fpa/cash_forecast/snapshots/{id}Show a cash forecast snapshot - GET
/fpa/cash_forecast/snapshots/{id}/accuracyForecast vs actual - GET
/fpa/margin_fadeMargin fade portfolio - GET
/fpa/margin_fade/{id}Job margin history - POST
/fpa/margin_fade/captureCapture projected margins - GET
/fpa/scenariosList forecast scenarios - POST
/fpa/scenariosCreate a forecast scenario - GET
/fpa/scenarios/{id}Show a forecast scenario - DELETE
/fpa/scenarios/{id}Delete a forecast scenario - POST
/fpa/scenarios/{id}/adjustmentsAdd a scenario adjustment - DELETE
/fpa/scenarios/{id}/adjustments/{adjustment_id}Remove a scenario adjustment - GET
/fpa/scenarios/compareCompare budget scenarios - GET
/fpa/settingsFP&A settings - PATCH
/fpa/settingsUpdate FP&A settings - GET
/report_definitionsList report definitions - POST
/report_definitionsSave a report definition - GET
/report_definitions/{id}Show a report definition - PATCH
/report_definitions/{id}Update a report definition - DELETE
/report_definitions/{id}Delete a report definition - GET
/report_definitions/{id}/exportExport a report definition - GET
/report_definitions/{id}/runRun a report definition - GET
/report_definitions/{id}/versionsReport definition versions - POST
/report_definitions/previewPreview an unsaved definition - GET
/report_definitions/sourcesReport builder data sources - GET
/reportsReport library - GET
/reports/{report_key}Run a report - GET
/reports/{report_key}/exportExport a report
Parameters, request and response fields, errors and a generated example for each operation are in the REST reference for this app. Read scopes, step-up and permissions in the Accounting API guide.
Keep exploring
Related across os.construction
- DocsFinancial reportsReview company financial statements and understand reconciliation coverage.
- DocsAccounting module and appsExplore company accounting apps, their business value, and the workflows connecting job activity to company books.
- BlogHow to read a contractor's financial statements: the lines a surety, lender or owner's rep checks firstA contractor's financial statements are read for one thing: can this company finish its work and pay its bills? Check the CPA's report level and date, then working capital, the over and under billings, retainage, the gross margin trend, leverage and the notes, and tie the balance sheet to the WIP schedule. Here is the order, with a worked balance sheet.
- BlogHow to close the month in construction accounting: a step list from cutoff to lockA construction month-end close gets every cost and every billing into the right month, proves cash and the subledgers against the ledger, updates the WIP schedule from current cost-to-complete, has someone else review it, and then locks the period. Here is the step list, an example close calendar and a worked example of what one late invoice does to WIP.
- GlossaryGeneral ledgerThe complete record of every financial transaction a company posts, organized by account, from which the trial balance and financial statements are built.
- GlossaryTrial balanceA list of every account's debit or credit balance at a date; total debits equal total credits.
Was this helpful?
Run it on your own project.
Start a 14-day free trial. Want a say in what ships next? Join the founding program.
14-day free trial. Pricing for paid plans isn't set yet. Talk to us. Already have an account? Sign in →