Telus TPM Documentation

User Tools

Site Tools

Trace: • dashboard_and_search • probable_exposure_explained
accrual_process

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
accrual_process [2024/08/20 19:41] – tina.roblesaccrual_process [2024/08/20 19:55] (current) – tina.robles
Line 1: Line 1:
-**__ Old Accrual Process__** (if not transitioned to the new process, this will be your guide. New accrual process guide is below this section)+**__ OLD ACCRUAL PROCESS__** (if not transitioned to the new process, this will be your guide. New accrual process guide is below this section)
  
 Accruals are a record of the expenses that have been incurred as a result of a contract in TPM.   The methods for calculating these values can differ by program type.  The client can choose to pre-define the calculation method in TPM at the Template level or allow the contract creator to select a method from more than one option.  Accruals are a record of the expenses that have been incurred as a result of a contract in TPM.   The methods for calculating these values can differ by program type.  The client can choose to pre-define the calculation method in TPM at the Template level or allow the contract creator to select a method from more than one option. 
Line 183: Line 183:
  
 Our standard reporting source has those terminated contract’s accruals available, but a given client could filter it out of their totals if they desired. Our standard reporting source has those terminated contract’s accruals available, but a given client could filter it out of their totals if they desired.
 +-----
  
 **__NEW ACCRUAL PROCESS__** **__NEW ACCRUAL PROCESS__**
Line 211: Line 212:
  
 (**ability to perform these actions is limited to users with access to these setting only**) (**ability to perform these actions is limited to users with access to these setting only**)
 +
 +-----
  
  
Line 221: Line 224:
 There are 3 different types of settings – Estimates (Forecast), Product Accruals and Lumpsum.   There are 3 different types of settings – Estimates (Forecast), Product Accruals and Lumpsum.  
  
-__ESTIMATE SOURCES__+**__ESTIMATE SOURCES__** 
  
 **CONTRACT ESTIMATE** – Uses the estimates defined on the contract as the quantity to estimate for. Allocates the estimate evenly over the entire time frame of the contract to determine estimated dollars per period. Estimates are associated to the contractee company (if there is only one) or to the contract in general if the contractee is a group.       **CONTRACT ESTIMATE** – Uses the estimates defined on the contract as the quantity to estimate for. Allocates the estimate evenly over the entire time frame of the contract to determine estimated dollars per period. Estimates are associated to the contractee company (if there is only one) or to the contract in general if the contractee is a group.      
Line 237: Line 241:
 **NONE** – Do not pull in any quantity to estimate, so nothing will be estimated for this contract.  **NONE** – Do not pull in any quantity to estimate, so nothing will be estimated for this contract. 
  
-__PRODUCT SOURCES__+**__PRODUCT SOURCES__** 
  
 **CLAIM** – This would use the actual volume from the claims processed against the contract to determine the accrual volume.   **CLAIM** – This would use the actual volume from the claims processed against the contract to determine the accrual volume.  
Line 245: Line 250:
 **NONE** – Do not pull in any quantity to accrue, so nothing will be accrued for this contract.  **NONE** – Do not pull in any quantity to accrue, so nothing will be accrued for this contract. 
  
-__LUMPSUM SOURCES__+**__LUMPSUM SOURCES__** 
  
 Lumpsum estimates and accruals tie to the contract version they are created under without rolling up to a specific company as they are a bucket of spend which can be claimed by any of the participants under the contract. Lumpsum estimates and accruals tie to the contract version they are created under without rolling up to a specific company as they are a bucket of spend which can be claimed by any of the participants under the contract.
Line 256: Line 262:
  
 **NONE** – This would not accrue any value for any lumpsum event on the contract.   **NONE** – This would not accrue any value for any lumpsum event on the contract.  
 +
 +-----
  
  
Line 272: Line 280:
  
 {{:pasted:20240820-183310.png}} {{:pasted:20240820-183310.png}}
 +
 +-----
  
  
Line 301: Line 311:
  
 The order in which the above are selected drives the order in which we look for the data to use.   If you chose SALE, LIST and COMPANY – we would first look for a sale value for the time frame, product and customer.  If none could be found, we would then look for a LIST value for that item and time frame.   If none could be found, we would look for a COMPANY value for that item and time frame. The order in which the above are selected drives the order in which we look for the data to use.   If you chose SALE, LIST and COMPANY – we would first look for a sale value for the time frame, product and customer.  If none could be found, we would then look for a LIST value for that item and time frame.   If none could be found, we would look for a COMPANY value for that item and time frame.
 +
 +-----
  
  
Line 314: Line 326:
  
 **1069_accrual_sale** is a supplemental file that the client can use to validate the values in the detail file where a sales invoice was the source used to generate the accrual amount.   **1069_accrual_sale** is a supplemental file that the client can use to validate the values in the detail file where a sales invoice was the source used to generate the accrual amount.  
 +
 +-----
  
 **REPORTING IN TABLEAU** **REPORTING IN TABLEAU**
Line 321: Line 335:
 {{:pasted:20240820-184409.png}} {{:pasted:20240820-184409.png}}
  
-__THREE CATEGORIES-TOTAL ESTIMATES, ACCRUALS AND ACTUALS__+**__THREE CATEGORIES-TOTAL ESTIMATES, ACCRUALS AND ACTUALS__** 
  
 This report shows everything at the highest level by Run Date.   The Run Date is the date that our system generated the accruals.     This report shows everything at the highest level by Run Date.   The Run Date is the date that our system generated the accruals.    
Line 349: Line 364:
 The report is defaulted to include Prior Year and Current Year for comparison.  Additional filters may be added at the clients’ request as long as the data is available in the datasource.   The report is defaulted to include Prior Year and Current Year for comparison.  Additional filters may be added at the clients’ request as long as the data is available in the datasource.  
  
-__ESTIMATES, ACCRUALS AND ACTUALS BY CONTRACT__+**__ESTIMATES, ACCRUALS AND ACTUALS BY CONTRACT__** 
  
 This report breaks the numbers from the previous tab down to the contract level.  There is a base set of filters at the top of the report, but others can potentially be added at the clients’ request.  This report breaks the numbers from the previous tab down to the contract level.  There is a base set of filters at the top of the report, but others can potentially be added at the clients’ request. 
Line 378: Line 394:
  
  
-__ESTIMATES, ACCRUALS AND ACTUALS BY CONTRACT ITEM__+**__ESTIMATES, ACCRUALS AND ACTUALS BY CONTRACT ITEM__** 
  
 This report breaks the numbers down to the contract item level.  There are a base set filters at the top of the report, but others can potentially be added at the clients’ request.  This report breaks the numbers down to the contract item level.  There are a base set filters at the top of the report, but others can potentially be added at the clients’ request. 
Line 409: Line 426:
  
  
-__ACCRUALS AND ACTUALS__+**__ACCRUALS AND ACTUALS__** 
  
 This report shows the difference in what was calculated based on the contract settings (Accruals) and what actually happened based on paid claims (Actuals) received from the customer.  This difference is displayed in the Balance column.   This report shows the difference in what was calculated based on the contract settings (Accruals) and what actually happened based on paid claims (Actuals) received from the customer.  This difference is displayed in the Balance column.  
Line 436: Line 454:
  
  
-__SALES DETAIL__+**__SALES DETAIL__** 
  
 This report shows by contract – the sales invoice details that were used to calculate an accrual amount on contracts where Sale Earning is the accrual method.  This gives the user the ability to see the invoice details that were specifically used to generate an accrual amount. This report shows by contract – the sales invoice details that were used to calculate an accrual amount on contracts where Sale Earning is the accrual method.  This gives the user the ability to see the invoice details that were specifically used to generate an accrual amount.
Line 461: Line 480:
  
  
-__CLAIMS DETAIL__+**__CLAIMS DETAIL__** 
  
 This reports shows by contract the claim id and details that were used to calculate an accrual amount where Claim is the accrual method.   This report provides the user all of the information needed to research the details of a specific accrual amount that used Claim to calculate the value.   This reports shows by contract the claim id and details that were used to calculate an accrual amount where Claim is the accrual method.   This report provides the user all of the information needed to research the details of a specific accrual amount that used Claim to calculate the value.  
Line 489: Line 509:
 Dates are also expandable in the report as previously detailed above.  Dates are also expandable in the report as previously detailed above. 
  
-__COMPARISON TOTAL__+**__COMPARISON TOTAL__** 
  
 This report allows a user to select two specific accrual run dates to compare to get a difference.  This is high level total date periods.  You can drill down from year to another period set up in your calendar. (i.e. quarter, month, week)  This report allows a user to select two specific accrual run dates to compare to get a difference.  This is high level total date periods.  You can drill down from year to another period set up in your calendar. (i.e. quarter, month, week) 
Line 502: Line 523:
  
  
-__COMPARISON BY CONTRACT__+**__COMPARISON BY CONTRACT__** 
  
 This reports allows a user to select two specific accrual run dates – but also one or more  specific contract IDs so they can see the accrual differences between two periods.   This reports allows a user to select two specific accrual run dates – but also one or more  specific contract IDs so they can see the accrual differences between two periods.  
Line 517: Line 539:
  
  
-__LUMPSUM SPECIFICS__+**__LUMPSUM SPECIFICS__** 
  
 Lumpsum Estimates - calculated based on the total lumpsum amount for the entire period of the contract/event no matter when that falls (past or future).  Lumpsum Estimates - calculated based on the total lumpsum amount for the entire period of the contract/event no matter when that falls (past or future). 
Line 547: Line 570:
 Lumpsum Actuals - always match the claim actuals paid against the contract lumpsum.  Lumpsum Actuals - always match the claim actuals paid against the contract lumpsum. 
  
 +-----
 +
 +
 +**__OFF INVOICE CONTRACTS__**
  
-__OFF INVOICE CONTRACTS__ 
  
 If we create claims for these contracts automatically, they will be included in the actuals as they are claims that were created in TPM.  If we create claims for these contracts automatically, they will be included in the actuals as they are claims that were created in TPM. 
  
 +-----
 +
 +
 +**__WHY WOULD ACCRUALS BE A DIFFERENT VALUE THAN THE ACTUALS?__**
  
-__WHY WOULD ACCRUALS BE A DIFFERENT VALUE THAN THE ACTUALS__ 
  
 If you short pay or override and pay more than allowed on a claim this will cause these amounts to be different.    If you short pay or override and pay more than allowed on a claim this will cause these amounts to be different.   
Line 559: Line 588:
 If you are accruing based off sales data a customer may not submit rebates against all the volume purchased.  This will cause a difference also.   If you are accruing based off sales data a customer may not submit rebates against all the volume purchased.  This will cause a difference also.  
  
 +-----
 +
 +
 +**__WHEN SHOULD I SETUP CONTRACTS NOT TO ACCRUE?__**
  
-__WHEN SHOULD I SETUP CONTRACTS NOT TO ACCRUE?__ 
  
 Contracts setup with all products, all customers, and a fake rate/price.  Example:  Samples and Damages.    Contracts setup with all products, all customers, and a fake rate/price.  Example:  Samples and Damages.   
  
 When you setup a contract both at sku level and lump for the same spend make sure both are not setup to accrue or you will overstate your accruals. When you setup a contract both at sku level and lump for the same spend make sure both are not setup to accrue or you will overstate your accruals.
 +
 +-----
  
  
accrual_process.1724182882.txt.gz · Last modified: 2024/08/20 19:41 by tina.robles

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki