All tools
Close & Review

AR & Tenant Prepays Workpaper

Upload the Aged Receivables detail (all accounts and past tenants), Tenant Prepays, GL 4190 detail, Charge Detail and Tenant Listing, pick the AME period, and download the 1400 / 2300 workpaper — both GL tie-outs, the past-tenant write-off grid with the bad-debt roll-forward, and every prepay explained.

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.