| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Week | Details | India Team | US Team | Location | Comments | ||||||||||||||||||||
2 | Monthly | |||||||||||||||||||||||||
3 | Monthly | Reports | Run all Reports | 1. Review all Reports - Check inconsistencies by 7tth of every month * AR Ledger * AP Ledger * AR Aging * AP Aging * 12 Month Forecast * General Ledger * 12 Month Trial Balance * Bank Reconciliation * Balance Sheet * Profit and Loss Report 2. Mail Sunny by 7th of every month * AR Aging & AP Aging with details of pmts to be released | DEADLINE : 7th of Every Month | |||||||||||||||||||||
4 | Monthly | Bank Recon | Bank Recon | Review Bank Recon - All Companies | DEADLINE : 7th of Every Month | |||||||||||||||||||||
5 | Quarterly | |||||||||||||||||||||||||
6 | Quarterly | CAM Recon | Complete Quarterly CAM Reconciliation | Review - Quarterly recon - Check income and expense numbers, Review all reports with Sunny Every Quarter | DEADLINE : 10th of Every new Quarter | |||||||||||||||||||||
7 | Quarterly | Reports | Close Books on Quarterly basis and discuss Profit and Loss with Sunny | Review P&L with India team and make any adjustments | DEADLINE : 10th of Every new Quarter | |||||||||||||||||||||
8 | Quarterly | Training | Update - training document - New procedures and practises | Look at New Software Capabilities and incorporate them in our work | DEADLINE : 10th of Every new Quarter | |||||||||||||||||||||
9 | Week 01 | |||||||||||||||||||||||||
10 | Week 01 | ARs | Run Scheduled Charges - Current month | Check - Scheduled Charges - Run correctly | DEADLINE: By 1st of Every Month | |||||||||||||||||||||
11 | Week 01 | ARs | Complete GL Entries | Upload - Bank Transactions & Statements - All Companies - Explain the bank transactions | https://drive.google.com/drive/folders/1lRnaPItxlDERjJo6ZRhVdmJv1AYVKgEJ?usp=sharing | DEADLINE : By 23rd & 3rd of Every Month | ||||||||||||||||||||
12 | Week 01 | ARs | Check all entries completed from Bank Txn and Statements | DEADLINE : By 25th & 5th of Every Month | ||||||||||||||||||||||
13 | Week 01 | ARs | Build if any Manual Invoices e.g., HVAC/prop Mgmt etc and Upload on RP | Knowing individual repairs completed and ensuring AR invoices are built, sent to tenants and uploaded on RP - US Team mails tenants. India Team upload on RP | https://drive.google.com/drive/folders/1lRnaPItxlDERjJo6ZRhVdmJv1AYVKgEJ?usp=sharing | DEADLINE : By 23rd & 3rd of Every Month | ||||||||||||||||||||
14 | Week 01 | ARs | Run AR and report payments not collected to US Team | Follow up on unpaid amounts from previous month | DEADLINE : By 5th of Every Month | |||||||||||||||||||||
15 | Week 01 | APs | Collect (Download/email/collect) invoices from vendors | Support India Team to Collect (Download/email/collect) invoices from vendors | https://drive.google.com/drive/folders/1lRnaPItxlDERjJo6ZRhVdmJv1AYVKgEJ?usp=sharing | DEADLINE : By 5th of Every Month | ||||||||||||||||||||
16 | Week 01 | APs | Check - Invoices - Billed as per Contract Terms | Support India team in Checking - Invoices - Billed as per Contract Terms | DEADLINE : By 5th of Every Month | |||||||||||||||||||||
17 | Week 01 | APs | Book All Vendor Invoice on RP and upload invoices | Check 30 day Aging AP payments released | Check - AP invoices not received / corrections - follow up - Every Monday India Team sends any Qs for US Team purview | DEADLINE : By 5th of Every Month | ||||||||||||||||||||
18 | Week 01 | APs | Build Any Manual and inter company invoices - current month and Upload | Provide Plan of what to bIll and Who? - Provided on subsequent tabs on this document - THhis is on the SNDA Bible | https://drive.google.com/drive/folders/1lRnaPItxlDERjJo6ZRhVdmJv1AYVKgEJ?usp=sharing | DEADLINE : By 23rd & 3rd of Every Month | ||||||||||||||||||||
19 | Week 01 | APs | Check - AP invoices not received / corrections - follow up | Support India Team | DEADLINE : Every Monday | |||||||||||||||||||||
20 | Week 01 | Reports | Generate all reports for previous month for all Companies below and upload: | Check 9 Reports - All Companies - Correct / Ask Qs | Upload Location - Each company has Folder for Reports | DEADLINE : 23rd of Every Month | ||||||||||||||||||||
21 | Week 01 | Reports | * AR Ledger | Check - Income & Expenses | DEADLINE : 23rd of Every Month | |||||||||||||||||||||
22 | Week 01 | Reports | * AP Ledger | Florence:-Design a process for India team to --Scrutinize all reports or what Criteria by Report and call out -- Call Out AR Collections -- Call Out Pending AP payments and what was the work covered in that invoice -- Call Out anything worth mentioning in BS,P&L and 12 month -- | Florence:-Design a process for US team to --Scrutinize all reports or what Criteria by Report and call out -- Follow up on AR Collections -- Discuss Pending AP payments and next steps -- Discuss and address anything worth mentioning in BS,P&L and 12 month -- | DEADLINE : 23rd of Every Month | ||||||||||||||||||||
23 | Week 01 | Reports | * AR Aging | DEADLINE : 23rd of Every Month | ||||||||||||||||||||||
24 | Week 01 | Reports | * AP Aging | DEADLINE : 23rd of Every Month | ||||||||||||||||||||||
25 | Week 01 | Reports | * 12 Month Forecast | DEADLINE : 23rd of Every Month | ||||||||||||||||||||||
26 | Week 01 | Reports | * 12 Month Trial Balance | DEADLINE : 23rd of Every Month | 4121.71 | 8243.42 | ||||||||||||||||||||
27 | Week 01 | Reports | * Bank Reconciliation | Steps 1. Check all bank transactions liune by line with real page entries 2. Review Bank Reconicilation Report and make sure ending balance on last month bank statement and ending balance on current month bank statatememnt match with Real page | DEADLINE : 23rd of Every Month | |||||||||||||||||||||
28 | Week 01 | Reports | * Balance Sheet | DEADLINE : 23rd of Every Month | 2,948.42 | |||||||||||||||||||||
29 | Week 01 | Reports | * Profit and Loss Report | DEADLINE : 23rd of Every Month | 121.71 | |||||||||||||||||||||
30 | Week 01 | Reports | Upload all reports on drive | DEADLINE : 23rd of Every Month | 2,826.71 | |||||||||||||||||||||
31 | Week 01 | Reports | Bank Reconciliation - All Companies - Complete | DEADLINE : 23rd of Every Month | ||||||||||||||||||||||
32 | Week 02 | |||||||||||||||||||||||||
33 | Week 02 | ARs | Complete GL Entries - Since Last GL Entries | Upload Bank Txns & Stmts -till Date and Explain Complete AIs from Week 01 Meeting | ?? | DEADLINE : Every Monday | ||||||||||||||||||||
34 | Week 02 | ARs | Bill any new manual AR Invoices | Provide Plan of what to bIll and Who? - Provided on subsequent tabs on this document | DEADLINE : Every Monday | |||||||||||||||||||||
35 | Week 02 | ARs | Check - Pending AR payments and follow up with Customers on collecting them | DEADLINE : Every Monday | ||||||||||||||||||||||
36 | Week 02 | APs | Book any new invoices from vendors and inter company | Provide Plan of what to bIll and Who? - Provided on subsequent tabs on this document | DEADLINE : Every Monday | |||||||||||||||||||||
37 | Week 02 | APs | Check - Pending AP payments | DEADLINE : Every Monday | ||||||||||||||||||||||
38 | Week 02 | Reports | Complete Weekly touch base with Sunny/Florence / Gina | Review - ARs and Aps - Collections and Payouts | DEADLINE : Every Monday | |||||||||||||||||||||
39 | Week 03 | |||||||||||||||||||||||||
40 | Week 03 | ARs | Complete GL Entries - Since Last GL Entries | Upload Bank Txns & Stmts -till Date and Explain | ?? | DEADLINE : 5th of Every Month | ||||||||||||||||||||
41 | Week 03 | ARs | Bill any new manual AR Invoices | Provide Plan of what to bIll and Who? - Provided on subsequent tabs on this document | DEADLINE : 5th of Every Month | |||||||||||||||||||||
42 | Week 03 | ARs | Check - Pending AR payments and follow up with Customers on collecting them | DEADLINE : 5th of Every Month | ||||||||||||||||||||||
43 | Week 03 | APs | Book any new invoices from vendors and inter company | Provide Plan of what to bIll and Who? - Provided on subsequent tabs on this document | DEADLINE : 5th of Every Month | |||||||||||||||||||||
44 | Week 03 | APs | Check - Pending AP payments | DEADLINE : 5th of Every Month | ||||||||||||||||||||||
45 | Week 03 | Reports | Complete Weekly touch base with Sunny/Florence / Megan/ Gina | Review - ARs and Aps - Collections and Payouts | DEADLINE : 5th of Every Month | |||||||||||||||||||||
46 | Week 04 | |||||||||||||||||||||||||
47 | Week 04 | ARs | Complete GL Entries - Since Last GL Entries | Upload Bank Txns & Stmts -till Date and Explain * Check AI's from Week 3 have been completed | DEADLINE : Every Monday | |||||||||||||||||||||
48 | Week 04 | ARs | Bill any new manual AR Invoices | Provide Plan of what to bIll and Who? - Provided on subsequent tabs on this document | DEADLINE : Every Monday | |||||||||||||||||||||
49 | Week 04 | ARs | Check - Pending AR payments and follow up with Customers on collecting them | DEADLINE : Every Monday | ||||||||||||||||||||||
50 | Week 04 | APs | Book any new invoices from vendors and inter company | Provide Plan of what to bIll and Who? - Provided on subsequent tabs on this document | DEADLINE : Every Monday | |||||||||||||||||||||
51 | Week 04 | APs | Check - Pending AP payments | DEADLINE : Every Monday | ||||||||||||||||||||||
52 | Week 04 | Reports | Complete Weekly touch base with Sunny/Florence / Megan/ Gina | Review - ARs and Aps - Collections and Payouts | DEADLINE : Every Monday | |||||||||||||||||||||
53 | Yearly | |||||||||||||||||||||||||
54 | Yearly | Complete CAM Reconciliation | Review CAM Reconciliation prepared by india team | Florence: Document CAM reconciliation process. Ask megan for Help for recording screens and other ways to document and embed on this document | DEADLINE : By 4th week of January | |||||||||||||||||||||
55 | Yearly | Annual CAM Recon - Prepare Invoices to Tenants for collection | Annual CAM Recon - Send Invoices to Tenants for collection | DEADLINE : By 31st of January | ||||||||||||||||||||||
56 | Yearly | Taxation Review - Corrections/Adjustments with management | Review Income and Expense numbers | DEADLINE : By 2nd week of December | ||||||||||||||||||||||
57 | Yearly | Annual Closing - Processes | Renewal of AMC Contracts with Vendors | DEADLINE : Depends of renewal date - refer AMC Vendor Excel | ||||||||||||||||||||||
58 | ||||||||||||||||||||||||||
59 | ||||||||||||||||||||||||||
60 | ||||||||||||||||||||||||||
61 | ||||||||||||||||||||||||||
62 | ||||||||||||||||||||||||||
63 | ||||||||||||||||||||||||||
64 | ||||||||||||||||||||||||||
65 | ||||||||||||||||||||||||||
66 | ||||||||||||||||||||||||||
67 | ||||||||||||||||||||||||||
68 | ||||||||||||||||||||||||||
69 | ||||||||||||||||||||||||||
70 | ||||||||||||||||||||||||||
71 | ||||||||||||||||||||||||||
72 | ||||||||||||||||||||||||||
73 | ||||||||||||||||||||||||||
74 | ||||||||||||||||||||||||||
75 | ||||||||||||||||||||||||||
76 | ||||||||||||||||||||||||||
77 | ||||||||||||||||||||||||||
78 | ||||||||||||||||||||||||||
79 | ||||||||||||||||||||||||||
80 | ||||||||||||||||||||||||||
81 | ||||||||||||||||||||||||||
82 | ||||||||||||||||||||||||||
83 | ||||||||||||||||||||||||||
84 | ||||||||||||||||||||||||||
85 | ||||||||||||||||||||||||||
86 | ||||||||||||||||||||||||||
87 | ||||||||||||||||||||||||||
88 | ||||||||||||||||||||||||||
89 | ||||||||||||||||||||||||||
90 | ||||||||||||||||||||||||||
91 | ||||||||||||||||||||||||||
92 | ||||||||||||||||||||||||||
93 | ||||||||||||||||||||||||||
94 | ||||||||||||||||||||||||||
95 | ||||||||||||||||||||||||||
96 | ||||||||||||||||||||||||||
97 | ||||||||||||||||||||||||||
98 | ||||||||||||||||||||||||||
99 | ||||||||||||||||||||||||||
100 |