Pre-billing Summary

Parameter Setup

On projects360 parameter form, under billing schedule tab, a new parameter “Activate pre-billing summary” has been introduced to control the pre-billing summary functionality. When this checkbox is turned on ‘Yes’, the Pre-billing summary feature is activated.

Go to Project management and accounting > Setups > projects360 parameters > Billing schedule Tab.

Details of the fields available on this tab are as follows:

Field	Description
Activate pre-billing summary	When this parameter is set to Yes, then user will have an option to generate and review pre-billing transactions through a report.
Document type	Select the document type that will be used to generate pre-billing summary report.

New button is introduced to generate pre-billing summary where a report will be created showing a summary of % progress and transactions for all the projects in the structure from “Billing schedule” form. This report will be available for the review where users will be able to highlight, makes notes, corrections or any edits.

Details of the fields available on this form are as follows:

Fields	Description
From date	User can define the From date to include the project posted transactions.
To date	User can define the To date to include the project posted transactions.
Hour transactions	User can select this option to include hour transactions.
Expense transactions	User can select this option to include expense transactions.
Fee transactions	User can select this option to include fee transactions.
Item transactions	User can select this option to include item transactions.
On-account transactions	User can select this option to include on-account transactions.
Show summary progress	When this parameter is turned on, ‘Progress summary’ section will be printed on the report.
Show timesheet comments	When this parameter is turned on, timesheet internal and external comments will get displayed for each hour transaction.
Show indirect cost	When this parameter is turned on indirect cost and total sales amount will get displayed on the pre-billing summary report.
Show on hold transactions	When this parameter is turned on, on-hold transactions will get displayed on the pre-billing summary report.
OK	On clicking OK, pre-billing summary report will get generated and tiff file will get attached.
Cancel	On clicking Cancel the process will get cancelled.

Pre-billing summary review

New form is introduced to maintain all the “Pre-billing summary” versions generated. Once the pre-billing summary is generated, a tiff file will be opened for user to review where users will be able to highlight, makes notes, corrections or any edits using toolbar. This report displays the progress summary section provides an insight of progress of each subprojects and transaction summary section provides an insight of all the posted transactions which includes chargeable and non-chargeable transactions for each subprojects with fee type.

‘Comments’ functionality is added for the users to put in their thoughts and if any clarifications required. Comments can be added on each attachment and history of it will be maintained.

Apart from above capabilities, user can open the tiff attachment and related billing schedule.

Details of the fields available on this report header are as follows:

Field	Description
Company logo	Displays company logo.
Billing schedule Id	Displays billing schedule Id from selected billing schedule.
Contract number	Displays contract number related with billing schedule.
Contract name	Displays contract name related with contract number.
Legal entity	Displays legal entity related with billing schedule.
From date	Displays from date from process parameters.
To date	Displays to date from process parameters.

Details of the fields available under Progress summary section are as follows:

Field	Description
Phase/Task	Displays subproject name.
Fee type	Displays fee type of the subproject.
Contract value	Displays contract value of the subproject.
Progress	Displays “ progress” if the project type is Progress or displays value where Earned value is divided by Contract value and multiplied by 100.%
Complete	Displays “Estimated % complete” from fee management If “ETC/EAC management” is active or displays “ revenue completed” from fee management form.%
Earned	Displays value by multiplying Contract value * % Progress if the project type is Progress or displays value by adding Previous billing and Current billing
Previous billing	Displays value from “Invoiced” field from Fee management form related with selected subproject.
Current billing	Displays value by deducting Previous billing value from Earned value if the project type is Progress or displays sum of sales amount for all the chargeable transactions

Details of the fields available under Transactions summary section for Hour transactions are as follows:

Field	Description
Date	Display the project date from transaction.
Role	Display role from the related transaction.
Resource name	Display resource name from the related transaction.
Category	Displays category from the related transaction,
Hours	Displays hours quantity from the related transaction.
Sales price	Displays sales price from the related transaction.
Sales amount	Displays sales amount of the related transaction.
Indirect cost	Displays indirect cost for the related transaction.
Total sales amount	Displays total sales amount for the related transaction.
Status	Displays chargeable status of the related transaction.
On hold	Displays check mark if the transaction is on-hold.

Note – When the Show timesheet comments parameter is marked while generating the report, Internal comments and External comments will get displayed for the timesheet transactions.

Details of the fields available under Transactions summary section for Expense transactions are as follows:

Field	Description
Date	Display the project date from transaction.
Resource name	Display resource name from the related transaction.
Category	Displays category from the related transaction,
Qty	Displays hours quantity from the related transaction.
Sales price	Displays sales price from the related transaction.
Sales amount	Displays sales amount of the related transaction.
Status	Displays chargeable status of the related transaction.
On hold	Displays check mark if the transaction is on-hold.

Details of the fields available under Transactions summary section for Fee transactions are as follows:

Field	Description
Date	Display the project date from transaction.
Category	Displays category from the related transaction,
Transaction text	Displays transaction text from the related transaction.
Sales amount	Displays sales amount of the related transaction.
Status	Displays chargeable status of the related transaction.

Details of the fields available under Transactions summary section for Item transactions are as follows:

Field	Description
Date	Display the project date from transaction.
Category	Displays category from the related transaction,
Transaction text	Displays transaction text from the related transaction.
Qty	Displays quantity from the related transactions.
Sales prices	Displays sales price from the related transactions.
Sales amount	Displays sales amount of the related transaction.
Status	Displays chargeable status of the related transaction.

Details of the fields available under Transactions summary section for On account transactions are as follows:

Field	Description
Date	Display the project date from transaction.
Description	Displays description from the related transaction,
Transaction origin	Displays transaction origin from the related transaction.
Sales price	Displays sales price from the related transactions.
Status	Displays chargeable status of the related transaction.

Periodic process

Progress billing phases