GPL Rent Collection 

Tenants may pay the rent with the following online payments or local banks:

Zelle 

Venmo  

• Login on WebSite to get some transaction history 

CashApp

• CashApp Update: https://docs.google.com/spreadsheets/d/1pmA4FmIzLUPWShewKSLHI5eRiy2zn7ANjPItuQS9CuA/edit?usp=sharing

PayPal

• PayPal WebSite: https://www.paypal.com/myaccount/summary

• Download activities in .zip file => monthly statements in pdf => Manual copy text based entries and then parse manually => very inconvenient

• Needs some manual edits since the data is not numeric based

Chime

• Manual edit the data

• Chime Data needs be integrated with PayPal data manually

End

Wells Fargo Bank

• Payable to: Gordian Properties LLC

• Download csv file and input to WF Data here: https://docs.google.com/spreadsheets/d/1NF4iazbmCNsAGcaT7D34--sxltOb77umLUtmLcb7o-U/edit?usp=sharing

• WF UT Sheet: Needs manual update

Bank of America

• Payable to: Gordian Properties LLC

• https://secure.bankofamerica.com/login/sign-in/signOnV2Screen.go

• Download csv file and input to BOA Data here: https://docs.google.com/spreadsheets/d/1UgFHrznQTIgDfiJKD2joi6QB-i3pSem-bcCoURe4QhU/edit?usp=sharing

• 
  

BMO (used to be Bank of West)

• https://usdigital.bmo.com/www/#/login

Citi Bank

• Manual Input: https://docs.google.com/spreadsheets/d/1sGiCcg76B-sSUcRH5ZOvfvsXjt4GtDibb2ofW38ARyo/edit?usp=sharing

• Change date and balance with <> below:

  • <11/06> Citibank Global Transfer 10/04 03:31a 0005262228406924093 231004CITIBANK MOBILE 2,800.00 <7,873.14>

Chase Bank

California Bank

Using the following sheet to input lease terms such as rent amount, pet fee, utils flat fee

Also add some adjustments as needed

URL https://docs.google.com/spreadsheets/d/1PpbM5wMI-l_7awBIc2-kMcDwJqZnUi-d0FkL5iXGN0Y/edit?usp=sharing

Document: GPL Lease

Sheets: MonthlyDue