Spending to Budget Report
To run the Spending to Budget report:
- ClickReports > Report Listin the left navigation
- ClickSpending to BudgetunderBudget/Accruals Reports.
- Specify the report criteria.
- ClickRunin the toolbar.
note
After you run the report, the
REPORT CRITERIA
collapsible section is minimized to allow you to view your report results. To change any of the reporting criteria and generate a new report, click the heading of the REPORT CRITERIA
collapsible section to expand it.Report Details and Specifications
The following table includes details and specifications regarding the Spending to Budget report:
Data | Source of Data | Comments |
|---|---|---|
Matter Names | All matters entered by Company users for which a budget was provided | Does not include matters where:
|
Actual Spending | Invoices submitted by law firms | Includes:
If more than one firm is working on the same matter, the actual spending amount for all firms is shown only for the lead firm in the matter. |
Budget | Budget information entered by law firm | Includes the full budget for the month of the start date through the end date of the report (for example, if the report dates are 11/15/2019 through 12/15/2019, the budget will include the cumulative budget for the months of November and December of 2019. If more than one firm is working on the same matter, the actual budget amount is shown only for the lead firm in the matter. |
Actual/Budget% | Invoices submitted by law firms and budget information entered by law firm | This amount is the ratio of the actual spending divided by the budget. |
Last Invoice Billing Period End Date | Invoices submitted by law firms | This field includes the billing end date from the invoice with the most recent billing period. |
Export Report Results to a .csv file
You can export the report results to a .csv file, which you can then view and manipulate in a spreadsheet program, such as Microsoft Excel.
To export the data:
- From the report results, click the three small dots icon on the toolbar then selectExport.
- If necessary, select the check boxes for the information to include in the header and footer.
- SelectCSV formatas the type of formatted file you want to export the report to. The Save As window displays so you can save the file.
Data Export Specifications
The following fields are displayed as columns in the exported Spending to Budget report:
- Matter Name (Short)
- Substantive Law
- Actual Spending
- Budget
- Actual/Budget %
- Last Invoice (Amount)
- Last Invoice (Billing Period End Date)
- Lead Outside Counsel
- Firm