Invoicing Worksheet Report
This section describes the fields and descriptions on the Invoicing Worksheet report.
The Invoicing Worksheet report displays various balance figures related to invoicing for each customer and the jobs associated to that customer. In addition, it displays a breakdown of the hours entered into tasks, with summation sections for the tasks and employees involved. It also displays a monthly distribution of the entered billing prices compared to the invoiced; thereby giving a realization divided by month.
The report is often printed so that auditors or other authorities can make their manual comments. Therefore, a dedicated column is reserved for that in the report.
All figures are displayed in company currency.
The report groups the figures by company currency.
There is no drilling in the report.
Summary Tab
The first tab displays invoicing and budgeted figures by customers and the job that is associated with the customer. If there are several jobs for the same customer, the customer is repeated for each of these jobs.
| Column | Description |
| Customer, No. | This column displays the customer's number. |
| Customer, Name | This column displays the customer's name. |
| Job, No. | This column displays the job's number. |
| Job, Name | This column displays the job's name |
| Budgeted Billing Price | This column displays the job's budgeted billing price. The budget figures are taken from the latest approved revision. |
| Prev. Invoiced | This column displays the total amount already invoiced as according to the beginning of the date interval provided. That is, it includes only invoices with an invoice date before the From Date . |
| Open, Hours | This column displays the open quantity on time activities for entries with a date within the given date interval, and invoices with an invoice date within that same interval. That is, the open quantity is as of the To Date of the interval but omitting entries that are older than the From Date . |
| Open, Time | This column displays the open billing price for time activities. The restriction is the same as for the Open, Hours column. |
| Open, Amount | This column displays the open billing price for amount activities. The restriction and calculation is similar to those for the Open Time Act. , except that this is for amount activities. |
| Open, Total | This column displays the open billing price as a product of the Unit Price and the Open, Hours . This figure corresponds to the open billing price for time activities. |
| On Account, Net | This column displays the Net On Account . Only invoice and reconciliations with an invoiced date within the date selected interval are included. |
| Last 30 Days, WIP | This column displays the WIP balance for the last 30 days for invoices on the job. |
| Last Invoiced | This column displays the latest invoice date for invoices on the job. However, invoices with an invoice date after or before the date interval provided, are not considered. |
Details Tab
The second tab has a large header that displays the summarized invoicing and budget figures for each customer and the job for that customer.
Customer Job Header
| Column | Description |
| Customer, No. | This column displays the customer's number. |
| Customer, Name | This column displays the customer's name. |
| Job, No. | This column displays the job's number. |
| Job, Name | This column displays the job's name. |
| Budgeted Billing Price (customer) | This column displays the job's budgeted billing price. The budget figures are taken from the latest approved revision. |
| Prev. Invoiced (customer) | This column displays the total amount already invoiced according to the beginning of the provided date interval. That is, it includes only invoices with an invoice date before the From Date . |
| Open Billing Price (customer) | This column displays the open quantity on time activities for entries with a date within the given date interval, and invoices with an invoice date within that same interval. That is, the open quantity is as of the To Date of the interval but omitting entries older than the From Date . |
| Net On Account | This column displays the Net On Account for jobs for that customer. Only invoices and reconciliations with an invoiced date within the date selected interval are included. The figures should match the On Account, Net. figure for that job on the Summary tab. |
| A/R Balance | This column displays the A/R balance similar to the balance stated in the AR Aging report. The figure should include only customer entries on the customer and job stated in this header. In addition, the balance should be calculated using the end of the date interval as the statement date and omitting entries that are older than the beginning of the date interval. That is, only entries and reconciliations within the specified date interval are included. |
Approved Time
This part displays approved open quantity on time activities entered for each employee. The table is organized by date and employee and grouped by task name and description. As a result, there is a table for each task entered for the job in the header.
| Column | Description |
| Date | This column displays the Entry Date or Finance Entry Date of the entries, depending on which date type you choose. |
| Employee, No. | This column displays the number of the employee who made the entries. |
| Employee, Name | This column displays the name of the employee who made the entries. |
| Remark | This column displays the remark (if any) that the employee made when entering. |
| Open, Hours | This column displays the open quantity on time activities coming from entries of the employee. |
| Open, Unit Price | This column displays the hourly price used for calculating the billing price on the job entry. If entries have different hourly prices, a line with each price is displayed along with the associated quantity and total. |
| Open, Total | This column displays the open billing price as a product of the Unit Price and the Open, Hours . This figure corresponds to the open billing price for time activities. |
| Notes | This column is left blank. It is a placeholder in case auditors want to write notes on printed versions of the report. |
Unsubmitted Time
This part displays the time entered, but not yet submitted, for each employee. The figures and structure are the same as for the Approved Time. Figures coming from submitted but unapproved entries are not captured. This is intentional, because the amount of such entries is considered very small.
Approved Amounts
This part displays the approved open amounts entered for each employee. That is, the amounts have been entered and approved, but not yet invoiced. The table is organized like the Approved Time part.
| Column | Description |
| Date | This column displays the Entry Date or Finance Entry Date of the entries, depending on which date type you choose. |
| Employee, No. | This column displays the number of the employee who made the entries; if any. |
| Employee, Name | This column displays the name of the employee who made the entries; if any. |
| Remark | This column displays the remark (if any) that the employee made when entering. |
| Open, Qnt. | This column displays the open quantity on amount activities possibly coming from entries of the employee. The open quantity is calculated as the entered quantity minus the invoiced quantity. |
| Unit Price | This column displays the unit price of the amount entries. If entries have different hourly prices, a line with each price is displayed along with the associated quantity and total. |
| Open, Total | This column displays the open billing price as a product of the Unit Price and the Open, Qnt. This figure corresponds to the open billing price for amount activities. |
| Notes | This column is left blank. It is a placeholder if auditors want to write notes on printed versions of the report. |
Summary by Employee
This part displays the open quantity on time activities, summarized by employee. The table is organized like the Approved Time part. Only figures that are approved are included.
Summary by Task
This part displays the open quantity on time and amount activities, summarized by task. In addition, it displays the budgeted hours and budgeted billing price. The budget figures are taken from the latest approved revision of the planning budget. The table is organized like the Approved Time part.
Monthly Distribution
This part displays the entered and invoiced billing prices split into time and amount activities, for each calendar month of the date range considered.
| Column | Description |
| Reg. Time Act. | This column displays the entered billing price for entries on time activities. The figures are distributed over the individual calendar months according to the Entry Date or Finance Entry Date , depending on what you chose. |
| Reg. Amount Act. | This column displays the entered billing price for entries on amount activities. The figures are likewise distributed. |
| Inv. Time Act. | This column displays the invoiced billing price for entries on time activities. The figures are likewise distributed. |
| Inv. Amount Act. | This column displays the number of hours entered and approved but not yet invoiced. |