(800) 234-1111

FINPACK News

Top 5 Cash Discrepancy Culprits

by | Feb 17, 2021

There are always tricky situations that leave you scratching your head on how to get a customer’s year-end analysis balanced when it comes to cash in and cash out.  Whether you are using the Schedule F Cash to Accrual Analysis or the Financial Analysis (FINAN) there are some common culprits to track down cash discrepancies in these tools.

Cash Discrepancy Sleuthing

First, if the Schedule F tax form (FINPACK Schedule F Analysis – additional input form is available here) is your main data source for income and expenses, remember tax reporting purposes do not always follow cash in and out of the business in a year.  This leads to many of the common discrepancies.  The FINPACK Knowledge Base has an article that goes into more detail on cash flow sleuthing, but let’s consider five situations coming from the Schedule F tax form.

5 Cash Discrepancy Culprits

  1. Feeder livestock purchases – This is found on Schedule F line 1b.  This is one instance where the tax form attempts to make an accrual adjustment by asking for the cost or basis of the items sold in line 1a.  FINPACK will make this adjustment a different way so it needs the cash purchases during the year of all feeder livestock, not just the purchase cost of what was sold that year.
  2. Patronage dividends – This is found on Schedule F line 3b. Cash dividends should be entered in FINAN. The non-cash portion of patronage dividends is added to the co-op equity on the balance sheet.  The Schedule F Cash to Accrual Analysis will handle this entry correctly.
  3. CCC loansCCC loans reported under election or taken as income are challenging. CCC loans reported on Schedule F line 5a are being treated as income for tax purposes.  FINPACK always treats CCC loans as a loan.  This situation has many possible outcomes, so we have a separate article on it.
  4. Cull income – cull breeding livestock income is not found on the Schedule F, but on Form 4797. Remember the gross sale price of cull livestock needs to be included in your data entry to balance cash receipts.
  5. Hedging gains or losses – you will want a copy of the 1099-B Proceeds from Broker and Barter Exchange Transactions. The total from Box 8 is entered in the Schedule F Cash to Accrual Analysis under net hedging detail.  This is the aggregate profit or loss on contracts.  For FINAN, the total from Box 11 is entered.  If the net is positive, it is entered as a FINAN hedging withdrawal.  If the net is negative, this is entered as a hedging deposit in the FINAN.

In Summary

Cash flow sleuthing is challenging, but looking for these common situations will help you identify and address where the cash went.

Economist & Software Developer | 612-625-5283 | wynn@umn.edu | + posts

Wynn leads the software development and technical team for FINPACK / FINPACK+

Latest News
New and Improved: Financial Ratios in FINPACK

New and Improved: Financial Ratios in FINPACK

This post highlights the updated financial ratios in FINPACK. The ratio updates are based on the recent updates to the Farm Financial Standards Council's Financial Guidelines for Agriculture. The 2022 release of the Farm Financial Standards Council's (FFSC) Financial...

FINPACK News – November Digest

FINPACK News – November Digest

The FINPACK Lenders Conference is around the corner, the FINPACK 2022 update is live including new monthly Commercial Cash Flow capabilities, and the FINPACK team at the ABA Ag Bankers conference in Omaha! Register Now for the FINPACK Lenders Conference...

The New Monthly Commercial Cash Flow Capability of FINPACK

The New Monthly Commercial Cash Flow Capability of FINPACK

What's New in the Commercial Cash Flow Tool in FINPACK? The 2022 Fall Release of FINPACK adds the capability to complete annual OR monthly cash flow projections for commercial clients. These projections can be for a few months or multiple years. This replaces the...

What’s New in the 2022 FINPACK Update?

What’s New in the 2022 FINPACK Update?

The 2022 FINPACK update brings changes to Tax Forms, incorporates new Financial Standards Measures, introduces a new Cash Flow Projection into our commercial tools and more! Farm Financial Standards Update The FINAN Financial Analysis and FINFLO Cash Flow Projection...

FINPACK NEWS Digest – October 2022

FINPACK NEWS Digest – October 2022

FINPACK lenders conference registration is open, the updated Farm Financial Scorecard, lender training, and looking forward to the ABA Ag Bankers Conference Register for the FINPACK Lenders Conference The FINPACK Lenders Conference is back in-person! Join us...