- Location
- Sedgefield
we’re in Durham
And I would recommend a local Agricultural Secretary service
They’d be cheaper than a Land Agent
Vicky Anderson Training in North Yorkshire would be ideal but she’s probably too far for you
I have an Excel spreadsheet with 12 month columns across the top So Sept through to August as I’m arable and that suits my crop year
then down the side all the “stuff” that I buy or sell. Which corresponds with the accountants accounts
Ie
Wages
Paye
Farm diesel
Tractor repairs
Water
Electric
Bank commission. Etc etc
then each monthly column has a Budget column and an actual column
And I project what the 24 months costs will be
And at the end of every month I put in actual figures
so this is a rolling cash flow which shows actual past performance and projected future performance
By using Excel formulas it’s easy to make the actual month total recalculate all the future budget totals. So I know exactly where my cash flow pinchpoints will be and where I need to sell grain to mitigate that
And I would recommend a local Agricultural Secretary service
They’d be cheaper than a Land Agent
Vicky Anderson Training in North Yorkshire would be ideal but she’s probably too far for you
I have an Excel spreadsheet with 12 month columns across the top So Sept through to August as I’m arable and that suits my crop year
then down the side all the “stuff” that I buy or sell. Which corresponds with the accountants accounts
Ie
Wages
Paye
Farm diesel
Tractor repairs
Water
Electric
Bank commission. Etc etc
then each monthly column has a Budget column and an actual column
And I project what the 24 months costs will be
And at the end of every month I put in actual figures
so this is a rolling cash flow which shows actual past performance and projected future performance
By using Excel formulas it’s easy to make the actual month total recalculate all the future budget totals. So I know exactly where my cash flow pinchpoints will be and where I need to sell grain to mitigate that