Learn with Manish Shori

Introduction The actual meaning of the word memorandum is a note recording something for future use. Note: A memorandum voucher is a voucher in which you record entries for which you are NOT sure whether they are going to occur and if they are going to occur then by HOW much amount. A main characteristic of memorandum voucher is that it does not affect your accounts unless you convert it to a general voucher. Example of Memorandum Voucher In your office, you gave ₹10,000 for office expenses for a month. Now, you are NOT sure how much amount will be spent and what will remain at the end of the month. In this case you will create a Memorandum Voucher for payment of ₹10,000. At the end of the month let us assume that the actual expenses were ₹9,000. What you will do is convert the memorandum voucher to payment voucher and change the amount from ₹10,000 to ₹9,000. By doing this, along with the modified entry, the books of accounts will also get updated. Sales or No Sales! An

Introduction The Excel ROW function returns the row number for a reference. For example, when no reference is provided ROW returns the row number of the cell which contains the formula. As in the above picture, no reference is provided and close the bracket without providing any reference It returns 2, because we apply the formula in cell C2 When we define the proper reference: The result will be As we have seen that we put the formula in C2 but we define the reference here A1 so it display the result 1 not 2 Purpose Get the row number of a reference. Return value A number representing the row. Syntax =ROW ([reference]) Arguments • reference - [optional] A reference to a cell or range of cells. Notes: ·        Reference is optional and will default to the cell in which the ROW function exists. ·        Reference cannot include multiple references or addresses. Summary… The ROW function returns the row number for a cell or range. For example =ROW(B3) returns

  Introduction Journal entries in Tally are the most widely used accounting entries after payment and receipt entries. Note: Journal entries are used when there is NO involvement of cash or bank account in an accounting entry. Otherwise it would be payment or receipt entry. Generally, journal entries are created for closing books of accounts at the end of the year or for adjusting entries. Journal entries are an important part of accounting in general as well as in Tally. Any entry that does not include the following accounts will be a journal entry. ·        Cash Account ·        Bank Account For example, if we take an entry of depreciation. As it is a non-cash entry and it does not involve bank, sales and purchase account as well, it will be journal entry. There are 4 major journal entries which are used in day to day transactions. They are: 1. Depreciation entry 2. Accrued Income entry 3. Entry for Purchase on Credit 4. Entry for Sales on Credit How to create J