Operating Expense Worksheet - BC Bookkeeping Tutorials|dwmbeancounter.com

Go to content

Operating Expense Worksheet

Cash Forecasts > Forecasting Exercise

Cash Operating Expenses Worksheet
Used to estimate and enter your different types of Payments (expenses)
Cash Operating Expenses Summary
4-Week & 5-Week Periods
Add Extra Expense Categorys To The Worksheet
The worksheet allows you to enter Additional Expense Categories to the Worksheet Using the Yellow Highlighted Area.

Note: Although shown in the Schedule above in the "Blank" worksheet you'll be using for our Example Of Ma & Pa we need to add the following additional expenses to our Worksheet:
  • Refinishing Supplies- Use 1.5% as the percentage amount
  • Shipping & Packing Crates-Use 1.79% as the percenrage amount
Where Do We Get This Information ?
Ma and Pa reviewed their Profit and Loss Statements for the last three years and decided to use the information from their most current year's statement for their Cash Projection estimates of their operating expenses.

What's next ?

Weekly Cash Forecast Spreadsheet
Back to content