Generate Planned Billing Schedule

Modified on Thu, 12 Mar at 11:46 PM

The Planned Billing Schedule in Linarc serves as a financial roadmap, projecting how project funds will be distributed over the duration of the project. You can view the distribution of SOV across the project timeline based on the start and finish dates of associated tasks, according to your custom SOV grouping layout for consistent billing records.

Generate monthly billing projections to anticipate cash flow requirements for each period. The system-calculated Planned SOV dynamically updates whenever funds are allocated to scheduled tasks.
Manually adjust the anticipated payment percentages for each month where needed, overriding the system-calculated values.
Lock the Planned SOV once finalized to establish a baseline for performance tracking.
Any revisions arising from approved change orders are automatically incorporated, ensuring the SOV always reflects the most current project scope and funding.

Generate the Planned SOV

Ensure you are on the 'Planned SOV' screen. If not:
- Click the app launcher icon in the top-right, and select "Finance" from the drop-down
- Click 'Contract' at the top, then select 'SOV' from the options on the left
Click the 'Generate' button on the top right

Linarc automatically generates the Planned SOV for the project. It displays the cumulative projected completion percentages of the work items linked to each SOV line item categorized, along with their corresponding monetary values for each month.

The table consists of the following columns:

SOV Line Item - The specific label that will appear on the planned billing and payment applications.
Total Contract– The overall contract value.
- Percentage (Contract) – The share of the work item’s cost value in relation to the total contract value.
- Amount (Contract) – The actual monetary value tied to the work item in the contract.
Total Allocation
- Percentage – The fraction of cost allocated to scheduled tasks, represented as a percentage of the total line-item amount.
- Value – The cumulative monetary value allocated to scheduled tasks to date.
Total Monthly % – The sum of anticipated payments across the months during which the tasks linked to this SOV line item are scheduled to take place.
Monthly Values
- Percentage – The fraction anticipated as billable for the month. This is system-calculated from the aggregated planned completion percentages of the tasks linked to the SOV line item. You can manually adjust this percentage if needed.
- Value – The corresponding monetary amount of the expected payment for the month, based on the applied percentage.

Search, filter, and sorting options

Use the 'Search' box located at the top left to find a template using any value from the table as search criteria
Right-click the column header and customize the display and order of the columns as you wish
The options at the top right allow you to filter the entries, create nested groups of entries, and manage personalized and customized views of the table. Use the links below to learn more about these:

Hover over a column header and click the icon to sort the rows in ascending or descending order of entries in that column

View Groups and Subtotals

You can get totals and subtotals of numerical data for any selected set of records by grouping and applying nested grouping. Use the icon at the top right to organize the data by column headers
The system automatically aggregates relevant numerical values, giving a structured breakdown and a clear view of the grand total distribution. See Group and Organize Items in a List View for more details

Download as Excel Sheet

Click the button at the top right to save a local copy of the list in Excel format for sharing and record-keeping. See Download List Views and Logs in Excel Format for more details

Adjust the Anticipated Payments

The Planned SOV calculates anticipated monthly payments based on task timelines and the projected completion percentages of the scheduled tasks linked to each SOV line item. When needed, you can manually adjust the expected payment for any month by modifying the share percentage of the corresponding SOV line item.

To change the planned monthly payments

Directly edit the value in the percentage (%) column for the required SOV line-items for the required months
Ensure that the total of the distribution of the payments for a line-item across the spanning months is 100%, as indicated in the 'Total Monthly %' column

The Cost Code column shows an alert message until the total becomes 100%. You can change these values until the planned SOV is locked.

Lock planned SOV

The finalized Planned SOV can be locked and shared with the paying party as a notice of expected monthly payments.

To lock the Planned SOV

Click the 'Lock' button on the top right.

The Planned SOV is protected from any inadvertent changes. Any revisions to the contract effected by the approved change orders are reflected in the planned SOV automatically.