Esc

↑↓ move↵ openIndex · Pagefind
Accounting apps / Financial Reports

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.

On this page

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

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. 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.
  9. 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.
  10. 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

  1. GET /budgetsList GL budgets
  2. POST /budgetsImport a GL budget from CSV
  3. GET /budgets/{id}Show a GL budget with its lines
  4. DELETE /budgets/{id}Delete a GL budget version
  5. POST /budgets/{id}/approveApprove a budget version
  6. PUT /budgets/{id}/cellsSet budget cells
  7. GET /budgets/{id}/gridBudget grid
  8. POST /budgets/{id}/lockLock a budget version
  9. POST /budgets/{id}/returnReturn a budget version
  10. POST /budgets/{id}/spreadSpread a budget line
  11. POST /budgets/{id}/submitSubmit a budget version
  12. GET /budgets/varianceBudget vs actual
  13. POST /budgets/versionsCreate a budget version
  14. POST /cecl_allowancePost the CECL allowance adjustment
  15. POST /current_portion_reclassPost the current-portion reclass
  16. GET /dashboardsMy accounting dashboard
  17. PUT /dashboardsSave my dashboard layout
  18. DELETE /dashboardsReset my dashboard
  19. GET /dashboards/widgetsDashboard widgets and presets
  20. GET /debt_schedulesList debt and lease schedules
  21. POST /debt_schedulesCreate a debt or lease schedule
  22. DELETE /debt_schedules/{id}Deactivate a debt or lease schedule
  23. GET /fpa/cash_forecastCash forecast
  24. GET /fpa/cash_forecast/adjustmentsList manual forecast lines
  25. POST /fpa/cash_forecast/adjustmentsAdd a manual forecast line
  26. POST /fpa/cash_forecast/adjustments/{id}/voidVoid a manual forecast line
  27. GET /fpa/cash_forecast/compareCompare cash scenarios
  28. GET /fpa/cash_forecast/days_to_payCustomer days to pay
  29. GET /fpa/cash_forecast/snapshotsList cash forecast snapshots
  30. POST /fpa/cash_forecast/snapshotsStore a cash forecast snapshot
  31. GET /fpa/cash_forecast/snapshots/{id}Show a cash forecast snapshot
  32. GET /fpa/cash_forecast/snapshots/{id}/accuracyForecast vs actual
  33. GET /fpa/margin_fadeMargin fade portfolio
  34. GET /fpa/margin_fade/{id}Job margin history
  35. POST /fpa/margin_fade/captureCapture projected margins
  36. GET /fpa/scenariosList forecast scenarios
  37. POST /fpa/scenariosCreate a forecast scenario
  38. GET /fpa/scenarios/{id}Show a forecast scenario
  39. DELETE /fpa/scenarios/{id}Delete a forecast scenario
  40. POST /fpa/scenarios/{id}/adjustmentsAdd a scenario adjustment
  41. DELETE /fpa/scenarios/{id}/adjustments/{adjustment_id}Remove a scenario adjustment
  42. GET /fpa/scenarios/compareCompare budget scenarios
  43. GET /fpa/settingsFP&A settings
  44. PATCH /fpa/settingsUpdate FP&A settings
  45. GET /report_definitionsList report definitions
  46. POST /report_definitionsSave a report definition
  47. GET /report_definitions/{id}Show a report definition
  48. PATCH /report_definitions/{id}Update a report definition
  49. DELETE /report_definitions/{id}Delete a report definition
  50. GET /report_definitions/{id}/exportExport a report definition
  51. GET /report_definitions/{id}/runRun a report definition
  52. GET /report_definitions/{id}/versionsReport definition versions
  53. POST /report_definitions/previewPreview an unsaved definition
  54. GET /report_definitions/sourcesReport builder data sources
  55. GET /reportsReport library
  56. GET /reports/{report_key}Run a report
  57. 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

Run it on your own project.

Start a 14-day free trial. Want a say in what ships next? Join the founding program.

Your role (optional)

14-day free trial. Pricing for paid plans isn't set yet. Talk to us. Already have an account? Sign in →

Ask the OS

Reading this page

Ask anything about this page. Answers use what you're reading as context.

Suggested

    AI · may be imperfect · sample data where shown

    Open file