Builds the 1400 / 2300 workpaper from seven RentManager reports: both GL tie-outs, the past-tenantwrite-off grid with the bad-debtroll-forward, and every tenant prepay explained. The files are read by the EXOedge engine and are not stored.
1. Upload files
Aged Receivables – Detail Required, one file
RentManager Aged Receivables report, all accounts, as of AME end. CSV or Excel export, either works.
Aged Receivables – Past tenants Required, one file
The same Aged Receivables report run for past accounts only. CSV or Excel.
Tenant Prepays Required, one file
RentManager Tenant Prepays report, detail, all tenants. CSV or Excel. The phone column is dropped on upload and never stored.
GL 4190 detail Required, one file
General Ledger detail report for account 4190 Bad Debt Expense, AME month only. CSV or Excel.
Charge Detail Required, one to three files
RentManager Charge Detail for the AME month, with the month before and after if available. CSV or Excel. Skip rent, credits and payment activity.
Tenant Listing Required, one file
RentManager Tenant Listing, all tenants including past. CSV or Excel. Move-out, lease-end and future move-in dates.
Trial Balance Required, one file
RentManager Trial Balance for the AME month. CSV or Excel. The 1400 and 2300 balances are read from it; nothing is typed.
Prior month workpaper Optional, Excel workbook
Last month's finished 1400 / 2300 Excel workbook, as saved by the accountant. Seeds the table of change and the FCO dates.
Files go to the EXOedge engine over your signed session and are not stored.
2. Period & settings
Days after FCO before balance is written off.
Used in the file name.
Used in the file name.
Add the seven required reports to begin.
3. What the reports do not carry ()
FCO is the final charge-out date, when the move-out account was finalised; W/O = FCO + policy days. SD & payments to adjust is the security deposit on hand plus payments after the report cut-off. Nothing typed here is stored beyond this run.