The Invoices by Client with Narration report gives a list of clients and their invoices with narration between selected dates.
How to generate the Invoices by Client with Narration Report
Go to Reports >> Performance Reports >> go to ‘Invoicing’ section beneath ‘Sub-Consultants’ >> click on ‘Invoices by Client with Narration’ and select the required date range.
You can also optionally filter this report by Invoice Office, Client, Job Owner and by charge rate/cost rate.
Now click on the ‘Report Options’ button and select one of the preview options to see a preview of ‘Invoices by Client with Narration’ report.
Understanding the Data
The Invoices by Client with Narration report shows the following information –
- Client Name
- Client Code
- Invoice Number
- Invoice Date
- Invoiced Amount
- Total Value of Time and Cost $ and
- Narration
The Invoice No, Invoice Date and Invoiced Amount for this report comes from Invoice Management page.
From Invoices >> Load Invoices >> click on the required invoice number to go into Invoice Management page >> Invoice No and Invoice Date can be found in the Invoice Details Section.
Invoiced Amount and Narration can be found in the Invoice Lines, Narratives and Amounts section.
The Narration in the report displays the first line of narration from the invoice lines section.
From Invoice Management page >> click on the Report Options button on the top of the page >> select ‘Assigned Time and Disbs’ from the dropdown menu to go into Assigned Time and Disbursements of Invoice page.
The ‘Total Value of Time and Cost $’ for this report comes from the total of ‘Charge Extension’ column in this page if the report is run by charge rate.
If the report is run by cost rate, the information is taken from the timesheets for the invoice.
You can view the timesheets with cost and charge rates for a selected invoice from the ‘Bulk View Timesheet’ report.
For this, first you need to enable the cost rate and charge form Administration >> Settings >> User Control Settings.
Then, from Reports >> Performance Reports >> select ‘Bulk View Timesheet’ from the Timesheet Entries section >> select the dates, client and project.
Now click on the ‘Report Options’ button and select one of the preview options to go to the ‘Bulk View Timesheets’ page.
Filter the report by the invoice number to view the cost rate, charge rate, units, etc.
Abtrac KB# 2147