Taxation for mlm Industiries

In India we have many mlm companies having TDS according to the government Rules and regulation with few methods and simple ways we can create the TDS forms using the Access , the necessary steps to create the the Database and reports according to the rules of the government , lets see the details in step wise  , This blog helps users or persons working in mlm industry to have TDS software let see the TDS creation in a simple and easy method.

The MLM industries may give the TDS in Monthly basic or in a Quarterly basic or Yearly basic its all depends on the Industry requirement

Steps As...
Mostly which i have done in Quarterly basics...

like 4th month 7th month , 10th month so on....

which i made in Access 2003

Open Access database and create Table for the Tds Containing Details of

Table: Dealer Name ,Dealer Id , Spouse Name Spouse Id , Bonus,Tax,month,etc...

Once the table is created update the records according to the information which u have
and create form to generate the report

Queries for Appending the records from source to current database


INSERT INTO TDS ( BH, XM, DS, SE, TB, XBH, DQDM, ymonth, SS )
SELECT ts1111q.BH, ts1111q.XM, ts1111q.DS, ts1111q.SE, ts1111q.TB, ts1111q.XBH, ts1111q.DQDM, ts1111q.Ymonth AS Expr1, ts1111q.SS
FROM ts1111q
WHERE (((ts1111q.DS)>0));

from Source table to destination table append 

After the data s is been appended 

Update if any special characters in Data using 

UPDATE tds SET tds.XM = Replace(Replace(Replace([XM],".",""),"'",""),",","");

After the data is verified here he create the records according to the group of the Dealer who is have 3 months and above to create the reports .

Using the records using Grouping we do query as 

SELECT TDS.BH, TDS.DQDM, 1 AS SNO, Sum(Round([SE])) AS S, TDS.TAXNO INTO Sample

FROM Sheet1 INNER JOIN TDS ON Sheet1.[ID No] = TDS.BH

WHERE (((TDS.TAXNO)>"0") AND ((TDS.DQDM)=[Forms]![PAN]![DQDM]))

GROUP BY TDS.BH, TDS.DQDM, 1, TDS.TAXNO

HAVING (((Sum(Round([SE])))>0));

Now we start with creating reports in Access to create the PDF Format

To generate the reports we create the SQL command 

Here the Sql Command as Follows.

SELECT Sample.BH, Sample.DQDM, Sample.Sno1, Date.Start, Date.End, Date.tax, Address.XM, Sample.Convert, Sum(Round([tds].[correctbonus])) AS DS, Round([tds].[SE]) AS TotalTax, Address.ADDRESS, tds.TAXNO, tds.Pdate AS pdata, tds.cdate AS chdata, tds.Chequesno AS Chequeno, tds.Vouchersno AS Voucherno, Address.COMP_ADDRESS AS Comp_Addre, Address.POSTALCODE, Round(Sum(Round([TDS]![DS]+[TDS]![TB])-(Round([TDS]![XBH])))) AS Refund, tds.Cess AS Cess, tds.SE, tds.Surcharge AS Surcharge, tds.Brcode AS Bcode

FROM ([Date] INNER JOIN (Sample INNER JOIN tds ON (Sample.BH = tds.BH) AND (Sample.DQDM = tds.DQDM)) ON Date.Sno = Sample.Sno) INNER JOIN Address ON Sample.BH = Address.BH

WHERE (((Sample.BH)=[Forms]![Detail]![BH]) AND ((Sample.DQDM)=[Forms]![Detail]![DQDM]))

GROUP BY Sample.BH, Sample.DQDM, Sample.Sno1, Date.Start, Date.End, Date.tax, Address.XM, Sample.Convert, Address.ADDRESS, tds.TAXNO, tds.Pdate, tds.cdate, tds.Chequesno, tds.Vouchersno, Address.COMP_ADDRESS, Address.POSTALCODE, tds.Cess, tds.SE, tds.Surcharge, tds.Brcode, tds.DS, [TDS]![SE]

ORDER BY tds.Pdate, tds.cdate;

If need any support or Help on this TDS Generation For MLM please contact through mail i can assist ans help u

TDS Generation

In MLM TDS Preparation is difficult to some companies due to different rules in different countries and many distributors will be active for few month and may not , to solve this problem i have a few techniques and simple application to solve the problem using Access and reports generated to export in using VBA to PDF, Here we learn how to generate TDS for the MLM companies with a simple example and Query to process the application in successful method .

Step : 1  Make a data compiled according to the section you would like to create the report for the distributors.