The Reconciliation Report helps you understand what work was carried into a period, what was done during the period, what was invoiced, and what’s still left unbilled — all in one place.
If you’ve ever wondered “Where did our WIP go?” or “Why didn’t this invoice show up in this month’s totals?” — this report was built for you.
What does the Reconciliation Report show?
The Reconciliation Report tracks Work-in-Progress (WIP) over time using the actual service date of billable items — not the invoice date.
Each row in the report shows:
- Work that was carried forward (Beginning WIP)
- Work produced during the report period
- The subtotal before invoicing
- What was invoiced during the report period
- The actual amount billed
What is still left over as Ending WIP
Key Columns:
| Column | Description |
| Beginning WIP ($/hrs) | Uninvoiced work performed before the report start date. |
| Produced WIP ($/hrs) | Work performed during the report period that hasn't been invoice yet. |
| Subtotal ($) | Beginning + Produced — this is your total unbilled work before invoicing. |
| Invoiced WIP ($) | Billable items invoiced during the period, based on their service date. |
| Invoiced Amount ($) | What was actually billed, including any write-ups or write-downs. |
| Ending WIP ($) | Remaining WIP that hasn’t been invoiced yet. |
Only Hourly items contribute to Hours columns. Fixed and Progress items appear only in dollar amounts.
What makes this report unique?
This report follows the work, not the invoice.
Most billing reports in Firm360 group work based on the invoice date. But the Reconciliation Report focuses on the billable item’s service date — when the work was done.
This means:
- You may see amounts from past or future invoices here.
- The “Invoiced Amount” column may not match totals in invoice-based reports.
- It’s great for reconciling what’s been earned vs. what’s been billed — regardless of invoice timing.
Example:
An invoice dated July 1 may include billable items from May, June, and even August. In this report:
- The May and June items will show as Invoiced WIP in their respective months.
- The August item (future-dated) will not show up until that period.
Things to Keep in Mind:
| Live Data | The report always reflects current data. If someone edits a billable item after the period ends, prior values may change. If you would like to preserve snapshots, you will need to export the reports monthly. |
| Approval Not Required | Time entries appear whether or not they are marked approved. |
| No Write-Up Breakdown | Write-ups and write-downs are reflected in Invoiced Amount but not broken out separately. |
| No Invoice Count | The report tracks items billed, not how many invoices were sent. |
| No Data Validation | Items with missing users, zero/negative hours, or rate issues are included “as-is.” |
Frequently Asked Questions:
Why doesn’t the Invoiced Amount match other billing reports?
Because this report is based on service date, not invoice date. The same invoice might be spread across multiple months in this report.
Why is Invoiced WIP different from Invoiced Amount?
Invoiced WIP uses the standard rate and quantity. Invoiced Amount reflects what was actually billed (after overrides or adjustments).
Can Ending WIP be negative?
Yes — especially with progress billing or pre-billing scenarios. If you bill more than the subtotal, it can result in a negative Ending WIP.
Can I use this report to “close the books”?
Not directly. Since it recalculates live, values may change if items are edited. We recommend exporting a copy at month-end for your records.
Related to