 |
 |
|
|
The Staff Billing Analysis is a Time Ledger report that displays recoveries at staff level.
To access reports ensure that the staff allowances 'can see WIP valuations of Time' and 'see Cost Valuations of Time' are enabled.
To produce the Staff Billing Analysis report complete the options, order, selection and columns tabs in sequence. (See report format topic).
To access the Staff Billing Analysis report:
Enter the Time Ledger.
From the menu select Reports.
Click Staff reports, a sub menu displays.
Click Billing Analysis.
The options screen allows you to define the system constraints for the Staff Billing Analysis report.
The following options are available:
Select one of the following options to set the timescale the report covers:
Current Periods - click to include invoices or write offs made between the earliest and latest current periods.
Last periods up to - clicking the option next to Last periods up to the fields to the right become available. Here enter the number of periods (prior to the most current period) that you wish to display.
For example, if the number 2 is entered into the field, invoice or write offs, postings made into the current period and its preceding period will be displayed.
The minimum number of periods to be covered is 2.
Time Periods From - if selected the fields 'from' and 'to' become available. Here you can enter the start and end of a period range that the report is to be run for.
Dates from - if selected the fields 'from' and 'to' become available. Enter the start and end of the date range the report is to be run for.
The calculation of recovery percentages options relates to how recovery percentages are reported on.
There are two methods available:
Amount billed less amount written out divided by amount billed - select this option to show the percentage of an invoice that was recovered. For example, a client is billed £1200, £900 is written out giving a £300 recovery. Using this formula, £1200 less £900 gives a recovery value of £300. £300 divided by £1200 produces a 25% over recovery. This formula shows that 25% of an invoice for £1200 (£300) has been over recovered.
Amount billed divided by amount written out - select this option to show the percentage of an invoice that was written out. For example, a client is billed £1200, and £900 is written out. £1200 divided by £900 gives a 133% recovery. This formula shows that the practice has invoiced 133% more than the WIP costs removed with the invoice, and so a 33% over recovery (profit) has been made.
To display recovery Percentages ensure the column 'recovery as percentage' is selected.
Below are some further options for exclusions on the report:
Exclude any line where all figures are zero - select this option to exclude staff without invoice or write off set.
Include postings not made against any staff member - select this option to include postings not made against a staff member.
The following postings can be made to not affect staff members; general adjustments, general expenses, opening WIP balances.
Include any carried forwards under/over recoveries in matched postings - select this option to include carried forwards within the recovery figures.
Click here for details on carried forwards.
The Level of detail option relates to the first sort criteria that is selected under the Order tab.
On the Staff Billing Analysis report there are four options:
One line per staff member - each staff that satisfies the Selection criteria will be displayed on a separate line on the report.
Show actual Instructions - each staff that satisfies the Selection criteria will be included in the report. The information will be presented will print the individual instructions (invoices, , write offs)by the first sort criteria of the Order tab.
Show Instructions and postings - each staff member that satisfies the Selection criteria will be included in the report. The information will be presented will print the individual instructions (invoices and write offs), grouped with the postings (timesheets, corrections) that they have been matched to. This will sort by the first sort criteria of the Order tab.
Subtotals only - every staff member that satisfies the Selection criteria will be included in the report. The information will be subtotalled by the first sort criteria selected under the Order tab. For example, if the first sort criteria selected was Partner. One line of totals would then be printed for each of the partners registered on the system.
The include option is used to select the type of posting that will appear on the client billing analysis.
The following options are available:
Final bills - select to include invoices posted as 'final' on the report.
If a final bill has finalised any interim invoices, the value of the interim finalisation will be included.
Interim bills - select to include invoices posted as 'interim' on the report
The staff billing analysis report will include the interim bill finalisation postings within the billed column. This will appear when non-staff postings have been matched against a credit note, and the report has been run to include non-staff postings (Options tab).
Write offs - select to include 'WIP write offs' on the report.
Credit Notes - the credit note option is not available for the staff billing analysis report.
The staff billing analysis report will include the credit note write back postings within the write out column. This will appear when non-staff postings have been matched against a credit note, and the report has been run to include non-staff postings (Options tab).
The credit notes option is not available for the staff billing analysis report. The staff billing analysis report is staff based and allocation the credit note value will be arbitrary.
To continue the reporting help topic click on the Order tab at the top of the screen, and here for the topic on using the Order tab settings.
Staff reference
Staff Billing Analysis Reference
Reporting Overview
Reporting Format
Recommended reports
Memorised reports