Skip to main content
Checked against the product · 2026-10-05

The Reports Library — Controller Guide

Every downloadable report Arcvue produces, in one place: Accounting → Reports. Categories on the left, the reports in that category on the right, and one period picker governing the lot.

Who uses it: a controller pulling a workbook for a close, an auditor request, or a customer.

Part 1 — The period picker, and why it opens where it does​

The control is labeled Reporting period. It sits at the top right, showing the month you are on and a badge for that month's state.

The picker defaults to the most recently CLOSED period — never to today's month, and never to an open one. That is the whole design: a report pulled from an open month is provisional, and a workbook that looks final is the one thing this page must not hand you by accident.

Each period carries its state:

Closedthe books are closed for that month
Lockedclosed and locked against further posting
Openstill accepting entries

If you select an open period the page says so above the cards. Read that line before you send anything onward — the numbers are real, they are simply not final, and nothing in the downloaded file will remind you.

The period travels in the address. It rides in the URL as ?period=YYYY-MM, so a link you paste into a ticket opens on the month you were looking at rather than on the recipient's default.

You can see every month's state before you choose one​

The state badge is on every row of the open list, not only on the month you are currently viewing. Open the picker and the whole period list is in front of you with Closed, Locked or Open beside each month — so finding the most recent closed month is a glance, not a search.

That is the reason this is a custom list rather than a plain dropdown: a plain dropdown can show you the month names and nothing else, and which months are closed is half of the decision you are making.

It works from the keyboard​

The picker is fully operable without a mouse, which matters on a page a controller works through quickly:

keywhat it does
Up / Downmove through the months
Home / Endjump to the newest or oldest
Enter / Spacechoose the month you are on
Escapeclose without choosing, and put focus back on the picker
Tableave the list

Opening the list lands you on the month you are already viewing, not at the top — so a step back one month is one key, not a hunt.

If the picker is not there, there are no periods to pick​

On a page where no accounting periods exist yet, the picker does not render at all — it is absent rather than present-and-empty.

So a missing period picker is a statement about your data, not a missing FEATURE. It means no periods have been created for this tenant yet. A control that opened onto an empty list would invite the click and then refuse it, with nothing on screen saying why.

The same picker is on the Job Status Report​

The Job Status Report — the per-contract P&L — uses this same control, so the month you choose there behaves exactly as it does here, badge and all.

That report previously had no month control. Its period could only be set by editing the address, and with nothing in the address it fell back to the current calendar month, which is always open. If you remember having to type a month into the URL to see a closed period, that is what this replaced.

Part 2 — What each card gives you​

Every report card carries its name, a one-line description, and two controls:

  • Preview opens the live page behind the report, so you stay in the product rather than downloading something to look at it.
  • Download produces the workbook.

A report with no export yet keeps its Download button visible but disabled, and the tooltip says why. That is deliberate — a missing button would read as a missing report.

Custom reports​

Custom Reports in the page header opens the library of reports built with Arcvue AI, narrowed to the ones that read an accounting measure — payables, receivables, the general ledger. Each is a saved question, run fresh against live data as you when you open it; the Custom Reports guide covers sharing, exporting and deleting them. The link appears for program managers and above; an administrator grants Custom Reports under Admin → Permissions.

Part 3 — The catalog​

Financial Statements​

P&L, Balance Sheet, Cash Flow, Trial Balance.

ReportWhat it holds
P&L by MonthRevenue, costs, indirect pools and net income for the selected period.
P&L by ContractMargin contribution per active contract.
Balance SheetAssets, liabilities and equity as of period end.
Cash Flow StatementOperating, investing, financing — net change in cash.
General LedgerThe ledger itself, exportable as a workbook or CSV.
Trial BalancePeriod-level debits and credits per account, with the balanced check.

Cost & Indirect Rates​

Pool balances, rate trends, provisional versus actual.

ReportWhat it holds
Indirect Rate SummaryFringe, Overhead and G&A rates for the selected period.
Pool Balance DetailPer-pool absorbed costs against allocated base.
Rate Trend (12 months)Indirect rate movement period over period.
Provisional vs ActualThe variance between your provisional rates and actuals.

Contract Performance​

Revenue, cost, margin and burn by contract.

ReportWhat it holds
Job Status Report (JSR)Per-contract revenue, cost, margin, burn and EAC, in DCAA standard format.
Project Status Report (PSR)The same picture for a single contract, formatted as a CDRL deliverable for government submission.
Revenue by ContractRecognized revenue per contract, year to date.
Cost by ContractDirect and indirect cost rollup per contract.
Margin by ContractGross margin and contribution margin per contract.
Contract Burn RateFunded value remaining and projected exhaustion.

The JSR and the PSR are the same numbers for two audiences — see the Job Status Report guide for how to read either.

Compliance​

Unallowable costs, DCAA exports, aging.

ReportWhat it holds
Unallowable Cost SummaryFAR Part 31 unallowable costs by account and period.
DCAA Audit ExportA risk-scored audit package: ICS, timesheet sample, journal-entry register.
Open AR AgingOutstanding invoices by customer and bucket — 0-30, 31-60, 61-90, 90+.
Open AP AgingOpen vendor payables by counterparty and age.
GSA TDR Sales ReportTransactional Data Reporting per GSA schedule: the FAS SRP upload file, the invoices behind it, and the filing record. Preview opens its own page, where the schedule and the period are chosen. It carries the month picked here, and the page opens on that month when it is one of the schedule's monthly periods; otherwise it opens where it would on its own, on the period GSA is waiting on if there is one. The card's Download stays disabled: the upload file and the support workbook download from that page. See the GSA TDR Sales Report guide.

Payroll​

Period summaries, pay code distribution, SCA split.

ReportWhat it holds
Time DetailTimecard lines by employee, contract and charge date.
Payroll Summary by PeriodPay run totals, posted against suspense, by company.
Pay Code DistributionThe breakdown by pay code across the year.
SCA vs Non-SCA SplitService Contract Act labor by contract and employee.
PTO and Sick Leave BalancesEvery employee's balance in each leave plan family, as of a date.
warning

The period picker does not slice the payroll run exports, and that is correct. A pay period straddles month ends, so Payroll Summary by Period and Pay Code Distribution export your runs with their own dates in the workbook rather than being cut at a month boundary.

Their filenames deliberately carry no month — a file named for a period whose data does not honor that period is worse than one that does not claim it. Read the dates inside the workbook, not the name.

Time Detail is the exception: it does follow the selected period, taking the whole month.

Time Detail exists because the general ledger summarizes to document grain. That is the correct behavior for a ledger — and it leaves timecard line detail with nowhere to land. This is where it lands.

PTO and Sick Leave Balances​

This is the only card with a third button. Alongside Preview and Download it carries Incl. departed, and the two downloads answer different questions:

  • Download gives you the current roster — the file you correct balances against.
  • Incl. departed adds people who have left, each with their termination date. A balance owed at departure belongs to someone no longer on the roster, so a payout or a dispute needs this one.

Preview opens the Leave Plans page on its Balances table: the same roster as the file, with the same As of date and the departed-staff toggle, so the report can be read in the system without downloading it.

warning

An empty hours cell means the person holds no plan in that family — it is not a zero balance. Someone with a PTO plan and no sick plan shows hours in one column and nothing in the other. A 0.00 there would say they had spent leave they were never granted. The sheet repeats this in its own header.

The period picker does not slice this report. A leave balance is point-in-time, like a balance sheet, so it is taken as of a date and the filename carries that date. The server resolves the date from your company's own clock rather than the browser's.

Balances are derived from the leave ledger every time, never stored. A correction booked with an earlier effective date is already reflected the next time you take this report — you do not need to re-run anything.

Part 4 — When something looks wrong​

What you seeWhat it usually is
The numbers are not finalThe selected period is Open — the line above the cards says so.
Download is grayed outThat report has no export endpoint yet; the tooltip says as much.
A payroll workbook does not match the monthCorrect — payroll runs are not sliced by period. Read the dates in the file.
A shared link opened on the wrong monthThe link was copied without its ?period=; open the period and copy the address bar.
  • Job Status Report (JSR / PSR) — how to read the contract performance pair.
  • Contract Register — where the contract data these reports read comes from.
  • Cost Pools and Indirect Rates — what sits behind the rate reports.