Contingent Asset & Liability Contingent Asset Is a possible asset that may arise from a future event, and that is not under the business’s control. Its be realised asset only after it becomes certain. Eg. A lawsuit filed against a competitor for infringement of design/trademark, and chances of getting one crore as compensation. Contingent Liability […]
Formula for Find out Last Value in an Excel Column
This formula will help you in finding out the value in the last cell of a column. =LOOKUP(2,1/(ISNUMBER (C1:C100)) ,C1:C100)
How to extract number only from a text in Excel
The following long formula can help you to extract only the numbers from the text strings, please do as this: Select a blank cell where you want to output the extracted number, then type this formula: =SUMPRODUCT(MID(0&A5, LARGE(INDEX(ISNUMBER(–MID(A5, ROW(INDIRECT(“1:”&LEN(A5))), 1)) * ROW(INDIRECT(“1:”&LEN(A5))), 0), ROW(INDIRECT(“1:”&LEN(A5))))+1, 1) *10^ROW(INDIRECT(“1:”&LEN(A5)))/10) and then drag the fill handle to fill the […]
What is the journal entry for goods given for CSR activity/Charity?
When a business decides to give goods in charity it also needs to account for those goods in the appropriate financial statement(s), in this case, stock/purchases are reduced with the exact cost of goods donated. Journal entry
What are Fictitious Assets?
The Fictitious word, itself says “fake”. So Fictitious Assets are not an asset in the true sense but this is a huge amount of expenses or losses which are unclaimed in profit/loss account during the year in which they are incurred. Bind this to your memory fictitious assets are not assets they are fake or deceptive they are actually expenses & losses […]
What is Amortization?
Reduction in the value of an intangible asset by prorating its cost over a period of time (generally in multiple accounting periods) is called Amortization. Point worth remembering is that it can only be done for intangible assets such as copyrights, patents, trademarks, goodwill, etc. It is used for writing-off intangible assets whereas depreciation is used for tangible assets. If related to obligations, it can also […]
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)
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 […]
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 accounting Real Account If the item (real […]
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) GOODS Following 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 […]