#Monthly family cashflow spreadsheet free#

To do this you may have to fill out actual paperwork, but most can be done online. It will save you lots of headaches and smooth out peaks and valleys in your month-to-month budgeting.Īutomatic payments: We set up all of our bills on auto payment. Ask your provider to be put on budget billing. This is a rough estimate based on a complete fill up and has helped us budget our fuel expenses (a category that fluctuates a lot).īudget billing: You will quickly get tired of trying to guess how much your heat/AC bill is going to be. Fill in how many gallons your vehicle(s) hold, the current price of gas, how many times you anticipate filling up each vehicle per pay period (based on your upcoming schedule), and it will give you a total to add to your budget. At the end of the month you should be left with un-bolded items that need to be recorded on the “budget savings” tab and then bolded as well.įuel calculator: This is at the bottom. Once you spend it, bold it: Once a transaction is complete and you have the correct amount noted on the monthly budget, bold it so you know that it’s been paid. Note the date bills are due in the column “A”: If you get paid on different dates each month, this will help you know what paycheck each payment will come from. (This info can also be found in the “HOW TO USE” sheet in the download.)

#Monthly family cashflow spreadsheet free#

More importantly, this helps you predict which months you will be short, so you can move expenses or revenue around to cover costs.Īs always, whether you own your own farm or you are a farm manager, I recommend working with someone who can help you run a number of scenarios in a cash flow projection based on various timing, weather, price and cost scenarios.9 Tips to Making This Free Budget Spreadsheet Awesome:

With a cash flow statement or projection like this one, it is much easier to track your line of credit or cash balance. There are also tax implications to consider. In the case of wheat, it might make sense to spread out sales more than in others. In the case of cows, sales that occur earlier can reduce interest, decrease shrink and also eliminate possible death loss. Instead, evaluate storage and other marketing costs, feed costs, weather and other factors. Don’t depend on things to work the same each year and don’t market for price alone. Cull cow prices may typically be at a low in November when the market is saturated and generally a high in May. Wheat typically experiences a post-harvest rally. When looking at the timing of your revenue, compare your options such as which crops are you paying storage on and make sure you take account for margin calls and forward contracts.Īlso, don’t get caught up in historical market trends and make general assumptions based on those. List each crop separately as each commodity will often have different timing and market considerations, prompting different decisions that need to be made. By mapping revenue in your cash flow projects, you can segment your marketing decisions to the most basic level, measure potential outcomes and choose the best management strategy. Remember to evaluate when you can leverage vendor financing and stretch out the terms on your expenses. Make sure you look at the timing of your term debt payments and also seasonal family living needs. It is important to build a cash flow so you can see all your options. This will make give you a more manageable cash flow situation. In this example, it probably makes sense to incrementally forward contract corn and wheat, and make incremental purchases of fertilizer. Obviously, we need to have some options for moving some things around in your cash flow projection. This exercise shows your cash deficits and alerts you to take action accordingly. As you build out your list by month you will note that some expenses will have flexible timing and some will have fixed dates (See Example below).įind out if you can maximize your farm’s financial decisions based on this short 45 second quiz.

The first step is to build a table-use Microsoft Excel or work with your consultant-that lists your expenses by month. So what does that look like and how do we do it? The first step is to develop a cash flow projection, preferably by month. Last month we talked about strategies to improve cash flow.