Description
Packaged Food and Beverage Business Income Statement Generator is a simple bookkeeping spreadsheet for small business owners or financial persons to generate profit & loss report quickly. This business could also fall into manufacturing business since companies/parties produce products by combining multiple ingredients and package them into ready meal and ready to drink products.
There are 2 different bookkeeping versions. One yearly bookkeeping version (re-use the original file every year to generate subsequent one year report) and 5 yearly bookkeeping version (re-use the original file every 5 years).
There is a product page where you can type pre fill with your products as well as their price and COGS values.You can set up to 3 different COGS combination. For example, you can set PRICE only, set PRICE and complete COGS or PRICE and partial COGS values where you can put custom COGS values in transaction worksheet.
There are 5 different income statement format where all of them are fully editable and 2 optional report that should be useful if you plan to track profit & loss of particular projects, group of products and services etc. With this flexibility, you can present suitable income statement format to particular parties.
You don’t need accounting background to record your business transactions. Just fill the transaction and all income statements will be generated automatically.
Remember that income statement or profit/loss report is different from cash flow report. Balance from each report might be different since not all cash transactions are parts of income statement. You might check my other bookkeeping spreadsheet for a spreadsheet with a more complete financial statements.