Designing a simple tenant ledger

SUGGESTED

I'm a controller for a multi-family firm. Recently, I was informed by one of our attorneys that the Sage-supplied tenant ledger is too confusing. He has refused to take it before a judge because he doesn't think it will be easy enough for a judge to understand. 

Is there a way for me to design a simple tenant ledger that just shows a charge or payment on a line and then shows a balance?

Here's an example of what I'd like:

Date Description Charge

Payment

Balance

1/1/17 Rent Charge 500.00 500.00
1/2/17 Payment #200 495.00 5.00
1/3/17 Payment #201 10.00 -5.00

I've made a few attempts at this, but I'm still very inexperienced. If anyone has any hints at how to get this done, it would be much appreciated. 

  • 0
    Krash, can you use the Check Register inquiry and export it to Excel? AP.. Inquiry.. Cash Management.. Check Register.. Filter by Payee. Then, export to excel and then use a formula to calculate the running balance. Delete any unnecessary columns and print it. Would that do it for you? Otherwise, you'd be looking at a new report in Report Designer or in Crystal Reports.
  • 0 in reply to PSK
    SUGGESTED
    Krash, I recently created a simple tenant ledger for a client using Crystal Reports, but pulled the billing information only from the General Ledger, using the Unit ID that was contained in the Reference 1 field of the General Ledger transaction in the revenue accounts (accrual account). We included columns for Transaction Date, Type of Charge (from the GL Account description), Rent, Concession, Parking, Storage, Exp Reimb, Other and Total. All sorted in date order. Beautiful report. The same information could be pulled from the PM Transaction Record including payment information and presented in the same way. It merely requires writing formulas to specify the Charge Type for each column where you want detail, or simply three formulas, one for charges, one for payments, and a balance column that shows the net. Of course if you utilize all the various transaction types, including adjustments and applying deposits etc you'll need to get more sophisticated with your formulas.
  • 0
    SUGGESTED
    I'll add one more suggestion that has worked well for others. Try the Tenant Activity Report instead. It's a summarized version of the Tenant Ledger so it's found to be less confusing.