Advanced Analytics for TallyPrime

Advanced Analytics for TallyPrime helps you gain clear visibility into your financial data, track key metrics like revenue, expenses, and profitability, and identify underlying trends in your business performance. It enables you to make informed decisions, optimize cash flow, and build effective strategies to drive growth and maintain a competitive edge.

You can also reports from TallyPrime along with data using this integration.

Prerequisites
Setting up the Integration
- Modules and Fields
- Data Sync Frequency
Handling Data Synchronization Failure
Managing Data Sources
Data Modeling & Preparation
Data Visualization/Analysis
Sharing & Collaboration
Help & Support

Prerequisites

To set up the TallyPrime Advanced Analytics connector, TallyPrime must be installed and running on your machine and Zoho Databridge should be installed. The following prerequisite steps are designed to help you create the necessary TallyPrime App and obtain these credentials.

Step 1: Configure TallyPrime — Enable ODBC

Open TallyPrime.
Navigate to: Help > Settings > Connectivity.
In the Connectivity page, select the Client/Server Configuration.
In the Client / Server Configuration under TallyPrime Acts As, choose the configuration that suits your setup and ensure Enable ODBC is set to Yes.
Please note the Port value, which is required during the setup process.
ODBC will be automatically enabled, which is required for the Zoho Databridge connection.

Step 2: Install & Upgrade Zoho Databridge

To set up this integration, you need to install a Databridge on either your TallyPrime server or a local server that can connect to TallyPrime. The Databridge acts as a link between TallyPrime and Zoho Analytics, periodically collecting data from TallyPrime and sending it to Zoho Analytics for analysis.

Download and install Zoho Databridge from Zoho Analytics.
If Databridge is already installed, open the application and check for updates. Upgrade to version 10.9.8 or above, earlier versions do not support TallyPrime integration.
Ensure the Databridge agent is running before proceeding. You will select this agent later during the Zoho Analytics setup.

Setting up the Integration

A Zoho Analytics user with administrator privileges (Account admin, and Org admins) can configure the integration.

Follow the below steps to import your TallyPrime data into Zoho Analytics seamlessly:

On the Zoho Analytics home page, click Import Your Data.
Navigate to the Finance tab and select TallyPrime from the available data sources.
The Important Prerequisite dialog will open, prompting you to install the Zoho Databridge to set up the integration. Install it to proceed.
The dialog box Step 1: Import from TallyPrime will appear.
Enter the Workspace Name and Workspace Description (Optional).

Enter Connection Credentials from your TallyPrime Account.

Credentials	Details
Connection String	Format: DSN=<DSN_Name>; PORT=<PORT_Value> To find your DSN Name: Search for ODBC Data Source on your system, go to the System DSN tab, and copy the name listed under the 64-bit ODBC Data Source for Tally. Use the Port value you have noted earlier.
Machine Name & Port	Format: <Machine_Name>:<PORT_Value> Enter the hostname of the machine running TallyPrime, followed by PORT information.
Company Name	Enter the company name exactly as it appears in TallyPrime. This is case-sensitive.
Choose Agent	Select the Zoho Databridge agent from the dropdown. If the agent does not appear, ensure Databridge is running and is version 10.9.8 or above.

Click Authenticate TallyPrime. Zoho Analytics will authenticate via the Databridge agent and retrieve your TallyPrime data schema.
In the next step, select the Modules and Fields from which you intend to import data.
You can also choose the Reports to import from TallyPrime. These reports will be imported as tables in Zoho Analytics.
Select the Fiscal Year for data import. This applies only to TallyPrime Reports.
In the How Often section, set up a schedule to import data at regular intervals. Refer to the Data Sync frequency section to learn more.
Click Create.
The data import process will be initiated and may take a few minutes depending on the data being imported. You’ll receive an email and in-app notification once the initial data fetch is complete.

Note:

The initial fetch might take a few minutes depending on the volume of the data to be imported. An email and an in-app notification will be sent, once the initial fetch is complete.
The setup process can sometimes fail for a variety of reasons. In this case we request you to access the Data source tab and click the Retry link to import again. If the issue persists then write to support@zohoanalytics.com.

Modules & Fields (What are the modules and fields in PayPal that will be synchronized in Zoho Analytics Workspace?)

The below table lists the modules and fields that will be synced to Zoho Analytics.

Modules	Fields
Godown	Active From, Active To, Excise Registration Date, LUT Date of Issue, LUT Expiry Date, Bond Date of Issue, Bond Expiry Date, Name, Address, GUID, PIN Code, Phone Number, Excise Range, Excise Range Address, Excise Division Address, Excise Commissionerate, Excise Range Code, Excise Division Code, State Name, Parent, Narration, Remote GUID, Remote Alternate GUID, Target Remote Id, Entered By, Altered By, Type Of Update Activity, Object Update Action, Requestor Rule, Importer Exporter Code, Excise Reg No, Job Name, Excise Registration Type, Excise Mailing Name, Excise Manufacturer Type, Excise Large Tax Payer, Excise Division Name, Excise Comsnrate Code, Excise Comsnrate Address, ARE1 Serial Master, ARE2 Serial Master, ARE3 Serial Master, LUT Number, Bond Number, Authority Name, Authority Address, Tax Unit Name, Type of Consignment Agent, Item State, Excise ARE Name, Trader RG No Prefix, Trader RG No Suffix, Is Master From Sync, Is Updating Target Id, Is Deleted, Is Security On When Entered, As Original, Has No Space, Has No Stock, Is External, Is Internal, Enable Export, Is Primary Excise Unit, Allow Export Rebate, Is Trader RG Number On, Err Key, Sort Position, Alter ID, Remote Alter ID, Updated Date Time, Opening Balance, Closing Balance, Credit Totals, Debit Totals, Opening Value, Closing Value, Inward Value, Outward Value, This Year Balance, Previous Year Balance, This Quarter Balance, Previous Quarter Balance
Ledger	Starting From, ST Registration Date, LBT Registration Date, VAT Registration Date, CST Registration Date, Sampling Date One Factor, Sampling Date Two Factor, Active From, Active To, Created Date, Altered On, VAT Applicable Date, Excise Registration Date, PAN Applicable From, Pay Ins Running File Date, VAT Tax Exemption Date, Name, GUID, Currency Name, Email, Prior State Name, Website, Income Tax Number, Sales Tax Number, Inter State ST Number, VAT TIN Number, Excise Range, Excise Division, Excise Commissionerate, LBT Regn No, LBT Zone, Export Import Code, Branch Name, Interstate Old ST Number, VAT Old TIN Number, VAT District Name, GST Registration Type, VAT Dealer Type, State Name, Price Level, Upload Last Refresh, Parent, Sampling Method, Sampling Str One Factor, IFS Code, Narration, Remote GUID, Remote Alt GUID, Target Remote Id, Entered By, Altered By, Type Of Update Activity, Object Update Action, Requestor Rule, Grp Debit Parent, Grp Credit Parent, Sys Debit Parent, Sys Credit Parent, TDS Applicable, TCS Applicable, GST Applicable, Created By, Old Mailing Name, Old Address, Tax Classification Name, Tax Type, Bill Credit Period, Bank Details, Bank BSR Code, Deductee Type, Business Type, Type Of Notification, MSME Reg Number, Country of Residence, Related Party Id, Rel Party Issuing Authority, Importer Exporter Code, Email CC, Description, Ledger Additional Allocation Type, Transporter Id, Old PIN Code, Ledger Phone, Ledger Fax, Ledger Contact, Ledger Mobile, Relation Type, Ledger Country ISD Code, Mailing Name Native, Address Native, State Name Native, Country Name Native, Basic Type Of Duty, GST Type, Exemption Type, Appropriate For, Sub Tax Type, STX Nature Of Party, Name On PAN, Used For Tax Type, E-Comm Merchant ID, Party GSTIN, GST Duty Head, GST Appropriate To, GST Type of Supply, GST Nature of Supply, Cess Valuation Method, Party Old GSTIN, Old Ledger State Name, Philippines LED VAT Class, VAT Dealer Nature, Pay Type, Payslip Name, Attendance Type, Leave Type, Calculation Period, Rounding Method, Computation Type, Calculation Type, Pay Stat Type, Professional Tax Number, User Defined Calendar Type, IT Nature, IT Component, Notification Number, Registration Number, Service Category, Abatement Notification No, STX Duty Head, STX Classification, Notification Serial No, Service Tax Applicable, Excise Ledger Classification, Excise Registration Number, Excise Account Head, Excise Duty Type, Excise Duty Head Code, Excise Allocation Type, Excise Duty Head, Nature Of Sales, Excise Notification No, Excise Imports Registration No, Excise Applicability, Excise Type of Branch, Excise Default Removal, Excise Notification Serial No, Type Of Tariff, Excise Reg No, Excise Nature of Purchase, TDS Deductee Type Master, TDS Rate Name, TDS Deductee Section Number, PAN Status, Deductee Reference, TDS Deductee Type, IT Exempt Applicable, Tax Identification No, Ledger FBT Category, Branch Code, Client Code, Banking Config Bank, Banking Config Bank ID, Bank Account Holder Name, Use For POS Type, Payment Gateway, Type Of Interest On, Bank Config IFSC, Bank Config MICR, Bank Config Short Code, Payment Instruction Output Name, Product Code Type, Salary Payment Product Code, Other Payment Product Code, Payment Instruction Location, Encryption Location, New IMF Location, Imported IMF Location, Bank New Statements, Bank Imported Statements, Bank MICR, Corporate User No ECS, Corporate User No ACH, Corporate User Name, Bank User Login ID, IMF Name, Pay Ins Batch Name, Last Used Batch Name, Pay Ins File Num Period, Encrypted By, Encrypted Id, ISO Currency Code, Bank Capsule ID, Sales Tax Cess Applicable, Bank IBAN, VAT Tax Exemption Nature, VAT Tax Exemption Number, Old Country Name, VAT Applicable, Party Business Type, Party Business Style, Swift Code, E-Banking Format, Is Bill Wise On, Is Cost Centres On, Is Interest On, Allow in Mobile, Is Cost Tracking On, Is Beneficiary Code On, Is Export On Voucher Create, PL as Income Expense, Is Master From Sync, Is Updating Target Id, Is Deleted, Is Security On When Entered, As Original, Is Condensed, Affects Stock, Is Rate Inclusive VAT, For Payroll, Is ABC Enabled, Is Credit Days Check On, Interest on Billwise, Override Interest, Override Advance Interest, Use For VAT, Ignore TDS Exempt, Is TCS Applicable, Is TDS Applicable, Is FBT Applicable, Is GST Applicable, Is Excise Applicable, Is TDS Expense, Is EDLI Applicable, Is Related Party, Use For ESI Eligibility, Is Interest Incl Last Day, Appropriate Tax Value, Is Behave As Duty, Interest Incl Day Of Addition, Interest Incl Day Of Deduction, Is Oth Territory Assessee, Ignore Mismatch With Warning, Use As Notional Bank, Behave As Payment Gateway, Over Ride Credit Limit, Is Against Form C, Is Cheque Printing Enabled, Is Pay Up Load, Is Pay Batch Only SAL, Is BNF Code Supported, Allow Export With Errors, Consider Purchase For Export, Is Transporter, Ise Cash Ledger, Use For Notional ITC, Is eComm Operator, Override Based On Realization, Is EC Diff Ins Date, Show in Payslip, Use For Gratuity, Is TDS Projected, Is Salary Mul File, For Service Tax, Is Input Credit, Is Exempted, Is Abatement Applicable, Is STX Party, Is STX Non Realized Type, Use For KKC, Use For SBC, Is Used For CVD, Ledger Belongs To Non Taxable, Is Excise Merchant Exporter, Is Party Exempted, Is SEZ Party, TDS Deductee Is Special Rate, Is eCheque Supported, Is eDD Supported, Has eCheque Delivery Mode, Has eCheque Delivery To, Has eCheque Print Location, Has eCheque Payable Location, Has eCheque Bank Location, Has DD Delivery Mode, Has DD Delivery To, Has DD Print Location, Has DD Payable Location, Has DD Bank Location, Is EBanking Enabled, Is Export File Encrypted, Is Batch Enabled, Is Product Code Based, Has DD City, Has Cheque City, Is File Name Format Supported, Has Client Code, PayIns Is Batch Applicable, PayIns Is File Num App, Is Salary Trans Grouped For BRS, Is eBanking Supported, Is SCB UAE, Is Bank Status App, Is Salary Grouped, Use For Purchase Tax, Audited, Sampling Num One Factor, Sampling Num Two Factor, Err Key, Sort Position, Alter ID, Remote Alter ID, Default Language, Old Audit Entry IDs, Rate Of Tax Calculation, Gratuity Month Days, Gratuity Limit Months, Calculation Basis, Rounding Limit, Abatement Percentage, TDS Deductee Special Rate, Beneficiary Code Max Length, e-Cheque Print Location Version, e-Cheque Payable Location Version, e-DD Print Location Version, e-DD Payable Location Version, PayIns Running File Number, Transaction Type Version, PayIns File Number Length, Opening Balance, Sampling Amount One Factor, Sampling Amount Two Factor, Credit Limit, Gratuity Limit Amount, OD Limit, Updated Date Time, Primary Group, Closing Balance, Address 1, Address 2, Address 3, Address 4, Address 5, Overdue Bills, On Account Value, Cash In Flow, Cash Out Flow, Performance, Debit Interest, Credit Interest, Last Interest Date, This Year Balance, Previous Year Balance, This Quarter Balance, Previous Quarter Balance, First Alias, HSN Description, HSN Code, Party GSTIN, Integrated Tax, Central Tax, State Tax, Cess, Transaction Type, Favouring Name, Account Number, Party Bank Code, Party Bank, Party SWIFT Code, Party Company Bank, Party Beneficiary Code
Company	Starting From, Books From, Vat Appl Date, Composite Applicable Date, VAT Reg Date, Deactivate Excise From, ST Reg Date, Deactivate Service Tax From, LBT Regn Date, Deactivate VAT From, CMPVATTIN Valid Till, CMP Entitlement Date, CMP Exemption Expiry Date, CMP Exemption Extent From, CMP Exemption Extent To, VAT Registration Date, CST Registration Date, CST Appl Date, GST Applicable Date, Auto Set Off Adv Rcpt Pymt From Prev, Audited Upto, FIFO Applicable From, Returns Start From, Name, Basic Company Formal Name, GUID, E Mail, Prior State Name, PIN Code, Phone Number, CMP Employer Id, Fax Number, Website, Country ISD Code, Income Tax Number, Sales Tax Number, Interstate ST Number, TA Number, VATTINNUMBER, Composite TIN, EEC Debtors, EEC Creditors, Country Name, VAT Pymt Period, CST Pymt Period, ST Pymt Period, TDS Pymt Period, TCS Pymt Period, PF Pymt Period, PT Pymt Period, ESI Pymt Period, FBT Pymt Period, FBT Year End Pymt Period, IT Deductor Ward, IT Deductor Resp Person Name, IT Deductor Resp Person Father Name, IT Deductor Resp Person Desig, TAN Reg No, VAT Filing Periodicity, IT Deductor Branch, Excise Regn, Excise Range, Excise Range Address, Excise Division, Excise Division Address, CMPIEC Code, Excise Assessee Type, Excise Commissionerate, Excise Range Code, Excise Division Code, Excise Focal Bank Code, Excise Focal Bank Name, Excise Focal Bank Addr, ST Reg Number, ST Assessee Code, ST Org Type, ST Major Service, ST Division Code, ST Division Name, ST Range Code, ST Range Name, ST Commrt Code, ST Commrt Name, ST Focal Bank Code, ST Focal Bank Name, ST Focal Bank Addr, ST Adj Expenses, ST Large Tax Payer Unit, ST Premises Code No, Service Tax Liability Type, Rev Charge Type, Deductor Ward, Deductor Status, Deductor Resp Person Name, Deductor Resp Person Desig, Deductor Resp Person Father Name, Head Office TA Number, TDS Deductor Type, Person Responsible PAN, Person Responsible Flat No, Person Responsible Premises, Person Responsible Road, Person Responsible Area, Person Responsible City, Prior Person Responsible State, Person Responsible Pincode, Person Responsible Mobile, Person Responsible STD Code, Person Responsible Phone, Person Responsible E Mail, Person Responsible Alt STD Code, Person Responsible Alt Phone, Person Responsible Alt E Mail, Person Responsible Alt Mobile, Deductor Responsible Alt STD Code, Deductor Responsible Alt Phone, Deductor Responsible Alt E Mail, Deductor Responsible Alt Mobile, IT Deductor Resp Person PAN, Deductor Branch, Company FBT Assessee Type, Company FBT Assessee Category, CMPPF Code, CMPPF Account Group Code, CMPPF Security Code, CMPESI Code, CMPESI Branch Office, CMPESI Working Days, XBRLCIN, XBRL Industry Type, LBT Regn No, LBT Zone, Economic Activity Code, Authorised Person Name, Authorised Person Designation, Authorised Place, Circle Sector, Circle Division, Export Import Code, Tax Authorised Person, Circle Ward, VAT Return Form, CMPVAT Post Bo X No, CMPVAT Town, CMPVAT Street, CMPVAT Building, CMP Authorised Place, CMP Circle Ward, CMP Import Export Code, CMP Circle Sector, CMP Circle Division, Tax Invoice Code, Lineof Bussiness, CMP Trade Name, CMP Assessingauthority, CMPSON Daughter, CMP Entitlement Certificate No, CMP Dealer Status, CMP Fax Number, Branch Name2, CMP Comp Tax Sl No, CMP Exemption Name, CMP Taxissued Person, CMP Taxissued Designation, CMP Lump Sum Permission No, CMP Prof Tax Enrol No, CMP Prof Tax Regn No, CMP Exempt Certificate No, Corporate Identity No, Branch Name, Interstate Old ST Number, VAT Old TIN Number, VAT District Name, CMP Eco Activity Code, CMP Auth Persn Name, CMP Tax Auth Person, CMP Auth Persn Desgnation, CMP Tax Auth Designation, GST Registration Number, GST Registration Type, Cmp Type Of Supply, Company Name Native, Company Emirate Native, Company Country Native, GST Applicability, HSN Applicability, E Way Bill Applicable Type, VAT Dealer Type, Connect Name, SMS Short Code, SMS Prefix, Company Contact Person, Company Contact Number, Company SMS Name, Logopath, State Name, Person Responsible State, Company Cheque Name, TDS Natureof Payment, TCS Natureof Good, CR Number, Branch CR Number, Show Bank Details, Generate Batches On, Upload Last Refresh, Admin Email ID, Last Whats App Template, Is Aggregate, Indian VAT, Is VAT Regd Dealer, Is VAT Composite Dealer, Is Daywise Cash Aggregate, IT Deductor Type, Is Audit Working Paper On, Is Audit Category On, Is Round Off Exce On, Is CST With Addl Tax, Is Sales Tax Cess On, Is Excise Classification On, ST Is ST Large Tax Payer, STX Is Round Off Applicable, Service Tax Is SEZ, ST Is Multi Unit, ST User Defined Class, ST Is Input Serv Distributor, Is ST Stock Item On, Is Reverse Applicable, ST Is Monthly Returns, Deductor Type, Ignore IT Exemption, Ignore TCSIT Exemption, Is TDS Stock Item On, Is FBT Surcharge Applicable, XBRL Is Consolidated Rep Type, Is LBT On, Is VAT Class On, Is MRP On, Is Revised Annexure On, Enable VAT On Item Rate, Enable VAT On Quantity, Is In ZR Basic Services, Is Designated Zone, ST Maintain Sep Acc For Exempt, Is Device Details Req, CMP Is Under NPV Scheme, Reset Manual Recon Status, Send Empty Prod Desc To E Inv, Auto Set Off Adv Rcpt Pymt Prev, Is GS Te Inv Incl E Way Bill, Printe Way Bill, Is Security On, Is Accounting On, Is Inventory On, Is Integrated, Is Bill Wise On, Is All Bill Wise On, Is Cost Centres On, Prev Is Cost Category On, Prev Is Stock Category On, Is Batch Wise On, Is Perishable On, Prev Is Multi Godown On, Prev Is Multi Currency On, Prev Is Invoicing On, Prev Is Rev Jrnl On, Is Reminders On, Prev Is DC Note On, Prev Is Rejection On, Prev Is Tracking On, Is Excise On, Is Chq Printing On, Diff Actual Qty, Use Zero Entries, Addl Amount, Is Tally Audit On, Prev Is Budgets On, Is Payroll On, Is TDS On, Is Service Tax On, Is Job Costing On, Is Tcs On, Is Excise Reports On, Is Composite Dealer, Is BOM On, Prev Is Sales Orders On, Prev Is Purc Orders On, Is Discounts On, C Note As Invoice, UKVAT Returns, Use Price Levels, Is Interest On, Is Adv Interest On, Purc As Invoice, Prev Use Auto Cost, D Note As Invoice, Prev P Las Income Expense, Allowin Mobile, Is Indent On, Is FBT On, Is Excise Mfgr Trader On, Is Sales Tax On, Is Payroll Stat On, Connect Company, Connect Company On Load, Is Entry Tax Applicable, Revenue Led For Op Bal, Enable SMS Access, Is Rcpts Pymts On, Is Logo Enabled, Is XBRL On, Is Proprietorship, Is Year Wise, Is Cmp LTU On, Is GST On, Is GST Classif On, Deny Connect Company To BPS, Prompt On Connect, TC Sfor Other Goods, Is Connect On Load Disabled, Is Demo Env Enabled, Is Browser Desktop View, Is Edit Log On, Was Edit Log On, Is Payment Request On, Is Disallow In Edu Mode, Is Multi Address On, Is Ebanking On, Is Job Work On, Prev Is Material Transfer On, Is Cost Tracking On, Enable Pwd Policy, Restrict Pwd Reuse, Reset Pwd On First Login, Allow Pwd Reset, Notify Of Expiry, Is Def Pwd Policy Altered, Is Banking Vch Migrated, Is Beneficiary Code On, Is Transfer Mode On, Is Bankingfor CC On, Is Imp Bank Details On, Is Approval On, Is Export On Vch Create, Is Export With Errors, Is Reset Bank Status, Is ISO Currency Applicable, Is Ignore With Warnings, Is FIFO Applied, Is Track Vouchers On, Reset Tracked Changes, Company Number, Statutory Version, VAT Pymt Due Date, CST Pymt Due Date, ST Pymt Due Date, TDS Pymt Due Date, TCS Pymt Due Date, PF Pymt Due Date, PT Pymt Due Date, ESI Pymt Due Date, FBT Pymt Due Date, FBT Year End Pymt Due Date, ST Cr Adj Percent, Cmp Tax Amount Tolerence, Pwd Length, Letters In Pwd, Numerals In Pwd, Spcl Chars In Pwd, Pwd History, Pwd Expiry, Expiry Notif Period, NACH Version, Exchange Activity Master Id, Exchange Activity Alter Id, Ret Trans Master Id, Ret Trans Alter Id, Cmp Vch Stat Id, Cmp Ret Stat Id, Max Cash Value, Min Cash Value, CMPESI Eligible Amount, CMP Allowed Exemption Amt, CMP Exemption Extent Amt, E Way Bill Inter State Threshold, RTGS Limit, Address, Company Address Native, Price Level, Mobile Numbers, VNS Name, Extern Files, User Account Ids, DB Name, This Year Beg, This Year End, Prev Year Beg, Prev Year End, This Quarter Beg, This Quarter End, Prev Quarter Beg, Prev Quarter End, Alias Name, Address1, Address2, Address3, Address4, Address5
Voucher Stock Item	Active From, Active To, Price Level Date, Name, GUID, Price Level, Parent, Category, Mailing Name, Narration, Remote GUID, Remote Alt GUID, Target Remote Id, Entered By, Altered By, Type Of Update Activity, Object Update Action, Requestor Rule, TDS Applicable, TCS Applicable, GST Applicable, Tax Classification Name, Description, GST Type of Supply, Service Tax Applicable, Excise Applicability, Sales Tax Cess Applicable, VAT Applicable, Ledger Name, Costing Method, Valuation Method, Base Units, Additional Units, Excise Tax Type, Nature of Item, Excise Item Classification, Old Basic Tariff Type, TCS Category, Basic Tariff Type, VAT Commodity, Entry Tax Commodity, VAT Base Unit, VAT Trail Unit, VAT Schedule Entry No, Reorder Period, Reorder Round Type, Min Order Period, Min Order Round Type, GST Reporting UoM, GST Conversion Unit, Is Cost Centres On, Is Batch Wise On, Is Perishable On, Is Entry Tax Applicable, Is Cost Tracking On, Is Mst From Sync, Is Updating Target Id, Is Deleted, Is Security On When Entered, As Original, Is Rate Inclusive VAT, Ignore Physical Difference, Ignore Negative Stock, Treat Sales as Manufactured, Treat Purchases as Consumed, Treat Rejects as Scrap, Has Mfg Date, Allow Use of Expired Items, Ignore Batches, Ignore Godowns, Adjustment Difference In First Sale Ledger, Adjustment Difference In First Purchase Ledger, Calculate On MRP, Exclude Journal For Valuation, Is MRP Inclusive Of Tax, Is Additional Tax Exempt, Is Supplementary Duty On, GVAT Is Excise Applicable, Is Additional Tax, Is Cess Exempted, Reorder As Higher, Minimum Order As Higher, Is Excise Calculated On MRP, Inclusive Tax, GST Calculate Slab On MRP, Modify MRP Rate, Error Key, Sort Position, Alter ID, Remote Alter ID, Old Audit Entry Ids, Denominator, Conversion, Rate of MRP, Basic Rate Of Excise, Rate Of Entry Tax, Rate of VAT, Rate of SAT, VAT Base No, VAT Trail No, VAT Actual Ratio, Reorder Period Length, Reorder Round Limit, Minimum Order Period Length, Minimum Order Round Limit, GST Item Units, GST Representative Units, Opening Balance, Opening Value, Basic Value, Basic Quantity, Reorder Base, Minimum Order Base, Opening Rate, Updated Date Time, Closing Balance, Inward Quantity, Outward Quantity, Closing Value, Inward Value, Outward Value, Closing Rate, Last Sale Date, Last Sale Party, Last Sale Price, Last Sale Quantity, Last Purchase Date, Last Purchase Party, Last Purchase Price, Last Purchase Cost, Last Purchase Quantity, Consumption, This Year Balance, Previous Year Balance, This Quarter Balance, Previous Quarter Balance, First Alias, HSN Description, HSN Code, Integrated Tax, Central Tax, State Tax, Cess
Company Vouchers	VAT Registration Date, CST Registration Date, From Date, To Date, Active To, Altered On, Voucher Date, LUT Date of Issue, LUT Expiry Date, Bond Date of Issue, Bond Expiry Date, Banker's Date, Tax Cheque Date, Tax Challan Date, Reference Date, Shipping Bill Date, Bill of Entry Date, VAT Party Transaction Return Date, Original Voucher Date, ISD Document Date, IRN Cancel Date, IRN Acknowledgement Date, Reconciliation Date, Form 16 Issue Date, CST Form Issue Date, CST Form Received Date, Certificate Date, Trader Manufacturer Invoice Date, FBT From Date, FBT To Date, Return Invoice Date, Agreement Order Date, Goods Receipt Date, Lorry Receipt Date, Transport Sale Landing Date, Transport Buyer Landing Date, Credit Letter Date, Airway Bill Date, VAT Order Date, Invoice Delivery Date, Bill of Lading Date, VAT Deposit Date, VAT Document Date, VAT Challan Date, EC Date, VAT TDS Date, Adjustment From Date, Adjustment To Date, VAT DD Cheque Date, VAT Due Date, VAT Interest Date, VAT Delay Date, VAT GRN Date, Refund Order Date, VAT Form Submission Date, VAT Cancelled Sales Invoice Date, VAT Form Twelve Date, UTK Agreement Order Date, UTK Goods Delivery Date, VAT Bilty Date, EI Despatch Date, VAT CST E1 Series Date, Voucher VAT Deposit Date, Voucher Reference Date, Tax Pay Period From Date, Tax Pay Period To Date, Service Tax Challan Date, GST Challan Date, GST Challan Expiry Date, Adjustment Party Invoice Date, Adjustment Party Payment Date, Party Order Date, Advance Receipt Date, Refund Voucher Date, Voucher Status Date, Payment Link Expiry Date, VAT Submission Date, Party Invoice Date, Inspection Document Date, VAT Cancelled Invoice Date, VAT Goods Receipt Date, VAT CST E1 Date, Dispatch Date, Audited On, Address, GUID, VAT District Name, GST Registration Type, VAT Dealer Type, State Name, Price Level, TDS Nature of Payment, Auto Cost Level, Purpose Type, Narration, Remote GUID, Remote Alternate GUID, Entered By, Altered By, Type Of Update Activity, Object Update Action, Requestor Rule, Country of Residence, Importer Exporter Code, Party GSTIN, VAT Dealer Nature, Nature Of Sales, Excise Notification No, Place Of Supply, LUT Number, Bond Number, Authority Name, Authority Address, Tax Unit Name, Item State, Excise Unit Name, Class Name, POS Card Ledger, POS Cash Ledger, POS Gift Ledger, POS Cheque Ledger, Section Name, Excise Classification Name, TDS Section No, TDS Deduction Status, Tax Bank Challan Number, Tax Challan BSR Code, Tax Cheque Number, Tax Bank Name, Tax Bank Branch Name, Party Name, GST Registration, Company GSTIN, Return Name, Voucher Type Name, eCommerce GSTIN, Party Ledger Name, Voucher Number, Tax Adjustment, Buyer Address Type, Port Code, Shipping Bill No, Bill of Entry No, VAT Party Transaction Return Number, Basic Buyer Name, Company GST Registration Type, URD Original Sale Value, GST Nature of Return, Original Voucher Number, ISD Document Number, Tax Payment Type, Stat Payment Type, GST Additional Details, Reference, GST ITC Document Type, Party Mailing Name, Party Pin Code, IRN, IRN Cancel Reason, IRN Cancel Code, Bill To Place, Dispatch From Name, Dispatch From Address, Dispatch From State Name, Dispatch From Pincode, Dispatch From Place, Ship To Place, Consignee GSTIN, Consignee Mailing Name, Basic Buyer Address, Consignee Pincode, Consignee State Name, Company GST State, IRN QR Code, Consignee Country Name, Party Address Type, GST Supply Type, IRN Acknowledgement No, Basic Base Party Name, Basic Voucher Cheque Name, Basic Voucher Cross Comment, Exchange Currency Name, Serial Master, Serial Number, Stat Adjustment Type, Consignee IE Code, Supplier IE Code, ARE Serial Master, ARE Serial Number, Summary Auto Voucher Number, Voucher Retained Purpose, Numbering Style, Tax Bank Account Number, CST Form Issue Type, CST Form Issue Number, CST Form Receive Type, CST Form Receive Number, Consignee CST Number, Buyer's CST Number, CST Form Issue Series Number, CST Form Receive Series Number, Excise Treasury Number, Excise Treasury Name, Certificate Type, Certificate Number, ARE Form Type, Destination Tax Unit, Trader Consignee VAT TIN No, Trader Consignee Excise Registration No, Trader Consignee Range, Trader Consignee Division, Trader Consignee Commissionerate, Trader Supplier Excise Registration No, Trader Supplier Range, Trader Supplier Division, Trader Supplier Commissionerate, Trader Manufacturer Excise Registration No, Trader Manufacturer Range, Trader Manufacturer Division, Trader Manufacturer Commissionerate, Trader Manufacturer Name, Trader Manufacturer Address, Trader Manufacturer Invoice No, FBT Payment Type, POS Card Number, POS Cheque Number, POS Cheque Bank Name, Challan Type, Cheque Depositor Name, Excise Notification Serial No, Persisted View, Excise Tariff Type, Consignee LBT Registration No, Consignee LBT Zone, Supplier LBT Registration No, Supplier LBT Zone, LBT Mapped Category, LBT Mapped Zone, LBT Nature of Liability, Cash Party PAN, Cash Party Deduction Type, Voucher Tax Type, Purpose Of Purchase, Point of Transaction, Transporter Name, Transport Mode, Agreement Order Number, Foreign Seller Name, Foreign Seller Address, Exporter Country, Goods Vehicle Number, Ship Name, Ship Agent Name, Ship Agent Address, Clearing Agent Name, Clearing Agent Address, Lorry Receipt Number, Carrier Name, Carrier Address, Credit Letter Reference, Airway Bill Number, Forwarding Agent Name, VAT Order Number, VAT Seller TIN, Transaction Source Place, Transaction Category, VAT Document Type, VAT Transaction Bill Quantity, VAT Transaction Bill Number, Bill of Lading Number, VAT Paid Against, VAT Bank Name, VAT Bank Branch, VAT DD Cheque Number, VAT Adjustment Type, VAT Form Status, VAT Document Number, VAT Source State, VAT Destination State, VAT Destination Place, VAT Party Organization Type, VAT Party Type, VAT Challan Number, VAT Designation of Purchaser, VAT Purchase Receipt Type, VAT Goods Receipt Number, VAT Party Organization Name, Airport Name, TDN of Awarder, EC Number, EC Issuing Authority, Contractor TIN, VAT TDS Bar Code, VAT Payment Mode of Deposit, VAT Payment Tax Description, VAT Bank Account Number, VAT Branch Code, VAT Transaction Source, VAT Adjustment Additional Details, VAT Branch Name, Priority State Conflict, EI Check Post, Port Name, VAT E-Form Applicable, VAT E-Form Applicable Number, VAT In Course Of, VAT Dispatch Time, VAT Transporter Address, VAT Contractee TDN, VAT Contractee District, VAT Contractee Name, Consumer Identification Number, VAT Voucher Handle, VAT Challan No, Tax Invoice No, VAT Treasury, VAT Type, VAT Issue Bank, Book Number, VAT Challan Against, VAT Payment Mode, VAT Demand Purpose, VAT Form 38 No, VAT Customs Entry No, VAT Partner Name, VAT Driver Address, VAT Source District, VAT Destination District, VAT License State, VAT Vehicle No, VAT Way Bill Number, VAT Check Post Name, VAT Cancelled Sales Invoice No, VAT Cancelled Sales Party Name, VAT Cancelled Sales Party CST TIN, VAT Form Twelve No, UTK Agreement Order No, UTK Transport Company Name, UTK Transport Mode, UTK Transport Vehicle No, VAT Bilty No, VAT Form 49 No, VAT Category Type, VAT Way Bill Quantity, Voucher VAT Document Type, Refund Order No, VAT Purpose Code, VAT Description, Depot Name, CMP Type of Device, CMP Device No, VAT Bank, VAT Branch, VAT Draft Cheque No, VAT WC Description, VAT Check Post, VAT CST E1 Series Number, VAT CST E1 Serial Number, Buyer PIN No, Consignee PIN No, VAT Exempt Certificate No, VAT Way Bill No, VAT Brief Description, VAT Export Entry Number, STT Voucher Handle, SRVT Registration Number, ST Tax Bank Challan Number, Type of Excise Voucher, GST Bank Name, GST Bank Account Number, GST Bank Account Type, GST Bank Account Holder, GST Bank Branch Address, GST Bank IFSC Code, GST Bank MICR Code, GST Debit Document Number, GST Payment Mode Of Deposit, GST Bank Branch Name, GST Instrument Number, GST Challan Number, GST CPIN Number, GST CIN Number, Adjustment Party GSTIN, Adjustment Party Invoice No, GST Merchant ID, Party Order No, GST ITC Reversal Details, GST Activity Status, GST Recon Status, GST Reason For Rejection, Advance Receipt Number, Refund Voucher Number, GST Nature, Voucher Tax Unit, Dispatch From Address Type, Voucher Status Tax Adjustment, Voucher Status Voucher Type, Voucher Status Tax Unit, Payment Link, Basic Shipped By, Basic Destination Country, Basic Place Of Receipt, Basic Ship Document No, Basic Port Of Loading, Basic Port Of Discharge, Basic Final Destination, Basic Order Ref, Basic Order Terms, Basic Ship Vessel No, Basic Buyers Salestax No, Basic Due Date Of Payment, Basic Serial Num In PLA, Basic Date Time Of Invoice, Basic Date Time Of Removal, Manufacturer Address Type, Transporter Addr Room, Transporter Addr Bldg, Transporter Addr Road, Transporter Addr Area, Transporter Addr Town, Transporter Addr District, Transporter Addr State, Transporter Addr Pin Code, Transporter Addr Phone, Transporter Addr Fax, Transporter Vehicle 2, Transport Local TIN, Previous References, VAT C Form Issue State, Place Of Supply State, Place Of Supply Country, Emirate POS, Voucher GST Class, Cost Centre Name, Additional Narration, Party Invoice No, Inspection Document No, Settlement Type, Voucher Time, Hold Reference, VAT Cancel Invoice No, VAT Cancel Purchase TIN, VAT Cancel Purchase Name, VAT Type of Device, VAT Brief Description, VAT Device No, Buyer PIN Number, VAT Export Entry No, Consignee PIN Number, VAT Exempt Certificate No, VAT Vehicle Number, VAT Goods Receipt Number, VAT Mobile Number, Is Master From Sync, Is Deleted, Is Security On When Entered, As Original, Audited, Is Common Party, For Job Costing, Is Optional, Effective Date, Use For Excise, Is For Job Work In, Allow Consumption, Use For Interest, Use For Gain Loss, Use For Godown Transfer, Use For Compound, Use For Service Tax, Is Reverse Charge Applicable, Is System, Is Fetched Only, Is GST Overridden, Is Cancelled, Is On Hold, Is Summary, Is eCommerce Supply, Is BOE Not Applicable, Is GST Section 7 Applicable, Ignore eInvoice Validation, Company GST Is Other Territory Assessee, Party GST Is Other Territory Assessee, IRN JSON Exported, IRN Cancelled, Ignore GST Conflict In Migration, Is Opening Balance Transaction, Ignore GST Format Validation, Is Eligible for ITC, Update Summary Values, Is eWay Bill Applicable, Is Deleted Retained, Is Null, Is Excise Voucher, Excise Tax Override, Use For Tax Unit Transfer, Is Excise ER1 NOP Overwrite, Is Excise F2 NOP Overwrite, Is Excise ER3 NOP Overwrite, Ignore POS Validation, Excise Opening, Use For Final Production, Is TDS Overridden, Is TCS Overridden, Is TDS TCS Cash Voucher, Include Advance Payment Voucher, Is Sub Works Contract, Is VAT Overridden, Ignore Original Voucher Date, Is VAT Paid At Customs, Is Declared To Customs, VAT Advance Payment, VAT Advance Pay, Is CST Declared Goods Sales, Is VAT Resale Tax Invoice, Is Service Tax Overridden, Is ISD Voucher, Is Excise Overridden, Is Excise Supply Voucher, GST Not Exported, Ignore GSTIN Validation, Is GST Refund, Override eWay Bill Applicability, Is VAT Principal Account, Voucher Status Is Voucher Number Used, Voucher GST Status Is Included, Voucher GST Status Is Uncertain, Voucher GST Status Is Excluded, Voucher GST Status Is Applicable, Voucher GST Status Is GSTR2B Reconciled, Voucher GST Status Is GSTR2B Only In Portal, Voucher GST Status Is GSTR2B Only In Books, Voucher GST Status Is GSTR2B Mismatch, Voucher GST Status Is GSTR2B In Different Period, Voucher GST Status Is Ret Eff Date Overridden, Voucher GST Status Is Overridden, Voucher GST Status Is Stat In Different Date, Voucher GST Status Is Ret In Different Date, Voucher GST Status Main Section Excluded, Voucher GST Status Is Branch Transfer Out, Voucher GST Status Is System Summary, Voucher Status Is Unregistered RCM, Voucher Status Is Optional, Voucher Status Is Cancelled, Voucher Status Is Deleted, Voucher Status Is Opening Balance, Voucher Status Is Fetched Only, Payment Link Has Multiple Reference, Is Shipping Within State, Is Overseas Tourist Transaction, Is Designated Zone Party, Has Cash Flow, Is Post Dated, Use Tracking Number, Is Invoice, Manufacturing Journal, Has Discounts, As Payslip, Is Cost Centre, Is STX Non Realized Voucher, Is Excise Manufacturer On, Is Blank Cheque, Is Void, Order Line Status, VAT Is Against Cancel Sales, VAT Is Purchase Exempted, Is VAT Res Tax Invoice, VAT Is Assesable Calc Voucher, Is VAT Duty Paid, Is Delivery Same as Consignee, Is Dispatch Same as Consignor, Is Deleted Voucher Retained, Change Voucher Mode, Reset IRN QR Code, Is Voucher From Split, Error Key, Alter ID, Remote Alter ID, Master ID, Old Audit Entry IDs, QR Code CRC, Voucher Key, Voucher Retain Key, Base Voucher Type, EC Fee Rate, VAT Consignment Number, VAT Rate of Tax, EI Discount Rate, WB Transfer Assess Rate, VAT WC Deduction Percentage, Rate Of Invoice Tax, Voucher Status Dummy Long, VAT TDS Rate, Contributed Voucher List, Referred Voucher List, Reuse Hole ID, Exchange Activity ID, BOND Amount, POS Cash Received, Custom Duty Paid, VAT Party ITC Claimed, VAT Party Tax Liability, Value Of Works Contract, EC Fee Amount, EC Fee Deposit By Awarder, EC Fee Deposit By Contractor, TDS Deducted, Value of Sub Works Contract, VAT TDS Amount, VAT Purchase Value, MAHWC Assessable Value, WB Transfer Base Value, VAT WC Deduction Amount, VAT WC Other Deduction Amount, Cess Assessable Value On Class, Additional VAT Class Amount, Adjusted Party Invoice Value, GST Invoice Assessable Value, EI Discount Amount, Payment Link Amount, VAT Goods Value, Exchange Rate, Processing Duration, Voucher Number Series, Updated Date Time, Gross Profit, Gross Revenue, Gross Cost
Ledger Vouchers	Starting From, ST Registration Date, LBT Registration Date, VAT Registration Date, CST Registration Date, Sampling Date One Factor, Sampling Date Two Factor, Active From, Active To, Created Date, Altered On, VAT Applicable Date, Excise Registration Date, PAN Applicable From, Pay Ins Running File Date, VAT Tax Exemption Date, Name, GUID, Currency Name, Email, Prior State Name, Website, Income Tax Number, Sales Tax Number, Inter State ST Number, VAT TIN Number, Excise Range, Excise Division, Excise Commissionerate, LBT Registration Number, LBT Zone, Export Import Code, Branch Name, Interstate Old ST Number, VAT Old TIN Number, VAT District Name, GST Registration Type, VAT Dealer Type, State Name, Price Level, Upload Last Refresh, Parent, Sampling Method, Sampling Str One Factor, IFS Code, Narration, Remote GUID, Remote Alt GUID, Target Remote Id, Entered By, Altered By, Type Of Update Activity, Object Update Action, Requestor Rule, Grp Debit Parent, Grp Credit Parent, Sys Debit Parent, Sys Credit Parent, TDS Applicable, TCS Applicable, GST Applicable, Created By, Old Mailing Name, Old Address, Tax Classification Name, Tax Type, Bill Credit Period, Bank Details, Bank BSR Code, Deductee Type, Business Type, Type Of Notification, MSME Reg Number, Country of Residence, Related Party Id, Related Party Issuing Authority, Importer Exporter Code, Email CC, Description, Ledger Additional Allocation Type, Transporter Id, Old PIN Code, Ledger Phone, Ledger Fax, Ledger Contact, Ledger Mobile, Relation Type, Ledger Country ISD Code, Mailing Name Native, Address Native, State Name Native, Country Name Native, Basic Type Of Duty, GST Type, Exemption Type, Appropriate For, Sub Tax Type, STX Nature Of Party, Name On PAN, Used For Tax Type, eComm Merchant ID, Party GSTIN, GST Duty Head, GST Appropriate To, GST Type of Supply, GST Nature of Supply, Cess Valuation Method, Party Old GSTIN, Old Ledger State Name, Philippines LED VAT Class, VAT Dealer Nature, Pay Type, Payslip Name, Attendance Type, Leave Type, Calculation Period, Rounding Method, Computation Type, Calculation Type, Pay Stat Type, Professional Tax Number, User Defined Calendar Type, IT Nature, IT Component, Notification Number, Registration Number, Service Category, Abatement Notification No, STX Duty Head, STX Classification, Notification Sl No, Service Tax Applicable, Excise Ledger Classification, Excise Registration Number, Excise Account Head, Excise Duty Type, Excise Duty Head Code, Excise Allocation Type, Excise Duty Head, Nature Of Sales, Excise Notification No, Excise Imports Registration No, Excise Applicability, Excise Type of Branch, Excise Default Removal, Excise Notification Sl No, Type Of Tariff, Excise Reg No, Excise Nature of Purchase, TDS Deductee Type Master, TDS Rate Name, TDS Deductee Section Number, PAN Status, Deductee Reference, TDS Deductee Type, IT Exempt Applicable, Tax Identification No, Ledger FBT Category, Branch Code, Client Code, Banking Config Bank, Banking Config Bank ID, Bank Account Holder Name, Use For POS Type, Payment Gateway, Type Of Interest On, Bank Config IFSC, Bank Config MICR, Bank Config Short Code, Payment Instrument Output Name, Product Code Type, Salary Payment Product Code, Other Payment Product Code, Payment Instrument Location, Encryption Location, New IMF Location, Imported IMF Location, Bank New Statements, Bank Imported Statements, Bank MICR, Corporate User No ECS, Corporate User No ACH, Corporate User Name, Bank User Login ID, IMF Name, Pay Ins Batch Name, Last Used Batch Name, Pay Ins File Number Period, Encrypted By, Encrypted ID, ISO Currency Code, Bank Capsule ID, Sales Tax Cess Applicable, Bank IBAN, VAT Tax Exemption Nature, VAT Tax Exemption Number, Old Country Name, VAT Applicable, Party Business Type, Party Business Style, SWIFT Code, E-Banking Format, Is Bill Wise On, Is Cost Centres On, Is Interest On, Allow In Mobile, Is Cost Tracking On, Is Beneficiary Code On, Is Export On Voucher Create, PL as Income Expense, Is Master From Sync, Is Updating Target Id, Is Deleted, Is Security On When Entered, As Original, Is Condensed, Affects Stock, Is Rate Inclusive VAT, For Payroll, Is ABC Enabled, Is Credit Days Check On, Interest on Billwise, Override Interest, Override Advance Interest, Use For VAT, Ignore TDS Exempt, Is TCS Applicable, Is TDS Applicable, Is FBT Applicable, Is GST Applicable, Is Excise Applicable, Is TDS Expense, Is EDLI Applicable, Is Related Party, Use For ESI Eligibility, Is Interest Include Last Day, Appropriate Tax Value, Is Behave As Duty, Interest Include Day Of Addition, Interest Include Day Of Deduction, Is Other Territory Assessee, Ignore Mismatch With Warning, Use As Notional Bank, Behave As Payment Gateway, Override Credit Limit, Is Against Form C, Is Cheque Printing Enabled, Is Pay Upload, Is Pay Batch Only SAL, Is BNF Code Supported, Allow Export With Errors, Consider Purchase for Export, Is Transporter, Is Cash Ledger, Use For Notional ITC, Is Comm Operator, Override Based On Realization, Is EC Diff Insurance Date, Show in Payslip, Use For Gratuity, Is TDS Projected, Is Salary Multiple File, For Service Tax, Is Input Credit, Is Exempted, Is Abatement Applicable, Is STX Party, Is STX Non Realized Type, Use For KKC, Use For SBC, Is Used For CVD, Ledger Belongs To Non Taxable, Is Excise Merchant Exporter, Is Party Exempted, Is SEZ Party, TDS Deductee Is Special Rate, Is Cheque Supported, Is DD Supported, Has Cheque Delivery Mode, Has Cheque Delivery To, Has Cheque Print Location, Has Cheque Payable Location, Has Cheque Bank Location, Has DD Delivery Mode, Has DD Delivery To, Has DD Print Location, Has DD Payable Location, Has DD Bank Location, Is E-Banking Enabled, Is Export File Encrypted, Is Batch Enabled, Is Product Code Based, Has DD City, Has Cheque City, Is File Name Format Supported, Has Client Code, PayIns Is Batch Applicable, PayIns Is File Num Applicable, Is Salary Trans Grouped For BRS, Is Banking Supported, Is SCB UAE, Is Bank Status Applicable, Is Salary Grouped, Use For Purchase Tax, Audited, Sampling Num One Factor, Sampling Num Two Factor, Error Key, Sort Position, Alter ID, Remote Alter ID, Default Language, Old Audit Entry IDs, Rate Of Tax Calculation, Gratuity Month Days, Gratuity Limit Months, Calculation Basis, Rounding Limit, Abatement Percentage, Primary Group, Closing Balance, Address 1, Address 2, Address 3, Address 4, Address 5, Overdue Bills, On Account Value, Cash In Flow, Cash Out Flow, Performance, Debit Interest, Credit Interest, Last Interest Date, This Year Balance, Previous Year Balance, This Quarter Balance, Previous Quarter Balance, First Alias, HSN Description, HSN Code, Party GSTIN, Integrated Tax, Central Tax, State Tax, Cess, Transaction Type, Favouring Name, Account Number, Party Bank Code, Party Bank, Party SWIFT Code, Party Company Bank, Party Beneficiary Code
Trial Balance	Account Name, Debit Amount, Credit Amount
Movement Analysis	Item Name, Stock In Quantity, Stock In Eff. Rate, Stock In Value, Stock Out Quantity, Stock Out Eff. Rate, Stock Out Value
Balance Sheet	Account Name, Sub Amount, Main Amount
Profit and Loss	Account Name, Sub Amount, Main Amount
Ratio Analysis	Ratio Name, Ratio Value
Transfer Analysis	Item Name, Stock In Quantity, Stock In Cost, Stock In Value, Stock Out Quantity, Stock Out Price, Stock Out Value
Stock Summary	Item Name, Closing Balance Quantity, Closing Balance Rate, Closing Balance Amount
Sales Register	Voucher Type, Voucher Date, GUID, Voucher Number
Voucher Register	Voucher Type, Voucher Date, GUID, Voucher Number
Purchase Register	Voucher Type, Voucher Date, GUID, Voucher Number
Contra Register	Voucher Type, Voucher Date, GUID, Voucher Number
Payment Register	Voucher Type, Voucher Date, GUID, Voucher Number
Journal Register	Voucher Type, Voucher Date, GUID, Voucher Number
Receipt Register	Voucher Type, Voucher Date, GUID, Voucher Number
Credit Note Register	Voucher Type, Voucher Date, GUID, Voucher Number
Debit Note Register	Voucher Type, Voucher Date, GUID, Voucher Number
Delivery Note Register	Voucher Type, Voucher Date, GUID, Voucher Number
Receipt Note Register	Voucher Type, Voucher Date, GUID, Voucher Number
Physical Stock Register	Voucher Type, Voucher Date, GUID, Voucher Number
Stock Journal Register	Voucher Type, Voucher Date, GUID, Voucher Number
Stock Group Summary	Item Name, Closing Balance Quantity, Closing Balance Rate, Closing Balance Amount
Stock Category Summary	Item Name, Closing Balance Quantity, Closing Balance Rate, Closing Balance Amount
Group Summary	Account Name, Debit Amount, Credit Amount
Group Outstandings	Account Name, Debit Amount, Credit Amount
Cost Category Summary	Cost Category Name, Debit Amount, Credit Amount, Closing Balance
Reorder Status	Item Name, Closing Stock, Purchase Orders Pending, Sales Order Due, Nett Available, Re-order Level, Short Fall, Min. Reorder Quantity, Order to be Placed

Data Sync Frequency

Zoho Analytics offers flexible sync schedules to ensure that your data is always up-to-date for effective analysis. These schedules allow you to automate the process of updating your data, ensuring that your analyses are based on the latest information.

1 Hour (Enterprise plan only)
3 Hours
6 Hours
12 Hours
Every day

Handling Data Synchronization Failure

Data synchronization can fail,

If the data type of a field is changed in the TallyPrime Application.
If the Modules and Field selected for analysis are deleted in the source application.
If the user who configured the integration no longer has permission to access the modules.

In any of the above mentioned cases, the data sync will be paused. You will be notified via email and in- app notification with the exact reason for failure along with the solution.

To resolve the sync failure, delete or restructure the views, or restore the specific modules and fields from the source application. Refer to Data Sync failure and solutions article for more details.

Once you have made the changes, click the Sync now option in the data source tab to resume data sync. If the issue persists, contact support@zohoanalytics.com

Managing Data Sources

The Data Sources tab provides essential information to monitor and manage the integration setup. It also allows you to edit the settings as needed. Users with administrator privileges will be able to view and modify the connection settings.

Data Source Permalink

The Data Source Permalink helps you easily access the data source tab. Only the Organization Admin and Account Admin can make changes in the Data sources page, other users can know the synchronization details like whether the last data sync was successful or not, when the last data sync happened, when the next sync is scheduled to happen, etc. This link can also be pasted in dashboards so that everyone accessing the dashboard can know about the sync status.

Edit Setup

The Edit Setup tab allows you to add or delete modules or fields, change the schedule interval, and modify other settings specific to the business application.

To modify the settings,

Click Data Sources > Edit Setup.
The Edit Setup - TallyPrime dialog will open. Modify the settings as needed and click Save.

Re- Authenticate

Re-authentication will be helpful when the API key or password is changed. In this case, the data sync will be paused, and the administrator who configure the connector setup must re-authenticate to resume the data sync.

To reauthenticate the setup,

Click Data Sources > Re-Authenticate.
The Re-Authenticate - TallyPrime dialog will open. Enter the credentials and click Authenticate TallyPrime.

Sync History

The Sync History tab provides details about the data sync for the last 45 days. A successful data sync is marked in green, and a sync failure is marked in red.

To view the Sync history,

Click Data sources > Sync History.
A calendar with the Sync History of the last 45 days will open. The date when the data sync has happened will be highlighted. Hover to view the number of times the data had got synced on a specific date.
Click the date to view more details.
- Time - Displays the time when the data is synced.
- Status - Shows whether the sync was a success or a failure.In case of failure, the reason will be displayed. Refer to this page to learn how to resolve the issue and avoid further failure.

Audit History

Zoho Analytics logs all the user activities and system events within the TallyPrime workspace. The following actions that are logged in Zoho Analytics,

User Action: Create, Modules Added, Modules Removed, Fields Added, Fields Removed, Schedule Change and Entities Modified, Delete, Take Ownership, Re-authenticate, Sync Now, Retry.
System Action: Plan upgrade or downgrade.

To view the audit history,

Click Data Sources > Audit History.
A dialog with the activities for the last 180 days will open.

Remove Data Source

Zoho Analytics allows you to remove the integration if needed. Removing the integration will suspend further data synchronization. The data tables and the reports will be available.

Click the Settings icon in the Data Sources tab, and select Remove Data Source from the drop-down menu.

Data Modeling & Preparation

Zoho Analytics allows you to combine data from various sources such as Files, Feeds, Databases and Business Applications for an in-depth analysis. Query Tables allows you to combine data from different tables to create reports.

While blending data from other data sources, Zoho Analytics automatically identifies similar columns and provides suggestions for lookups. Refer to the Joining Tables article for more details.

Data Visualization / Analysis

Chart Types in Zoho Analytics

The below table lists the range of visualizations supported in Zoho Analytics.

Visualization	Types
Bar	Stacked bar, Histogram, Horizontal bar
Stacked Bar	Horizontal Stacked bar, 100% vertical and horizontal stacked bar
Area	Area with markers, Smooth Area, Smooth area with Markers
Line and Bar Combination chart	Bar with Line, Bar with Bubble, Bar with Scatter, Bar with Area, Area with Bubble, Line with Bubble and Custom Combination
Bubble Chart	Bubble Pie, Packed Bubble, Word Cloud
Stacked Area	Stacked area with markers, Smooth stacked area, Smooth stacked area with markers
Map	Heat Map, Map Scatter, Map Bubble, Map Pie, Map Bubble Pie, Map Filled, Geo Heat Map
Pie	Pie, Ring, Semi Pie, Semi Ring
Tree map	Default View
Sankey	Default View
Sunburst	Default View
Race Chart	Default View
Doughnut	Default View
Matrix View	Pivot table
Tabular	Summary and Tabular view
Dashboards and KPI widgets	Single Numeric Widget, Dial Chart Widget Bullet, Chart Widget

Sharing and Collaboration

Share data and reports with your colleagues & friends with fine-grained permission
Enable real-time commenting on a shared view to efficiently collaborate with your users
Publish reports for wider consumption. Embed reports/dashboards within your websites, web applications, and blogs.
Export, Email, and Print reports in a variety of formats.
Use Zoho Analytics mobile apps (optimized for both IOS and Android platform) and access the reports and dashboards on the go.

Help & Support

We offer 24x5 technical support (Monday to Friday). In case if you need our assistance kindly do mail us your questions to support@zohoanalytics.com.

You can also reach out to us on our toll-free numbers.
United States: +1 (888) 900 9646
United Kingdom: +44 (20) 35647890
Australia: +61-2-80662898
India: +91 44 6965 6060