---
title: "Report 186 - Expenditures/Invoicing Summary by Dimension"
canonical: "https://technology.bytangram.com/space/TGKB/952205350/Report%20186%20-%20Expenditures%2FInvoicing%20Summary%20by%20Dimension"
format: markdown
---
Report 186 provides a comprehensive analysis of burn rates compared to estimates and schedules, organised by activity and summed by dimension. This report is instrumental in monitoring the overall health of activities within a specified timeframe.

It is particularly beneficial for retainer reporting, as the detailed breakdown of activities enables you to identify what is included in the approved price quote (the periodic retainer). You can easily compare this against what has been scheduled, utilised, and invoiced. This allows for an accurate assessment of what is being quoted and invoiced to the client versus the actual status of the project or retainer.

> ✅ **Filter Tip:** This report brings data in based upon the jobs filtered within the jobs list. Always check your job filter before filtering further when running the report.

> ✅ **Retainer Tip: **Set up a price quote per period you wish to track the retainer against. If you wish to run a monthly retainer report, then set up a quote per month on the retainer billing job. Finally, ensure the date within each PQ header reflects the month you will report on it.

| **ON THIS PAGE YOU WILL FIND:** |
| --- |
| > Macro (toc) |

---

## NAVIGATION

With your **jobs filter **set up to show the jobs you want to report on, in the **jobs** module:

- Go to the **reports** icon > select **expenditures/invoicing summary by dimension (186) **from the drop down

![image-20250519-222414.png](media://12f254af-16c5-4c3f-9260-5de25280c8aa)


---

## SET REPORT CRITERIA

- **Summarise chosen jobs by** - select the dimension you want to report on e.g. Client, Project Manager, Account Manager etc.
- Select your **from **and **to dates **-** **define the reporting period using the date range selectors


![image-20250520-054331.png](media://5ce64bc2-d1b9-4d14-931f-84d4619cda96)


---

## VIEWING THE REPORT

- Go to the icons in the top right and select either:
  - View as a PDF
  - Export as an email
  - Export as a PDF, Excel, CSV file


![image-20250520-054426.png](media://e7366489-a0a2-4103-b1c1-e993e197d48a)


![image-20250519-222919.png](media://da1a04bf-9d93-495c-ab93-e51f95616744)

| **NUMBER** | **COLUMN NAME** | **DETAILS** |
| --- | --- | --- |
| **1** | **Activity** | Any activity used within the dimension you are grouping by. Activities “used” includes those that are scheduled, quoted on, timesheets, purchases, PO, expense, material and/or invoices |
| **2** | **Schedule **  
(Budget) | Value of scheduled time within the date range |
| **3** | **Quote **  
(Budget) | Sums the value of internally or externally approved price quotes, where the PQ date (in the PQ header) lies within the date range |
| **4** | **Hours **  
(Budget) | Sums the hours of internally or externally approved price quotes, where the PQ date (in the PQ header) lies within the date range |
| **5** | **Hours**  
(Expenditures) | Number of hours time-sheeted within the date range |
| **6** | **Hours Value**  
(Expenditures) | Value of hours time-sheeted within the date range |
| **7** | **Materials**  
(Expenditures) | Value of materials entered within the date range |
| **8** | **Purchases**  
(Expenditures) | Value of approved creditor invoices & expenses entered (cost + mark-up), within the date range |
| **9** | **PO**  
(Expenditures) | Value of approved purchase orders, less partially settled values, within the date range |
| **10** | **Total**  
(Expenditures) | Sum of all expenditure columns |
| **11** | **Draft**  
(Invoicing) | Sum of invoice value where invoice status is **not finalised** |
| **12** | **Finalised**  
(Invoicing) | Sum of invoice value where invoice status is **finalised** |
| **13** | **Total**  
(Invoicing) | Sum of (12) finalised and (11) non-finalised invoices |
| **14** | **Balance**  
(Invoicing) | (13) Total Invoiced less (10) Total Expenditure |
| **15** | **Total** | Column totals |
| **16** | **NR** | Net revenue by column |
| **17** | **NR%** | Net revenue percentage by column |

---

### Related articles

> Macro (contentbylabel)