Loan Level Detail


At the heart of our mortgage loan software, the AMB system has the ability to record transactions at loan level. What is truly unique about this capability is that it exists at a fundamental level of the system and not as an afterthought. The result is that entering or reporting on loan level activity is seamless and easy. In addition to the capability to manually enter data at loan level is the extensive capability to import transactions at loan level. These imports have made the use of loan level detail viable. They have also allowed us to develop procedures relative to the different types of loan level entries encountered on each loan, the funding, the warehouse advance, the purchase and the warehouse settlement. The funding data can be downloaded from the Loan Origination system. The warehouse advance and settlement entries can generally be downloaded from the respective warehouse lender’s web sites and the purchase transaction can either be downloaded from the LOS or entered using a form in AMB that was designed specifically for that purpose. By building a consistent approach for each of these transaction types we can minimize errors and dramatically improve the speed of entry.

Reconcile balance sheet accounts more quickly – the GL Reconciliation report was designed to show which loans comprise any account balance as of any date. At the push of a button you can see which loans comprise the Warehouse Line Payable, Loans Held for Sale, Appraisal fees Payable or even your Trust Cash accounts.

See errors more easily – the Multi-Account Reconciliation report allows you to see which loans comprise multiple GL account balances. Each account appears as a separate column on the report. Comparing Loans Held for sale to multiple warehouse line balances has never been easier.

Quickly report on income by loan using numerous fields from our borrower database.

The Multi-Account Reconciliation report shows not only the income and expense accounts comprising the net income on the loan but the ability to include borrower data allows the user to easily include loan amount, loan officer, loan type , branch code and any other field from our borrower table to enhance the report. Because any number of columns can be used, the report goes directly to Excel where you can format the data any way you like.

Quickly see every transaction on a single loan.

The Transactions by Loan Number report allows the user and your auditors to quickly analyze the activity on a loan. Did you get the appraisal money? Did you pay the Flood cert? These questions can be answered in seconds without leaving your desk.

Quickly see loan level detail by GL Number – Our Transaction by GL and Loan Number report shows the specific transactions comprising the balances of an account. This report offers numerous options such as limiting the activity by those loans within a given state which has proven ideal when preparing for state banking audits.

Quickly see the income on a population of loans. Called the Funded Loan Report because of its original focus on funded loans, the report has long since been enhanced to run based on a number of dates within our borrower table. Loans funded or sold or initiated or just having activity within a given period are easily reported and the you get to control the contents of each column on the report. It’s basically the Multi-Account reconciliation report on steroids.

P&L by Loan Number – Provides a P&L on a loan by loan basis. Any questions about whether or not you made money on a loan can be answered in seconds. Using our unique Budget by Type capability, the report will compare the income planned for a given loan amount and loan type to what actually occurred.

P&L by Loan Officer – The P&L by Loan Officer report allows you to quickly see the profitability of each loan officer.