| Tally Accounting Software Tally's– Financial Accounting and Management System. Prices Hot Scheme (Tally 7.2 + Value pack = Tally 9)
*CALL FOR CUSTOMISATION *DATA RECOVERY *UP GRADES Tally Enterprise Solutions
Tally Financial Accounting Software COMPLETE BOOKKEEPING BOOKS, REGISTERS AND STATEMENT OF
ACCOUNTS GENERAL LEDGER CREDIT CONTROL
(Outstanding Management) INCLUDING CREDIT LIMIT To set Credit Limits follow the procedure below : Activate Budgets and controls by pressing F11 (Features) -> Select Accounts Info -> Select Ledger --> Select Credit limits -> Select Group -> Define the limit for each ledger either by Value or Period or Both.
ACCOUNTS RECEIVABLES AND ACCOUNTS
PAYABLE How to use this facility? Activate ‘BillWise’ details by pressing F11 (Features). Now Create a Party (Ledger A/c) under the group ‘Sundry Debtors’ as well as one under group ‘Sundry Creditors’, and also activate ‘Maintain balances bill by bill’ for all the Parties while you are in Ledger creation mode. Next, select the option ‘Voucher Entry’ in ‘Gateway of Tally’ -> Select Sales or Purchase Voucher. Now, while entering the transaction, the user can specify a Ref. no with due date for the amount or break it up by giving multiple ref no with different due dates. To view the reports follow the procedure given below. Select ‘Display’ (in Gateway of Tally menu) -> Select ‘Statement of Accounts’ -> Select ‘Outstandings’ -> Select ‘Receivables’ (in case you want to see amount due to the company) -> Select any particular group. The report displays bill by bill outstanding for all parties along with the pending amount as well as the due date. In case user wants to see the amount payable by the company then select the option ‘Payable’ under the menu ‘Outstandings’. The user, once he has selected either Payables or Receivables can toggle between the two reports by clicking F4 function key. For individual Party wise outstanding: ->Select ‘Ledger’ option under ‘Outstandings’. This report gives a bill-by-bill display of all outstandings for the concerned party along with the total outstanding amount.
For a display of total outstandings for all parties -> select ‘Group’ in the menu ‘Outstandings’ and then select any particular group or sub-group.
Tally gives Age wise Analysis Reports and hence keeps the user informed for the range of period the bills have been outstanding. The user has the luxury of defining the Ageing periods as per his needs. e.g. 0 to 30 days, 30 to 45 days, 45 to 60 and so on. The procedure for displaying the report is given below. The aging analysis gives flexibility to do ageing by due date or bill date. -> Select ‘Ouststandings’ under Display menu -> select ‘Receivables ‘ or ‘Payables’ press F5 (age wise) -> select method of ageing -> specify the periods FLEXIBLE VOUCHER NUMBERING Select ‘Accounts Info’ -> select ‘Voucher Type’ -> select ‘create’ option -> Now enter the Voucher name, specify the type of voucher, specify the method of numbering, activate or deactivate the other functions as per needs. FLEXIBLE CLASSIFICATION OF ACCOUNT
HEADS / CHART OF ACCOUNTS E.g. the user can have Continent wise Debtors groupings (i.e. Asia, America, Europe, Africa, Australia) under the Group ‘Sundry Debtors’. The continents can also be further bifurcated into countries and states and so on. BIRD'S EYE VIEW/ DRILL DOWN DISPLAY DATE BASED REPORTING VOUCHER AND CHEQUE PRINTING To activate Cheque printing option press F11 -> activate ‘Set modify company features’ -> enable Cheque printing -> specify bank name (as created in Ledgers) -> Specify dimensions of Cheque. Now while entering Payment Voucher mention the name to be printed on the cheque. Once the voucher is saved Tally prompts the user to print cheque. COLUMNAR REPORTS For Columnar Reports, Select Display -> Accounts Book -> select any of the registers -> Press F5 (Columnar).
For bank reconciliation follow the following procedure: Firstly, while creating “Bank Account” Ledger, specify ‘Effective date of reconciliation’ (ie the date from which the user wants to reconcile his bank accounts). Then, Select, -> Display -> Account Books -> Bank Book -> Select the particular ‘Bank’ à Select month -> Press F5 (Reconcile). Now enter the date, on which a particular transaction has been cleared. Tally now provides information of balances as per company Books as well as per Bank.
STOCK CATEGORY How to create Stock Categories ? -> Select F11 (Features) -> activate Stock Categories and save screen -> select Inventory Info -> select Stock Category -> select Create -> specify name of Category -> specify under which Parent category and save screen. How To View Reports ? -> select Display (from Gateway of Tally) -> select Statement of Inventory -> select Stock Category -> select any particular category. Tally displays all items under the selected Category.
STOCK QUERY How to view Sock Query Report ? -> Select Display -> select Statement of Inventory -> select Stock Query -> select the req’d stock item. Tally displays information for the selected stock item. Select F4 (Item) to change to another item.
The user can also create locations to keep track of job works and Sub-contract i.e. the item issued to and rec’d from Job works. Each Job Work / Sub-Contract can be equated to a location How to create a Location ? -> Select F11 (features) -> activate ‘activate Multiple locations’ -> now select Inventory Info -> select Locations -> select Create -> specify Location name and other details and save screen. How to view a report ? -> Select Display -> select Statement of Inventory -> select Locations -> select any Location. Tally displays stock statement for that Location. To compare : Tally allows comparisons of multiple locations -> once the user has selected Location report -> select New Column (Alt + C). Tally now displays locations in columnar format. Alternately the user could select Auto Column (Alt + N)-> select locations -> activate Total Column and save screen. Tally displays all locations in columnar format and also displays total column.
Sub Locations : Users can also create Sub-Locations (multiple levels of Locations). While creating sub-location the user has specify location name and the parent Location under which the sub-location has to be created. Tally also allows creation of Virtual Locations. Virtual locations will not allow storage of materials. This is useful when a city has more than one location e.g. a city like Singapore can have locations at Jurong and Tampines. The user would require stock statement for both these locations as well Singapore. In this case Singapore warehouse can be made as virtual location, since Singapore as a warehouse does not exist, but the user can get a stock statement report. This can be done in Tally by creating a warehouse and de-activating the feature ‘Use storage of materials’. STOCK TRANSFERS TO WARE HOUSES -> select Voucher Entry -> select Stock journal -> In the source column select stock item and the locations from where they are to be transferred -> again select Stock Item and specify location where it is to be transferred. How to Transfer by using Voucher Classes ? First create a voucher class: -> select Accounts Info or Inventory Info -> select voucher Type -> select Alter ->select the voucher Stk Journal -> come down to class and specify class name (e.g. Location Transfer) -> activate ‘ Use Class for Inter Location Transfers’ and save screen. Now select Voucher Entry from ‘Gateway of Tally’ -> select Stk Journal -> select class -> now specify destination location and select stock items along with source locations and complete the entry.
MULTIPLE STOCK VALUATION Procedure : Lets assume Stock items are already created. Now select Inventory Info -> select Stock Items -> Alter -> select any item -> select F12 (configuration) -> activate Advanced entries in masters and save screen. -> Specify costing method and save screen. How to view report in different valuation methods : -> select Stock Summary -> Tally displays stock summary based on default valuation methods. Now select New Column (Alt+C) -> specify date range -> specify ‘Methods of Valuation’ as per requirements. Tally, now displays stock report based on the valuation option opted for.
Procedure : -> select F11 (features) -> activate ‘Maintain Batch wise details’ -> The user can also activate ‘Set expiry dates for Batches’ (if required) and save screen -> select Inventory Info -> select Stock Item -> select Create -> specify Stock item name and other details -> activate ‘Maintain Batches’ -> activate Mfg date and expiry dates if needed -> specify opening balance with batch details and save screen. Entering Transactions : While entering purchase entry, select the item and specify batch details along with mfg date and expiry date. How to view reports on Batch details ? -> Select Stock Summary -> select F12 (Config) -> activate ‘Expand all levels in detailed format’ and save screen -> select detailed (Alt + F1). Tally displays all stock items along with their batch details.
-> select Inventory Info -> select Stock items -> select alter -> select any item for which ‘Alternate Unit’ is to be activated -> now select configure (F12) -> activate Alternate Units -> now come down to Alternate Units and specify alternate units -> specify the relation between the two units (e.g. base unit is Nos alternate unit is kgs, now you can specify a relationship ->1 nos = 0.5 kgs) How to view reports ? -> Select Stock Summary -> Select F12 (Configure) -> activate ‘Show using Alternate units’ and save screen. Tail Units : select F12 (configure) in Stock Summary -> activate ‘Tail units of compound Units’ and save screen. Tally displays compound units of stock items in ‘Tail units’. SALES AND PURCHASE ORDERS
Procedure : -> select F11 (features) -> select activate Purchase orders and Sales Orders and save screen. -> now, select Voucher Entry -> select F9 -> opt for P.O. -> select supplier name and related details -> enter Order No. -> select item and enter other details and save Voucher. Likewise, Sales ordes rec’d are enterd in Sales order Voucher screen. How to view reports ? -> Select Display -> select Statement of Inventory -> select Purchase order summary or Sales order summary -> Tally shows Group wise summary. Now, drill down till you get P.O. details. If the user wishes to view orders, which are over due then he selects F7 (Due only) and Tally displays order, which are already overdue for that item. The user can also shift to another item by clicking on F4 (Item).
TRACKING THROUGH RECEIPT NOTES AND
DELIVERY NOTES -> activate Tracking nos in F11 features ® select Inventory Info -> select F9 -> select Receipt Notes -> enter Party details -> select item ® now user will have to specify tracking nos -> complete the voucher by specifying all other details. In case of delivery notes select Delivery Notes (F8) after selecting voucher entry -> then follow the same procedure as above. While raising invoices, recall the tracking no specified during the entry of inventory vouchers (Receipt note and Delivery notes). How to view a report ? -> Select Display -> select Statement of Inventory -> select Purchase bills Pending. Here the report will show information on ‘Goods rec’d but purchase bill not rec’d as well as ‘Purchase bill rec’d but goods not rec’d’. REJECTION IN AND REJECTION OUT Procedure: -> activate Rejection Notes in F11 (features) For Rejection In -> select Voucher Entry from ‘Gateway of Tally’ -> select F8 (Rejection In) -> select Party Ledger -> select item which is rejected (sales return) -> Tally displays the list of tracking nos. -> select particular tracking no., enter the qty and complete the transaction. For entering Rejection out select F9 (Rejection out) and continue with the transaction as above. Additional Cost on Purchases : When a purchase is made there are additional expenses like freight, handling charges, taxes etc incurred. These additional charges need to be added to the value of the product. Tally allows the user to add additional cost incurred, to the value of the product during the time of voucher entry or at a later stage. Procedure : There are two methods of adding additional cost on Purchases. Method 1 : -> select F11 (features) -> activate ‘Track additional cost of purchase’ and save screen -> now, select Voucher entry -> select F9 (purchases) -> enter accounting details. When the user selects purchases, Tally displays list of inventory items -> select item, specify qty, rate, value. Tally now displays another screen, where the user has to specify the additional cost along with the percentage or can specify actual cost. The additional cost is added to the value of the product. Method 2 : At times the user would have completed the purchases and would want to add additional cost on purchases at a later. Then follow the procedure below. Firstly create a ledger account -> select Accounts info -> select Ledger -> select Create -> create new ledger, activate ‘Inventory values are affected’ and save screen -> select Voucher Entry -> select payments -> select the Ledger account (e.g. Customs Duty, Taxes, freight etc), the cost of which will have to be added to the to the value of stock item purchased -> Tally displays list of stock items -> select stock item and without specifying qty, specify value. Select other stock items and complete the transaction. This entry automatically updates the value of stock item. How To a view report ? : If the user wishes to view additional cost for stock items for any purchase, then he can -> select Display -> Inventory Book -> Movement analysis -> select stock item analysis -> Tally displays all parties from whom the item has been purchased with their effective rate-> Drill down further and the user will be able to get information of all purchases with their basic rate, additional cost, total value and effective rate.
Movement analysis for Party shows, inward and outward movements of all stocks with effective rate and value for the selected party. Select an item and drill down further and Tally displays transaction wise details along with a separate column for additional cost. Movement analysis of Stock items shows party wise inward and outward movements of stock items with basic rate and effective rate. Select any Party and Drill down further for more analysis Movement analysis of a stock group shows the total inward and outward movement of stock items with their effective rates for that particular group of items. Procedure : -> select Display -> Inventory Books -> select Movement analysis -> select any option as per requirements -> You can drill down further to get more analysis. PROFITABILITY ANALYSIS- Stock Group
Wise / Stock Item Wise / Invoice Wise / Location Wise -> select Display -> select Inventory Books -> select Stock Group -> select F7 (Show profits) -> Tally displays sales value, consumption cost, gross profit along with %’s.
-> select Display -> select Inventory Books -> select Stock item -> select F7 (Show Profits) -> Drilldown further to get transaction wise profitability (Only for outward entries). Invoice Wise : -> select Display -> select Inventory Books -> select Sales Register -> select any month -> Tally displays all sales entries -> select F7 (Show profits)- > Tally displays Gross profitability for all sales entries.
Location wise : -> select Display -> select Statement of Inventory -> select Locations (Warehouses) -> select any location -> select F7 (Show profits) PRICE LIST WITH MULTI PRICE LEVELS How to define Price levels ? -> Select F11 (features) -> activate ‘ Set / modify other company features’ -> activate ‘ Use multiple price levels for Invoicing’ specify names of different levels that are to be created and save screen. How to enter price level details ? -> Select Inventory Info -> Select Price list -> select any Group or All -> specify rate for all items of the group. The user can specify different rates for different quantities of the same item as well as specify different rate of discount. > save screen.
Synchronization of Data between Offices INTRODUCTION True to its reputation, Tally is attempting to simplify the lives of harried managers by launching TallyServer - the server enabled version of Tally ees 6.3 that makes synchronization/replication of data between the head office and various branches extremely simple, reliable and instantaneous. In short, Tally will make data synchronization a "single-click" activity with TallyServer.
Mr.Bharat Goenka, Managing Director, Tally Solutions Pvt. Ltd said, "Our effort has been to develop innovative and leading-edge technology products that have practical relevance to our customers and can provide rapid benefits. In today’s world, where there is relentless pressure to reduce costs and stay competitive, many organizations are looking for practical applications that can help them utilize the power of the internet to integrate their operations and information flows. Through TallyServer, Tally has come forward to provide a solution for seamless data flow between branches, business partners and for capturing transactions through the net". GENERAL DETAILS The simplest use of TallyServer and TallyClient is therefore the transmission and updating of information and data from branches / remote locations. As is the case with all Tally products, the installation and set-up is very simple and easy and does not require complicated procedures or assistance. TallyServer and TallyClient can also be used to streamline and standardize information flows across multiple programs running in some functional overlap with Tally (ODBC compliant databases) and in the creation of complex environments. This will require the assistance of programmers adept in TDL and scripting languages. TallyServer and TallyClient is completely modular, which means that existing users of Tally ees 6.3 Gold can purchase TallyServer and TallyClients at a reasonable cost. The Company has started marketing TallyServer through a separate network of Tally Enterprise Partners (TEP). Support will be available both from the TEP and from the Company. The Company provides free web-based and telephone support. The product is operational in the Company as well as with the following customers: Ornate Multimodal Carriers Pvt.Ltd. TECHNICAL
OVERVIEW
THE SOLUTION We shall assume that the Head Office is connected to the Internet through a leased-line, and therefore, has a ‘fixed IP address’. A user can deploy a ‘TallyServer’ (which is nothing but normal Tally with the ‘Server’ capabilities activated) at the Head Office, and TallyClients at the remote locations (a TallyClient is also normal Tally with ‘Client’ capabilities activated). Each remote location then creates a ‘Rule’... which is essentially a ‘request to allow data synchronization’ with the Head Office. At the Head Office, the administrator ‘allows’ this Remote location to exchange data with it. Now, whenever the remote location connects to the internet, they can select to ‘Synchronize’ their data, and all updated transactions and masters will automatically get exchanged with the head-office, so that both places have identical sets of data available. This is the simplest use of TallyServer and TallyClient... At a more complex level, and with the help of some programmers who are adept in TDL and/or Web programming, a user could ensure that data is exchanged only after some ‘modification’ has been made to it (for example, data coming from location A would automatically be assigned to cost-center A, or that a Delivery Note for material sent to Head Office becomes a Receipt Note at the Head Office). Highly complex environments can be created using this mix of programming. Taking the second problem - which is working with multiple programs: A TallyClient has capabilities to ‘push’ information to a listening ‘server’ (which is what is described above), and also, capabilities to ‘pull’ information from another ‘server’... Thus, a TDL programmer can use Tally and pick up information from other ODBC compliant databases (which basically means almost all commercial databases like Oracle, MS-SQL, DB2, Access, Foxpro etc). and represent it in Tally. For example, a user could get a report of the current list of Outstandings, customer-wise, with an additional column showing which Salesman is attending the customer, when the last visit to the customer was made, and when the next visit is expected (this information probably coming from his Customer Relationship Management software). On the reverse side, if a TallyServer is installed, a user could write programmes in Visual Basic, Java, Perl, Visual C++, or other scripting languages, to extract information from Tally to use in other applications. One example of this is already available through ODBC. However, the ODBC approach is a little limited in the range of information which can be supplied from Tally... and a person adept in TDL and another scripting language can create esoteric applications. For example, if a person wants remote users to enter vouchers using a browser over the Internet, then a combination of TDL and ASP/Java programming can achieve it. This, of course, requires that TallyServer be installed.
TALLY CAN BE CUSTOMIZED AS PER YOUR NEEDS !
A FEW EXAMPLES OF TALLY CUSTOMIZATIONS DONE BY US: GENERAL MODULES PURCHASE CONTRACTS COST-CENTER WISE OUTSTANDING STATEMENT PURCHASE ORDER WITH CUSTOM TERMS & CONDITIONS
Some
of Your Basic Requirement, You Find
Missing In Tally which is Very Useful in Day to day Transaction &Time
Consuming to Maintain Manually so for that we are providing you Solution
for the same which are as Follows................... Group / Ledger Security Tally’s Group/Ledger Security Module is an add-on for existing Tally users. This module enables you to allow/prevent access to groups & ledgers based on user login The primary intention of this module is to disallow access control of groups/ledgers implicitly, which allows the organization to deploy and allow only the required information to the users. Unique Voucher Number Unique Voucher Number Module enables you to set the voucher numbering for vouchers with unique number allocation, as against default Tally’s function of date based numbering. This enables you to enter even backdated entries, however the number allocated shall be of latest voucher number.¯ Voucher Type Security Tally’s Voucher Type Security Module
is an add-on for existing Tally users. This Module enables you to allow/prevent
access to tally’s default vouchers based on user login.
During Sales/Purchase Voucher Creation, facility is provided to select the Sales Tax Form. On entering the Form Type field, all the Tax Form Types, entered will be displayed. The user has to select the relevant Tax Form Type against which the Sales/Purchase Invoice is being prepared, before proceeding ahead with the Sales/Purchase Invoice entry. Form Type field is followed by Form No and received on field, which are normally left blank during Voucher Entry, as data pertaining to the same is received only after the issue of Sales Invoice. Location/Godown Security Module Tally’s Locations Security Module is an add-on for existing Tally users. This Module enables you to allow/prevent access to locations or godowns based on user login. Price Levels Tally’s price list module enables to review multiple price levels across single screen display, with option to choose the relevant stock group / stock item. Invoice Declaration With this module you can print your own invoice declaration, with an option to modify/configure the declaration text. along with you can add 5 to 6 additional terms & condition Customer Mailing List This module allows you view/print all your customer details (sundry debtors) such as address, telephone, notes, contact person etc., in most simpler and presentable format with an additional feature of F12 configuration option to print only the required columns. Sales Stock Summary This module enables you to look at outwards column broken up in to two columns sales and stock transfers one to look at true sales figure in separate column and allows you to run the profitability report Synchronisation Data shall be synchronized only one way, data would flow from branch office to head office, but NOT from head office to branch office Tally Customization Offshore Software
Development Business Intelligence
Solutions DID
YOU KNOW ? INTRODUCING ... Tally TDS Capsule A simple yet powerful add-on Capsule for existing Tally Users This Capsule enables you to: Automatically calculate Form
16A related TDS (% Rate + Surcharge) Some examples of the TDS Expenses / Sections / Forms covered are : a. TDS on Professional / Technical
Fees -------Section 194J Form 26K The Printing / Return / Certificate related elements cover: 1. TDS Certificate (Created
Automatically)
|