Checks and Balances for the Accounting Division

Each Division is accountable for their overall performance of the office, both on an individual basis as well as on a team basis. These activities are assessed by division and analyzed by management on a Daily, Weekly, and Monthly basis in order to determine the level of achievement as well as the overall health of the organization.  The following is a checklist of items for the accounting division which has been been listed out in the order of the frequency needed to make sure their progress remains constant without becoming mundane. Following is the proper instruction on how to correlate and reconcile these activities within the m1Solutions System.

Weekly
One Touch
  1. Make sure the One Touch System is being followed
  2. Open bottom drawer of two set cabinet to the right of the computer screen.
  3. Make sure month and date on the first pendaflex “folder” (the one closest to you) is set to the current month and tomorrow’s date. That indicates that the current date has been pulled and is in the workbox.
  4. There is an awaiting call back folder anything that is pending will go on this folder.
  5. Organize your in-box and work-box
  6. Check Voicemails
Late Fee Totals
  1. Run report Resident Ledger - Non-rent owned (80A) to confirm that this action is being accomplished weekly on late fees
  2. Notices out: make sure outstanding rents have been issued a 3-day notice as well as having late fees applied through the Late Fees Management screen. All items must be check marked therefore no check box will show. A check box appearing means that person has not been issued late fees. This screen will also give you information on partial rents (colored pink). See colors on top for more information. Note: this screen only shows active residents.
  3. (Tree View>ACCT Receivable>Late Fees>Late Fee Management>Resident Name>Resident Detail>Notice History)
Closeouts on Target
  1. Under reports in the tree, run the Closeouts (79) report (under property) and select dates from 01/01/ YYYY to 12/31/YYYY. This will give you a snapshot of all closeouts completed, in progress, and to come.
  2. To look at properties that are currently in progress to finalize, you can check on the steps by going to Property on the tree, then Closeout Ledger. You will automatically see properties under closeout status or in progress. Make sure all dates are updated and file is on schedule to be completed.
Security Deposits on Target
  1. Under reports in the tree, run the Security Deposit Disbursement (74) report (under resident) and select dates from 01/01/YYYY to the last date of the current month. This will give you the information of all security deposits completed, in progress and to come.
Daily Accounting reports ran - Daily Balance
  1. Grab Daily Balance ring-binder for each account from overhead, the front page should be the day prior’s report filled out accompanied by the General Ledger (76) report and the Owner Balances (15) report.
Gold Book Balanced
  1. There is no gold daily balance. Only deposits are placed in the gold book. On a deposit, reports Security Deposit Ledger (77) and Security Deposits Held (17) are run and made sure they balance. Additionally, on each deposit a copy of the deposit detail from bank is attached
Utilities On/Off
  1. Pull Utility Log ring-binder and reconcile "move-outs" and "move-ins" in alphabetical order to make sure the "turn on" dates and "turn off" dates have been updated.
Temp. Lawn Service On/Off
By Work Order

Going off of the Internal Leasing Report (ILR) .click on the CC link for each property up for rent.

  1. Under the command center screen of each property for rent:
    1. Click work order history
    2. Under the search criteria on the top part of the screen, select recurring work orders
    3. Click search
    4. It will show you if any recurring work orders (temp. service) has been issued.

You can use the "Back" link in the horizonal menu to go back the the ILR.

By Recurring Work Order

Alternatively, You can look up recurring work orders

  1. you can click on leasing under the tree instead of having to search properties under command center
  2. Then click  Internal Leasing Report (ILR) .
  3. Click on the property detail/internal post for the property you are checking
  4. Then the select the work order (w/ord) link from the horizontal menu, on the top right side of the screen
  5. Under the search criteria on the top part of the screen, select recurring work orders
  6. Click search
  7. It will show you if any recurring work orders (temp. service) has been issued.
    1. If there is no work order issue, the property might have permanent lawn service by owner or no lawn.
Outstanding Rents
  1. The list of outstanding rents can be checked through:
    1. Accounts Receivable under the tree
    2. Then click on the Late Fees Screen
    3. In the Late Fee management Screen, click LOAD
    4. Every property in there has outstanding rent owed.
Thank you Cards
  1. Open top drawer of two set cabinet to the right of the computer screen.
  2. Folders are organized in alphabetical order, Thank you folder is towards the back.
  3. Most recently mailed out thank you card will be on the front with the date on the top right hand corner. It should have the date of the last Friday prior to the date being checked.
Daily Calendar Check
  1. Open top drawer of two set cabinet to the right of the computer screen.
  2. Folders are organized in alphabetical order. Daily Calendar folder is towards the front.
  3. Most recent calendar will be on the front, it should be the previous business day.
Self Development (weeks 2, 3, and 4)

An email is sent to management by the team member to alert them this task has been completed and snippet of what was accomplished that week.  

Monthly
Check Outstanding Checks- Over 90 Days

From the Reconciling activities, there will be a list provided monthly for any checks outstanding from 2 months prior which are to be worked on.

Rent Increases- On time / Detail updated / Fees
  1. Rent increase reports are sent with GB reports on the last Friday of the month. It includes a copy of the Lease Expiration (27) report and Code Summary (23) reports for code 207 and code 209 showing fees have been taken.
  2. Rent increases are processed on the 15th or the next business day in case it falls on a weekend.
  3. Using the Month-end Close Out report you can reconcile each resident detail and ledger to make sure fees were taken.
  4. For Lease Renewals, those are started by leasing and submitted to Management on the 15th of the month, once Management completes his checks he will then send to accounting.
  5. Accounting then sends the letters to owners to get approvals (1 week deadline) and the lease renewals are mailed and emailed to residents by the end of the month.
Management Fee Increases / Modifications
  1. These are not done every year, but if they were, they would be across the board and similar to the lease renewals. Running the report on the 15th of the month prior, working on details, then sending out to owners via email 60 days in advance to their effective date. Effective date the 1st of the month after their management agreement expiration.
  2. Management Fee increase reports consist of the Owner Expiration (24) report and Code Summary (23) reports for code 201 showing fees have been taken.
Check Supervisory Fees - Invoice / Collected
  1. Supervisory Fee reports are sent with GB reports on the last Friday of the month. It includes a copy of the Job Estimate Management Screen for the month, (Tree View>Maintenance>Job Estimates>Job Estimate Management); filter by dates from the 1st to the last day of the month.
  2. the Code Summary (23) report for code 250 showing fees which have been taken, a copy of the invoice marked paid (if paid), and a copy of the invoices used to generate supervisory fee invoice).
  3. Supervisory Fees are processed on the 15th or the next business day in case it falls on a weekend.
  4. Using the Month-end Close Out report you can reconcile each ledger to make sure fees were taken.
  5. On the cover sheet of that report a red checkmark will show invoices paid and an R for retains set on those that did not have enough funds to be paid, and a P for pending rehabs.
Check Rent Up Fees Collected
  1. Click reports on the tree
  2. Then select Code Summary (23) report under accounting
  3. Select dates for report (the current month being inspected)
  4. Ledger code 202
  5. Click search

This is to be reconciled with the Properties Rented report:

  1. Click reports on the tree
  2. Then select Resident Rented (28) report under leasing
  3. Select dates for report (the current month being inspected)
  4. Select date rented (NOT move in date)
  5. Click search

Using the information on those two reports will help you reconcile. Make sure all properties rented show under code 202 in the Code Summary (23) report .