Payment Performance of Sundry Debtors

Payment Performance of Debtors
(Receivable Turnover in days) is the average time the customers take to actually pay their bills irrespective of the outstanding balance on the statement date. It is quite possible that the receivable turnover is low and the payment performance is high, indicating that the customers cleared their outstanding, but took a long time doing it.

To get group level and customer level performance reports and a detailed position of debt collection, you have to drill down from the ratios. Use a customer statement that shows both the receivable turnover in days and the customer’s actual payment performance.

The Ledger Payment Performance screen is displayed as shown:


The Ledger Payment Performance statement displays the receivable turnover in days. This is the balance outstanding in relation to the total sales made multiplied by the total number of days in the period. This ratio should be used in combination with the Average Performance of actual payments and the payment history of the customer to assess how long he might take to pay the outstanding balance.

The Actual payment history is given in the table for each invoice that was paid by the customer. It shows when the invoice was paid, how long it was due and what was the delay in payment. The customer’s average performance is shown at the bottom of the screen.

To view single ledger from Gateway of tally à Display àAccounts Books àLedger

Select the ledger, press F8(other reports), Select Ledger payment performance

You can view a similar group report also.

Gateway of tally à Display à Accounts Books à Group summary

Select the desired group, press F8(Other reports), Select group payment performance

You can press enter on any ledger to view the payment performance of that ledger.

Tally.ERP9 Series A Rel 4.5 Launched

 

 

Tally.ERP 9 is the latest offering of the Tally software series. As with all Tally products, rapid updates are made available for the lifetime of the product via periodic releases, thereby providing the high level of business capability that millions of users trust. This migration is recommended for all Tally 9 licenses.

The Highlights in Tally.ERP 9 Release 4.5 :
64-bit native support application
Voucher Type Security
Single Login for group company
Reverse Charge Calculation


 

How to use Tracking Number

 

The tracking number pop-up list appears after you have entered the name of the item. A default list will contain the following:

 

You will use the tracking number to link this receipt note with the Supplier\”s Invoice that will be received later. (record the Supplier\”s Invoice through the Purchase Voucher). Hence, select the number you think will help maintain the link.

Tally.ERP 9 gives you two numbers that are defaults of the Receipt Note number and the Reference. However, you may opt to give your own number, in which case select New Number. If you do not wish to give a tracking number at all, select

Not Applicable.

 

An explanation on the four options in the list is necessary. Tracking numbers link the different accounting and inventory vouchers as follows:

  • Receipt Note/Goods In vouchers with Purchase Vouchers
  • Goods Out /Delivery Note with Sales Voucher/Invoice.
  • Rejections-In with Credit Note
  • Rejections-Out with Debit Note

New number

Give a number not in the list. You will use this number to reconcile, when making a Purchase Voucher entry.

Not applicable

If you do not want a tracking number. This may be resorted to in cases where you want to update stocks immediately with this entry and no goods inward entry will be needed. When in an inventory voucher if you select \”NotApplicable\”, that will update stocks and you do not want to make a separate accounting/invoice entry. Not Applicable option is important and hence we repeat the cases where you would use it:-

  • When you raise a sales voucher/invoice that accompanies the goods and you do not want to pass Goods Out entry. \”Not Applicable\” will update stocks without the Goods Out entry.
  • Likewise, when you record a purchase voucher and wish to update inventory without a separate Goods In entry, select \”Not Applicable\” for the tracking number.
  • The same applies to Debit Notes-Rejection Out and Credit Note-Rejection In.
  • When you send out samples for approval, where you do not want to raise an invoice. Likewise when you receive samples but no invoice will be forthcoming.

Reports of Sales Agent in Tally.ERP9

How to generate Reports of Sales Agent in Tally.ERP9, if Sales Invoice includes Commission for the Agents?

 

To generate reports of sales agent:

1. Create Cost Category as Commission and Agents as Cost center

  • Ensure the following options are enabled in F11: Features > F1: Accounting Features
    • Maintain Cost Centres
    • More than ONE Payroll / Cost Category
  • To create Cost Category, go to Gateway of Tally > Accounts info > Cost Categories > Create

 


 

  • To create Cost Centres, go to Gateway of Tally > Accounts info > Cost Centres > Create


 

2. Create Commission ledger under Indirect Expenses and enable the cost center option

 

  • To create ledger, go to Gateway of Tally > Accounts info > Ledgers > Create


 

3. While passing the sales invoice allocate the commission to the Agents by selecting appropriate cost category and cost centre

 

 

 


 

4. Check the Category Summary or Ledger Break-up report.

  • To view reports, go to Gateway of Tally > Display > Statements of Accounts > Cost Centres > Category Summary / Ledger Break-up

     


 


 

Key Combinations for Currencies in Tally.ERP9

£ – Pound

Alt + 1 + 5 + 6

¥ – Yen

Alt + 0 + 1 + 6 + 5

€ – Euro

Alt + 0 + 1 + 2 + 8

Ctrl + 4

 

Use ASCII Special Characters with [Alt] key combination, if your keyboard does not have the symbol. Utilities like Character Map (Start > All Programs > Accessories > System Tools) in Windows, shows the key combination for most symbols. This might be different on some notebook computers, refer to the computer’s user manual or the vendor.

STOCK VALUATION AT THE END OF THE YEAR

 

 

Did you know that you can now do stock valuation at the end of the year?

 

How to change the stock value at the end of the year?

 

We need to do the stock valuation whenever there is change in stock prices. Now tally provides this Feature for stock valuation at the end of the year.

 

We can do change value of stock at the end of the year by following way:

Assume that, you are closing your stock value as on 31 March 2007. The financial year ending amount is Rs.10,000/- whereas the Market Value of the same is Rs. 8,000/-.

The Stock value of the item is Rs.10,000/-, as shown in the snap-shot of the stock summary below:

To change the value of ‘Item X’ to Rs. 8000.00, it is suggested to alter the ‘Stock Item X’ and set the standard rate for the same, as follows:

1. Go to Inventory Info > Stock Item > Alter > ‘Stock Item X’, press F12 (Configuration) and activate the option ‘Allow Std. Rates for Stock Items’

 

 

2. Next, go to the option Alter Standard Rates (under Item alteration screen) and mention the standard cost applicable rate as Rs. 80 per item applicable from 31-03-2007.

 

Now the value of the stock item will become Rs. 8000.00 (Rs. 80 x 100no.s)

 

3. Then, change the Costing Method from Avg. Cost to Std. Cost

This way we can change value of stock at the end of the year. Tally.ERP9 provides easy way to do stock valuation through F12 feature.

 

VAT Assessable Value bifurcation Utility

VAT Assessable Value bifurcation Utility

Introduction

Tally has an inbuilt VAT computation and reporting system which shows VAT Tax class wise bifurcation of assessable value and Tax value as shown in following illustration.


During audit user still needs to verify and certify the correctness and generate bifurcation of the VAT assessable values for various VAT Types. This Utility will assist the users / auditors in validating the bifurcation of the VAT assessable value.


The Amount Shown of Rs. 205617 is total assessable value for Input VAT 12.5%.

Similarly the output vat computation will be as follows.


 

The customized report has a drill down facility that will allow you to drill down to voucher level if required.

 

Highlights

  • The report also shows columns for vat class “NOT APPLICABLE” and it will show a total of all transactions in which VAT class was not selected / enabled. Eg. A figure of -10000 is being shown under NOT considered for VAT because a sales return was done by JV in which VAT class was not used.
  • The report has another column for not considered for VAT. This will show values of transactions in which VAT / Class is not selected at all. In the example the value -10000 has appeared because a sales return was settled using a JV.
  • The column totals for CST 2%, Output VAT 12.5% and Output VAT 5% are matching with the VAT assessable values of the VAT computation report above.
  • “Output VAT Reco report” will include credit notes also.
  • “Input VAT Reco Report” will include debit notes.

 

For a demo please mail your tally serial number to makrands@winjit.com

ACCESSING FINANCIAL RECORDS VIA SMS in Tally.ERP 9

Did you know that you can now access business information from anywhere by SMS?

In this information age, when time has become even more precious than money, timely access to business information can change the way one does business. Now, Tally provides a solution with which you can access information from your Tally.ERP 9 system anytime, from anywhere, simply by using an SMS-based service named ‘PULL SMS’. The service is available for the Tally.ERP 9 Series A release 2.0 or later, as part of Tally.NET services portfolio.

 

How it works

To get started with this service, first register the mobile number(s) that you will be using to access information. Only those who are authorized by the system administrator to access information can do so using the Tally system. Then, you need to enter your query or requirements and send it to 556679.

To access information, you need not type any key word or follow any syntax; just type free text, quite akin to writing in your ‘natural language’. For example, in case you type in ‘Sales for Today’, the software will return–the sales figure for that day. After this, if you type, ‘Yesterday’, the context of the previous SMS is retained and the sales figure for the previous day is shown. Now, the previous request can be overridden by sending another query via new key words, such as ‘Purchase today’ and figures corresponding to this query will be received

 

Configure SMS in Tally.ERP 9

This can be done in four easy & simple steps:

 

1. Include Mobile Number:

Login to the Control Centre by providing User ID and Password

  • Click ‘W: My Profile’ or press ‘Alt+W’
  • Select the required ‘Salutation’
  • Enter the ‘Name’ of the contact person
  • Enter the mobile number in ‘Mobile No(s)’ field

 


  • Accept the screen

 

2. Enable SMS

  • Go to Gateway of Tally > F11: Features > F4: Tally.NET Features
  • Set ‘Yes’ to ‘Enable SMS Access’
  • Enter the short name for the company in ‘SMS Company Name’

 

 


 

  • Accept the screen

3. Authorize Users

  • Go to Gateway of Tally > select ‘F3:Cmp Info’ > Security Controls > User and Passwords
  • Select the required ‘Security Level’
  • Enter user’s email id in ‘Name of User’
  • Set ‘Yes’ to ‘Allow Remote Access’
  • Set ‘Yes’ to ‘Allow SMS Access’

 


 

  • Accept the screen

     

4. Connect Company

  • Go to Gateway of Tally > click ‘F4: Connect’

 

 

On successfully connecting the company to Tally.NET the message appears in the calculator pane.

You can now proceed to query information via SMS by sending in your queries to 556679<9>. <9> is the SMS Suffix or a unique sequence number allotted to each company connected.

Hence, with Tally.ERP 9′s SMS option, you can have up-to-date financial record of your business wherever you are.

Item Cost Tracking in Tally.ERP 9

Item Cost and Profit Tracking refers to accumulation of costs and revenue for a particular quantity of a Stock Item across various transactions. The track can be created with any transaction and then referred subsequently in any transaction without needing the discipline of any master or configuration. Thus allowing to analyze the running cost and profitability of the item being tracked through manufacturing, sales, purchase and so on.

The Item Cost and Profit Tracking feature helps you effectively track and ascertain the Procurement cost, Landing costs, Manufacturing or Production cost, Order cost/profit, Job cost/profit. This feature is also useful in determining Sale price of finished goods based on the costs incurred till date and the overall profitability.