Import Sales Data into Tally

@hits

I recommend using TallyPrime with an XML-based import for this project. Once we review the sample Excel file and test company access, we will create the required mapping and import routine for sales invoices, ledgers, amounts, and tax breakups. To help us assess the exact mapping and provide an accurate timeline (we prefer taking up projects on a fixed cost basis to avoid any kind of dispute), please share the following details and files: - Sample Excel file - Tally version/release number (and whether it is a desktop installation) - Test company access in Tally - Whether sales are : Item/inventory, service, or both - GST requirements (CGST/SGST/IGST, GSTIN, HSN/SAC, etc.) - Whether customer ledgers and item masters already exist in Tally, or if they should be created automatically during import

@bojans9

Hi, I can build a repeatable Excel-to-Tally import workflow that removes manual data entry and validates the imported results against the source spreadsheet. I can work with Tally XML, ODBC, or VBA depending on your Tally version and the most reliable integration method. The solution can map invoices, amounts, tax splits, customers, ledgers, and voucher types correctly, with validation to identify any mismatches. I will deliver: * Working import routine tested with your sample Excel file * Reusable Excel template/macro where appropriate * Clear instructions for future imports * Validation report confirming source vs Tally totals * Optional export from Tally back to Excel if practical Rate: 1250/hour Estimated turnaround: 2-4 days Please confirm whether you are using TallyPr

@alluankit01

Hi, I can build a reliable Excel-to-Tally sales import workflow that eliminates manual re-entry and keeps invoices, ledgers, taxes, customers, and totals accurate. I’m comfortable with TallyPrime / ERP 9, Excel, XML import structures, VBA, and repeatable accounting-data integration. I can deliver: • Excel-to-Tally sales import • Correct voucher type mapping • Customer/ledger mapping • Invoice number/date handling • GST/tax split mapping • Amount and total validation • Error handling for missing/invalid fields • Reusable Excel template • Optional one-click VBA/import button • Export from Tally back to Excel where practical • Step-by-step usage guide • Validation report proving Excel and Tally totals match My approach is to first review your sample spreadsheet and Tally company structure, define the field/ledger mapping, test with a small batch, then run a full reconciliation before handover. I prefer TallyPrime, but I can also work with ERP 9 if that is your current environment. Estimated turnaround: 1–3 days after receiving the sample Excel file and test-company access. Best regards Ankit

@caajoys

I can build a repeatable Excel-to-Tally workflow that eliminates manual re-entry while preserving invoice-level accuracy, tax splits, customer details and voucher classification. The priority will be a reliable process you can run independently after handover. I have gone through the requirements in detail. I can: • Review your Excel structure and Tally master/voucher requirements • Develop the most suitable approach using XML, ODBC or Excel VBA based on your Tally version • Map customers, ledgers, tax fields, amounts and voucher types accurately • Test the import against your sample file and Tally test company • Add an export-to-Excel routine where practical for analysis • Provide a simple reusable template/button-based process where appropriate • Validate imported totals against the source Excel and provide a reconciliation report • Prepare clear step-by-step instructions for future files I have uploaded samples similar to this project completed by me earlier in my profile. With 10+ years of professional experience, I am a Chartered Accountant (ICAI) and CPA, with strong expertise in Excel automation, VBA, accounting processes, reconciliations and financial reporting. Thank you for considering my proposal. I would first confirm whether you are using TallyPrime or ERP 9 and then finalize the import method and turnaround based on your sample file.

@AdeebaShamsi

Having years of experience as a Chartered Accountant and being a CA finalist, my expertise in managing financials and accounting softwares including Tally will be a great advantage for your project. I've worked extensively on similar tasks involving data import/export, generating macros and VBA scripts to ensure seamless data transfer. My approach is always focused on accuracy as that is critical for you, which will be evidenced through a detailed validation report that proves the match between Tally's processed totals and source sheets after import. Moreover, I'm proficient in Power BI, which could enhance your data analysis capabilities, enabling a robust evaluation of your business performance from the sales records registered in Tally itself. Another unique benefit of choosing me would also be the comprehensive step-by-step instructions that I'll provide for future use. Furthermore, my adeptness doesn't end at this project. My extensive background in financial management and accounting would also make me an asset for any future requisites encompassing tasks like income tax returns, company registration or GST filings. Whether you choose ERP 9 or TallyPrime, I'm adept in both and can deliver impeccable results within your estimated turnaround time. Look forward to lend my expertise to make your financial processes smoother and more efficient.

@ZohaibSathio

Hi, a repeatable Excel to Tally import where every invoice and tax split lands on the right ledger and voucher type. One wrong ledger name and Tally quietly creates a new one, so mapping is the real work here. How I'd build it: a VBA button on your sheet that validates rows against a mapping table for ledgers, tax heads and voucher types, then writes Tally XML and posts it to the Tally gateway. Bad rows get flagged in the sheet, not pushed in half. TallyPrime or ERP 9? I've built Excel driven loaders into accounting systems before, handing over a reconciliation sheet that proves the totals match. Happy to start on your sample file. Regards, Zohaib

@FreeLancers360

Hi, Thanks for posting "Import Sales Data into Tally" — it lands right in our wheelhouse, and we'd be thrilled to bring it to life. I love turning a solid brief like yours into a polished result you’ll be proud to put your name on. From your brief I can see this involves excel, data processing — all areas we handle in-house. We specialise in XML, Visual Basic, Data Processing, Excel, which lines up directly with what you need. How we'd approach it: - Define the exact fields, sources and output format - Build the collection / processing pipeline - Validate accuracy and clean the data - Deliver in your preferred format with a short summary I also noted you don’t need manual re-typing or copy-paste errors — that’s clear, and I’ll keep the work clean and strictly on-brief. Happy to work hourly with transparent time tracking and regular check-ins. Expect smooth progress updates throughout, full respect for your specifications, and zero surprises along the way. Happy to jump on a quick chat to walk through scope and timelines whenever suits you. Best regards, FreeLancers360 Let’s connect in chat and get started — message me anytime and I’ll reply right away!

@camilob44

For this Excel-to-Tally import, I'm the strongest hire you'll find. I build data pipelines for a living, and this job is a pipeline problem: read the source schema, map each row to the right destination type, run the import, and prove the totals reconcile end to end. That's the same work I do on ETL and data integration projects, just with Tally as the target. The approach: map your Excel columns to Tally's XML voucher structure (date, party name, ledger, line items, tax splits), write the import routine using TallyXML or VBA depending on what gives you the cleanest repeatable result, test against your sample file, and deliver a row-by-row validation report confirming every total matches. If you want the reverse export too, Tally to Excel for quick analysis, I'll include it in the same handover session. Deliverables: working import method tested on your data, step-by-step instructions to run it on future spreadsheets, and the validation report. I'll ask at the start whether you're on ERP 9 or TallyPrime, since the XML schema differs slightly. Rs 900/hr, estimated 4 to 6 hours depending on voucher complexity.

@manishashree12

Hello there, I understand your need to seamlessly import sales data from Excel into Tally without errors. I can create a reliable import routine using Tally's XML import structure to ensure accurate transfer of data. Additionally, I will provide clear step-by-step instructions for future use and a validation report to confirm data accuracy. I will start by testing the method on your sample Excel file. Let's discuss further details and your preferred version (ERP 9 or TallyPrime) to get started promptly. Thanks, Manisha

@Mobarak303

I can help you create a reliable Excel-to-Tally import workflow that eliminates manual data entry and reduces errors. I understand the importance of accurate invoice mapping, ledger assignment, voucher types, tax splits, and customer details. I can work with Tally XML import, ODBC connectivity, or Excel VBA-based automation depending on your preferred workflow. I will provide: A tested import solution using your sample Excel file Clear step-by-step instructions for future use Validation checks to confirm imported totals match the source data Please let me know whether you are using Tally ERP 9 or TallyPrime, and I can confirm the approach and estimated timeline. Best regards, Mubarak

@Digitalizers010

Hi, Excel sales rows landing in Tally as proper vouchers, tax split on the right ledger. Ledger name mismatches are what break these. How we'd do it: a VBA macro maps each column to a voucher field, writes Tally XML, then posts it in, with a mismatch log so a wrong ledger name surfaces before the import, not after. TallyPrime or ERP 9? We have built the same Excel to XML bridge for a distributor. Regards, Digitalizers

@antonyxaviour

Hello Sir, I can develop a reliable Excel-to-Tally sales import system that eliminates manual data entry and minimizes errors. I can work with TallyPrime or Tally ERP 9; after reviewing your setup, I will select the most suitable method (Tally XML, ODBC, VBA/Excel automation, or a combination). **Scope of work:** * Review your Excel sales format and Tally configuration. * Map customer/party ledgers, sales ledgers, GST, tax rates, invoice numbers, dates and amounts. * Create a working import routine and test it using your sample data. * Ensure correct voucher type and ledger posting in Tally. * Validate invoice count, taxable value, GST breakup and grand totals against Excel. * Provide a reusable Excel template/macro or import utility for future files. * Provide clear step-by-step instructions for running the process independently. * If practical, create an Excel export/reporting routine to pull data from Tally for analysis. * Provide a brief validation report confirming the imported totals match the source data. Turnaround: Approximately 2–4 working days after receiving the sample Excel file and access to the test Tally company. I will first test the process in the test company before recommending it for live data. My focus will be on accuracy, repeatability and easy hand-over, so you can run the process yourself in the future. I am available to start immediately.

@cernix

Hi - You asked for a working Excel-to-Tally import (XML/ODBC or Excel macro/VBA) tested on your sample file, for ERP 9 or TallyPrime, with accurate invoice/tax/customer fields. I can deliver that as specified: - Working import method tested on your sample Excel - Step-by-step instructions you can reuse on future spreadsheets - Brief validation report proving Tally totals match the source sheet Delivery: within 24 hours after I receive the sample file. I'll follow your current setup, no extras. Which Tally version - ERP 9 or TallyPrime?

@SoneJ

Hello, I understand your need for a seamless integration between your Excel sales records and Tally, ensuring accuracy and efficiency. My approach will involve assessing your spreadsheet structure and selecting the most suitable method—whether Tally’s XML import, ODBC connectivity, or a custom Excel macro—to create a reliable import routine. To get started, could you clarify which version of Tally you are using—ERP 9 or TallyPrime? Additionally, do you have any specific formats or fields in your sales records that require special consideration? I will provide a tested import method, detailed step-by-step instructions for future use, and a validation report confirming the accuracy of the data in Tally. Looking forward to starting this project with you. Sone Joubert Studio SJ

@Sirchon

As an experienced Excel-wizard with a keen eye for detail and sharp data analysis skills, I am confident in my ability to masterfully import and export your sales data into Tally. Whether it be through Tally’s XML import structure or the use of Excel macros/VBA scripts, my goal is always to maintain the integrity and precision of your data. And given my proficiency in creating dynamic tables and working with formulas in Excel, I can develop a meticulous import process that will guarantee each invoice, amount, tax split, and customer field is accurately mapped in Tally. Moreover, my background in full-stack web development leans towards robust architecture that's eminently maintainable. I would utilize these same principles to build a consistent and easily repeatable process for you to follow when importing future spreadsheets into Tally. To top it off, I can even provide you with a sleek interface or button that will allow for quick extraction and analysis of sales data from Tally back into Excel. In conclusion, choosing me for this project ensures that not only do you get a tested, working import method for your current spreadsheet but also the means to replicate the process in the future, all whilst feeling the assurance of detailed validation reports. I am already excited about getting started on your project; let's match the flow of your sales records to the flow of your business success!

@ejikekc

Hi, I can build this as a repeatable Excel → Tally import workflow with validation as a core requirement, rather than a one-time data conversion. I would first map your spreadsheet fields to the required Tally entities: customer/party ledger, invoice number/date, sales ledger, voucher type, amounts and tax splits. The workflow would then: Excel → validate/normalize → map ledgers & voucher fields → generate/import Tally-compatible data → verify import → reconcile source vs Tally totals. I would include clear exception handling for missing ledgers, invalid tax values, duplicate invoices and malformed rows so bad records are reported rather than silently imported. My preference is to evaluate TallyPrime with XML integration first, because it provides a clean repeatable interface without tying the solution entirely to a desktop macro. If your environment is ERP 9, I can assess the supplied test company and adapt the integration accordingly. Deliverables will include the working importer, reusable instructions, mapping/configuration guidance and a validation report comparing source and imported totals. I work with APIs, XML/JSON, databases, Excel/data transformation and business automation. I will validate everything against your test company before any production use. Rate: ₹1,000/hour Estimated turnaround: 3–5 days Regards, Ejike COLBRYAN Technologies

@duongha2k

Hello, I can build a reliable and repeatable Excel-to-Tally import solution using Tally’s XML import format. My approach will be: • Read and validate your Excel sales data • Map invoices, customers, amounts, tax splits, ledgers, and voucher fields correctly • Generate Tally-compatible XML for import • Test the process using your sample Excel file and test Tally company • Verify the imported results against the source Excel totals • Provide a clear validation/reconciliation report • Provide simple step-by-step instructions so you can repeat the process with future spreadsheets I can provide this as a simple standalone Windows tool, so no server setup is required. You will be able to select an Excel file, validate the data, and generate the Tally XML for import. I prefer TallyPrime for this implementation. Estimated turnaround: 5–7 days, depending on the Excel structure, voucher/tax mapping, and validation requirements. The initial scope will focus on a reliable Excel-to-Tally import and reconciliation process. Tally-to-Excel export can be discussed as an optional enhancement after the core import workflow is completed. Before starting, I would like to review your sample Excel file and confirm the TallyPrime version and voucher/tax structure. Thank you.