Clause 44 of Form 3CD (Tax Audit)

Discussion in 'Tally Developer' started by Amit Kamdar, Sep 8, 2022.

    
  1. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Managed to extract data in Tally in the required format.

    Still to add - Fixed Assets.......

    clause44-1.PNG
     
    psr and Gagan Jyoti like this.


  2. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Groups -- Fixed Assets and Misc.Exp (ASSET) added.

    Group-wise report......

    In Case of non-allocation, difference will be highlighted in RED color.

    clause44-2.PNG
     


  3. PANKAJ BHONDLE

    PANKAJ BHONDLE Active Member


    ADD COLUMN NO.8 [GST TAX AMOUNT]
     



  4. Sir please give your services to TSPL also. They are badly in need of your talent.

    Otherwise TSPL is disappointing very much.
     
    Amit Kamdar likes this.


  5. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Okay .... Do you have the format?? Any revision in this Form?? Send to me.
     


  6. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Maybe they will check this FORUM Site and recognize the many many talented coders here..........

    and hopefully will give some of the talented coders -- a much bigger platform to showcase. ;):):cool::cool:
     
    Rajnish Kapahi likes this.



  7. Excellent work.. i have just completed my file today only
    but happy to see your work .... will me making few changes ie GUI changes like yours

    thanks
     
    Amit Kamdar likes this.


  8. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    very good..........share screenshots of your goodies.... :):cool:
     



  9. sure will do the same after making few changes of GUI .. more important my module is cross tallied with GSTR2 hence it took time to develop
     


  10. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    This Clause 44 Report has nothing to do with GSTR-2 tallying.

    All expenses has to be shown..... even bus.prom, food, petrol, stationery, conveyance, travelling etc. And if there are any bills/items within this expense head and has a GST invoice, then you need to show in COL-5 else COL-7.

    e.g. Travelling has a total for 15375/- out of which there are GST paid hotel bills of 11375/- (nett of GST) then it will come under COL-5 and balance is like bus fare, taxi, then it should be under COL-7

    Fuel exp should be shown under COL-3 (Exempt)

    Expenses head like Depreciation, Bad Debts, W/offs, Round offs, Salaries, Wages, Remuneration etc are to be excluded. (Refer guidance notes as per ICAI)

    Groups to be included are - Purchase, Direct & Indirect Exp, Misc.Exp (Asset) and Fixed Assets.
     



  11. I partly agree but there expenses has to be broken into categories where its purchased from Registered Vendor, Unregistered Vendor , Composite Vendor and Lastly Its Exempt.. Also expenses which are not covered in above category you can report in 1 more column which is not in GST





    if you check the video we will get more idea .. i might have interpret it wrong. but what i have understood it requires the breakup on basis of gst vendors

    There are expenses/Purchase which can be from either unregistered vendor or registered vendor for same product or type of expense or might be from composite Vendor
    that needs to be broken properly.

    I understand as of now it wont be more of important for users they might give it as per their understanding but later on its narrowing to the Audit point
     


  12. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Revised Format....

    Items not allocated or items with difference will be highlighted in RED.

    Enter respective LEDGERS from this screen for Voucher-wise data.


    clause44-1.PNG
     
    Gagan Jyoti and Devendra_Rawat like this.


  13. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Having problems in uploading the rest..... will upload later.....
     



  14. Sir first let me thanks for the IDEA of Good GUI ie presentation
    also 1 suggestion increase 1 more column like i have done in the report
    The last column will be of expenses not to be reports like Salaries , Depreciation etc which are not part of the report and still to TALLY the same with P&L can be done
    Rest i belive as data is different of both of us we cannot test each others module but would belive give same results


    View attachment 9367
     


  15. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Your photo not being shown, there seems to be some problems. Re-Upload it later.

    Regarding the Reconciliation, I have made a separate report to show the reconciliation with the Final Books and also give CAs remarks/notes.

    Also work going on -- for a voucher-wise Audit for CAs working papers. This report will be of immense help to Companies and their CAs when the company has multi branches and they file a consolidated Final Results. But this will take some time to make, as am busy with other things.
     


  16. Amit Kamdar

    Amit Kamdar Administrator Staff Member



  17. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Purchase Ledgers


    clause44-05.PNG

    clause44-06.PNG
     
    Rajnish Kapahi likes this.



  18. Excellent approach for the drill down...
    i have added the field in end attaching it ... i have used similar GUI as yours as was happy to adapt it
    i have spoken to few CA also which had this would help to cross verify the complete expenditure with P&L.

    upload_2022-9-10_22-27-34.png
     
    Rajnish Kapahi likes this.


  19. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Lovely....well made :):)
     


  20. Himanshu-2002

    Himanshu-2002 Active Member


    Hello Sir,
    I also have to build the same report But I am not sure... If my report is correct.... Is it possible to share a Trial TCP?

    If not... It's completely fine... No worries
     


  21. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Okay... you begin building the report .... and share the screenshots .... and if there are any errors, will guide you through.
     


  22. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Sorry I do not have a Developer License, so cannot make any TCPs (trial or otherwise).
     


  23. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    Reconciliation Statement.......

    Still some fine tuning is pending...........


    clause44-07.PNG
     


  24. sharat

    sharat New Member


    Sir, How to get TDL (Clause 44) in 3CD
     


  25. Amit Kamdar

    Amit Kamdar Administrator Staff Member


    It is not for sale.
     


Share This Page