.svg){kind=small}
Create Bulk Purchase in Taxlink
Learn how to efficiently create multiple purchase entries in Taxlink using bulk upload functionality, including Excel management, data mapping, GST configuration, and Tally integration.
Prerequisites
- Active Taxlink subscription with bulk upload permissions
- Microsoft Excel or compatible spreadsheet software
- Valid purchase data with all mandatory fields
- Proper GST registration and ledger setup in Tally
- Stable internet connection for file uploads and Tally sync
Step-by-Step Bulk Purchase Guide
Start Bulk Upload Process
Navigate to the Bulk Purchase module in Taxlink to begin the bulk upload process for multiple purchase entries.
Step 1: Start Bulk Upload Process
Key Actions:
- Log into your Taxlink dashboard
- Navigate to the Bulk Master Creation section
- Click on "Create bulk Purchase in Taxlink"
- Wait for the bulk purchase interface to load
- Ensure you have proper permissions to perform bulk operations
Download Sample Excel Sheet
Download the official Taxlink sample Excel template to understand the required format and columns for bulk purchase data.
Step 2: Download Sample Excel Sheet
Key Actions:
- Click on the "Download Sample Excel Sheet" button
- Save the template to your local computer
- Open the template in Excel or Google Sheets
- Review all column headers and their requirements
- Note any mandatory fields marked in the template
- Keep this template as a reference for future uploads
Fill in Required Details
Populate the Excel sheet with your purchase data, ensuring all mandatory fields are completed accurately.
Step 3: Fill in Required Details
Key Actions:
- Open the downloaded sample Excel sheet
- Fill in purchase details like date, vendor information, amounts
- Enter item descriptions, quantities, and unit prices
- Include GST details, HSN codes, and tax rates
- Ensure all mandatory columns are populated
- Double-check numerical values for accuracy
- Save the file with a descriptive name
Upload Excel Sheet with File Options
Upload your completed Excel sheet to Taxlink with options to upload single or multiple files simultaneously.
Step 4: Upload Excel Sheet with File Options
Key Actions:
- Click on the "Upload Excel Sheet" button
- Choose between "Upload Single File" or "Upload Multiple Files"
- For single file: Select your completed Excel file
- For multiple files: Select all Excel files you want to upload
- Verify file formats are supported (.xlsx, .xls)
- Wait for upload confirmation message
- Review upload status for each file
Select Mapping Options
Configure data mapping options by selecting between mapped and unmapped data to ensure proper field alignment.
Step 5: Select Mapping Options
Key Actions:
- Review the uploaded data in the mapping interface
- Select "Mapped" for data that matches existing ledgers/items
- Select "Unmapped" for new data that needs to be created
- Verify column mappings are correct
- Map Excel columns to Taxlink fields if needed
- Review any mapping warnings or errors
- Confirm mapping selections before proceeding
Configure GST Ledger from Excel
Select and configure GST ledger options directly from your Excel sheet data for accurate tax calculations.
Step 6: Configure GST Ledger from Excel
Key Actions:
- Navigate to the GST Ledger configuration section
- Select GST ledger accounts from your Excel data
- Map different GST rates to appropriate ledgers
- Configure CGST, SGST, and IGST ledgers
- Set up input and output GST accounts
- Verify HSN codes are properly mapped
- Review GST configuration before finalizing
Enable GST Auto Calculation
Configure automatic GST calculation settings to ensure accurate tax computations for all purchase entries.
Step 7: Enable GST Auto Calculation
Key Actions:
- Locate the "GST Auto Calculation" toggle option
- Enable automatic GST calculation for purchase entries
- Set default GST rates for different item categories
- Configure reverse charge mechanism if applicable
- Set up interstate and intrastate GST rules
- Verify calculation rules match your business requirements
- Test calculation with sample entries
Save and Send to Tally
Save all your bulk purchase entries and synchronize them with Tally for complete integration.
Step 8: Save and Send to Tally
Key Actions:
- Review all entries before saving
- Click "Save" to store entries in Taxlink
- Wait for save confirmation message
- Click "Send to Tally" to synchronize data
- Monitor the sync progress indicator
- Verify successful transmission to Tally
- Check Tally for the imported purchase entries
- Resolve any sync errors if they occur
Pro Tips for Success
Always download the latest sample Excel template to ensure compatibility with current Taxlink version
Keep your Excel data organized with consistent formatting to avoid mapping issues
Preview your data mapping before finalizing to catch any potential errors
Double-check GST calculations and rates to ensure compliance with tax regulations
Related Articles
Need Additional Help?
Our support team is ready to assist you with bulk purchase setup and troubleshooting.