(800) 234-1111

FINPACK News

Consolidating Detailed Balance Sheets and Tax Forms

by Pauline Van Nurden | Dec 1, 2017

Consolidating Detailed Balance Sheets and Tax FormsFarm and other small business credit analysis becomes increasingly difficult when the business owner(s) has organized into multiple entities. Commonly, multiple entities are created for tax and/or liability reasons. To aid in credit analysis for operations of this type, FINPACK allows users to quickly consolidate the balance sheets or tax forms from several different data files into a single file. By consolidating these financial statements, the lender can quickly garner the most complete, global financial picture of their borrower.

It is a best practice to consolidate Detailed Balance Sheets or Tax Forms from the different entities into a new data file and indicate this is a consolidated FINPACK file. Create a Detailed Balance Sheet or Tax Form of the same date as that of the other entities in the new consolidated file. Once created, the FINPACK user can select Edit +  Consolidate to bring each entity’s Detailed Balance Sheet or Tax Form into the consolidated FINPACK file. For more detailed information on the consolidating process see the FINPACK Knowledge Base.

Pauline Van Nurden joined the FINPACK Team as an Economist in 2017.

Prior to joining the FINPACK Team, she worked as a lender. This provides her valuable industry experience and knowledge in her work with FINPACK. Pauline holds a Master’s Degree in Agricultural Education and Bachelor’s Degree in Applied Economics, both from the University of Minnesota.

Latest News
How to Determine Schedule F Income in FINPACK

How to Determine Schedule F Income in FINPACK

Today’s post focuses on Schedule F income utilized in the Schedule F Cash to Accrual tool. This FINPACK tool takes cash income from Schedule F, along with beginning and ending balance sheets, to arrive at accrual adjusted income for the year.

Latest FINPACK Update Available Now

Latest FINPACK Update Available Now

The latest FINPACK update is version 6.4.8.219. The update will be applied automatically for FINPACK+ users. For users of FINPACK installed, you’ll need to update via the HELP menu inside FINPACK. Launch FINPACK and select Software Updates under the HELP menu. Click ‘Check for Updates’, then follow the steps to install.

FINPACK News March Digest

FINPACK News March Digest

FINPACK FAQs, Registration for FINPACK Lender Training, Consolidating Data Sources in FINPACK+, How to Import Data into FINPACK+ Credit Analysis Files, Unlocking Business Secrets wtih UCA Cash Flows and more!

Unlocking Business Secrets with UCA Cash Flows

Unlocking Business Secrets with UCA Cash Flows

In the commercial lending world, the uniform credit analysis (UCA) cash flow is a powerful tool allowing lenders to accurately determine sources and uses of cash for a business and determine the ability of a business to repay a loan. In this article, we will discuss UCA cash flows in FINPACK, how to use the UCA cash flow, and how to sleuth for discrepancies in the UCA cash flow.