Advances and Retainers in Project Operations

Below is how you can setup Advanced and Retainers – and what is this in simple terms?

  1. Pre-Bill the Customer upfront.
  2. Reconcile the Billing amount before the next Billing cycle.
  3. If under-utilized or till the Amount, 0 is billed on.
  4. If over-utilized, the overage is billed to the customer on the Invoice created on Contract.

Setup Contract for Retainer Schedule

On the Contract for a combination of T&M and Fixed Price Contract Line, here’s how I setup the Retainer Schedule –

  1. Here are the Line Items on the Project Contract tied to the same project.

  2. And on the Contract, you have Advanced and Retainers Setup already.

  3. Here, you have the option to Setup the schedule.


  4. When you click on Setup a retainer schedule, it’ll ask you to fill out the details. You can either select and End Date for the Retainer of no. of Retainer Invoices to be created.
    But, the message isn’t shown till you realize it after you enter both.


    And when I tried to enter this – it gave me an error.

  5. So, I just kept the End Date

  6. And it’ll create the Schedule for me.

    Now, this is set.

Invoice the Retainers

Now, the Retainer Schedule is ready, let’s Invoice and confirm the Invoice –

  1. I can select the Retainer line and click on Ready to Invoice.

  2. Once this is ready, I can create the Invoice from the Contract.

  3. Once the Invoice is created, you’ll see that the Advances and Retainers section shows the Invoiced line item.
    Now, you confirm this Invoice.


  4. Once the Invoice is confirmed, this amount is available to be used on the Contract.


Consuming the Retainers

Now, this amount is available for us to consume on the Project. Let’s pre-date the Time Entries to see how the Available Amount is consumed –

  1. These are my time entries. And I’ll submit them.

  2. The Project Approver approves them so that Actuals are created which can be made as Ready to Invoice.


    Now, the Unbilled Sales will be made as Ready to Invoice.

  3. Now, as usual – Invoice will be created without doing anything to the Contract Retainer setup.

  4. Now, the Pro-forma Invoice will be created and the Amount is seen on the Line Items of what was Ready to Invoice but the Invoice amount itself will be 0.

  5. If you scroll to the bottom of the Invoice, you’ll see the Balance remaining due to this Invoice.

  6. Now, you confirm the Invoice.

  7. And once the Invoice is Confirmed, the Used Amount on the Contract’s Retainer schedule will be updated.


    If you over use the balance, the upcoming Invoice will have less amount to be billed based on what’s available.

Hope this was helpful!

Here are some Power Automate posts you want to check out –

  1. Select the item based on a key value using Filter Array in Power Automate
  2. Select values from an array using Select action in a Power Automate Flow
  3. Blocking Attachment Extensions in Dynamics 365 CRM
  4. Upgrade Dataverse for Teams Environment to Dataverse Environment
  5. Showing Sandbox or Non Production Apps in Power App mobile app
  6. Create a Power Apps Per User Plan Trial | Dataverse environment
  7. Install On-Premise Gateway from Power Automate or Power Apps | Power Platform
  8. Co-presence in Power Automate | Multiple users working on a Flow
  9. Search Rows (preview) Action in Dataverse connector in a Flow | Power Automate
  10. Suppress Workflow Header Information while sending back HTTP Response in a Flow | Power Automate
  11. Call a Flow from Canvas Power App and get back response | Power Platform
  12. FetchXML Aggregation in a Flow using CDS (Current Environment) connector | Power Automate
  13. Parsing Outputs of a List Rows action using Parse JSON in a Flow | Common Data Service (CE) connector
  14. Asynchronous HTTP Response from a Flow | Power Automate
  15. Validate JSON Schema for HTTP Request trigger in a Flow and send Response | Power Automate
  16. Converting JSON to XML and XML to JSON in a Flow | Power Automate

Thank you

Leave a Reply