Customizing Archer's Underwriting Model
      Back to home
      1. Help Center
      2. Underwriting
      3. Customizing Archer's Underwriting Model

      Underwriting FAQs

      Using the Archer underwriting system, including how to update templates, hide or delete unnecessary tabs, review financial discrepancies, resolve rent roll issues, apply overrides, and input annualized data

      Guide

      1. How do I switch between running a deal in the Archer model and our own model (BYOM)?

      1. Navigate to the Archer system.

      2. Select the relevant property (e.g., Vernon Gardens).

      3. Click Run Underwrite to generate the latest model.

      4. Verify that the correct template is used by checking the dropdown menu.

      5. If an expected update is missing, refresh the file and confirm the correct version is loaded.

      2. My model looks good and now I need to share with outside partners. How do I remove unnecessary information?

      1. Open the generated Excel file.

      2. Review the included tabs.

      3. If certain tabs are unnecessary for external sharing:

        1. To hide a tab: Right-click on the tab name and select Hide.

        2. To delete a tab: Right-click on the tab name and select Delete.

      4. If modifications are made, save the updated file and re-upload it to Archer.

        1. Note: Make sure to save a new version of the file if you are removing tabs so that you have the original if needed. 
      5. Saving the file will ensure it appears as the latest model within the underwriting activity tab on the property page. 

      3. The T-12 data that is flowing through seems off. How do I confirm?

      1. If underwriting results appear incorrect, navigate to the Financials Tab.

      2. Look for any unexpected variances in the NOI Matching Section.

      3. Verify if flagged discrepancies appear in Column V (e.g., income categorized as expenses, missing data, incorrect sign values).

      4. Cross-check with the rent roll data to ensure it is not causing the issue.

      4. How do I resolve rent roll issues?

      1. Go to the Rent Roll Tab. 
      2. Check for multiple columns labeled Markets Rent or Lease Rent that might be causing incorrect calculations.
      3. To correct the issue: 
        1. Locate the Override Headers Section in the rent roll tab.
        2. Use the Ignore function for unnecessary columns (e.g., ignore annual and per-square-foot rent columns if already accounted for). 
        3. Save changes and refresh the file.

      For support with other common issues, check out our Rent Roll troubleshooting guide 

      5. How do I re-classify an expense item on the uploaded financials?

      1. If income or expenses are misclassified:

        1. Go to the Financials Tab.
        2. Locate the Overrides Section.
        3. Update the category manually and save changes.
      2. If rent roll classifications are incorrect:
        1. Navigate to Rent Roll Mapping Overrides.
        2. Adjust bed/bath counts, affordability status, or other rent roll details.
      3. If it appears as though the parsing returned incorrect data, please email support@archer.re with the property name and issue. Someone on the support team will reach out with any questions and fix the document within 24 hours.

      6. Is there a way to upload multiple years of financial data or a new T-12? 

      1. If you need to input historical financial data (e.g., for 2022 and 2023):

        • Open the Financials Tab.

        • Click Upload T12 in the Archer ribbon.

        • Select the relevant file and process the upload.

      2. After uploading and saving multiple years of financial data:

        • Click Refresh Data in the Archer ribbon.

        • Verify that all available data appears in the system.

        • Select which periods to include in the model.

      7.  I parsed the financial statement in a blank Excel utilizing the Archer Add In. Is there a way to get this info into the model?

      1. To update an existing model with new financial data:

        • Open the model in Excel.

        • Navigate to the Financials Tab.

        • Click Upload Financials if you have new financials or Refresh Data if the financials have already been parsed and saved. 
        • Select the updated dataset and apply changes.

      2. This process ensures the model reflects the most recent data without requiring a full re-run of underwriting.

      Summary of the Guide

      • Verify the latest template is being used by selecting the correct dropdown option.

      • Hide or delete unnecessary tabs to simplify the output for external sharing.

      • Review financial discrepancies in the Financials Tab and check for flagged outliers.

      • Resolve rent roll issues by ensuring that duplicated rent columns are ignored.

      • Use overrides to adjust incorrect categorizations in financials and rent rolls.

      • Input annualized data for multiple years using the T12 upload and data refresh functions.

      • Refresh the model to incorporate the latest financial data without restarting the underwriting process.

      Conclusion

      Following these steps ensures accurate and efficient underwriting using the Archer system. Regularly updating templates, reviewing financial data, and applying overrides where needed will streamline the process and improve reporting accuracy. Users can reference this guide or request recorded walkthroughs for further clarification.

      For additional support, refer to Archer’s knowledge base or reach out for assistance as needed.