Contents
- Index
Interfaces: Leveraged Financing
The leveraged fianancing interface will create a journal for exporting to an external ledger.
How To
The leveraged fianancing interface is always run for one full month. The date range is used to extract any leveraged fianancing that was active within that range.
You must select the Leveraged Banks in the grid to include in the journal extract.
Use the buttons in the Interface Run Option box to select the date range to use for this export.
All journals created will be passed to the Journal Export screen for review and export.
If you have more than one leveraged financing bank, you may limit the interface extract to the specific banks selected.
Test for Interest
Sometimes, the leveraged financing bank will not calculate interest based on the the number of days in the month. You can use this box to override the number of days that ALMSys uses to what the bank used.
Steps to override:
1. Set the calanders to the date range of the leveraged financing data.
2. Enter a control number in the test box that is in the bank's data.
3. Click the Calculate Interest button.
This will give you the beginning principal balance, the normally calculated principal and interest (Defaults column), and then 7 alternate interest calculation in the Interest column of buttons.
If the default interest amount is correct, then run the interface using one of the buttons in the teal box (Interface Run Options).
If the interest is correct on one of the Interest buttons, then click the correct interest button and then click the Run Using Interest Days Selected button.
Bank Spreadsheet Analyzer
This feature will allow you to post a leveraged financing journal from what the bank breaks down as principal and interest.
The spreadsheet must have one page of non-stop entries. You must delete any row between the starting data row and the ending data row that is not data (such as subtotals, etc.).
To use this feature, set the date range on the calendars of the interface screen. (Do not use the Interface Run Options buttons.) Mark one of the "Limit to Specific Leveraged Bank(s)" that matches the bank whose spreadsheet is being used. Click the Open Analyzer Screen button.
The definition of the spreadsheet is kept with the leveraged financing bank, and it tells ALMSys how to read the spreadsheet. First, click the Locate the Spreasheet button and select the spreadsheet from the bank. In the Spreadsheet Specifics box, tell ALMSys the sheet (tab) number that has the data. Specify the row number of the first line of data, and the row number for the last line of data.
In the Set Columns for Search Fields box, specify the column letters for the items listed. You must specify principal and interest columns, along with at least one column for Control Number, Stock Number, and VIN. ALMSys uses those columns in order to find the deal in ALMSys. (If a deal is not found, that line will not be used.)
Once the Definition page has been filled out, click the Test Importing the Spreadsheet, as Defined Below button. This will import the spreadsheet data (you'll see a progress bar), look up the information in ALMSys, and take you to the Imported Results page, which will show you the analysis grid.
The grid will show columns from the spreadsheet, ALMSys information looked up from those columns, the calculated principal and interest for leveraged financing for the month specified, and the differences between the spreadsheet and ALMSys. If ALMSys information cannot be found, the the Notes column will state so and the ALMSys columns will be blank.
Non-matching Principal and non-matching Interest will be highlighted in the Differences columns. This grid is sortable by clicking on the desired column heading.
Only those rows which contain ALMSys information will be included in the journal.
When the grid is correct, click the Create Journal from Spreadsheet P & I button in order to create the journal.