To get to view forms, you must first navigate to the LoanBeam Excel add-in in the excel ribbon.
You will need to login to the LoanBeam Add-in first. Click on the "Login" button.
You can view, select and deselect all the forms that are used in the qualifying income calculation by clicking on the "View Forms" option.
"View Forms" shows the "Tax Forms" that are submitted for processing and are used in the QI calculation in the template.
The Tax Forms are further divided into four groups and each group has their own output forms.:
- 1040: U.S. Individual Income Tax Return
- 1065: U.S. Return of Partnership Income and Schedule K-1
- 1120s: U.S. Income Tax Return for an S Corporation and Schedule K-1
- 1120: U.S. Corporation Income Tax Return
The 'View Forms' window is split into 'Current Year' and 'Prior Year' panels.
In case you do not want to view the data in the excel file uncheck the box next any of the Tax forms, Transcripts, IRS Forms either in the current or prior year panel.
The data for that particular fields will not be seen in the Excel.
Check the box again, to restore the values from the forms into the calculation.
The data will now populate in the respective fields.
You can also skip the entire tax year (current or prior) by deselecting the box. It will exclude all the forms relating to that tax year in the Income calculation.
The system will verify and match the Social Security Number of the tax payer and spouse (if applicable) on the form 1040 with the Schedule K-1 SSN. In case the SSN of K-1 and 1040 do not match, then data from that particular K-1 will not be populated in the excel output. However the same will be available in View Forms with an which are not checked. You may check the box in case you want to include the data in the excel output.