Home
Procedures
Working With Financial Analysis Spreadsheets
This section is provided help while working with the financial spreadsheets for the Financial Analysis and Authorization screen.
Disbursement Schedule
The purpose of this form is to help keep track of disbursements.

Procedures
- New Loan Workflow
- Adding a Loan Party
- Adding an Individual Party
- Adding an Entity Party
- Adding a Sole Proprietorship Party
- Adding a Related Party
- Using Nested Entities
- Working with Loans
- Quick Quotes
  This procedure explains how to create a quick quote.
- Working With Financial Analysis Spreadsheets
  This section is provided help while working with the financial spreadsheets for the Financial Analysis and Authorization screen.
  - Opening the Financial Analysis Spreadsheet
    This section is provided help opening the financial analysis spreadsheets.
  - Importing a Financial Analysis Spreadsheet
  - Spread Setup
    The Spread Setup spreadsheet allows you to enter information for each period that you plan to enter financial information
  - Balance Sheet – Historical
    Use the Balance Sheet spreadsheet to enter the applicant's historical balance sheet information.
  - Balance Sheet - Pro Forma
    The Balance Sheet - Pro Forma tab is provided to compile the information from the Lender's Guaranty page.
  - Profit and Loss – Historical
    The Profit and Loss - Historical spreadsheet is provided to enter the three-year Historical P&L information and the interim information.
  - Profit and Loss - Pro Forma
    The Balance Sheet - Pro Forma tab is provided to compile the information from the Lender's Guaranty page.
  - Sales Schedule
  - COGS Schedule
  - Other Expense Schedule – Historical
  - Other Expense Schedule – Projections
  - Executive Summary
  - Financial Ratios
  - Net Worth Reconciliation
  - UCA Cash Flow
  - Business Valuation Tab 1
  - Business Valuation Tab 2
  - Monthly Profit and Loss
  - Monthly Cash Flow
  - Accts Receivable/ Pay Aging
    The purpose of the Accts Receivable/ Pay Aging form is to provide an exhibit to detail the age of the borrower's accounts receivable and accounts payable.
  - Statement of Financial Need
    This spreadsheet provides lenders in SBA Region 4 with the required SBA form for detailing the sources and uses of funds for startup businesses that are applying for a SBA loan.
  - Bal Sheet – Hist – Affiliate 1-20
  - P&L-Hist-Affiliate 1-20
  - Executive Summary - Affiliate 1-20
  - Personal Cash Flow - Principal 1-10
  - Global Cash Flow
  - Debt Summary
    The Debt Summary is used to provide one location to input all of the borrower's debts.
  - Collateral Summary
    The Collateral Summary is used to provide one location to input all of the borrower's collateral.
  - Income Statement
    Information entered into the Income Statement tab is used in the Credit Memo.
  - Credit Memo
    The Credit Memo tab contains the SBA Loan Report, allowing you to print the report when required.
  - Disbursement Schedule
    The purpose of this form is to help keep track of disbursements.
- Importing Loans
  Data must first be in an XML format that conforms to our Import schema, which can be found on our Software support web site.
- Importing Transaction Data
- Exporting Transaction Data
- Updating TSoftPlus
- Creating Submitting a Loan from TSoftPlus to ETran
  add short description here

Disbursement Schedule

The purpose of this form is to help keep track of disbursements.

The purpose of this form is to help keep track of disbursements.

Note the following:

The Use of Proceeds/Lender is automatically populated by TSoftPlus and cannot be edited. It is a combination of the following different Use of Proceeds found on the Loan Information tab.
- Land Acquisition
  - Purchase Land only
  - Land and Improvements
  - Purchase Improvements
- Construction
  - Construct a Building
  - Add to Existing Building
  - Renovate Existing Building
  - Pay Off Interim Construction Loan
  - Pay Off Lender's Interim Loan
  - Leasehold Improvements
- Machinery & Equipment
  - Purchase Equipment
  - Purchase Furniture and Fixtures
- Inventory Purchase
  - Purchase Inventory
  - Pay Trade or Accounts Payable
- Working Capital
  - Working Capital
  - SBA Guaranty Fee
- Acquisition of Business
  - Purchase Business Asset
  - Purchase Business Stock
- Payoff SBA Loan
  - Refinance SBA Loan (Not Same Institution Debt)
  - Refinance SBA Loan (Same Institution Debt)
- Payoff Bank Loan
  - Pay Notes Payable (not same Institution Debt)
- Other Debt Repayment
  - Pay Notes Payable (Same Institution Debt)
- Other
  - Other