![]() ![]() ![]() In the next cell to the right build another formula - in this case the starting bank balance will be the value in the cell to the left. The balance is your starting bank balance, plus the total income and minus expenses for that month. Below the total expenses for the first month you can calculate the month-end bank balance. When the amount is the same for all months, enter one month’s data and drag on the fill handle in the bottom right corner of the cell to enter the value into the remaining months of the year.Įnter all the estimates and then total the monthly income and expense amounts. Opposite each income and expense item for each month of the year, enter the amount you anticipate you will receive or payout in that month. Across the top of the worksheet, enter the months January to December. Leave two blank rows between income and expense items. Open a new worksheet and enter these income sources and expense items into two separate groupings in column A. You can find much of this information in your small business accounting software or end-of-year tax reports. Set up income and expenses categories, and then enter your budgeted expenditure and income based on your past history and future plans.Ĭreate a cash flow budget in Excel by listing your sources of income and categories of expenditure.
0 Comments
Leave a Reply. |