• Who We Are
    • About Us
    • Factor - D
    • Our Networks
    • Accolades
  • What We Do

    SERVICES

    • Consulting / Implementation
    • Migration
    • Development

    OUR SOLUTIONS

    • GUMU Integration
    • BPortaly
    • Sales Commission
    • Shipping
    • IOT

    COMPREHENSIVE SERVICES FOR

    ERP

    • Acumatica
    • Sage Intacct
    • Sage X3
    • Sage 300
    • Sage 100
    • Sage 500

    CRM

    • Salesforce
    • D365 CRM
    • Sage CRM
    • Creatio
    •  

    Other Solutions

    • E-commerce
    • EDI
    • POS
    •  
    •  
  • Resources
    • Case Study
    • Blogs
    • Videos
    • Ebooks
    • News
  • +1 888 221 6661
Contact us
Career |
  • Africa
  • Middle East

Sage 300 ERP – Tips, Tricks and Components

Explore the world of Sage 300 with our insightful blogs, expert tips, and the latest updates. We’ll empower you to leverage Sage 300 to its fullest potential. As your one-stop partner, Greytrix delivers exceptional solutions and integrations for Sage 300. Our blogs extend our support to businesses, covering the latest insights and trends. Dive in and transform your Sage 300 experience with us!

Tax Audit Report

By sage300 | April 28, 2015
1 Comment

During audits your auditor may ask you to reconcile the TDS amount with the general ledger accounts. The general accounts are used in the respective transactions where TDS is being deducted; also this account can be used to calculate balance sheet or income statement.
In Sage 300 ERP we have customized such kind of reports for one of our clients that can help us reconcile the TDS amounts with the corresponding general ledger accounts. Purpose of the report is to display the general ledger accounts and the TDS amounts deducted in front of each of them along with the debit and credit amount. The Report UI will look as shown below.
New Stuff:Migrate Item Pricing from Sage 50 US (Peachtree) to Sage 300 ERP
01
The UI has a filter criteria of “from” and “to” Account Number along with the Posting Date.
The report has the below columns:
 Account number and its description
 Source Type
 Date
 GL Batch- Entry Number
 Vendor and its Name
 Debit Credit Amount
 Document Number
 TDS Percentage
 TDS Amount
Also this report gives us the detailed list of all the transaction of AP, GL-Journal Entry and PO with and without TDS. This report also displays tax accounts along with the corresponding TDS and gives us the detailed line wise proration of TDS amount.
The report will be generated in excel format. Output of the report will look like the following:
02
Thus this report can turn out to be critical when it comes to reconciling the TDS returns before you file it.
Also Read:
1. Greytrix TDS with PJC Integration
2. Multicurrency in Greytrix TDS
3. Configuring Greytrix TDS in Sage 300 ERP – II
4. Manual TDS Posting in Greytrix TDS Module for Sage 300 ERP
5. Configuring Greytrix TDS in Sage 300 ERP – III

Related Posts

  • Statutory Audit Report for TDS
  • Tax Tracking Report in Sage 300
  • TDS Section Summary Report
Category: TDS Tags: and Reconciliation of TDS, AP- PO Transaction report with TDS, Reconcile TDS with General Ledger Account, Sage 300 ERP, Sage TDS, Tax Audit report, TDS Report
Post navigation
← Migrate Item Pricing from Sage 50 US (Peachtree) to Sage 300 ERP Update & Delete rights to specific Users →

Greytrix Websites and Blogs

  • Greytrix
  • Greytrix Africa
  • Sage X3 – Tips, Tricks and Components
  • Sage 100 & 500 ERP Tips and Tricks
  • Sage CRM – Tips, Tricks and Components
  • Salesforce.com Tips and Tricks by Greytrix
  • Sage Intacct– Tips, Tricks and Components
sage crm and sage 300 integration

Categories

  • Sage 300
    • ACCPAC SDK
  • Sage 300 People
  • Sage 50 US
  • Sage Business Cloud
  • TDS
  • Uncategorized

Recent Posts

  • Inspection Release Note
  • GL Customized Report
  • Introduction to OCR Analyzer Add-on for Sage 300 ERP
  • Input Service Distributor (ISD) for Sage300
  • Customization of Default commits quantity on greymatrix order entry screen.

Archives

Awards

Premier Partner of the Year Premier Partner of the Year
Platinum Partner of the Year Platinum Partner of the Year
The CEO Story The CEO Story
Gold Partner pf the Year Gold Partner pf the Year
Top Excellence Distributor Top Excellence Distributor
  • na.sales@greytrix.com
  • +1 888 221 6661
  • B301, 3rd Floor, Everest Nivara Infotech Park, MIDC, Turbhe,
    Navi Mumbai 400 705. India

Our Global Locations >>

Who We Are

  • About Us
  • Factor - D
  • Our Network
  • Accolades
  • Career
  •  
  •  

Services

  • Consultation & Implementation
  • Migration
  • Development

Solutions

  • GUMUTM Integration
  • BPortaly
  • Sales Commission
  • Shipping
  • IOT
  •  
  •  

ERP

  • Acumatica
  • Sage Intacct
  • Sage X3
  • Sage 300
  • Sage 100
  • Sage 500

CRM

  • Salesforce
  • D365 CRM
  • Sage CRM
  • Creatio
  •  
  •  
  •  

Other Solutions

  • E-commerce
  • EDI
  • POS

Resources

  • Case Study
  • Blogs
  • Videos
  • E-books
  • News
  •  
  •  

Connect

  • Contact Us
  • Privacy Policy
  • Terms Of Use
  •  

© 2025. Greytrix, All Rights Reserved