Learn with Manish Shori

  Introduction In the ledger there are many personal accounts, some of them may show debit balances, some others may show credit balances. If all the names are to be written in the trial balance it will be unduly long. Therefore, a list of names with the debit balances is prepared. This list is known as ‘Sundry Debtors’ Note: Sundry means ‘many’ Follow the below steps to create a ledger easily. 1.   From Gateway of Tally, select Accounts Info. 2.   Then select Ledgers 3.   Under Single Ledger, select Create 4.   Create ledger as I have explained below for Sundry Debtor. I am creating a ledger named Jugal under the head Sundry Debtors as shown in the picture: Sundry Creditor Ledger Create a Sundry Creditor Ledger in the same way as you’ve created the Sundry Debtors Ledger. The name of the Sundry Creditor would be Kartik. So, create a ledger named Kartik under the head Sundry Creditors as shown in the picture: You can also see the video regarding " Sundry Debt

  Introduction The SUMPRODUCT function multiplies ranges or arrays together and returns the sum of products. This sounds boring but SUMPRODUCT is an incredibly versatile function that can be used to count and sum like  COUNTIFS or SUMIFS but with more flexibility. Other functions can easily be used inside SUMPRODUCT to extend functionality even further. Purpose Multiply, then sum arrays. Return value The result of multiplied and summed arrays. Syntax =SUMPRODUCT (array1, [array2], ...) Arguments ·        array1 - The first array or range to multiply then add. ·        array2 - [optional] The second array or range to multiply then add. Useful notes The SUMPRODUCT function works with arrays but it doesn't require the normal array syntax (Ctrl + Shift + Enter) to enter. The purpose of the SUMPRODUCT function is to multiply then sum arrays. If only one array is supplied SUMPRODUCT will simply sum the items in the array. Up to 30 arrays can be supplied. When you

  Introduction Post Dated Cheque is an essential part of today’s business world. For a better financial planning and fund management PDC cheque is a must tool to survive in a tight financial conditions of a competitive world. A cheque in which a future date is written on its face is called Post Dated Cheque or popularly known as PDC. PDC can be issued to your suppliers and can be received from your customers. Normally Post-dated cheques are presented on the date of Cheque and booked or accounted on the same date. If you have a large number of PDC to manage then it is annoying for accountant to keep track of cheques. Tally ERP 9 take charge of the PDC Management for you and let you do a tension free accounting. You can enter post-dated cheques into receipt voucher, payment voucher and contra vouchers. Benefits of Post-dated Cheque Transactions 1.    You can enter the cheque into tally immediately after receiving or issuing it. 2.    You can mark a cheque as post-dated which wi

  Introduction The Excel INDIRECT function returns a valid reference from a given text string. UseINDIRECT when you need to convert a reference assembled as text into a proper reference. Purpose Create a reference from text. Return value A valid worksheet reference. Syntax =INDIRECT (ref_text, [a1]) Arguments ·        ref_text - A reference supplied as text. ·        a1 - [optional] A boolean to indicate A1 or R1C1-style reference. Default is TRUE = A1 style. Useful notes Use INDIRECT to create or supply a reference in text form. Indirect is useful when you want to convert a text value into a valid cell reference. The reference created by INDIRECT will not change even when cells, rows or columns are inserted or deleted. For example, the formula =INDIRECT("A1:A100") will always refer to the first 100 rows of column A, even if rows in that range are deleted or inserted. ·        References created by INDIRECT are evaluated in real time and the content