Reports > Accounting > AMB Loans Funded Journal Entry Export (Closing)
The AMB Loans Funded Journal Entry Export (Closing) report creates the accounting transaction for recording the assets created and the fees earned by the funding of a loan (the funding entry). This transaction is based off of the fees that were recorded on HUD PAGE 2 in the Closing Docs.
For loans submitted prior to October 3, 2015, the logic used must match the GFE /HUD fees (when to use the base vs the total loan amount, etc.) If the user runs this report and the HUD PAGE 2 fees are not available, the system will use the GFE values available.
For a loan to appear in this report: Closing Docs > Settlement Date must be between the Settlement Date Range selected.
Include Cancelled Loans check box is available if cancelled loans are to be included in the report findings.
Include Archived Loans check box is available to be marked if archived loans are to be included in the report findings.
A Settlement Date Range can be selected and will be the date range that determines the loan files that will fall into the report based on the settlement date of the loan.
Enter in the Records/Page amount which can range between ten and two hundred.
Click Submit after all applicable information has been entered.
AMB Loans Funded Journal Entry Export (Closing) results will display.
A Printer Friendly Version link will display and if clicked, users will have the ability to print the report results.
The Beginning Date and End Date previously entered on the Report Filter will display in the upper left corner of the screen.
A Return to Report Filter link will display and if clicked, the user will return to the report filter to make changes and re-run the report.
The Report results will display with the following parameters: Reference Number, Alternate Vendor Code, Vendor name, Joint Payee, Funding Date, Invoice Number, Loan Number, Loans Held For Sale, Origination Fee, Loan Discount Fee, Appraisal Fee, Credit Report Fee, Tax Service Fee, Flood Certification Fee, Lender Credit Fee, Yield Spread Premium, VA Funding Fee, Buydown Fee, Line 811 Fee, Line 812 Fee, Line 813 Fee, Line 814 Fee, Line 815 Fee, Line 816 Fee, Line 817 Fee, Line 818 Fee, Line 819 Fee, Line 820 Fee, Line 821 Fee, Line 822 Fee, Line 823 Fee, Line 824 Fee, Line 825 Fee, Escrow, Interest, Cost/Rebate to Broker, and Wire Amount.
To Export the report in CSV format, click the button in the upper right corner of the screen, Export CSV. To review the report, click the Download Report link. To save the report to a local computer, right-click the Download Report link and click Save Target As.
To Export the report in Tab format, click the button in the upper right corner of the screen, Export Tab. To review the report, click the Download Report link. To save the report to a local computer, right-click the Download Report link and click Save Target As.