Vat_Reports

1. I am printing VAT Challans on A4 Paper Size. Challan is being printed in landscape Mode. However out of the four parts, three parts are printed correctly but about an inch of the fourth part is not printed. Why?

Printer setting may be A4 Legal Landscape. So either use Legal Paper or change the Paper setting to A4 landscape. You may also have to increase the Right Margin.

You have marked yourself as tot dealer. Rectify it through firm setup. See Help Topic Firm Setup

3. I am looking at Form VAT-20 for the six months period. ITC B/F from previous Year is not being Considered at S.No. 4(a). What could be the reason?

Form no. 20 is supposed to be printed for the whole year. It will consider ITC B/f when full year Period is given. The problem is likely to be solved in future versions.

4. I am purchasing goods from exempted units. I have claimed notional credit on the said goods. However in form no. 15, it is showing the exempted stock balance. I have already sold the goods. What should I do?

Your attention is invited to help topic no. 79 & 80 which deals with notional ITC and Exempted stock. It seems that you have wrongly attached the vat class 'Purchase from exempted Units without notional ITC'. This class should be used only where notional ITC is not claimed.

This option sends output to the default printer. Please see that the relevant printer is switched on and is your default printer.

6. We make purchases of packing material from vat dealers. This account is marked in vat returns As 'packing' under additions. But the packing purchase figures are not considered in vat returns?

You should mark this A/c as purchase in vat classes. Packing as additions is used only when packing is charged as an addition to purchase / sale in which case relevant purchase/Sale amount is increased by the amount of packing.

7. All my .XLS files as prepared by V.catpro are properly validated. When I try to upload files on Department site it gives the message that file are not valid xls files. What could be the reason?

Department Keeps on changing their Xls file formats from time to time. Last change (as of writing this para on (21-10-2008) was made on 25 sep. 2008. So if any body is using old version of Visual Catpro this error will come. It is very likely that department will change their e-File xls format file every Quarter. So users are advised to use our latest version.

8. At the end of Vat Return, name of one of the partner is printed. But he is out of station today. How can I change the name?

9. Certain credit notes were issue against rebate & discount to Inter-state customers. Information as given in Form VAT-15 & Form-I is O.K. But I do not want to show these credit notes in Form No. 18. What should I do.?

This is possible w.e.f. version 4.9.36. Four new setting are available in VAT Return Module to hide goods returned information in Form No. 18,19, 23 & 24. If you specify yes against the prompt "Hide goods returned information " under Form Vat 18 then the credit notes information will not be shown in Form VAT - 18. However a new pink color button is activated to show list of Sales Returns / Credit Notes. This shall apply subject to the following conditions: -

1. Accounts in which goods return / credit notes are posted should be classified as Sale / Purchase Returns under Balance Sheet Class.

10. My sales account balance does not tally with VAT return. Main reason for this is that excise duty is included in VAT returns. How can I see how much excise duty is included in the Sales Amount?

Sales Amount as shown in vat returns includes certain additions like Excise duty, Cess, Packing etc. a new button 'Amt. Details' is available in each of the forms 18,19,23,24 (w.e.f. ver 4.9.41). When you click on this button you will be shown the amount of additions made in the Sale Amount.

11. My Gross Sales as per Form VAT-15 does not tally with my Sales Accounts. What could be the reason?

Check that Vat Classes are properly assigned to your accounts. Reconciliation of Sales with Vat Return is available in Others option in Bottom Button Bar of Vat Form 15. (w.e.f. Ver. 4.9.43). Reconciliation of Purchase & VAT/CST is also available.

12. I want to fill 'interest under CST act in VI(2) of Part B of Form VAT-20'. How can I modify my report to show interest in the report?

You may edit most of the reports by pressing Ctrl + Shift + E while previewing the report. In this mode you may Add/Delete/Edit any row of the report. The changes are not saved anywhere. Hence the modified report should be printed immediately after editing. Note that you have to make consequential changes in total etc. manuall.

Yes. You may preview Form-1 and then Press Ctrl+Shift+E to edit it. However changes made will not be saved. This is a general facility to edit most of the reports in Visual Catpro. See Help Topic Advanced Features of Preview.

Yes. You may edit Form-16 by pressing the 'F3: Edit' button from the Bottom Button Bar. The general facility of editing by pressing Ctrl +Shift+E while previewing a report does not work here.

15. I have one Laptop & one desktop. On desktop we have prepared the return. When I restore the data on my laptop & VAT return some differences are observed. What could be the reason?

In addition to your data, VAT Reports are depended upon the various settings of your software. Settings w.r.t. VAT returns can be changed by pressing F11 while in VAT return module.

It seems that your VAT settings in laptop differs from your desktop. While restoring data you should click the advanced button and check the checkbox against the prompt "Restore Settings File".

16. While making E-Files(Punjab) I observe that totals in Form-18,19,23,24 does not appear in excel files. What should I do?

No totals are required to be entered by us. However department has provided totals row at the bottom of the excel sheets. Clicking on any of the cells meant for totals shall display totals in the whole row.

17. While making E-Files(Punjab) I observe that Retail Sales appear in after totals in hard copy does not appear in excel sheet(Form 23). Should I write it manually?

We are of the opinion that total of retail sales are not required to be submitted in E-Files. However you may add the retail sales in Excel sheet of Form 23, If you do not agree with our opinion.

To show Rebate & Discount in VAT return you must open an account like 'Rebate & Discount' and attach balance sheet class Sales return with it. However, you may want to show the rebate & discount in P&L account. For this purpose you will have to open another account namely 'Rebate & Discount(P&L)'. You may transfer the amount of Rebate & discount to this account to show the rebate & discount amount in P&L account

Form 16 can be printed only on laser printers. It seems you are trying to print on Dot matrix printers. Draft mode is not supported for printing of form VAT-16.

There are different settings to which can effect the VAT return. Here under the different cases:

If Show 'Show Sale/Purchase Returns Separately' setting is marked as 'No' the the above entered voucher in VAT 15 will be shown as under:

If 'Show Sale/Purchase Returns Separately' setting is marked as 'Yes' the the above entered voucher in VAT 15 will be shown as under:

If 'Reduce Gross Purchases' setting is marked as 'Yes' the the above entered voucher in VAT 15 will be shown as under:

19. While making VAT returns it shows the error: Non-Dealer purchase from Vat dealer. I purchased from Non-dealer. I haven't fill the TIN no. in master. It is still showing the error. What could be the reason?

20. When I debit some amount in Vat Output account, it asks about the nature of payment in one of the firm maintained in Visual Catpro. However, it does not prompt this in another firm which also maintained in Visual Catpro. What could be the reason?

If you have marked 'Yes' against the setting 'Use Input / Output tax a/c interchangeably', it will not prompt for nature of payment when you debit an amount in Vat Output account. Further you must ensure that vat class 'OUTPUT TAX(VAT)' is attached with Vat Output account.

21. I have different kind of central sales like Sale CST 2%, Sale CST 4% Sale against H Form etc. In form no. 18 all sales are shown together. I want to print separate list of sales for each sales type. How can I do this?

In form no. 18 sales of different types are grouped together. A sub title for each sale type also appear. However, you may print a separate list for each sale type by selecting appropriate sales type from 'F7: Others' from bottom button bar in VAT form 18. The similar facility is also available in Form VAT-19.

22. We are managing data of our head office and branch office in separate firm. But we want to make their VAT return jointly. How can I do this in Visual Catpro?

23. While viewing Form VAT-16. It shows me some amount against 'Sales within State (non-taxable person)'. After double clicking on the amount it takes me to Form VAT 23. It shows me the amount in total but it does not show me anything in the grid. What could be the reason?

When we open Form VAT-23 by default it does not show the Non dealers detail. To view the Non-dealers details in Form VAT-23 click on 'F4: Parties' -> 'Non-Dealers only'.

24. I want to view the VAT return of a selected account in Visual Catpro. How can I do this?

To view a VAT return of a specific account. Open its A/c statement and then Click on 'F7: Others' -> 'Show VAT Information'.

25. Visual Catpro is not asking for additional VAT information in case of Cash Sales. What could be the reason?

If you want to input additional VAT information for cash sales. You should mark 'Yes' against 'Input Additional VAT Information' settings in Voucher updation module.