Yes you can. You would find a worksheet named Accounting Voucher (Read Me) in that import template Excel file. There if you scroll-down, you should find 2-3 columns related to Bill Allocations. Just add those columns into your main worksheet, with applicable values (like New Ref / Agst Ref, etc), which will incorporate bill referening in voucher. Ensure you backup your Tally company, as this require few trial-error.
Suppose I have 2 different ledgers, I made sales on same date.. Problem it is taking the 2nd voucher and adding amount of both 1st and 2nd legder and Debiting in 2nd ledger... Please suggest how to enter 2 different ledgers amount on the same date sales/purchase/payment.
i want to enter cash bank and credit payment dr to sales account cr entries using this method of your. can i put cash bank and party name instead of amazon in your example?
I am using Tally ODBC to get GST details, but I couldn't get GST Registration Type details correctly. Suppose I have entered a GSTIN which has "Input Service Distributor" as Registration Type, when importing from Tally I am not getting it. It shows null. And if I try VAT Registration Type Field it shows Regular. Please give a work around on this. $_PartyGSTIN gives GSTIN number, $PriorStateName gives state name, $GSTRegistrationType gives null for Sundry Debtors.
Use Tally to Database utility with CSV mode, which does this correctly. Check Tally Prime Excel Dashboard video where you will see the correct output of this in mst_ledger table
@@ExcelKida Thanks a lot. I am using that for Google Sheets and bigquery. But I need it to be my Excel only. Running it everytime will be hectic. I was going through the yaml file, can you just tell me this field "$LedGSTRegDetails[Last].GSTIN" how can I get it in ODBC? I couldn't find this anywhere.
As such there is no separate template for payroll. You need to use the same voucher template adding relevant columns of payroll (from that supporting sheet where column names are described). I have never used a Payroll voucher as such, but yes the procedure remains the same.
In the line of Sales ledger account, just keep on crediting the same sales ledger, with a bifurcated amount item wise. So technically the same ledger would be hit with multiple stock items. Tally handled this. Only thing you need to ensure that debit & credit balances for single transaction.
Thank you so much for this video, it was clear and it helped me a lot.
Thanks Sir 🙏
Excellent...How can we insert Voucher number as New Ref
Yes you can. You would find a worksheet named Accounting Voucher (Read Me) in that import template Excel file. There if you scroll-down, you should find 2-3 columns related to Bill Allocations. Just add those columns into your main worksheet, with applicable values (like New Ref / Agst Ref, etc), which will incorporate bill referening in voucher. Ensure you backup your Tally company, as this require few trial-error.
Suppose I have 2 different ledgers, I made sales on same date.. Problem it is taking the 2nd voucher and adding amount of both 1st and 2nd legder and Debiting in 2nd ledger... Please suggest how to enter 2 different ledgers amount on the same date sales/purchase/payment.
Tally does not know where you entry ends. It attempts to find it via cumulatively totalling
@@ExcelKidaitem wise sale import me multiple sale rate ledger kaise hoga jaise tally me hm log krte h use common ledger for item allocation set to NO
i want to enter cash bank and credit payment dr to sales account cr entries using this method of your. can i put cash bank and party name instead of amazon in your example?
Yes you can. Make a copy of this & just delete inventory related columns, and then you can push regular purely accounting voucher
I am using Tally ODBC to get GST details, but I couldn't get GST Registration Type details correctly. Suppose I have entered a GSTIN which has "Input Service Distributor" as Registration Type, when importing from Tally I am not getting it. It shows null. And if I try VAT Registration Type Field it shows Regular. Please give a work around on this.
$_PartyGSTIN gives GSTIN number, $PriorStateName gives state name, $GSTRegistrationType gives null for Sundry Debtors.
Use Tally to Database utility with CSV mode, which does this correctly. Check Tally Prime Excel Dashboard video where you will see the correct output of this in mst_ledger table
@@ExcelKida Thanks a lot. I am using that for Google Sheets and bigquery. But I need it to be my Excel only. Running it everytime will be hectic.
I was going through the yaml file, can you just tell me this field "$LedGSTRegDetails[Last].GSTIN" how can I get it in ODBC? I couldn't find this anywhere.
I don't think Tally allows editing inbuilt ODBC views.
Can you provide a payroll voucher template also
As such there is no separate template for payroll. You need to use the same voucher template adding relevant columns of payroll (from that supporting sheet where column names are described). I have never used a Payroll voucher as such, but yes the procedure remains the same.
how to solve mismatch in total amount between credit and debit entries ?
Use the round off ledger to park the difference, just like majority organisations do.
How to import multiple Inventory
In the line of Sales ledger account, just keep on crediting the same sales ledger, with a bifurcated amount item wise. So technically the same ledger would be hit with multiple stock items. Tally handled this. Only thing you need to ensure that debit & credit balances for single transaction.