There is no excerpt because this is a protected post.
TDS 194Q vs TCS 206C
TDS 194Q TCS 206C(1H) Applicable on Purchase of Goods Sale of Goods Effective Date 01st July, 2021 01st October, 2020 Who is responsible for TDS / TCS Buyer Seller Meaning of Buyer Buyer means a person carrying on business whose total sales, gross receipts or turnover from the business exceeds Rs.10 crores during the financial year immediately […]
Residual value/Salvage value/ Scrap value
What is the difference between residual value, salvage value, and scrap value? The terms residual value, salvage value, and scrap value are often used when referring to the estimated value that is expected at the end of the useful life of the property, plant and equipment used in a business. This estimated amount is used to calculate […]
Search function in Excel
You can check the template for how INDEX formula enables the search function within the worksheet using a textbox. Download template with full access (Password: jafarpp.in)
Golden Rules of Accounting
What are the Three Golden Rules of Accounting? Golden rules are used to prepare an accurate journal entry which forms the very basis of accounting and act as a cornerstone for all bookkeeping. This is also known as the traditional rules of accounting or the rules of debit and credit. Easy Interpretation of 3 golden rules of accountingReal AccountIf the item (real account) is coming into the […]
LIST OF GOODS AND SERVICES NOTIFIED UNDER REVERSE CHARGE MECHANISM (RCM)
(Updated as on 30th September 2019) Government has notified Goods and Services which are subject to GST under Reverse Charge.(I) GOODSFollowing are Supply of goods under RCM as per section 9(3) of CGST Act are: S. No. Tariff item, sub-heading, heading or Chapter Description of supply of Goods Supplier of goods Recipient of supply (1) (2) (3) […]
Why is Closing Stock not Shown in Trial Balance?
Not all goods purchased in beginning & during the accounting period are sold until the end of that period, this results in a remainder balance known as closing stock.Closing stock is a part of purchases & trial balance already includes purchases, hence if the closing stock is shown as a separate item it will double count and result […]
BMI Calculator
Calculate Your Body Mass Index. Body mass index (BMI) is a measure of body fat based on height and weight that applies to adult men and women. Enter your weight and height using standard or metric measures.
Suicide of An Excel File!
This is not a story, an amazing VBA code to protect your highly confidential excel file from theft/miss use. If you have developed a workbook which you want to self-expire by a certain date, such as a demonstration model or containing information or usefulness that will be outdated, you can program a workbook to delete […]
Panappayattu: A North Malabar Financial Model
What is Panappayttu? Panapayattu is a network of money exchange which can be seen in some parts of Calicut and Kannur district of North Malabar.“Panappayattu is a unique network system of exchange of money in which the financial needs of a person is met by a group of people on the basis of a request made the needy. The money is paid and received in a function. This function is known as panappayattu” (Dr Mohamed Kutty […]
Auto Save Excel File After Cell Value Change
A macro-enabled excel file can save automatically when changing any cell value. See the below given VBA code for autosave : 1. Right-click the sheet tab that you want to autosave the workbook after entering new data, and then choose View Code from the context menu, in the opened Microsoft Visual Basic for Applications window, copy and […]