(800) 234-1111

FINPACK News

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
Loan refinance in a FINPACK Projection

Loan refinance in a FINPACK Projection

Refinancing loans is a frequent option to help business owners in need when profits are down, and cash flows are tight. Following the correct loan steps in a FINPACK Projection ensures the Term Debt Coverage Ratio and other repayment capacity measures are correct...

Changing interest rates in FINPACK Projections

Changing interest rates in FINPACK Projections

Interest rates charged on loans can change during the year for any number of reasons; the rate is variable, the rate was renegotiated at renewal, or the customer’s risk profile changed to name a few. Because of this, interest rate changes on operating or term loans...

2019 FINBIN Report on MN Farm Finances

2019 FINBIN Report on MN Farm Finances

In our previous post, we discussed some of the financial highlights for Minnesota farms in 2019.  In this post, we want to highlight our more detailed report. The 2019 FINBIN Report on MN Farm Finances graphically shows how Minnesota farms performed in...

Minnesota farm incomes inch higher

Minnesota farm incomes inch higher

Minnesota farmers continued to struggle with low profitability in 2019.  Median net farm income was up slightly from the previous year at $36,211, but was still historically low.  Each of the past five years has fallen in the bottom third of historical...

COVID-19 Response

COVID-19 Response

Greetings, You’ve probably had a few of these emails hit your inbox recently.  All CFFM staff have moved off-campus to work from home and are trying to balance work and home life like many of you.  We wanted to give you a quick update from the FINPACK...