Accounting reports are essentially the bridge that connects your daily site work to your actual bank balance, making sure your bookkeeper doesn't have a meltdown come tax time. They act as a translator, taking every dollar you've earned or spent and slotting it into the right buckets—like labor, materials, or overhead—so your profit and loss statement actually makes sense. By keeping an eye on these, you can spot if a project isn't mapped to the right account or if your sync with Xero has hit a snag, ensuring that the numbers your accountant sees match the reality of what’s happening on the ground.
TABLE OF CONTENTS
- Accounting COGS in Period Report Pivot Report
- Revenue by GL Account in Period Pivot Report
- Revenue Forecast by Staff Pivot Report
Accounting COGS in Period Report Pivot Report
This report summarises Cost of Goods Sold (COGS) for projects completed in the selected period.
It gives you a Profit & Loss style breakdown of your COGS.
⚠ Important Checkbox
There is a filter called:
“Only for Projects Completed in Period”
When this is ticked:
The report will only include projects that were completed within the selected date range.
It ignores projects still in progress.
When unticked:
It can include data outside that completion constraint (depending on how your dates are filtered).
So if you're doing period-end financial reporting, this checkbox matters.
| Field | Notes / Expected Values | Description |
|---|---|---|
| CLIENT | text | transaction client |
| COMPLETEDDATE | DD/MM/YYYY | transaction completion date |
| DATE | DD/MM/YYYY | stock usage - usage date timesheets - start date purchases - supplier invoice date |
| DAY | numerical value | date day |
| DAYOFWEEK | text | date day name |
| ITEM | text | SKU / name for products / purchases Task for timesheets |
| MONTH | text | date month |
| QTR | month-month abbreviated | date quarter |
| SOURCE | numerical value | source transaction |
| YEAR | numerical value | date year |
| TOTAL (sum) | dollar value | cost value of line |
| GLACCOUNT | numerical value | related GL account |
Revenue by GL Account in Period Pivot Report
This report focuses on Revenue, grouped by GL Account, again tied to projects completed in the selected period.
Same financial style layout — but revenue side instead of cost side. Revenue can appear based purely on date filters, regardless of project completion.
⚠ Important Checkbox
Again, the “Only for Projects Completed in Period” checkbox applies here.
| Field | Notes / Expected Values | Description |
|---|---|---|
| CLIENT | text | billing client |
| COMPLETEDDATE | DD/MM/YYYY | transaction completion date |
| DATE | DD/MM/YYYY | invoice / credit issue date |
| DAY | numerical value | issue date day |
| DAYOFWEEK | text | issue date day name |
| ITEM | text | SKU / name for products name for task |
| MONTH | text | issue date month |
| QTR | month-month abbreviated | issue date quarter |
| SOURCE | numerical value | source transaction number |
| SOURCECREDITNOTE | numerical value | source credit note number |
| SOURCEINVOICE | numerical value | source invoice number |
| YEAR | numerical value | issue date year |
| TOTAL (sum) | dollar value | total revenue value |
| GLACCOUNT | numerical value | related general ledger account code |
Revenue Forecast by Staff Pivot Report
This one shifts from historical reporting to forecasting by staff member.
This is less about posted accounting entries and more about planned or forecasted financial performance.
| Field | Notes / Expected Values | Description |
|---|---|---|
| PROJECT | text | project number / project name |
| QUOTE | text | quote number / quote name |
| STAFF | text | owner / project manager |
| STATUS | Open, Completed, Invoiced, etc | current workflow status of transaction |
| REVENUE (sum) | dollar value | total estimated sales value |
| EXPENSE (sum) | dollar value | total estimated costs |
| NET (sum) | dollar value | total estimated profit |
| YEAR | numerical value | year of forecast dollar value fields |
| MONTH | numerical value | month numerical value (01 for January) of forecast dollar value fields |
| CLIENT | text | project / quote client name |
| SOURCE | text | project / quote number |
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article