|
Iowa | My system might not be a perfect fit for you in the sense that I typically make my plans for the following year before the end of the fiscal year ending on December 31 and plug them into the spreadsheet. All of the crop inputs for the following year in each field are ordered and generally prepaid by then, and about 90% of crop delivery dates are scheduled a year to 18 months in advance (specialty contracts), so there are not a lot of in season adjustments other than maybe an unplanned fungicide application. There are generally very few deviations from the plan. It's pretty much set in stone unless we have some sort of natural disaster. Yield and market prices are about the only things that normally get some in season adjustments unless I make some unplanned capital asset purchases. My livestock production is also mostly set in stone as well with regular delivery dates of weaned pigs in consistent numbers. Actual results normally come out very close to the projections. In other words, my crop, livestock, and whole farm budgets don't really change much in season. The only difference usually only amounts to how closely the actual application rates of inputs match the target rates. The pluses and minuses mostly balance each other out.
I've got Ag Leader GPS stuff for the planter and combine, but none of that feeds directly into my accounting spreadsheet. Data I get from my Ag leader stuff is plugged into the spreadsheet, but it is adjusted to match certified acres, actual purchases, settlement sheets, and/or bin measurements. I got the impression Farmworks used to more closely & seamlessly incorporate GPS data into their system. Granular might be doing something like that as well. I don't really know exactly how they do it. My spreadsheet is more strictly actual dollars and cents like the bank statements. My main cash flow BUDGET portion of the spreadsheet has the projections plugged into it early in January. A cash flow STATEMENT is all zeros on January 1st and fills in automatically with monthly totals sourced from the general ledger as the year progresses. Just below the cash flow budget and statement, the difference between the two is automatically calculated and displayed on a monthly basis as the year progresses. I have not really had a need for more than that, so that's all I did with it. | |
|
- before i buy QuickBooks, is there something better? - GrainTrader : 1/12/2021 09:41
- RE: before i buy QuickBooks, is there something better? - schmid : 1/12/2021 10:58
- RE: before i buy QuickBooks, is there something better? - Dave Cen.Ia : 1/12/2021 11:39
- RE: before i buy QuickBooks, is there something better? - JRthefarmer : 1/12/2021 11:48
- RE: before i buy QuickBooks, is there something better? - Purdue12 : 1/12/2021 12:18
- RE: before i buy QuickBooks, is there something better? - dutchdirtfarmer : 1/12/2021 12:18
- RE: before i buy QuickBooks, is there something better? - razorsedge2003 : 1/12/2021 12:28
- RE: before i buy QuickBooks, is there something better? - Chief Illiniwek : 1/12/2021 12:37
- RE: before i buy QuickBooks, is there something better? - frytownfarmer : 1/12/2021 12:47
- RE: before i buy QuickBooks, is there something better? - S. Mahoney : 1/12/2021 12:56
- RE: before i buy QuickBooks, is there something better? - GregWCIL : 1/12/2021 15:21
- No employees? Excel is about as easy and cheap as it gets - AF140 : 1/12/2021 15:35
- RE: before i buy QuickBooks, is there something better? - lawfarms : 1/12/2021 18:41
- RE: before i buy QuickBooks, is there something better? - boog : 1/12/2021 19:02
- RE: before i buy QuickBooks, is there something better? - Jackrabbit : 1/12/2021 19:47
- RE: before i buy QuickBooks, is there something better? - tigger : 1/12/2021 20:15
- RE: before i buy QuickBooks, is there something better? - ruralHusker : 1/12/2021 20:54
- RE: before i buy QuickBooks, is there something better? - kenswont : 1/13/2021 07:40
|