(800) 234-1111


Top 5 Cash Discrepancy Culprits

by | Apr 17, 2018

Top 5 Reasons for Cash DiscrepanciesThere 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 input form is available here) is your main data source for income and expenses, remember tax reporting purposes does 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 loans – CCC loans reported under election or taken as income are the issue. 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.

Latest News
2022 FINPACK Lenders Conference

2022 FINPACK Lenders Conference

The 2022 FINPACK Lenders Conference will be held in-person in 2022. Conference Information Date: December 13-14, 2022Location: Radisson Blu Mall of America - Bloomington, MN Dr. David Kohl returns to the FINPACK Lenders Conference + a full lineup of speakers. We will...

FINPACK Digest – June 2022

FINPACK Digest – June 2022

Credit scorecards, the FINPACK advanced training survey, register now for Lender training, and The FINPACK digest is published every month and links to all the FINPACK News post published in the previous four weeks. Want notifications on FINPACK news posts sooner?...

Training & Events Update

Training & Events Update

October training for Lenders, Training for Educators and Professionals, and save the date for the 2022 FINPACK Lender's Conference FINPACK Training for Lenders in October Registration is open for the next FINPACK Lender training on October 11th and 12th on the...

How to Design and Use Credit Decision Scorecards

How to Design and Use Credit Decision Scorecards

Using Credit Decision Scorecards in your credit decisioning represents a convenient way to 'filter' loan applications. By applying some basic criteria, you can quickly decide if a credit request is straightforward and can be approved or denied as is, or if it needs...