Uploading Sales/Sales return data through an excel sheet Suvitโs Sales/Sales Return automates sales and return tracking, syncing with Tally to ensure accurate records and reduce manual data entry for businesses.
๐ค Upload Sales or Sales Return Data via Excel
This guide is designed to help you upload sales data quickly and correctly using Excel in Suvit.
โถ๏ธ Quick Video Tutorial
VIDEO
๐ Quick Access
๐ช Step-by-Step Instructions
Step 1: Go to Bulk Upload โ Sales / Sales Return
From the left menu, click on Bulk Upload .
Then choose either Sales or Sales Return from the dropdown.
Here we have selected Sales
Step 2: Click Upload
Click on the Upload button on the top right corner to add your Excel file.
Step 3: Select and Upload Your Excel File
Click "Click to upload" to select your file from the computer.
Make sure:
โ The file does not contain dots (.) or dollar ($) symbols in headers.
โ The file size is under 30MB .
โ The date format is in DD/MM/YYYY (e.g., 05/08/2024).
โ Do not upload password-protected Excel files.
โ You have synced the required ledgers.
Once the file is selected, click Upload to proceed.
Step 4: File Appears in List
Your file will now appear in the list with its name, type, and transaction count.
This confirms it was successfully uploaded.
๐ก Pro Tip for Accountants
Double-check that the Sales Account Ledger is mapped as per your GST rate.
Always sort by Invoice Number A-Z to avoid mapping issues.
๐ What's Next?
Once your file is uploaded:
๐ Head to the Data Mapping Screen by clicking on the uploaded file.
To learn more about mapping: Learn how mapping works
โ