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:
| Closed | the books are closed for that month |
| Locked | closed and locked against further posting |
| Open | still 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:
| key | what it does |
|---|---|
| Up / Down | move through the months |
| Home / End | jump to the newest or oldest |
| Enter / Space | choose the month you are on |
| Escape | close without choosing, and put focus back on the picker |
| Tab | leave 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.
| Report | What it holds |
|---|---|
| P&L by Month | Revenue, costs, indirect pools and net income for the selected period. |
| P&L by Contract | Margin contribution per active contract. |
| Balance Sheet | Assets, liabilities and equity as of period end. |
| Cash Flow Statement | Operating, investing, financing — net change in cash. |
| General Ledger | The ledger itself, exportable as a workbook or CSV. |
| Trial Balance | Period-level debits and credits per account, with the balanced check. |
Cost & Indirect Rates
Pool balances, rate trends, provisional versus actual.
| Report | What it holds |
|---|---|
| Indirect Rate Summary | Fringe, Overhead and G&A rates for the selected period. |
| Pool Balance Detail | Per-pool absorbed costs against allocated base. |
| Rate Trend (12 months) | Indirect rate movement period over period. |
| Provisional vs Actual | The variance between your provisional rates and actuals. |
Contract Performance
Revenue, cost, margin and burn by contract.
| Report | What 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 Contract | Recognized revenue per contract, year to date. |
| Cost by Contract | Direct and indirect cost rollup per contract. |
| Margin by Contract | Gross margin and contribution margin per contract. |
| Contract Burn Rate | Funded 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.
| Report | What it holds |
|---|---|
| Unallowable Cost Summary | FAR Part 31 unallowable costs by account and period. |
| DCAA Audit Export | A risk-scored audit package: ICS, timesheet sample, journal-entry register. |
| Open AR Aging | Outstanding invoices by customer and bucket — 0-30, 31-60, 61-90, 90+. |
| Open AP Aging | Open vendor payables by counterparty and age. |
| GSA TDR Sales Report | Transactional 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.
| Report | What it holds |
|---|---|
| Time Detail | Timecard lines by employee, contract and charge date. |
| Payroll Summary by Period | Pay run totals, posted against suspense, by company. |
| Pay Code Distribution | The breakdown by pay code across the year. |
| SCA vs Non-SCA Split | Service Contract Act labor by contract and employee. |
| PTO and Sick Leave Balances | Every employee's balance in each leave plan family, as of a date. |
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.
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 see | What it usually is |
|---|---|
| The numbers are not final | The selected period is Open — the line above the cards says so. |
| Download is grayed out | That report has no export endpoint yet; the tooltip says as much. |
| A payroll workbook does not match the month | Correct — payroll runs are not sliced by period. Read the dates in the file. |
| A shared link opened on the wrong month | The link was copied without its ?period=; open the period and copy the address bar. |
Related
- 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.