Matrix will automatically reconcile your Deals for you. This means that Matrix will automatically close-win Deals for you when it recognizes matching dollars from your daily traffic system imports!
If the imported amount is equal to or more than the Deal, then the pending dollars are zeroed out and the Deal is closed (as a won deal). From that point forward, Matrix will only report on the booked amount.
->For example, you add a deal which contains pending amount for $500 for the current month/year.
->The order has billing for $700 for the current month/year.
->After the order is imported into Matrix, the pending amount get reconciled and remains ZERO and the deal status is set to Closed-Won.
Note: if the deal also contains pending amount for other months that billing hasn't been imported yet, the deal status will remain Open-Pending.
If the imported amount is less than the Deal, Matrix will deduct the amount and leave the remainder in pending until the start of the next month when all historical pending amounts will be removed.
->For example, you add a deal which contains pending amount for $500 for the current month/year.
->The order has billing for $300 for the current month/year.
->After the order is imported into Matrix, the pending amount gets reconciled and remains $200 and the deal status remains Open-Pending. If more billing gets imported, the pending amount will keep reconciling and leave the remaining amount on the deal.
Note:the pending amount of previous months will be removed when the next month begins and the deal status is set to closed-won if there is no more pending amount on other months on the Deal. For example, the current month is June and the Deal contains the pending amount for the months of May - Dec. On June 2nd, the pending amount of May will be automatically removed and the pending of June -Dec remains on the Deal.
For a Deal to Reconcile, it needs to meet the below requirments.
->the AE, Account, Office, Outlet and Month/Year on Deal and Order must match. Rev Type is optional, if it is included, then it needs to match to reconcile. For exameple, the Order has Local Office while the deal has National Office. So the Office on the deal and Order don't match. The deal wont' be reconciled after the order cames in.
->the pending must be entered BEFORE the order comes in. For example, if the order was entered into Traffice on 01/01/31. The deal must be added with pending amount into Matrix prior to 01/01/31. Otherwise the deal won't get reconclied.
->the deal status must set to Open - Pending. The deal won't get reconclied if the deal status is Open - Proposed, Closed - Won or Closed- Lost.
->there are no duplicate deals. When you have two deals that have the same AE, Account, Office, Outlet, and Month/Year, the system doesn't know which deal to reconclie. It ended up not reconcling any deals.
Notes:- Regarding the historical pending amounts being removed, this occurs on the 2nd of every month with an import of your Traffic Files. If the 2nd falls on a weekend and you do not send the Traffic Files over the weekend, monthly reconciliation will occur with Monday’s import.
- The bottom line - This means that you do not have to manually close-win all of your Deals! (Unless, for some reason, you need to).
Keyword Search: Deal Management, Deals, Deal Reconciliation, Zero out pending, adjust pending, daily pending adjustment, recently imported dollars, how does a deal get reconciled or zeroed out