Understanding the Fee and Interest Generation Process

Use the Fee & Interest Generation program (R15160) to generate a batch of invoices for fees and interest against accounts receivable invoices and adjustments for interest on security deposits. The program is based on the Customer Ledger table and controlled by the fee tables in the Fees and Interest table (F1525B).

You can calculate interest earned on security deposits. You must first set up the revenue bill code, such as INTR (interest) in a security group. After you calculate the interest earned, you can then generate the accounts payable voucher using the Security Deposit Refund Generation program (R15655) to refund the interest, the security deposit, or both.

Important: You can generate fees and interest for a tenant more than once in the same period until a batch is posted. If you inadvertently generate a batch of fees and interest, and have not yet posted it, you can delete the batch. The system deletes the batch header, the batch transactions, and the corresponding records in the Lease Billings History table (F1511HB). After you post a batch, you cannot delete it.

This table lists the tasks that you might perform after you generate fee and interest billing records to complete the billing generation process:

Task

Description

Generate the billing edit register (Required)

After you generate fee and interest records, you must run the XJDE0005 version of the Billing Edit/Register program (R15300) to validate the transactions in the batch and to change the batch status.

See Generating the Billing Edit/Register Report.

Review the invoice journal

You can review the batch of invoice fee records before you post them, and revise or delete transactions as necessary.

See Reviewing Transaction Batches.

Review the receipts journal

You can review the batch of receipt (adjustment) records before you post them, and revise or delete transactions as necessary.

See Processing Options for Receipts Journal Report (R03B311).

Post invoices (Required)

After you generate the billing edit register, you must post the billing transactions to generate the invoice records.

See Posting Invoices and Vouchers.

Post receipts (Required)

After you generate the receipt (adjustment) transactions, you must post them to update the general ledger.

See Posting Receipts.

Print invoices

After you post invoices, you can print and send them to the tenants.

See Printing Invoices.

Print statements

After you post invoices, you can print statements and send them to the tenants.

See Printing Statements.

Review billings transactions

You can review billing transactions in detail using the Billings Transaction Inquiry program (P15211).

See Reviewing Billing Transactions.

Review invoices

You can review the invoices generated from billing transactions using the Tenant Ledger Inquiry program (P15222).

See Reviewing Applied Receipts.

Review vouchers

You can review the vouchers generated from billing transactions using the Supplier Ledger Inquiry program (P0411).