AvachaTech's Financial Waterfall app is designed to track financial and operational performance of affordable housing properties and automatically calculates and projects the waterfall of project fee, reserve, loan, and bond payments throughout the compliance period.
The Financial Waterfall app is built in Salesforce, giving it built-in reporting and analytics capabilities. It can be installed as a stand-alone app within a new Salesforce environment or it can enhance your existing Salesforce architecture.
Click the link to the right to visit the Financial Waterfall website.
Data and Impact Analysis
Data is the underlying component of any modern business, regardless of the sector. AvachaTech helps organizations manage data to inform their business decisions.
Affordable Housing Policy Development
AvachaTech works with Moving to Work housing authorities to craft and implement new policies. This includes styding the policy choices to determine their impact, writing policy language, drafting materials for Board approval, and working with staff to put the new policies in place.
Process Automation
AvachaTech helps organizations with process automation in order to eliminate redundancies, reduce data processing time, and give policy-makers control over user choices.
Software Implementation
At AvachaTech, we understand how overwhelming software implementation can be. Whether your project is a simple stand-alone software program or it is a complex rework of all of your current legacy systems, we can help.
Project Management
Effective project planning and execution is essential to the success of any project. AvachaTech has extensive experience in leading and completing complex projects.
Performed an in-depth analysis of the impact of a new alternative payment standard schedule on households and the agency budget. Once the analysis was completed and presented to the team, worked with operations to implement both the new payment standards and utility allowances within their existing software system.
Worked with a large public housing authority to draft and submit its application for a $500,000 Choice Neighborhoods Planning Grant. Work included project-managing the application process, gathering required materials, writing application material, and compiling the application for submission.
Worked with a new Moving to Work (MTW) agency in Asset Building cohort to draft its first MTW supplement and submit to HUD. Work included the following:
Project managed the implementation of a legal case management system for a State agency. Work included the following:
Worked with a new Moving to Work (MTW) agency in Landlord Incentive cohort to draft its first MTW supplement and submit to HUD. Work included the following:
Worked with a County in Oregon to prioritize and select shelter projects to fund. Included assessing shelter needs, working with County staff to understand funding requirements and restrictions, drafting contract scopes of work, participating in work sessions with shelter providers, and drafting other project materials for the team.
Worked with housing authority staff to design a simplified utility allowance schedule. Work involved the following:
Designed and implemented an application to calculate financial waterfalls for affordable housing and tax credit developments. This application is hosted in Salesforce and includes automated waterfall calculation, tracking annual financial statements, and tracking other compliance-related activities.
Project-managed the application process and wrote the MTW application for a housing authority, which was ultimately successful. This project included:
Worked with a housing authority to analyze and document all processes and procedures used in the management of the Housing Choice Voucher program. Included developing a library of processes and forms, identifying areas for improvement, and training staff on new procedures.
Project-managed the implementation of Yardi for a public housing authority (PHA). Included working with PHA staff and Yardi to define requirements and training needs, handling data conversion tasks for the PHA, set up financial systems and define financial reporting needs, and advise on best practices.
Designed, built, and implemented system for inputting and tracking multifamily projects from project inception through completion. Includes the ability to track all project financials, waterfalls, and residual receipts.
Designed, built, and implemented an affordable housing database used to input, manage, and evaluate data related to affordable housing projects. This system enabled the client to easily see various restrictions placed on each property, identify the most restrictive restrictions, and evaluate whether a property is in compliance.
Worked with housing authority to draft application to HUD's Moving to Work (MTW) program, which was ultimately successful. This project included oversight of the public process and preparation of all materials for the housing authority board and the public.
Project-managed the application process and wrote the MTW application for a housing authority, which was ultimately successful. This project included:
Worked with a housing authority to prepare and submit an application for Project Turnkey funds. The application was utlimately successful and enabled the agency to purchase a hotel to house individuals unable to socially distance. This project included the development of all Board and public process documents.
Worked with a housing authority to draft a local implementation plan (LIP) document used to implement a regional supportive housing services program serving homeless families.
Designed, built, and implemented a system for tracking NEPA Compliance. The system stores high level project information and links the NEPA compliance information to projects already stored in other applications within the database. The system also stores funding sources for all projects and allows staff to record field inspections and track mitigation requirements.
Designed and managed the build and implementation of an integration between Salesforce and Intacct. All payables and receivables originated in Salesforce and were synced either nightly or on demand to Intacct. On the AP side, checks were issued out of Intacct and the information was sent back to Salesforce; on the AR side, the transactions were reconciled with bank deposits.
Designed and managed the build and implementation of a housing management system in Salesforce that included all functions related to Public Housing, Tax Credits, and Section 8. Functions included certifications / rent calculations, waitlist management, move-ins / outs, inspections, work orders, tenant accounting, Section 8 accounting, 50058 creation and export, etc.
Designed, built, and implemented an application used to track goals, discussion items, and notes for an executive team.
Designed and managed the build and implementation of a custom system used to manage reasonable accommodations. The system significantly reduced the agency’s legal exposure by automating the approval of accommodations based on a set of clear legal requirements. Note that as part of this process, a patent was secured for the unique approach to assessing RA’s.
Designed and managed the build and implementation of a case management system, including a customized MTW FSS program. Case management was based on bridge assessments and logic was built to route cases based on complexity and intensity.
Designed an add-on built in ColdFusion for managing a custom Family Self-Sufficiency program. Rather than earning escrow based on an increase in income like the traditional FSS program, the modified FSS program deposits funds into clients’ escrow accounts based on meeting certain “pay points”. If the client meets their obligations, then the escrow is later disbursed to the client upon move out. Note that this system was later replaced by Salesforce using the same design requirements.
Designed an add-on built in ColdFusion that connected to the VisualHOMES housing software. This add-on was used to calculate household’s rent outside of the standard HUD method for rent calculation. Note that this system was later replaced by Salesforce using the same design requirements.
Designed and built an application to accommodate a custom landlord payment program called Property Based Subsidy (PBS). Unlike traditional Section 8 where payments are made to landlords based on each tenant on program, PBS pays landlords a set amount each month as long as the landlord complies with the program income requirements. This project included the capability to import client data into the system each quarter to verify program compliance.
Designed and implemented a system in SharePoint for tracking agency incidents and insurance claims. Note that this system was later replaced by Salesforce using the same design requirements.