no license
64y6kMGBSVhmzQfbQP8oc9bYR1c2g7asOs4JOlci
Bookmark

Balance Sheet - Excel


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 where C refers to the stock column and D 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.

Practice

Post a Comment

Post a Comment

Ask your questions.