Pre-Bill & Revenue Recognition

April 2024 ยท 2 minute read

When adding or removing transactions from an unlocked invoice for a sub project the total transaction value can be greater or less than the invoice value. When this occurs there is an unallocated value for the sub project which is shown in red. The unallocated value needs to be allocated to the transactions before the pre-billing updates can be saved.

Click the image above to view the unallocated value on the sub project row.

Automatically split the unallocated value across the selected transactions for the sub project using the Auto Allocate button. The Unallocated Invoice Total for the sub project will be split across all transactions that are selected. This looks at the proportion the unallocated value to be greater for the transactions that have a higher chargeable value. Auto Allocate will not update any 'locked' transactions for the sub project.

You can also manually type the Invoice Value for the Transactions, or lock transaction rows to stop selected items from being included in the auto allocation. Manually entered invoice transaction values must add up to the sub project invoice total. 

Assign the Unallocated Value to the invoice transactions by:

  • Select the Sub Project in the list that has an Unallocated value shown in red.
  • (Optional) Lock any invoice transactions that you do not want to be altered. i.e. Lock the expense values to stop mark up/down.
  • Select the Auto Allocate button in the top right corner.
  • Repeat for each other sub project as required.
  • Save.
  • Click the image above to see the auto allocate button.

    Auto Allocate Formula

    Transaction Invoice Value = (Transaction Chargeable Value / (Total Chargeable Value- Sum of Locked Chargeable transactions for the Sub Project)) x (Sub Project Invoice Value - Sum of Locked transactions for the Sub Project).

    ncG1vJloZp6klZa%2Fr7XNoKmeq5%2Bqv6Sx0meZpaeSY7CwvsRnrqKmlKTEtHrNnqtom5ykwqW0xKWnaHyVqLi1u89oeqimpJq7tXuhoqOloZ6cfKq61aignJ2jYr2zscGio6WXopqwsLPNoquip55jtbW5