Documentation Validation Manuals
- Locking/Unlocking of Welcome Call (Conditional Approvals)
- Validation Guide (IDs)
- Validation Guide (Property Docs)
- Validation guide (Diablito)
- Validation Guide (Credit Checks of Personas Fisicas)
- Validation Guide (Credit Checks of Personas Morales)
- Validation Guide (Contracts)
- Validation Guide (Proposals)
- Validation Guide (Special Approval Checklist Item)
- Validation Guide (CFE MGMT Checklist Item)
- Validation Guide (Constancia de Situacion Fiscal)
- Validation Guide (Custom Checklist Items)
Locking/Unlocking of Welcome Call (Conditional Approvals)
WIKI OVERVIEW
- Wiki Purpose: Facilitate the unlocking of Welcome Calls by navigating through the OPS page, identifying and resolving lead-blocking attributes such as prepayment, pending approvals, or documents, and editing the attribute to 'none' only upon verification of resolved issues, while notifying requesting Sales or CE agents if any pending actions persist.
- Wiki Owner: Joseph Canaan
- Validity: n/a
For unlocking a Welcome Call
When there is a request from CE or Sales to unlock the welcome call, we need to follow this process:
- Go to the OPS page
- Go to the Attributes section and look for the "iops/scheduling_block"
- See what is the reason selected
- - : means there is no blocking for this lead. No action needed from Approvals.
- Prepayment: means that the client needs to pay his first scheduled prepayment to automatically unlock. Approvals shouldn't turn this off.
- pending_cfe_approval: something related to the CFE mgmt is pending. Go to the cfe_mgmt item section and look for the context to see if the IX team has already sign off the item or is still something pending.
- pending_docs: this one is likely not used anymore, however, if ecountered, go to the property document item section to see the notes of approval and define the document pending. See if they have already submitted the new document.
- None: there is no blocking for this lead. No action needed from Approvals.
- Once we verify that there is no pending document or action due to this blocking, we can proceed to edit the attribute and select "none" so the blocking is lifted.
- If there is still a pending document or action, do not change the attribute and notify the Sales or CE agent that requested the unblocking.
Validation Guide (IDs)
WIKI OVERVIEW
- Wiki Purpose: Establish and implement a streamlined validation process adhering to underwriting criteria, ensuring accurate review and approval/rejection of Identification Guide revisions based on stringent verification protocols.
- Wiki Owner: Joseph Canaan
- Validity: n/a
Approval Requirements for the Validation Guide (IDs)
Follow the Underwriting Criteria (Mainstream Valid Rules)
Process to review and approve/reject the Validation Guide (IDs)
- Open the following link to see the pending signer and cosigner ID revision.
- Visualize only the Top priority projects by activating the operator “Only show top priority projects”.
- Select the option “Signer info” or “Cosigner info” in operator Select Doc Type in the platform.
- Open the Identification document by clicking on the “Go to Doc” button.
- Check the information on the Ops platform is valid (according to the previous section of this wiki) and that it matches exactly the information on the submitted ID image.
- Create the following custom items in the lead page:
- “Previously Installed Photovoltaic Information”
- “Calculo de Planeación”
- “Comprobante de no adeudos”
- If everything is correct, approve. If not reject the document with the corresponding feedback for the EE.
Validation Guide (Property Docs)
WIKI OVERVIEW
- Wiki Purpose: To systematically review and approve/reject Property Docs by cross-referencing details such as address consistency with CFE Bills, verifying subscriber and co-subscriber IDs, confirming document types, names, and visible first and second names against set criteria, validating marriage certificates if necessary, ensuring street details alignment, checking for name change requirements in the platform, and providing clear approval notes or reasons for rejection.
- Wiki Owner: Joseph Canaan
- Validity: n/a
Approval Requirements for the Property Docs
Follow the Underwriting Criteria (Mainstream Valid Rules)
Process to review and approve/reject the Property Docs
- Open this link to see the pending property docs for revision
- Open the CFE Bill to check that the address in the bill is the same as in the property doc.
- Open the subscriber and co-subscriber ID´s in order to check that the names and surnames match the property doc.
- Identify the type of document to approve and check if it can be approved according to the characteristics described below for each case
- Expiration date: Current year only for predial if it requires a name change in the CFE bill, if it does not require a name change, we can accept a document from any year.
- Name of the document: Has to match the name of our subscriber or co-subscriber.
-
- First and second names need to be visible in the property doc. Otherwise, we need an extra certified document that validates that the person may appear with just one name in certain documents.
- If the signer or co-signer has their partner´s last name, a marriage certificate is required as an extra document to approve the property doc.
-
- The street name and external number: They must match the CFE bill and the property document.
- Verify if it requires name change or not in the platform: If it does, the option "true" must be selected in the platform section "cambio de nombre".
- If a change of name or address is needed consult the following link to see which requirements are needed for each state or CFE office.
- Add the approval note or the rejection reason
Template for approval:
“Notas de aprobación de doc de propiedad:
Installer Notes
Persona que debe firmar:
Cambio de nombre (YES/NO)
Cambio de dirección (YES/NO)
Cambio de tarifa (YES/NO)
Requiere RFC (YES/NO)
Recibo cuenta con RMU (YES/NO) :
CFE Número de recibo que queda activo:
Oficina de CFE:
Property doc Notes
Propietario:
Documento:
Dirección en doc de propiedad:
Nombre en recibo CFE:
Dirección en recibo de CFE:”
Flux diagram of the process:
IDB Eligibility Requirements:
Before approving the property doc make sure to add the corresponding IDB tag if necessary
- Summary: Cases in which the project is not IDB eligible: (Jonah comment - not IDB eligible or not approvable?)
- If the street name isn’t the same in the property deed and CFE receipt and it is not mentioned as a boundary.
- If notary deeds are already in process and there are no other property documents. (You can request the notary to generate a notarized letter showing the buyer, the property address, and, if possible, the cadastral code, this letter doesn’t have expiration date)
- If the CFE bill lists two external numbers, where one belongs to the entrance of the subdivision and the other to the external number of the property, and the external number and street of the property don’t match between the property document and the CFE bill.
- Non residential projects.
- Links between documents, as only one document is provided to lenders.
- Any Property doc approved with an informal document.
- Action needed: When a property document does not fulfill the IDB criteria for a subscription product BOTH the "idb_skip" and "special approval" tags must be added only if it can later on be eligible for IDB (by a name change, address change or more documentation from the lead). If this is not possible, then ONLY the "idb_skip" tag must be added.
- Add "idb_skip" --> attributes "property_document_for_MGM"
- Not needed for non residential projects
- Whenever a property document is approved with an informal document the 'informal_document' tag must be added in OPS.
Cases not listed here
When cases arise that are not described in this list or do not fully match any of these situations, the following steps will be necessary:
- Initiate a conversation on Slack. The Approval Analyst and your manager must be tagged.
-
- In this conversation, provide the context of the situation.
-
- Subsequently, escalate the case for Jonah's approval. It is important to try to obtain any documents that help validate our client as the property owner. The Approval Analyst will be responsible for emailing Jonah for approval.
-
- If you wish to expedite the process, the EE or manager can generate a summary with the context/obstacle we are facing and send the email directly to the Approval Analyst.
- The email will be copied to the EE and the manager so they are informed of the approval. If you wish to add more information regarding the case, you can respond directly to the email that the Approval Analyst sent.
-
- Once Jonah's approval is obtained, the project can proceed.
Validation guide (Diablito)
WIKI OVERVIEW
- Wiki Purpose: Ensure accurate determination of load requirements by cross-referencing CFE-installed and contracted load information within OPS NOTES to determine the necessity of potential load increase with CFE for eligibility and alignment with project proposals, while adhering to specific documentation criteria for CFE bills and proposal requests.
- Wiki Owner: Joseph Canaan
- Validity: n/a
Approval Requirements for the Diablito Check
Follow the Underwriting Criteria (Mainstream Valid Rules)
- Installed and contracted load by CFE info: Needs to be in OPS NOTES, it is necessary to determine if the case will need a load increase with CFE
- CFE bill:
- Complete and legible
- No more than 120 days older
- If there are more than 1 services, all the CFE bills need to be on the same PDF.
- Proposal request:
- Consumptions listed in the proposal request have to be the same as the CFE bill, if not, the project can´t be IDB eligible (add idb_skip tag) and we will need a write VoBo by the customer attached in OPS NOTES of PP made with estimated consumptions.
-
- Check that the consumptions used for the proposal are correct, it doesn’t matter if they´re not in the right time period.
- Check the dates of the readings to know if they correspond to a bimonthly period or more periods in one reading.
-
- If there are more than one bimonthly period, you will have to divide it by the amount of bimonthly periods.
- If the reading is a monthly period, you will have to sum the next period reading.
- If there is more than one CFE bill, you will have to sum the consumptions of all the bills
- Check that the "actual reading" doesn’t have a "Estim" rather than a number.
-
- Identify there are not one or more death phases:
- It is spotted when the most recent reading, the "actual reading" and "previous reading" stay the same, so the sum is 0. Pointing out there was no reading for that phase.
-
- Consumptions listed in the proposal request have to be the same as the CFE bill, if not, the project can´t be IDB eligible (add idb_skip tag) and we will need a write VoBo by the customer attached in OPS NOTES of PP made with estimated consumptions.
-
-
-
-
- Or if there are periods where the consumption is zero
-
-
-
-
-
- System size:
- Number of panels > 4
- Solar cover < 105%
- IRR must be between 15%-25% (Only proposals made by Jonah can be under this rate)
- DAC buffer >1500 kWh/year or >15% use
- Tarifa: Must be the same as that on the CFE bill, except:
- If it's a confirmed commercial case by the customer and the tarifa on the bill is residential (T1 or DAC), the proposal can be for a commercial (PDBT)
- If it's a GDMTO tariff, the proposal can be for a commercial (PDBT)
- Postal code: Must be the same than the CFE bill and validated on the Installable zones database, if not
- The EE should upload the written confirmation in OPS NOTES of the Idev team that we can approve the project since there is no extra cost for travel expenses or the written confirmation of the Idev team that we can absorb any extra cost for travel expenses and we can move forward with the process
- In case the bill contains the legend NETMET or PHOTOVOLTAIC means that the client has already an installed PV system. It is necessary to follow the underwriting's disclaimer about installed solar system.
- System size:
-
Process to Review and Approve/Reject the Diablito Check
-
- Open the Checklist Approvals from Retool and click the top priority option
- Open the CFE bill.
- Check that it is no more than 120 days old. If not, reject with notes of the situation.
- Check that the receipt holder and RPU written in OPS match the bill, if not
- There must be a SS of the new RPU and CFE service name in case of “Alta y baja” on the lead notes
- Check on lead notes for an EE explanation (ex. “El servicio es nuevo así que se usó los consumos de su casa anterior para hacer la PP”)
- If there's nothing on lead notes, reject with notes of the situation.
- Go to the "Diablito Check" item, check there are the installed and contracted load by CFE info, if not reject with the note:
“Faltan notas de carga instalada para saber si se considerarán costos extra de planeación” - Go to the Proposal Request section and check with the CFE bill
- Check the consumptions, if they are not OK then identify the written VoBo of the customer for PP with estimated consumptions on the diablito check evidences, if there is nothing then reject with the note:
“Casa Nueva / Recibo nuevo / PP con consumos estimados. Seguir wiki y obtener confirmación escrita del cliente: https://docs.google.com/document/d/1WQTkcvACEcDTHxhJ5Te1HxRW-t8O8n6lE0ZxqAyfd_w/edit#bookmark=id.n4qgj4v9hxp0 ¿Me apoyarían a subirlo a DIABLITO NOTES EVIDENCES por fis?
-
-
- Check there is not a dead phase, but if is then reject with the note:
”Se detecta fase muerta en el recibo, se debe revisar en RTVR. Es necesario agendar VT para tomar lecturas con egauge y revisar si hay presencia de ilícito.
TODAS LAS CIUDADES:
Agendar la visita usando el siguiente link:
https://thinkbright.tryretool.com/apps/Scheduling/Schedule
Importante: Agregar la siguiente información en las notas del evento:
Dirección de la casa del cliente.
Permisos especiales para entrar (en caso necesario).
Razón de la visita.
Especificaciones especiales de la instalación eléctrica del cliente” - Check that the Zip code it´s OK, but if it's not the correct ZIP Code and there is no comments in NOTES of the EE then, reject with the note:
"CP con viáticos: Agregar confirmación del equipo de Idev que esta zona no cuenta con viáticos. ¿Me ayudarían a subirlo a la custom item de TRAVEL EXPENSE, por fa? " - Check the bill is not NETMET or PHOTOVOLTAIC, but if it is and is no comments in NOTES of the EE then reject with this rejection note:
EE: Sistema con paneles ya instalados. Seguir wiki y obtener confirmación escrita del cliente:: https://docs.google.com/document/d/1WQTkcvACEcDTHxhJ5Te1HxRW-t8O8n6lE0ZxqAyfd_w/edit#bookmark=id.ye5xlrokgxg2 ¿Me apoyarían a subirlo a diablito notes evidences, por fis? - Check there no comments of the EE on NOTES about a diablito, but if it is then reject with the note:
“Es necesario agendar VT después de que el cliente retire el diablito / para corroborar que ya no hay presencia de diablito y tomar lecturas correctas.
TODAS LAS CIUDADES:
Agendar la visita usando el siguiente link:
https://thinkbright.tryretool.com/apps/Scheduling/Schedule
Importante: Agregar la siguiente información en las notas del evento:
Dirección de la casa del cliente.
Permisos especiales para entrar (en caso necesario).
Razón de la visita.
Especificaciones especiales de la instalación eléctrica del cliente”
- Check there is not a dead phase, but if is then reject with the note:
- Create the following custom items in the lead page:
- “Travel expense approval”
- “Installed/Contracted load information”
- “Estimated Consumption Confirmation”
- If everything is OK then approve the Diablito Check
-
Template:
Aprobación manual de diablito:
Carga instalada subida (YES/NO)
PP realizada con los consumos del recibo (YES/NO)
Código postal correcto y sin viáticos o absorbidos por algún equipo (YES/NO)
Tarifa en engine correcta (DAC, 01, 1A, 1B, etc) (YES/NO)
Sistema con paneles ya instalados (YES/NO)
Tiene fase muerta (YES/NO)
Propuesta sobrepasa el 105% (YES/NO)
DAC Buffer arriba de parámetros (YES/NO)
Notas importantes o notes de special request:
New Houses, CFE Bills, and New Residency Approval Process and Consumption Estimation
- CFE bill with >=4 months of consumption data: follow the process below (new construction process)
- CFE contract generated but no consumption data: follow the process below (new construction process) and we will be able to proceed as long as we have a CFE signed contract that allows us to verify the address, name in the contract and type of tariff. The contract must be submitted in the CFE bill section with the note that the CFE bill is being processed. The Approval Analyst will review the data with our standard CFE bill process.
- There is no CFE bill or contract: we can move forward but only with a purchase paid upfront (i.e. 1 year financial lease pay 100% upfront). Follow the process below (new construction process)
New Construction Process:
- Size the system is sized using Bright calculator (link here and benchmarks here) which has the best practices for how to estimate consumption following best practices based on the various scenarios we encounter
- The sign off on this amount is given by the client with written confirmation that this is an estimation and the real consumption could be higher or lower and may result in additional cost if the system size needs to change (more below on how to do so).
- Have a written confirmation from the customer acknowledging that this size system assumes x kWhs per year consumption and if it turns out differently then they acknowledge their CFE bill will be higher and they may need additional solar at additional cost,
IMPORTANT: This written confirmation can be done via mail or whatsapp. Please DO NOT request a signature from the client, just a confirmation of the previous statement.
-
- Once the written confirmation is received, request to Approvals to add the “Consumptions Estimation Confirmation” item in the checklist to store it.
Validation Guide (Credit Checks of Personas Fisicas)
WIKI OVERVIEW
- Wiki Purpose: To efficiently review and approve/reject credit checks for individual clients by accessing the authorization sheet, cross-referencing lead data, matching it with the authorization form, rejecting or modifying as necessary, retrieving the credit report from the designated Google Drive folder, uploading the report to the corresponding lead in the OPS platform, and finalizing the process through submission.
- Wiki Owner: Joseph Canaan
- Validity: n/a
Approval Requirements for the Credit Checks of Personas Fisicas
Follow the Underwriting Criteria (Mainstream Valid Rules)
Process to review and approve/reject the Credit Checks of Personas Fisicas
- Open the notifier at: https://ops.thinkbright.mx/approveBdcLookups
- Click on the “FILE” link highlighted in blue to open the authorization sheet document
- Open the lead by clicking on the lead name highlighted in blue.
- Go to the ID section of the lead checklist to be credit checked and open the ID with the requirements listed above (both sides of the ID).
- Check that in the Lead OPS platform, in the "Co/Subscriber Credit Verification" section, the data matches the authorization form.
- For RFC validation consider the following validation site.
- If they do not match, manually reject the request and add a note of what needs to be modified.
- Consult the following Google Drive folder created by the Sales Ops team, who are currently in charge of the credit report generation with Buro de Credito.
- Search the corresponding credit report with the following format: "Cnum_name_surname_CreditReport.pdf".
- If the credit report can't be generated by the Sales Ops agent, the Analyst should:
- Generate the credit report by consulting his/her Buro de Credito profile.
- Once the approval analyst log in in the page (request for credentials to Approvals Manager) he/she should fill all the mandatory fields indicated with a (*). Considering the following standard information:
- Tipo de contrato: Pago de servicios
- Tipo de moneda: MX/MEXICO
- Tipo de responsabilidad: Individual
- Importe: 0
- Incluir: BC Score
- Open de Record Manual BdC Lookups and search for the corresponding lead name and Cnum.
- Find the “Upload Results” section and upload the document you just saved.
- Submit to attributes in OPS "ops/d_and_b" section the report obtained.
- Approve or reject the item of credit check with the score range for the customer
The credit score ONLY be shared in the OPS platform, never by other communication channels
Validation Guide (Credit Checks of Personas Morales)
WIKI OVERVIEW
- Wiki Purpose: Establish an efficient procedure for reviewing and validating Credit Checks, incorporating the utilization of the CIAL platform for report requests and updates, adherence to Underwriting Criteria, and inclusion of the Buró de Crédito Report for a comprehensive assessment, facilitating timely approval or rejection decisions.
- Wiki Owner: Joseph Canaan
- Validity: n/a
Approval Requirements for the Credit Check of Personas Morales
Follow the Underwriting Criteria (Mainstream Valid Rules)
Process to review and approve/reject the Credit Check
- Once the approval analyst requested the report in the CIAL platform, should reject the CC with the note: MORAL. Reporte solicitado. Tiempo estimado de entrega de 7-10 días hábiles
- When the report is updated by CIAL, verify the fields within the report and consider the following information in order to approve or reject the CC:
- The CC can be approved if the fields following the Underwriting Criteria (Mainstream Valid Rules) criteria.
- Include the Buró de Crédito Report in “ops/d_and_b” attribute in order to have more information of the credit worthy profile of the customer.
Commercial Credit Checks
- This type of Credit check can only be done for a "Persona Moral" for commercial leads. In order to identify these kind of leads, you can check the lead's tag section and look for the "Commercial" tag.
Required Documents
We will require the most recent documents:
Must have the following documents
- Acta constitutiva
- RFC empresa
These additional documents can speed up the process but could be optional. (D&B will request it for their report directly to the client, Here is the letter that D&B sends to the customer)
- Balance financiero
- Estado de cuenta
- Estado financiero
- Declaración anual
Context on EMMA, Paydex and D&B Scores
- Overviews
-
- EMMA Score (specific to Mexico) - calculates how likely it is that the customer will pay you in the future based on historical behavior. EMMA's tailored approach to the Mexican market allows it to provide a more accurate and relevant assessment of credit risk for companies operating within Mexico (The specific weightings and criteria used by EMMA are tailored to the Mexican market):
-
- Factors likely more important in the EMMA score:
-
- The most important factor to get the EMMA score are payment references.
- Local market conditions: EMMA is likely to place more emphasis on factors such as local economic conditions, regional trends, and industry-specific risks within the Mexican market
- Regulatory environment: Mexico's legal and regulatory landscape could have a more significant impact on the EMMA score, as it is tailored to the Mexican market. Compliance with local laws and regulations and the company's history with local regulatory authorities may have more weight in the EMMA score.
- Business culture: Cultural factors specific to Mexico, such as business practices, payment behavior, and attitudes toward credit, might play a more prominent role in the EMMA score than in the D&B score.
- Currency risk: While D&B's international perspective may be more sensitive to currency fluctuations, EMMA's focus on the Mexican market might lead it to be less concerned with these factors. This could result in different weightings for currency risk between the two scoring systems.
- Domestic credit history: EMMA might place more importance on a company's credit history within Mexico, as it is specifically designed to assess credit risk in the Mexican context. In contrast, D&B might give more weight to the company's international credit history.
-
- It does also take financial performance, credit history, and market conditions.
- Caveat - this focus on the Mexican context also means that it may not be as effective in evaluating the credit risk of companies with significant international exposure or those operating in a global context. It may be less effective in evaluating the credit risk of companies with significant international exposure.
- Factors likely more important in the EMMA score:
-
- Paydex - Indicates whether they pay on time, in advance or with delay. Focused on commercial deals.
- D&B (international scoring system - score primarily based on ABILITY to pay) - analyzes risk based on capitalization, leverage, cashflows, etc
-
- The main difference between the EMMA and D&B Score lies in their focus and the specific weightings they assign to various factors: EMMA is tailored to the Mexican market, while D&B has a more global perspective.
-
- EMMA Score (specific to Mexico) - calculates how likely it is that the customer will pay you in the future based on historical behavior. EMMA's tailored approach to the Mexican market allows it to provide a more accurate and relevant assessment of credit risk for companies operating within Mexico (The specific weightings and criteria used by EMMA are tailored to the Mexican market):
-
- Considerations:
-
-
There are several reasons why certain factors may be more or less important in Mexico than internationally:
-
- Currency risk: While D&B's international perspective may be more sensitive to currency fluctuations and their impact on a company's credit risk, EMMA's focus on the Mexican market may lead it to be less concerned with these factors. This could result in different weightings for currency risk between the two scoring systems.
- Industry-specific risks: Some industries may be more prominent or face unique challenges in Mexico compared to other countries. EMMA's tailored approach allows it to better evaluate these industry-specific risks when assessing credit risk.
- Business culture: Cultural differences can influence business practices, payment behavior, and the way companies approach credit management. EMMA's focus on the Mexican market allows it to take these cultural factors into consideration when evaluating credit risk.
- Regulatory environment: Mexico's legal and regulatory framework can differ from those in other countries, which can impact the way businesses operate and their associated credit risk. By focusing on the Mexican market, EMMA can better account for these differences when assessing credit risk.
- Economic conditions: Mexico's economy can be subject to different trends, fluctuations, and challenges compared to other economies. This means that the risk factors affecting Mexican companies might be unique or have a different impact on their credit risk. EMMA's tailored approach allows it to take these specific economic conditions into account.
-
-
-
Process to order credit score report for Approval Analyst
To access the instructions for requesting a credit report for commercial customers, please access the Credit Check Service Guide wiki (Dun & Bradstreet).
Validation Guide (Contracts)
WIKI OVERVIEW
- Wiki Purpose: Streamline the Contract Validation process by systematically reviewing and either approving or rejecting the "Contrato de Suscripción" checklist on the corresponding Lead page, ensuring accurate contract information adherence to specified requirements, and providing justifications for rejection when necessary.
- Wiki Owner: Joseph Canaan
- Validity: n/a
Approval Requirements for the Contract Validation
Follow the Underwriting Criteria (Mainstream Valid Rules)
Process to review and approve/reject the Contract Validation
- Open the corresponding Lead page.
- Open the “Documents” section.
- Select the “Contrato de Suscripción” checklist and open the document linked.
- Validate the contract information following the requirements listed above.
- If the contract follows the requirements correctly, approve the contract checklist, if not leave a note with the justification.
Note that approving the contract approves the project, so make sure this process is followed only after the Approval process Validation Guide (Proposal) or Approval process Validation Guide (Credit Checks of Personas Fisicas) or Validation Guide (Property Docs) have been completely followed
Validation Guide (Proposals)
WIKI OVERVIEW
- Wiki Purpose: The objective is to meticulously review and either approve or reject the Validation Guide (Proposals) by verifying its alignment with the contract, ensuring adherence to the same consumptions as the CFE bill, verifying absence of extra costs or their accurate inclusion, and ensuring eligibility for IDB subscriptions by disqualifying proposals with a 100% added estimated consumption.
- Wiki Owner: Joseph Canaan
- Validity: n/a
Approval Requirements for the Proposal
Follow the Underwriting Criteria (Mainstream Valid Rules)
Process to review and approve/reject the Validation Guide (Proposals)
- Go to "Proposals" and tag the proposal signed as "Contract"
- Approve the proposal as "Proposal PPXXXXX" if:
- The proposal is valid
- The proposal must have the same consumptions as the CFE bill. A 100% added estimated consumption is not eligible for IDB subscriptions
- Same in the contract as in the platform
- If there are extra costs included, verify that are added correctly
-
The project won't be approved if the extra cost for Planeación is not included in the contract
- Energy sign in clause 5 is equal of to Design (100% in contract). Only in financial lease contract the generation in the contract is 85% of the design
- Verify the type of inverters (IQ+ 2 and 3 F) (APS (Hoymiles) for 1F)
- The number of panels is correct
- IRR is greater than 13% for IDB or greater than 15% for MGM. Dashboard to check
CSI Approval Checklist
Objective: This document seeks to ensure CSI analysts the success in CSI proposals approval.
Summary: CSI analyst is seeking 100% of proposals created, regardless of the type of proposal requested (subscription, prepayment, or financial), and gets approved by the exec team by implementing a checklist in order to diminish the errors in the template filled manually.
Subscription CSI template checklist
- CFE temperature zone, CFE geo region, postal code, and number of phases matches with the most recent CFE bill in OPS
- Consumption matches with the one from eGauge/estimator
- The number of actual panels and their wattage matches with the one in the approved commissioning
- The number of old panels and their wattage matches with the one in the current project design
- The number of new panels and their wattage matches with the one in the newly approved project design
- Make sure that the MXN/mo/kW should be similar in both cells (for the new and old system size), and a special not for prepayments, where we will usually look for a lower price over time
- The percentage for kWh expected vs preview is >98%
- The percentage for yield expected vs preview is >95%
- The original contract date matches with the one in installations “billing turned on by interconnection approval”
- The % of solar has to be <100%
- The column “Suggested $ from preview with Hacky Yield and panels equivalent” is filled with the data given by the preview using the hacky yield
- The savings percentage in “%Savings 1st out DAC” is at least 20%
- The column “Fair $ and Hacky yield” is filled with the data given by the preview using the hacky yield and new total price
- Make sure the “Panels (550W equivalent)” and the “Hacky yield Jonah needs to enter in RealSoftware” is taking into account the correct and most recent panels wattage in their formulas
- Check that the number “Panels (550 equivalent)” matches with the number from the preview
- Be sure to use “Suggested $ from preview tool” to price the new proposal at the moment to request t the proposal
Prepayment CSI template checklist
- As we don’t charge extra for the annual escalator for prepayment proposals, we’ll check the same data for consumptions, system size, and pricing that “Subscription CSI template checklist” but changing the extra panels price for the one given by setting ONLY the number of panels to add in the proposal preview.
- Be sure to use “Fair $ and Hacky yield” to price the new proposal at the moment to request the proposal
- For pricing the CSI on the template use the “Fair $ and Hacky yield” since this is the price the customer has paid + the price for the system increase
Financial CSI template checklist
- As we don’t charge extra for the annual escalator for financial proposals, we’ll check the same data for consumption and system size that “Subscription CSI template checklist”
- Request a preview in the “Financial lease preview” based on the number of panels needed
- Once the customer chooses the contract length and monthly lease request the contract with that info to the exec team.
Installers Led/Risk based proposal approval
Scope:
- In scope: T1, FutureDAC, PDBT, DAC <25 kW
- Out of scope: GDMT andSystems >25 kW
Process as of 26/01/2023 (to be revised in 10/02/2023):
- Whenever Jonah creates custom proposals for these installer led projects, we can assume it fulfils our IRR criteria of >15%.
- In order to verify if the lead corresponds to an Installer led sales project, check this list.
- If sales requires to modifying an already created custom proposal by Jonah then:
- This can only apply if the extra cost is paid by the client at maximum 12 months financed.
- If a change in the proposal is required such as extra cost modification, extra cost financing or yield change, we can copy the same inputs (monthly fee) in to create a modified proposal.
- This can only apply if the extra cost is paid by the client at maximum 12 months financed.
Validation Guide (Special Approval Checklist Item)
WIKI OVERVIEW
- Wiki Purpose: Establish a streamlined process for Sales or CE to request activation of the 'special approval' item on the Project approval checklist, involving Approval Analysts verifying economic feasibility criteria, CEO review, and iterative steps for final approval or rejection.
- Wiki Owner: Joseph Canaan
- Validity: n/a
Approval Requirements for the Special Approval Checklist Item
Follow the Underwriting Criteria (Mainstream Valid Rules)
Process to review and approve/reject the Special Approval Checklist Item
- Sales or CE should request the Approvals team to activate the “special approval” item on the Project approval checklist.
- Once the Sales / CE Manager fills the request, he/she should notify the Approval analyst to pre approve the request.
- The proposal number mentioned in the request will be used to search for the attached file which is sent to the CEO and CFO as a preliminary offer for the client (if the approval analyst doesn't receive the preliminary offers, he/she will ask for access to his/her manager)
- Approval analysts will search for the OPS information section of the mail and will use an indicator called “B Rating” data multiplying it by 10 in order to obtain the IRR and validate it with the one calculated for the special request.
- Approval analyst will find the NPV information in an attached file named “npv.csv.
- If both data correspond to the one listed in the Special Request and complies the economic project feasibility criteria of the Underwriting Source of Truth, Approval analyst will approve the special request with the note “Pre approved by Analyst name”. Otherwise he/she will reject the special request with a note explaining the situation.
- The CEO should then review the request on the CEO's dashboard
- If the CEO approves, it will be reflected as "Jonah approved this item" in the Ops approval checklist.
- If the CEO rejects, he should add questions/suggestions or next steps needed to be addressed by Sales Ops / CE Manger. Once comments are addressed Sales Ops / CE Manager should follow the process again from step 2.
Validation Guide (CFE MGMT Checklist Item)
WIKI OVERVIEW
- Wiki Purpose: The objective of the CFE management process is to facilitate UVIE requirements, ensure proper documentation for special name and address changes, and adhere to IDB eligibility criteria, subject to variations based on CFE office requirements, necessitating escalation with IX.
- Wiki Owner: Joseph Canaan
- Validity: n/a
Approval Requirements for the CFE MGMT Checklist Item
Follow the Underwriting Criteria (Mainstream Valid Rules)
The CFE mgmt process is needed when:
- UVIE is required
- Form commercial leads check project characteristics, if your project doesn’t comply with these checklist most likely it won’t need an UVIE, but this can vary according to the corresponding CFE office requirements so it will be necessary to always escalate with IX.
- Special name change
- When the approvals team is not sure if the documentation will serve for the name change (Follow the minimum documents required for name/address change in each geo table) and it's a IDB eligible project
- Adress change
- If their property doc address does not match with the address in their CFE bill and it's a IDB eligible project, they need an address change, it's recommended to realize the address change before the approval (Follow the minimum documents required for name/address change in each geo table)
- 2 meters wanted to be interconnected
- 2 different meters without unification cannot be normally approved due to CFE policies so it will necessary to have the IX approval
- The person who sign to interconnection is not a subscriber
- It is necessary to add the signer info in a CFE mgmt slot.
- CSF
- When a CSF is required and de customer cannot provide it.
Process for CFE MGMT Checklist Item
- Identify the case where we need the CFE mgmt process and reject the documentation.
- Sales request via Slack to open an item on the OPS page for CFE mgmt.
- Open OPS and add an item to the approval checklist.
- Add context about the situation and provide the proper documentation to be reviewed.
- The interconnections team should give the proper follow-up to this through CFE management page and specifically for CSF, the document will be shared through the channel in Slack customer_cfe_mgmt. Once the task is completed we can continue with the documentation approval.
Interconnections Office Minimum requirements
ALL CDMX CFE OFFICES REQUESTS THAT THE CFE BILL HAS THE COMPLETE NAME OF THE CLIENT AS THE 30 LETTERS LIMIT ALLOWS IT.
In all regions is necessary proof of tax situation (RFC with QR code) when are PDBT name changes (persona moral)
CFE Office / Zone |
Minimum documents required for a name change |
Special notes about the name change 👀 |
Minimum documents required for address change🏠 |
RFC needed for IX and Name ChangeYes/No |
✝︎ Titular falleció. 💀 |
Is it the CFE office strict? |
DM21 |
- Letter to cancel CFE service contract |
-The customer can remain without electricity up to 48 hrs. |
Ownership/Acquisition Deed or Predial (current year) |
YES 👁 |
-Death certificate |
YES 👁 |
DM22 |
- Letter to cancel CFE service contract |
-The customer can remain without electricity up to 48 hrs. |
Ownership/Acquisition Deed or Predial (current year) |
YES 👁 |
-Death certificate |
YES 👁 |
DM23 NAME CHANGE IS REQUIRED EVEN WHEN NAME IS CORRECT BUT IS NOT COMPLETE |
- Letter to cancel CFE service contract (current year) COMPLETE / FULL / ALL PAGES 😱 |
-The customer can remain without electricity up to 48 hrs. |
Ownership/Acquisition Deed or Predial (current year) COMPLETE / FULL / ALL PAGES 😱
- City Hall document that endorses same address |
YES 👁 |
-Death certificate |
YES 👁 |
DM24 |
- Letter to cancel CFE service contract |
-The customer can remain without electricity up to 48 hrs. |
Ownership/Acquisition Deed or Predial (current year) |
YES 👁 |
-Death certificate |
YES 👁 |
DM25 |
- Letter to cancel CFE service contract |
-The customer can remain without electricity up to 48 hrs. |
Ownership/Acquisition Deed or Predial (current year) |
YES 👁 |
-Death certificate |
YES 👁 |
DL70
NAME CHANGE IS REQUIRED EVEN WHEN NAME IS CORRECT BUT IS NOT COMPLETE |
- “predial” (current year) Ownership/Acquisition Deed or Predial (current year) COMPLETE / FULL / ALL PAGES 😱 |
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial (current year)
COMPLETE / FULL / ALL PAGES 😱
- City Hall document that endorses same address |
YES 👁 |
- Sentencia Definitiva from the Juicio Sucesorio, giving the property to the new owner (even better with the Auto de Adjudicacion) |
YES 👁 |
DL30 |
- “predial” (current year ) |
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial (current year) |
YES 👁 |
-Death certificate |
YES 👁 |
DN10 |
- “predial” (current year ) |
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial (current year) |
No |
-Death certificate |
No |
DN20 |
- “predial” (current year ) |
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial (current year) |
No |
- Sentencia Definitiva from the Juicio Sucesorio, giving the property to the new owner (even better with the Auto de Adjudicacion) |
No |
Monterrey/Saltillo |
- “predial” (current year ) -proof of tax situation (RFC with QR code) |
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial (current year) - City Hall document that endorses same address -proof of tax situation (RFC with QR code) |
YES 👁 |
-Death certificate |
YES 👁 |
Tampico |
- “predial” (current year ) -Requires CURP - Requires RFC
|
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial (current year) |
YES 👁 |
-Death certificate |
Not in meter bases, they are relatively flexible |
Baja California |
- “predial” (current year ) -proof of tax situation (RFC with QR code)
COMPLETE / FULL / ALL PAGES 😱 SCANNED, NO PHOTOS |
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial (current year) COMPLETE / FULL / ALL PAGES 😱 SCANNED, NO PHOTOS |
YES 👁 |
-Death certificate
|
No |
Acapulco |
- “predial” (current year )
COMPLETE / FULL / ALL PAGES 😱 |
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial |
No |
-Death certificate |
YES 👁 |
Tamaulipas |
- “predial” (current year ) -proof of tax situation (RFC with QR code)
COMPLETE / FULL / ALL PAGES 😱 |
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial -proof of tax situation (RFC with QR code)
|
No |
-Death certificate |
YES 👁 |
Hidalgo |
- “predial” (current year ) -proof of tax situation (RFC with QR code)
COMPLETE / FULL / ALL PAGES 😱 |
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial -proof of tax situation (RFC with QR code)
|
No |
-Death certificate |
YES 👁 |
Quintana Roo |
- “predial” (current year )
COMPLETE / FULL / ALL PAGES 😱 |
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial |
No |
-Death certificate |
YES 👁 |
Puebla |
- “predial” (current year ) -proof of tax situation (RFC with QR code) |
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial (current year) -proof of tax situation (RFC with QR code) |
YES 👁 |
-Death certificate |
YES 👁 |
Morelos |
- A special letter which must explain the reason for the name change. COMPLETE / FULL / ALL PAGES 😱 SCANNED DOC (NO PHOTOS) |
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial (current year) COMPLETE / FULL / ALL PAGES 😱 SCANNED DOC (NO PHOTOS)
|
No |
-Death certificate |
No |
GDL |
- Letter to cancel CFE service contract |
-The customer can remain without electricity up to 48 hrs.
-A photo of the meter must be presented at the time of the request in CFE |
Ownership/Acquisition Deed or Predial (current year) Photo of the meter taken in the exact same day of the tramite
Maps |
YES 👁 for name changes |
-Death certificate |
YES 👁 |
QRO |
- Letter to cancel CFE service contract |
-The customer can remain without electricity up to 48 hrs. |
Ownership/Acquisition Deed or Predial (current year) Photo of the meter taken in the exact same day of the tramite -proof of tax situation (RFC with QR code) Maps |
YES 👁 |
-Death certificate |
YES 👁 |
GTO |
- Letter to cancel CFE service contract -proof of tax situation (RFC with QR code) |
-The customer can remain without electricity up to 48 hrs. -A photo of the meter must be presented at the time of the request in CFE |
Ownership/Acquisition Deed or Predial (current year) -Photo of the meter taken in the exact same day of the tramite Maps |
YES 👁 |
-Death certificate |
YES 👁 |
SLP |
- Letter to cancel CFE service contract
|
-The customer can remain without electricity up to 48 hrs. -A photo of the meter must be presented at the time of the request in CFE |
Ownership/Acquisition Deed or Predial (current year) Photo of the meter taken in the exact same day of the tramite -proof of tax situation (RFC with QR code) Maps
COMPLETE AND ORIGINAL / FULL / ALL PAGES 😱 |
YES 👁 |
-Death certificate
COMPLETE AND ORIGINAL / FULL / ALL PAGES 😱 |
YES 👁 |
Merida |
- Letter to cancel CFE service contract |
- The cost of the name change is up to $590 MXN charged in the next bill
-A photo of the meter must be presented at the time of the request in CFE |
Ownership/Acquisition Deed or Predial (current year)
COMPLETE / FULL / ALL PAGES 😱 |
No |
-Death certificate |
YES 👁 |
Veracruz |
- “predial” (current year ) -proof of tax situation (RFC with QR code) COMPLETE / FULL / ALL PAGES 😱 |
- CFE bill must be paid. |
Ownership/Acquisition Deed or Predial (current year) -proof of tax situation (RFC with QR code) |
YES 👁 |
-Death certificate
|
YES 👁 |
Coahuila |
- “predial” (current year) Ownership/Acquisition Deed or Predial (current year) COMPLETE / FULL / ALL PAGES 😱 |
|
Ownership/Acquisition Deed or Predial (current year)
|
No |
-Death certificate |
No |
Chihuahua |
- “predial” (current year) Ownership/Acquisition Deed or Predial (current year) COMPLETE / FULL / ALL PAGES 😱 |
|
Ownership/Acquisition Deed or Predial (current year)
|
No |
-Death certificate |
No |
Validation Guide (Constancia de Situacion Fiscal)
WIKI OVERVIEW
- Wiki Purpose: To efficiently review and either approve or reject the Constancia de Situacion Fiscal by accessing the Ops platform via the provided link, searching for the relevant Cnum, selecting or creating the checklist named “Constancia de Situacion Fiscal,” validating the information against specified criteria, and providing justifiable notes alongside the decision.
- Wiki Owner: Joseph Canaan
- Validity: n/a
Approval Requirements for the Constancia de Situacion Fiscal
Follow the Underwriting Criteria (Mainstream Valid Rules)
Process to review and approve/reject the Constancia de Situacion Fiscal
- Open the Ops platform on the following link
- Search for the corresponding Cnum.
- Select the checklist named “Constancia de Situacion Fiscal”
- Only if needed create the checklist with the name mentioned.
- Validate the information with the criteria mentioned in the previous point.
- Approve or reject, add a note if needed to justify your decision.
Validation Guide (Custom Checklist Items)
WIKI OVERVIEW
- Wiki Purpose: Ensuring the project's compliance by verifying the latest template usage, data accuracy in specific documents, correct project naming, subscriber and cosubscriber IDs linking to the Ops portal, RTVR consideration, Company Summary section alignment with approved documentation, validation of legal representation based on participant type, property ownership through Property doc Notes, installation authorization via Customer Installation Permission Request, and contact information alignment with approved credit checks.
- Wiki Owner: Joseph Canaan
- Validity: n/a
One Pager approval (Only for GDMT and PDBT >50Kw)
Approval Requirements for the One Pager Checklist Item
Follow the Underwriting Criteria (Mainstream Valid Rules)
Process to review and approve/reject the One Pager Checklist Item
The cells where the inputs should be modified in the one-pager are filled in yellow.
- The EE should request the approval of the project through the #customer_approval_ninjas salck channel
- The approval analyst should validate the one-pager submitted was built with the most up to date version of this template
- The approval analyst should verify that the data in the Original cashflow csv is correct and matches with the one in the mail Oferta Preliminar (PPXXXXX) para XXXXXX
- The approval analyst should check the project name is correct
- The approval analyst should verify the subscriber and cosubscriber ID is ok and correctly linked to the customer Ops portal
- The approval analyst should verify the proposal ID is considered in the RTVR, is valid and it's correctly linked to the customer Ops portal
- The approval analyst should review the Company Summary section: Check ALL fields and validate the information in them matches the info in the signed contract and approved documentation in Ops.
- Note: Time in business, company size and project purpose sections won’t be validated by Approvals as it's not a field available in the contract or relevant for underwriting. Project purpose only must make sense with proposal characteristics.
- The legal representative will be validated if a moral person participates in the contract, if only personas físicas participate in the contract it will be mark a NA.
- Property ownership will be validated from the Property doc Notes from the property validation checklist.
- Installation authorization will be validated with the Customer Installation Permission Request checklist in the leads page.
- The contact information has to be related to the person who is going to be underwrited, considering if only one of them has his/her credit check approved.
- The approval analyst should review Bright Proposal section: Check ALL fields and validate their information matches what is included in the signed contract cash flow and savings files.
- The approval analyst should review link to Relevant Files: Check that all the links work correctly.
- Make sure to compare that NPV, IRR and Customer Savings files are the same as the ones in the valid contract.
- The approval analyst should fill out Persona Fisica Credit Score by adding the signer and cosigner exact approved credit scores from the Ops platform (when applicable)
- The approval analyst should fill out Persona Moral Credit Score by adding the signer or cosigner approved exact D&B EMMA, PayDex and Risk Matrix scores from the Ops platform (when applicable)
- The approval analyst should review Additional Information section:
- Check that explanation for any inputs that don’t meet the standard underwriting criteria for each individual doc on the above sections are included (i.e. building owner not signing the contract, IRR <18% threshold, Credit score below minimum, etc).
- Content is semantically, arithmetically, and grammatically correct (i.e. If there are calcs proposed make sure they make sense, If the building is not owned by the signer make sure this area doesn’t say otherwise)
- The approval analyst should review Risk Mitigation Section:
- Check that there are action plans for:
- In case the 30-day bag regulation is applied before the project is interconnected
- In case the customer declines any contract changes proposed to address the changes in regulation
- Check that content is semantically, arithmetically, and grammatically correct (i.e. If there are calcs proposed make sure they make sense, If the building is not owned by the signer make sure this area doesn’t say otherwise)
- The approval analyst should ensure we have a Sunwise 30-day bag proposal linked in the one pager and the Bright proposal that corresponds to it
- Check that there are action plans for:
- The approval analyst should review Sunwise mirror proposal:
- Log in Sunwise portal
- Ask for the credentials to Hector Angulo
- Go to the file with the project to analyze
- Go to Consumption history item in Sunwise and verify the consumptions match with the CFE bills updated in the CFE bill section in Ops
- Go to the approved version of the 30-day bag and verify the system size and annual production required match with the one in the project desing in Ops
- Verify in the 30-day bag in the Quotation item that the type and number of panels and inverters match with the one in the project design in Ops
- Go to the settings section and verify the total CapEx in the General > price adjustment > quantity is correct
- Go to the settings section and verify the Opex in the System > price adjustment > quantity is correct vs. O&M in cashflow
- Verify the downpayment and contract length in proposal and the data in it match the one in the contract (Pages 8 and 10)
- Go to the final proposal and ensure the savings are correct
- Log in Sunwise portal
- If the project is >50kW or in GDMT tariff, send it by email for second eye review by the approvals manager if not skip this step.
- Use the below template to request CEO approval via email (CC. Approval Manager, Head of Ops, Sales Manager, EE and CFO)
“Domicilacion” Authorization Checklist Item
The Domicialicion request format, can be found in here
Approval Requirements for the Domiciliación Authorization Item
Follow the Underwriting Criteria (Mainstream Valid Rules)
Process to review and approve/reject the Domiciliación Authorization Custom Item
- The fields colored in orange should be filled manually by the Sales team.
- Note: Section 6 defines the maximum amount we may charge per billing cycle (i.e. per month); we need to be able to charge at least 2x the monthly fee to ensure we can catch up on late payments if needed, and in the following cases must ensure we can charge more:
- The downpayment amount is larger than 2 monthly fees
- Note: Section 6 defines the maximum amount we may charge per billing cycle (i.e. per month); we need to be able to charge at least 2x the monthly fee to ensure we can catch up on late payments if needed, and in the following cases must ensure we can charge more:
- All mandatory fields colored in yellow in the format are filled and correspond to the subscriber information.
- The completed document should be sent to the client to e-sign to ensure validity.
- Approval agent will open the Lead page on the Ops platform by searching the C#.
- Approval agent will open the "Documents" section.
For a customer that has not yet been approved
- Add a Domiciliación checklist item to the Aprobación checklist
- Fill out the checklist item and submit it for review
If the domiciliación checklist item is not approved when the contract is signed then their account will not be set up for domiciliación. Make a separate Domiciliación checklist after the contract is made.
For a customer that already has a contract
- Add a Domiciliación checklist
- Fill out the checklist item and submit it for review
For both types of customer (unapproved and already with contract)
- Open the Domiciliación format submitted and follow the requirements listed in the previewed section.
- If the format follows all requirements, approve the custom item. Otherwise reject it and leave a note giving a justification.
Their contract's default payment method will need to be updated to domiciliación once we are ready to start charging them that way.
Note: A successful test charge is required to hold a Welcome Call
- An approved domiciliación checklist item will allow a project to reach the approval stage, but not Welcome Call.
- Once a contract is active with the domiciliación checklist item approved, Software and Billing will trigger a test charge of 10 pesos on the account.
- Note: Test charges must be submitted to Banamex by 3pm CDMX time and will post a response file reporting success or failure around 12pm CDMX time the next day.
- Currently, test charges require manual engagement with the Billing and Software teams, but stay tuned for automated processes.
Previously Installed System Disclaimer Confirmation Checklist Item
Approval Requirements for the Previously Installed System Disclaimer Confirmation
Follow the Underwriting Criteria (Mainstream Valid Rules)
Process to review and approve/reject the Installed System Disclaimer
- To identify if a property already has a solar system installed it can be easily identified with the CFE bill as it shows a "FOTOVOLTAICO" or "NET MET" in the heading of the bill.
- Once the new proposal is generated following the requirements mentioned in the Underwriting Criteria (Mainstream Valid Rules). Review the following aspects:
- Check that consumptions match the CFE Bill.
- Check that the proposal cover is close or equal to 100%
- Disable "Consumption Monitoring"
- Financial Lease term can be modified but we have to select 10 years as a base.
Confirmation Checklist Item
For now, this kind of project needs an approval from the executive team. Each case will be reviewed individually.