Learn with Manish Shori

 Introduction You can easily maintain personal accounts in Tally. To maintain personal accounts in Tally is very easy and simple. It is much faster than maintaining accounts for a company. The reason is that personal accounts are comparatively very small and involve only a few amounts of entries. Now compare that to a fully-fledged company which is selling products and includes all kinds of accounting entries and on the top of that, there is GST accounting entries too. But when you maintain personal accounts in Tally, there is generally no GST involved and you need to just focus on your balance sheet. So, let’s get started step by step. Maintain Personal Accounts in Tally When you have to maintain personal accounts in Tally, you should mainly focus on balance sheet. There is a specific reason for that. In personal account, there is no business account involved because it is your personal accounts. Therefore, there is NO need for a Profit and Loss Account. If you have a business...

  Excel COUNTIF function Excel COUNTIF function - count cells that meet one condition The COUNTIF function is purposed for counting cells that meet a certain criterion. Its syntax requires 2 arguments which are self explanatory. COUNTIF (range, criteria) In the first argument, you define a range where you want to count cells and in the second parameter, you specify a condition that should be met. For example, to count how many cells in range A2:A17 is "car", you use the following COUNTIF formula:   =COUNTIF(A2:A17, "car") Instead if typing a criterion directly in the formula, you can input a cell reference as demonstrated in the following screenshot: Excel COUNTIFS function - count cells that match several criteria The COUNTIFS function is similar to COUNTIF but it allows specifying multiple ranges and multiple criteria. Its syntax is as follows: COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2]…) For example, to count how many "cars...

  Introduction to company creation The first and foremost thing to do when we start accounting with tally is to know how to create a company in Tally ERP 9. Today one can operate Tally remotely using Tally.net features, process payroll and many more features are updating regularly by Tally solutions. The most recent improvement is GST with compatibility from version Tally.ERP 9. Create Company in Tally In this section, we will learn how to create a company using a simple step by step methods. The first step to get started is to create a company. In Tally, the creation of a company involves basic information about the company, books and details of currency. How to create a company in Tally In tally, after login double click on the create company option under company information. The following navigation path is used to create the company in Tally: Go to Gateway of Tally then press Alt+F3 or click on   Cmp Info (company Info) then press C or click on Create Company ...

  Excel COUNT Function Summary The Excel COUNT function returns the count of values that are numbers generally cells that contain numbers. Values can be supplied as constants, cell references or ranges.  Purpose Count numbers Return value Count of numeric values Syntax =COUNT (value1, [value2], ...) Arguments • value1 - An item, cell reference or range. • value2 - [optional] An item, cell reference or range. Usage notes The COUNT function returns the count of numeric values in the list of supplied arguments. Arguments can be individual items, cell references or ranges up to a total of 255 arguments. All numbers including negative values, percentages, dates, fractions and time are counted. Empty cells and text values are ignored. The result will be   First cell will be ignored because first cell contains text value and COUNT function does not count text, it only counts number. This function also ignore Blank cells The example below shows COUNT with 4 va...

Basic Accounting Entries in Tally Basic accounting entries require you to understand basic accounting vouchers in Tally. In Tally there are four basic accounting vouchers: · Contra Entry · Payment Entry · Receipt Entry · Journal Entry Contra Entry When there are just two accounts namely 1) Cash Account and 2) Bank Account. An accounting entry which is required to create is Contra Entry. For example, you want to deposit Rs. 500 and Rs. 1,000 notes in the bank, the entry required for the above would be a contra entry. On the other if you want to withdraw Rs. 2,000 notes, it would again be a contra entry. You can even enter the bank details in new version of Tally.ERP 9 like cheque no., number of notes deposited or withdrawn, branch name etc. Payment Entry It is basically an entry for paying something. For example, if you want to pay salary to someone working for you, it will be payment entry or if you want to pay for an expense such as maintenance expenses, you have...

  Excel COUNTA Function Summary The Excel COUNTA function returns the count of cells that contain numbers, text, logical values, error  values and empty text ("").   COUNTA does not count empty cells. Purpose Count the number of non-blank cells Return value A number representing non-blank cells. Syntax =COUNTA (value1, [value2], ...)  Arguments • value1 - An item, cell reference or range. • value2 - [optional] An item, cell reference or range. The result will be  Usage notes The COUNTA function counts cells that contain numbers, text, logical values, error values and empty text returned in formulas (""). COUNTA does not count cells that are completely empty. For example, to count non-empty cells in the range B2:B11: Invisible characters Be aware that COUNTA will also count cells that look empty but actually contain invisible characters  or an empty string ("") returned by a formula. You can check which cells are blank using Go To ...

  MATCH Function Summary In MS Excel there are lot of lookup functions that can find a certain value in a range of cells, MATCH is one of them. Basically, it identifies a relative position or location of any item in a given range in the cells. But it has also a limitation that if there is a duplicate value, it gives the result which is found in the first number. MATCH can find or you can say that it supports only approximate, exact and Wildcard (* ?) matches. MATCH is an Excel function used to locate the first position of a lookup value in a row, column or table. Often the INDEX function is combined with MATCH to retrieve the value at the position returned by MATCH. Purpose Get the position of an item in an array Return value A number representing a position in lookup_array. Syntax =MATCH (lookup_value, lookup_array, [match_type]) Arguments • lookup_value - The value to match in lookup_array. • lookup_array - A range of cells or an array reference. • match_type - [This is opt...