Skip to content

AP Schedule

This page sets the weekly AP schedule and the daily open invoice log. It is the standing rhythm once AppFolio is deployed for the whole office. During rollout, REA double-books every invoice in both MRI (our old AP system) and AppFolio.

For full invoice intake, REA posting, Smart Bill Entry, and approval detail, see the AP Processing Workflow.

Weekly Schedule

DayPersonTasks
DailyREAPost invoices to MRI and AppFolio
DailyIn-house controllersPost mortgage payments
Daily (end of day)Rachana or REASave the open invoice report to the Open Invoice Log folder
Bi-weeklyLilyPull online utility account billing
TuesdayMarsha (REA)Review the open invoice list
WednesdayAnna, Mike, RachanaReview open invoices, then review with Lily and Randy for check-cutting input
ThursdayOdeirre, DeeCut checks and make payments
FridayMike, Anna, RachanaReview open invoices and use open invoice dashboard to compare changes between Wednesday and Friday

Daily Open Invoice Log

At the end of each day, Rachana or REA saves the MRI open invoice report to the Open Invoice Log folder. This gives the Tuesday and Wednesday reviewers a dated snapshot of every open invoice.

Save Location

Z:\Shared\BBT Asset Management Inc\Accounting\REA_Invoices\Open Invoice Log

Save each export as yyyymmdd.xlsv (for example, 20260603.xlsv).

  • DirectoryREA_Invoices/
    • DirectoryOpen Invoice Log/
      • 20260603.xlsv
      • 20260602.xlsv
    • Directory06-03-2026/

Steps: Export the Open Invoice Report

  1. Open MRI Query
    From the MRI home screen, click MRI Utilities, then MRI Query.

    MRI Utilities and MRI Query

  2. Load the saved query
    Click Select Query, choose OPENINVLOG (LOG OPEN INVOICE), then click Select.

    Select the OPENINVLOG query

  3. Run and export
    Click Execute to run the query, then click Export Excel.

    Execute and Export Excel

  4. Save the file
    Save the export to the Open Invoice Log folder using the yyyymmdd.xlsv format.