Monthly Account Listing
From MagnOogle Magna WIKI
Contents |
[edit]
MONTHLY ACCOUNT LISTING
Selected from reports menu. Prints portfolio or combinations of portfolio's with current months results and delinquency information in a variety of sorts. Includes a recap of the delinquency status. There are many variations of the report that modify the heading on the page and the included columns, or just displaying the totals at the bottom of the page.
This report could also be called the Trial Balance report, or the Delinquency Report because it show all that information on one report, making it very handy. You can also turn this into the Past Due Report
[edit]
Getting There
Magna Computer Sys:12/07/2006 11:04 james
┌────────────────┌──────────────────────────────────────────┐
│ M O R T G A│ -M O R T G A G E R E P O R T M E N U- │
│────────────────│──────────────────────────────────────────│
│ Account Look-up│*Monthly Account Listing* │
│ EX Account Look│ Current status detail │
│*Reports Menu │ List Transactions │
│ Billing Menu │ List Transactions by entry date │
│ Letters Menu │ List Today's Activities │
│ Maintain Bank C│ Bad/No Phone number list │
│ Address Changes│ Uninitialized Accounts ┌────────────────────────────┐
│ Amortization Ta│ Receivable/CC/RCI fee by │ Monthly Account Listing │
│ Generate ACH Dr│ Receivable/CC/RCI fee by │────────────────────────────│
│ Funding Entries│ Low Balance Report │>Regular <│
│ 1098 Reporting │ Lendor Code Summary │ No Recency Delinquency │
│ Change Default │ Notes Printout │ Regular Fund │
│ Unix Menu │ Notes Printout per contra│ Alternate Format │
└────────────────│ Notes Printout per Employ│ Totals Only │
│ List recordings for ALL a│ Selction Criteria Removed │
└──────────────────────────└────────────────────────────┘
F1=Help Ctrl-A=UnixMenu Ctrl-C=Exit F7=Email F10=Backup One Menu
[edit]
Setting the parameters.
MONTHLY ACCOUNT LISTING Sys:12-07-2006 11:06 james ┌────────────────────────────[REPORT PARAMETERS]────────────────────────────┐ │ Journal Date: 12-07-2006 Month: Year: │ │ Enter ownership to match: │ │ Enter status to match: Up to 30days=Current: │ │ Zero Balance: Delinquency Days │ │ Sort order: Lower limit: │ │ Upper limit: │ │ Print Exception List: │ │ Fund Code to Match : │ │ Fund Transmittal Nbr: thru Min Fund Date: │ │ Max Fund Date: │ └───────────────────────────────────────────────────────────────────────────┘
- Journal date: may also be considered the " as of " date or cutoff date.
- Ownership to match: match string of account types or ownership.
- Receivable's status: print accounts with these status, single status code from the status field on the mortgage screen.
- Zero Balance: what to do with paid out accounts
- Sort order: define the order of the accounts
Selecting output:
Select printer for spooling to printer or file to print multi-copies.
[edit]
Report headings:
[edit]
Regular Monthly Account Listing
- O: Ownership (or Portfolio) of account or account type
- F: Funding Code on account. The code that will be transfered to the Ownership code after funding.
- KR STS: a combination of the contractual status (from the contract) and the Receivable status from the mortgage header information. Even though they are displayed together they come from two different areas.
- NAME: name of account
- RC: Recording Status
- CT: Country is foreign (non-us)
- PRIN. BALANCE: principal balance
- % OF EQUITY: ratio of the sales price to current prin. balance
- PAYMENT DUE: regular monthly payment
- AMOUNT: total of payments received this month
- PRINCIPAL: portion of payment that went to prin.
- INTEREST: portion of payment that went to interest
- CUMM. DUE: no. of pmts expected to date times the regular payment
- CUMM. PAID: cummulative payments received
- CON DEL: contractual delinquency (CUR current, CHG charged off, number of days delinquent)
- RCY DEL: recency delinquency, number of payments in last 3 months.
[edit]
Monthly Account Listing Example
See more about this report here. Montly_account_listing_example
