Billing schedule form
New form is introduced to create billing schedule based on the frequency and maintain the billing schedules for a project contract. This form helps to review the status for each billing period whether its pre-billing complete or not, invoice proposal is created or not or if it still pending for some reasons for a particular billing period. Users can review the details on these billing schedules and get the invoices proposals created from the same form once the details are verified and confirmed.
This form provides the details of all the transactions posted for each billing schedule and provides information on all the invoices posted for this particular contract and can also perform adjustments.
Go to Project management and accounting > projects360 > Billing schedule > All billing schedule.
Go to Project management and accounting > projects360 > Billing schedule > My billing schedule.
Go to Project management and accounting > Projects > Project contracts > Billing schedule tab > Billing schedule button.
Go to Project management and accounting > Projects > All projects > Billing schedule tab > Billing schedule button.
 |
Note – My billing schedule form and lines will displays where the logged in user is Principle, Project manager, Project accountant for a project. |
Details of the buttons available on this form are as follows:
| Field | Description |
| Billing schedule | User can create new billing schedules for a project contract. Billing schedule will get created based on the billing frequency set on the project contract. Ex: If Weekly is set as billing frequency and Day of week is set as Wednesday, then user will be able to create billing schedule every Wednesday. |
| Pre-billing summary | Pre-billing summary process creates pre-billing summary review report for the given date range and selected parameters. |
| Invoice proposal | User can create invoice proposal for a single or multiple billing schedule which is in pre-billing complete status. Once the invoice proposal is created thereafter standard process to be followed to post the invoice. |
| Billing schedule status | User can select the billing schedule status as Pending, On hold, Pre-billing reviewed, Pre-billing complete, Invoice proposal created, Invoice posted for a billing schedule when each of the process gets completed. |
| Adjustment requests | User will be able to generate adjustment request for a billing schedule. |
| Pre-billing summary review | User will be able to view the generated pre-billing summary report for a billing schedule. |
| Project invoices | User will be able to view the posted project invoice for a billing schedule. |
| Project invoice proposals | User will be able to view the project invoice proposal for a billing schedule. |
| Project invoices | User will be able to view the posted project invoice for a billing schedule. |
| Posted project transactions | User will be able to view the posted transactions for a billing schedule. |
| Pending project transactions | User will be able to view the pending project invoice for a billing schedule. |
Details of the filter options available on this form are as follows:
| Field | Description |
| Filter | User can filter the billing schedules records based on the available fields. |
| Status | User can filter the billing schedules based on various status like All, Pending, On hold, Pre-billing complete, Invoice proposal created and Invoice posted. |
| Indicator | User can filter the billing schedule based on various Indicator like All, Billing cycle finished, Pre-billing is due, Billing is due. |
Details of the fields available on this form are as follows:
| Field | Description |
| Billing schedule ID | Displays billing schedule ID created through number sequence. |
| Project contract ID | Displays project contract ID for the billing schedule. |
| Contract name | Displays contract name. |
| Main project ID | Displays main project ID for the billing schedule. Main project ID will display only when billing schedule is created when ‘Break down main project” parameter is marked on project contract. |
| Main project name | Displays main project name. |
| Billing period start | Displays start date of the billing schedule. When the billing period is created for first time, this filed will be blank and for subsequent records it will take Billing period end+1 day. |
| Billing period end | Displays end date of the billing schedule. This is calculated based on the frequency set on the project contract. Ex: If Weekly is set as billing frequency and Day of week is set as Wednesday, the the billing period end date will be every Wednesday that is 5th, 12th, 19th, 26th of august 2020. |
| Service date from | Displays billing period start date. This field is controlled through a parameter and is editable. |
| Service date to | Displays billing period end date. This field is controlled through a parameter and is editable. |
| Billing frequency | Defaults the billing frequency used for creating billing schedule. |
| Pre billing validation target date | Displays the validation date to complete pre-billing. This is arrived by adding the value set in ‘Days for validation target date’ to the billing period end date. |
| Posted target date | Displays the validation date to complete billing. This is arrived by adding the value set in ‘Days for posted target date’ to the billing period end date |
| Status | Displays the status of billing schedule whether it is Pending, On hold, Pre billing complete, Invoice proposal created, Invoice posted for a billing schedule. When the invoice proposal is created/posted from the billing schedule automatically status gets changed to Invoice proposal created/Invoice posted. |
| Indicator | Displays the indicator which helps to take necessary on the billing schedule. When ‘Pre-billing validation target date’ crosses current date then the indicator will be ‘Pre-billing is due’ and when ‘Posted target date’ crosses current date then the indicator will be ‘Billing is due’ and when the invoice gets posted the Indicator will be ‘Billing cycle finished. |
| Billing approver | Displays the billing approver of the project contract. User can filter the records based on billing approver |
| Modified by | Displays the person name who modified the billing schedule. |
| Modified date and time | Displays the modified date and time of the billing schedule. |
Details of the fact boxes available on this form are as follows:
| Field | Description |
| Project invoice proposals | Displays all the project invoice proposals for a billing schedule. |
| Project invoices | Displays all the projects invoices for the project contract. |
Billing schedule details form
In the billing schedule details form, all the project related details will be created based on conditions. Projects with fee type ‘Time and expense’ and ‘None’ will be created even without contract value and for projects with fee type ‘Time and expense NTE’, ‘Fixed fee’, ‘Progress’ will be created only when contract value is approved. User able to view the various indicators which describes if they are no posted transactions or no completed milestones or if progress percentage is not updated for the billing period. There is an option provided to the user to view the details such as Contract value, Progress percentage, Milestones etc.
Go to Project management and accounting > projects360 > Billing schedule > All billing schedule > Select Billing schedule ID.
Go to Project management and accounting > projects360 > Billing schedule > My billing schedule > Select Billing schedule ID.
Go to Project management and accounting > Projects > Project contracts > Billing schedule tab > Billing schedule button > Select Billing schedule ID.
Go to Project management and accounting > Projects > All projects > Billing schedule tab > Billing schedule button > Select Billing schedule ID.
Details of the buttons available on this form are as follows:
| Field | Description |
| Billing schedule | User can create new billing schedules for a project contract. Billing schedule will get created based on the billing frequency set on the project contract. Ex: If Monthly is set as billing frequency and Day of week is set as 5, then user will be able to create billing schedule on 5th of every month. |
| Pre-billing summary | Pre-billing summary process creates pre-billing summary review report for the given date range and selected parameters. |
| Invoice proposal | User can create invoice proposal for a billing schedule which is in pre-billing complete status. Once the invoice proposal is created thereafter standard process to be followed to post the invoice. |
| Billing schedule status | User can select the billing schedule status as Pending, On hold, Pre-billing reviewed, Pre-billing complete, Invoice proposal created, Invoice posted for a billing schedule when each of the process gets completed. In case if the billing schedule lines has pre-billing status as “On-hold” those lines status will not get changed when manually the header status is changed to pre-billing complete. |
| Adjustment requests | User can create Adjustment request for a billing schedule. |
| Pre-billing summary review | User will be able to view the generated pre-billing summary report for a billing schedule. |
| Project invoice proposals | User will be able to view the project invoice proposal for a billing schedule. |
| Project invoices | User will be able to view the posted project invoice for a billing schedule. |
| Posted project transactions | User will be able to view the posted transactions for a billing schedule. |
| Pending project transactions | User will be able to view the pending project invoice for a billing schedule. |
Details of the fields available on General tab are as follows:
| Field | Description |
| Billing schedule ID | Displays billing schedule ID created through number sequence. |
| Project contract ID | Displays project contract ID for the billing schedule. |
| Contract name | Displays contract name. |
| Main project contract ID | Displays main project ID for the billing schedule. |
| Main project name | Displays main project name. |
| Billing period start | Displays start date of the billing schedule. This field is made editable to include any type of corrected transaction with the question message to the user to proceed with changes. |
| Billing period end | Displays end date of the billing schedule. This field is made editable to include any type of corrected transaction with the question message to the user to proceed with changes. |
| Service date from | Displays billing period start date. This field is controlled through a parameter and is editable. |
| Service date to | Displays billing period end date. This field is controlled through a parameter and is editable. |
| Billing frequency | Defaults the billing frequency used for creating billing schedule. |
| Status | Displays the status of billing schedule. |
| Pre billing validation target date | Displays the validation date to complete pre-billing. |
| Posted target date | Displays the validation date to complete billing. |
| Proposed invoice date | Select proposed invoice date for the invoice proposal. |
| Billing approver | Displays the billing approver of the project contract. |
| Modified by | Displays the person name who modified the billing schedule. |
| Modified date and time | Displays the modified date and time of the billing schedule. |
Details of the buttons available on Billing schedule lines tab are as follows:
| Field | Description |
| Fee management | Opens Fee management form for the selected project. |
| ETC/EAC management | Opens ETC/EAC management form for the selected project. |
| Pending posted transactions | Displays all the pending transactions. |
| Transaction details | Displays all the Hour and Expense transactions for the select project. |
| % Progress history | Displays % progress history form and will be enabled only for projects with Fee type progress. |
| Update pre-billing status | User can change the pre-billing status for single or multiple lines. |
| Revenue adjustment | User can generate revenue adjustments for the project. |
Details of the fields available on Billing schedule lines tab are as follows:
| Field | Description |
| Project ID | Displays project ID included in the billing schedule. |
| Project name | Displays project name. |
| Fee type | Displays fee type of the project. |
| Pre-billing status | Select pre-billing status as Pending,On hold or Complete for a project. |
| Principal | Displays responsible principal for the project. |
| Project manager | Displays responsible project manager for the project. |
| Project accountant | Displays responsible project accountant for the project. |
| Indicator | Displays the indicator for the project. For fixed fee type of project, if the milestone is not completed for a billing period then the indicator will be displayed as ‘There are no milestones’ completed’. For progress type of project, if the progress % is not updated for a billing period then the indicator will be displayed as ‘% progress is not updated. For Time and expense or Time and expense NTE, if there are pending transactions for a billing period then indicator will be displayed as ‘There are pending transactions. If the projects are displayed with Header project parameter marked on projects the the indicator will be displayed as “Header”. In case if all the criteria is completed for a billing period then there will not be any indicator displayed. |
| Contract value | Displays the contract value of the project. |
| % Progress | User can update % Progress for the projects with fee type ‘Progress’. |
| WIP | Displays the WIP amount of the project. |
| Invoiced | Displays the Invoiced amount of the project. |
| Modified by | Displays the person name who modified the project. |
| Modified date and time | Displays the modified date and time for the project. |
Based on the type of the project selected on the Billing schedule lines tab, fields will be displayed accordingly. Ex: For Fixed fee type of project milestone details and for progress % of progress will be displayed.
Details of the fields available on Line details tab are as follows for Project type None, Time and expense, Time and expense NTE:
| Field | Description |
| Pre-billing status | Select pre-billing status as Pending,On hold or Complete for a selected project. |
| Indicator | Displays the indicator for the selected project. |
| Note | User can enter notes for a project. |
| Contract value | Displays the contract value of the selected project. |
| WIP | Displays the work in progress amount for the selected project. |
| Invoiced | Displays the invoiced amount for the selected project. |
| Remaining revenue | Displays the remaining revenue amount for the selected project. |
| % Revenue Completed | Displays the percentage of completed work for the selected project. |
| Estimated % complete | Displays the estimated percent complete for the selected project. |
Details of the fields available on Line details tab apart from the mentioned above for Project type Progress:
| Field | Description |
| % progress | User can update progress percentage for the selected project. |
Details of the fields available on Line details tab are as follows for Project type Fixed fee:
| Field | Description |
| Add | User can add a milestone. |
| Delete | User can add a milestone. |
| Date | Defaults with milestone date. |
| Description | Defaults with milestone description. |
| Amount | Defaults with milestone amount. |
| Complete | User can mark the milestone as complete. |
Details of the fact boxes available on this form are as follows:
| Field | Description |
| Project invoice proposals | Displays all the project invoice proposals for a billing schedule. |
| Project invoices | Displays all the projects invoices for the selected project. |
| Project totals | Displays the details of Contract value, Contract hours, WIP, Invoiced, Revenue, Actual hours, Revenue % completed, Estimated % complete and Remaining revenue on the main project for a billing schedule. |
Pre-billing summary
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. |
| Show summary progress | When this parameter is turned on, ‘Progress summary’ section will be printed on the 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. |
| Status | Displays chargeable status of the related transaction. |
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. |
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. |