Overview
First of all this is a Different balance sheet then aur Commerce's Balancesheet
We are Making This for Do some Basic Calculations For our small bussiness in Excel
This table provides an overview of the balance sheet details including stock, sales, income, and expenses.
Table Headings and Meanings
- Serial Number (sr.no.): This is a unique identifier for each row entry.
- Product Name (P.NAME): This column lists the names of the products being tracked in the balance sheet.
- Stock Quantity (STOCK): This column shows the quantity of stock available for each product.
- Sales Quantity (SALES): This indicates the quantity of each product that has been sold.
- Amount per Unit (AMT PER): This column provides the price per unit of the product.
- Balance (BALANCE): This column shows the balance of stock after sales, calculated using the formula
=C3-D3
whereC
refers to the stock column andD
refers to the sales column. - Income (INCOME): Income is calculated by multiplying the sales quantity by the amount per unit (
=D3*E3
). - Expense Name (EXP NAME): This column lists different types of expenses associated with the products.
- Expense Amount (EXP AMT): This column provides the amount for each listed expense.
- Cash in Hand (CASH IN HAND): This column appears to be intended for tracking the available cash after considering income and expenses, though it is empty in the provided sample.
Post a Comment