Upload Sales & Sales Return Data via Excel

Complete step-by-step guide for uploading sales and sales return data using Excel files. Learn how to navigate to bulk upload, select files, upload data, and manage your uploaded files efficiently in Taxlink.

Important: Excel File Requirements

Ensure your Excel file contains all required columns and follows the proper data format. Use the provided template for best results. Files should be under 50MB with a maximum of 100,000 records for optimal processing.

Excel File Requirements

File Format

Supported Excel formats and specifications

Excel formats: .xlsx, .xls
CSV format: .csv
Maximum file size: 50MB
Maximum rows: 100,000 records

Required Columns

Essential columns that must be present in your Excel file

Invoice Number (mandatory)
Invoice Date (mandatory)
Customer Name (mandatory)
Product/Service Description
Quantity and Unit Price
Tax Information (GST/VAT)

Data Format

Proper formatting requirements for data fields

Dates: DD/MM/YYYY format
Numbers: No special characters
Text: UTF-8 encoding
Currency: Numeric values only

Step-by-Step Excel Upload Guide

Go to Bulk Upload → Sales / Sales Return

Navigate to the Bulk Upload section in Taxlink and select the Sales/Sales Return module to access Excel upload functionality.

Step 1: Go to Bulk Upload → Sales / Sales Return

Key Actions:

Login to your Taxlink dashboard
Locate the "Bulk Upload" section in the main navigation menu
Click on "Bulk Upload" to expand the available options
Select "Sales / Sales Return" from the dropdown or submenu
The system will redirect you to the sales data upload interface
Verify that you have proper permissions for bulk data upload

Click Upload

Find and click on the "Upload" button to initiate the Excel file upload process for your sales data.

Step 2: Click Upload

Key Actions:

Look for the "Upload" button in the sales upload interface
The button may be labeled as "Upload Excel", "Import Data", or "Browse Files"
Click on the upload button to open the file selection dialog
Ensure your Excel file is properly formatted before uploading
The system will prepare to accept Excel file formats
Check that your file meets the size and format requirements

Select and Upload Your Excel File

Choose your prepared Excel file containing sales and sales return data, then upload it to the system for processing.

Step 3: Select and Upload Your Excel File

Key Actions:

Browse and select your Excel file from your computer
Ensure the file contains properly formatted sales data
Supported formats: .xlsx, .xls, .csv files
Verify column headers match the required template
Check that all mandatory fields are included
Click "Upload" or "Import" to start the file processing
Wait for the upload progress to complete

File Appears in List

After successful upload, your Excel file will appear in the uploaded files list where you can track processing status and manage your data.

Step 4: File Appears in List

Key Actions:

The uploaded file will appear in the files list or dashboard
View file upload status: Processing, Completed, or Error
Check the number of records processed vs. total records
Review any validation errors or warnings for the uploaded data
Access file processing logs and error reports if needed
Option to re-upload or edit the file if issues are found
Proceed to map and validate the imported sales data

Sample Excel Data Structure

Use this structure as a reference for preparing your Excel file:

Column Name	Example	Type	Required	Description
Invoice Number	INV-2024-001	Text	Yes	Unique identifier for each invoice
Invoice Date	15/03/2024	Date	Yes	Date when the invoice was issued
Customer Name	ABC Company Ltd	Text	Yes	Name of the customer or client
Product/Service	Software License	Text	No	Description of product or service sold
Quantity	5	Number	No	Quantity of items sold
Unit Price	1000.00	Currency	No	Price per unit of the item
Total Amount	5000.00	Currency	Yes	Total invoice amount including taxes
Tax Rate	18%	Percentage	No	Applicable tax rate (GST/VAT)

Advanced Upload Features

Bulk Processing

Upload thousands of sales records at once

Process up to 100,000 records
Batch validation and error checking
Progress tracking during upload
Rollback option for failed uploads

Smart Validation

Automatic data validation and error detection

Real-time data format checking
Duplicate record detection
Missing field identification
Business rule validation

Data Mapping

Intelligent mapping of Excel columns to system fields

Automatic column detection
Custom field mapping options
Template matching
Save mapping profiles for reuse

Best Practices for Excel Upload

Excel File Preparation

Clean your data before upload. Remove empty rows, ensure consistent formatting, and validate all required fields are present.

Data Backup

Always keep a backup copy of your original Excel file before uploading. This ensures you can recover if any issues occur.

Test with Small Batches

Upload a small sample first to verify data format and mapping before processing large volumes of data.

Review Upload Logs

Always check the upload logs and error reports to ensure all data was processed correctly and address any issues.

Troubleshooting Common Upload Issues

File Format Not Supported

Ensure your file is in .xlsx, .xls, or .csv format. Convert from other formats if necessary using Excel or similar software.

Upload Size Limit Exceeded

Split large files into smaller batches under 50MB. Remove unnecessary columns and compress data if possible.

Column Mapping Errors

Verify column headers match the expected format. Use the provided template and ensure consistent naming conventions.

Data Validation Failures

Check for proper date formats, remove special characters from numbers, and ensure all required fields are populated.

Duplicate Records Found

Remove duplicate entries from your Excel file or use the system's duplicate handling options to merge or skip duplicates.

Need more help?

Explore other sales features and data processing options

Sales Prerequisites Browse All Topics