CASE STUDY : Implement Manual VAT masters for a New State in India

OBJECTIVE  : Fast Roll out implementation   for any new state

RESOURCES GIVEN  : Item list file in .xls

THINGS TO DO : New deployment  of  items ,as Haryana is not in our standard state list all  Local & Interstate Sales /Purchase ledgers  and its corresponding VAT/ CST ledgers with their linking are to be done manually  .New units are to be introduced . Item properties is  made parallel .    

COMPANY CREATION

The Configuration_Settings  file in the Accord Four Folder  is to be modified in notepad mode as [UNIT_UNIT] KGS;MTR;PCS;BOX;SET;NOS;LTR;GMS   

Company Details

country : India
State : Haryana

Create a new company of Fin Year 2015-16 of State : Haryana.

In Item List Import Xls sheet Units are predefined as  KGS;MTR;PCS;BOX;SET;NOS;LTR;GMS   in different items . To correct item wise import with its respective units defined , one can pre-configure units in the Configuration setting  text file .   

In Company Details , you may or may not be configure Country : India and State: Haryana. But while creating new company  you have  to select Country name and proper State name from selection list .

ITEM IMPORT

A product list given in xls file having product name , rate, Tax % , Unit-I and Unit II. Download the Item Import Template from  Accord Four application menu  Tools >Import Data >Item Import. Fill the following columns in the import template xls from the given item list xls  columns in the import template xls from the given item list xls  

 

Desc

Unit

SaleRate

VAT

CST

Parallel Unit

Product names

Unit –I  

Rate

5.25

5.25

Unit II

Save the xls  file as IGLMST .Go to Menu   Tools >Import Data >Item Import and Product Import from Excel.

VAT – CST LEDGER CREATION  & ITS LINKING

Press F2  to create ledgers like

 

SALES  LOCAL

SALES  INTERSTATE

PURCHASE LOCAL

PURCHASE INTERSTATE

SALE @ 13.13%  

INTERSTATE SALE @ 13.13%

PURCHASE @ 13.13%

INTERSTATE PURCHASE @ 13.13%

SALE @ 5.25%

INTERSTATE SALE @ 5.25%

PURCHASE @  5.25%

INTERSTATE PURCHASE @ 5.25%

 

INTERSTATE SALE @ 2% AGAINST C  FORM

 

INTERSTATE PURCHASE @ 2% AGAINST C  FORM


Press  F7 > VAT Master > insert to create VAT/CST ledgers like

 

OUTPUT  TAX VAT

LEDGERS CST

INPUT  TAX VAT

LEDGERS CST

OUTPUT  VAT @ 13.13%

CST @ 13.13% ON SALE

INPUT  VAT @ 13.13%

CST @ 13.13% ON PURCHASE

OUTPUT VAT @ 5.25%  

CST @ 5.25 ON SALE

INPUT  VAT @ 5.25%

CST @ 5.25 ON PURCHASE

 

CST @ 2% ON SALE

 

CST @ 2% ON PURCHASE

Press  F7 > VAT LINK > insert to link VAT/CST ledgers with its respective assessable ledgers

PURCHASE/SALE

VAT/CST LEDGERS

 

PUR/SALES LEDGERS

% DEFINED IN PRODUCT MASTER

PURCHASE

INPUT  VAT @ 13.13%

Linked

PURCHASE @ 13.13%

13.13%

 

INPUT  VAT @ 5.25%

Linked

PURCHASE @  5.25%

5.25%

 

CST @ 13.13% ON PURCHASE

Linked

INTERSTATE PURCHASE @ 13.13%

13.13%

 

CST @ 5.25 ON PURCHASE

Linked

INTERSTATE PURCHASE @ 5.25%

5.25%

 

CST @ 2% ON PURCHASE

Linked

INTERSTATE PURCHASE @ 2% AGAINST C  FORM

2%

SALES

OUTPUT VAT @ 5.25%

Linked

SALE @ 5.25%

5.25%

 

OUTPUT  VAT @ 13.13%

Linked

SALE @ 13.13%

13.13%

 

CST @ 5.25 ON SALE

Linked

INTERSTATE SALE @ 5.25%

5.25%

 

CST @ 13.13% ON SALE

Linked

INTERSTATE SALE @ 13.13%

13.13%

 

CST @ 2% ON SALE

Linked

INTERSTATE SALE @ 2% AGAINST C  FORM

2%

  GO BACK ←

British Electric

A long time back British Electric needed a more robust Accounting Solution that would consolidate all their Accounts into a single platform. view more....

Gold Manufacturing

Mr.Raman  Soni for making gold ornaments through stock out entry under manufacturing voucherview more....

ADC INTERIOR L.L.C.

ADC Interior L.L.C., needed a more robustcustomizable and   integrated softwarethat would consolidate all their view more....

Unitech Chart of Accounts

The Company was facing the difficulty of import of items and ledgers in a lumpsome way. view more....