GPL Technologies

GPL System Introduction

GPL System is an automated system managing rental property assets in the following ways:

• Automated Rent Collection System based on data feeds

  • commercial banks data feeds such as Wells Fargo, Bank of America etc

  • mobile bank data feeds, such as Venmo, CashApp, Paypal, Chime

• Automated Payout Tracking System

• Automated Invoice System

  • Working with Handymen, HVAC professionals, etc to ensure the labor costs are paid in timely manner

  • Balance of owed invoices tracking

• Automated Supply Tracking system

  • Using Home Depot ProExtra account tracking all the supply expenses

  • Integrate the HD data into GPL system

• Automated Expenses Tracking System

GPL System -  Rent Collection

GPL System is an automated system managing rental property assets. The most critical process to ensure that the tenants pay full amount of rents matching the lease terms.

• Automated Rent Collection System based on data feeds

  • commercial banks data feeds such as Wells Fargo, Bank of America etc

  • mobile bank data feeds, such as Venmo, CashApp, Paypal, Chime

  • Tracking sheets for matching up the expected amount with a live data feeds.

• Using this system, we can quickly identify which tenant/property is owing non-zero balance.

GPL Payout System

GPL System is an automated system managing rental property assets in the following ways:

• Automated Payout Tracking System

• Carryover Expenses from last year

• Tracking net proceedings in real time based on the rent income less expenses

GPL Invoice System

GPL System is an automated system managing rental property assets in the following ways:

• Automated Invoice System

  • Working with Handymen, HVAC professionals, etc to ensure the labor costs are paid in timely manner

  • Pay for the invoices via Zelle, Venmo, etc.

  • The paid amount is reflected in the system in real time.

  • Balance of owed invoices tracking

GPL Supply System

GPL System is an automated system managing rental property assets in the following ways:

• Automated Supply Tracking system

  • Using Home Depot ProExtra account tracking all the supply expenses

  • Integrate the HD data into GPL system

GPL Utility and HOA Payment System

Dealing with HOA fees and utility bills are significantly overhead and troublesome. Even with auto draft / ACH or Bill pay set up, you may still get lost which utility bills each property is associated with. GPL system helps sort it out. Once it's set up, you can get a summary information easily at your finger tips.

• Automated HOA/Utility System

  • Using our Bill Pay system to track all the HOA bills and Utility Bills

  • Using our automated system, sort each incoming bills and associate with a corresponding property

  • Generates a summary reports

  • Deduct from the rent as expenses for Tax Reports

GPL Technologies

GPL system was developed based on Google Open Technology Platform.

• Google Sites

• Google Forms

• Google Sheets (Excel SpreadSheets)

• Google Doc

• Google App Scripts (will be used)

GPL Technologies - Google Sites

GPL system was developed based on Google Open Technology Platform.

• Google Sites

  • GPL WebSite was powered by Google Sites

  • It's self designed WebSite without any vendor's support

• 
  

GPL Technologies - Google Forms

GPL system was developed based on Google Open Technology Platform.

• Google Forms

  • GPL Entry forms that allow us to interact with the system

  • GPL Invoice System is based Google Forms interactive subsystem

• 
  

GPL Technologies - Google Sheets

GPL system was developed based on Google Open Technology Platform.

• Google Sheets (Excel SpreadSheets)

  • This GPL backend data base storing all property related data

  • Formula: ArrayFormula

  • Query Language

• Pivot Tables

  • BI - Business Intelligence drill down

  • OG# - Ownership such as OG06 (OG06-2, sub account for the same owner)

    • Property such as 123 Jimmy

      • Type such as Rent, Utility, HOA, Repairs, etc

        • Expenses in dollar amount

  • end