FINPACK News + Insights

FINPACK Balance Sheet Worksheet

by | Jan 24, 2019

Updated January 2026

Gathering customer data for year-end analysis and credit renewal can be difficult.  FINPACK tries to assist with the process by providing a Balance Sheet Input Worksheet with the customer’s most recent balance sheet data for updating.  This tool is provided to the customer as a means to get current, updated balance sheet information for the current year.  This worksheet is one FINPACK tool to assist with customer renewals.

What is the balance sheet input worksheet?

The FINPACK balance sheet input worksheet creates the selected customer balance sheet as a worksheet.  This form displays details from the selected balance sheet and provides areas for the customer to update the information with current values and/or add additional information as appropriate.  This worksheet can be given to customers in preparation for their year-end analysis or credit renewal visit.   

Screenshot of FINPACK Balance Sheet Input worksheet
Sample input worksheet

How to create the balance sheet input worksheet.

Creating and printing the balance sheet input worksheet is easy when you know where to do so.  The option to create an input worksheet is found in the Print dialogue box.  In the bottom half of the box, Input Worksheet Options is a tab option.  Selecting this tab will allow printing or previewing the selected balance sheet as a worksheet.  As always, the worksheet can be printed to a printer or as a PDF or Text file.

Screenshot of Print Dialog box in Detailed Balance Sheet in FINPACK
Print dialogue box

Working with new customers.

If beginning to work with a new customer, FINPACK has an input form available to assist with gathering the new customer’s information. A balance sheet input form and instructions are found in the FINPACK Knowledge Base for use with both agricultural and commercial customers.  In addition, there are a number of other FINPACK input forms to assist with gathering customer data for use in FINPACK tools.  The Sch. F Analysis – Additional Information form would be an example. Also remember, FINPACK Lite is another way to have customers provide balance sheet data.  This is a free tool, available for customer use.

Pauline Van Nurden
Associate Director at  | 6126254219 | pvannurd@umn.edu | Website |  + posts

Pauline Van Nurden is currently the Associate Director for the FINPACK Team. She has been with the team since 2017 as an Economist.

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 Import & Export Detail in Balance Sheet

Rather than manually entering detail in a new FINPACK balance sheet, you have the ability to import and export CSV files in certain areas. The process works with Intermediate, Long Term, and Personal Assets of an Agricultural balance sheet and Non-current and Personal...

Stress Testing: Crop Cost and FINPACK’s Long Range Planning Tool

Stress testing is a vital component of agricultural financial planning, allowing producers to evaluate how resilient their operations are under varying economic conditions. To help your customers in this process, we recommend two tools: FINPACK’s Long Range Planning...

Using Global Cash Flow Analysis in FINPACK

Analyzing the riskiness of a borrower becomes more complex when the borrower operates multiple businesses or mixes personal and business finances. To address these complex borrowing situations, FINPACK’s Global Cash Flow Analysis (GCFA) tool provides a structured way...

Ratio Review Series: ProSight Financial Association

Financial institutions rely on consistent information, sound risk management practices, and industry benchmarks to make informed financial decisions. Standardization in financial analysis helps ensure that institutions are operating from a common framework. The...