๐ญ. ๐ข๐ฝ๐ฒ๐ป ๐๐ฎ๐๐ ๐๐ป ๐๐น๐ผ๐ & ๐๐ผ๐ป๐ป๐ฒ๐ฐ๐ ๐ง๐ฎ๐น๐น๐
- Go to the Help sheet and match the Tally Port in Cell ‘D4’ to the Tally port.
(To set the port in Tally, press F12 on Gateway –> Advanced Configuration.)
- Now, on the Help sheet, click the “Connect Tally” option.
๐ฎ. ๐๐ผ๐ฝ๐ ๐ฑ๐ฎ๐๐ฎ ๐ถ๐ป ๐ฃ๐๐ฟ๐ฐ๐ต๐ฎ๐๐ฒ/๐ฆ๐ฎ๐น๐ฒ๐ ๐ฆ๐ต๐ฒ๐ฒ๐
- Select the Purchase/Sales sheet and check the Cell D1 Mode. If the mode is different, click the “Inventory Mode” button.
- Copy the necessary field below:
a) Inv No.
b) Date
c) Customer/Party Name
d) Supply Location
- If necessary, copy optional information such as the party GST number, narrative, consignee name, reference number, and reference date into future columns.
3. ๐๐ผ๐ฝ๐ ๐๐ฎ๐๐ฎ ๐ถ๐ป ๐ฆ๐๐ผ๐ฐ๐ธ ๐ฆ๐ต๐ฒ๐ฒ๐
- Navigate to the Stock Sheet.
- Fill in the blanks with the invoice number, item name, godown, quantity, item rate, and GST rate.
- Do not enter the unit; it will appear after you validate this document.
- If necessary, put in optional fields such as Discount (percent), TCS/Cess.
- Click the disable rate option if you wish to input assessable value instead of Item Rate.
- You can also use the Import GST Rate option to import GST rates for stock goods from Tally.
๐ฐ. ๐ฉ๐ฎ๐น๐ถ๐ฑ๐ฎ๐๐ฒ ๐ฆ๐๐ผ๐ฐ๐ธ ๐ฆ๐ต๐ฒ๐ฒ๐
- On the stock sheet, click the Validate button.
- All stock sheet data will be checked, and any inaccuracies will be noted in red. One error report will be created as well.
- Errors are divided into three categories:
Item Name Error- For a solution, go to the next step.
GST Rate Error- Choose a GST rate from the drop-down menu.
Godown Name Error- Select Godown from the drop-down menu.
Taxable Values Error- Taxable values should be within permitted decimal digits (Usually 2 decimal)
๐ฒ. ๐ฉ๐ฎ๐น๐ถ๐ฑ๐ฎ๐๐ฒ ๐ฎ๐ด๐ฎ๐ถ๐ป ๐๐ถ๐น๐น ๐ฎ๐น๐น ๐ฒ๐ฟ๐ฟ๐ผ๐ฟ๐ ๐ฟ๐ฒ๐๐ผ๐น๐๐ฒ๐ฑ
Validate the stock sheet once again to ensure that all mistakes have been eliminated. Proceed to the next step if Validation was successful.
๐ณ. ๐ฉ๐ฎ๐น๐ถ๐ฑ๐ฎ๐๐ฒ ๐ฃ๐๐ฟ๐ฐ๐ต๐ฎ๐๐ฒ_๐ฆ๐ฎ๐น๐ฒ๐ ๐ฆ๐ต๐ฒ๐ฒ๐
- In Cell E2, choose Voucher Type. All default and custom vouchers in Tally will be displayed here.
- Select the Calculate & Validate option to find any data errors and view the report on the error sheet.
- Click on the links to correct the inaccuracies.
- Errors are divided into four categories:
Error in the Party Nameโsee the following step for a solution.
Date should be accessible in Excel and within the financial year specified in Cell ‘C2’.
POS Error- Select POS from the drop-down menu.
Taxable Values Error- Taxable values should be within permitted decimal digits (Usually 2 decimal)
๐ด. ๐ฅ๐ฒ๐๐ผ๐น๐๐ฒ ๐ฝ๐ฎ๐ฟ๐๐ ๐ป๐ฎ๐บ๐ฒ ๐ฒ๐ฟ๐ฟ๐ผ๐ฟ
- All new ledgers are transferred to ledger sheet after confirmation. To export them in Tally, go to the ledger sheet.
- Alternatively, you may change the ledger name in sales data by using the drop-down menu.
๐ต. ๐ฉ๐ฎ๐น๐ถ๐ฑ๐ฎ๐๐ฒ ๐ฎ๐ด๐ฎ๐ถ๐ป ๐ฎ๐ป๐ฑ ๐๐ ๐ฝ๐ผ๐ฟ๐
- Validate the sheet once again to ensure that all mistakes have been eliminated. Click the Export to Tally button if Validation was successful. All data will be promptly exported to tally.
- Go to tally and double-check your data.
