Tally release its 6.4.7 version in it ERP 9. They updates usable things in this release. With this you can take entries in Stat Adjustment and Stat Payment vouchers with modified GST details that shows you in GSTR -3B in Tally report. And also when you save ledgers with GST details, it ask you to verify the party GSTIN. It is very useful to all business who have most of reversing journal entries or parties without having GSTIN numbers.
The features provided in tally solution website are as below:-
Highlights
● Enhanced GSTIN validation – Earlier for few taxpayer types, GSTIN validation was failing in Tally.ERP 9. Now, with this new Release, GSTIN will get validated for all taxpayer types
o If your business needs to avail input credit using reverse charge mechanism, you will find it delightfully useful and flexible to take credit on reverse charges in current or future periods
o If you wish to keep track of total liability towards reverse charges or input credit availed, you can easily do so now with the new report,Input Credit to be booked .
for more information you can go to below link: https://help.tallysolutions.com/article/Tally.ERP9/release_notes/release_6.4.7.htm
Bank reconciliations are most important factor for our business. Because without Bank reconciliation you can not know to how to utilise funds for your business. But when we reconcile the bank we get pending cheque amounts that issued to customers or gain by us. By this we can get exactly where we should use our funds. If you not reconcile banks, it will be reason to bounce of cheques and legal cases.
Sometime when we reconcile bank statements in Tally, there is some possibilities of errors and wasting your precious time.
But by this Excel to Tally software you can import your bank statements from Excel software to Tally software with all reconciliation details like chq no. , chq date, bank date etc. and you not required reconcile your bank separately, because it reconcile your bank directly and match your bank balances.
Also your entries will made with bill wise details of customers. You can also maintain customers ledgers with billwise details.
You can also import all type Tally vouchers along with masters via this software.
It is very useful for accounting. You can download it from this link : – http://imojo.in/bvdqa4
In a company or in own business reporting is most important part to know business progress. And excel is most usable software for reporting. And if you have knowledge of VBA coding it become
” Sone pe Suhaga”, So there is a sheet for you that have content of VBA Coding in simple way.
Also via this sheet you can maintain your RTO sheet with auto filter.
In this VBA enabled Excel sheet you can filter with any words of name that you entered and also clear filter with one click. It is very useful to auto sector.
By learning this VBA coding you can make your own report sheet in your format.
You can download it with this link : http://imojo.in/8ds44n
It is Excel to Tally advance item purchase with godown and with stock. In this sheet we have update regarding Tally voucher with Item.
When you go to Tally voucher, there you will find Item invoice (alt+I). In this voucher you maintain purchase with stock item, buyer and supplier detail, with godown, batch etc.
Sometime our entries will be in bulk and we spend lots of time to take entries in Tally. Because there required to fill lots of details in voucher for proper entry.
But by this software you can upload bulk entries with all details from your Excel sheet.
Now a days you can find your all data in excel so it will be easy to upload entries from Excel to Tally.
This software is very easy to use.
Just copy and paste your excel data in this sheet and generate XML file, that you can import in Tally.
I have updated this sheet with godowns. You can enter godown with there individual stock items.
How to use:
First open the Excel2Tally software and open you data in excel (that you want to import).
Choose Adv Item Purchase sheet in software. Here you select you financial period and type your voucher type name (as Purchase, (GST Purchase etc – with you modified with your own)).
enter the date in day and month field separately, then enter your voucher number and then reference no.( Purchase bill no.). (you can use copy and paste).
Then enter your creditor name (where from your purchase) then select Cr. and then enter amount. After this write your Purchase account ledger (Ledger that you created under purchase group) and same choose Dr. then enter amount, and after this same fill all column that you required as – gst ledgers and there amount and other expenses like freight etc. and in last enter narration.
If you want consignee and buyer details you can enter that details after narration.
Now your voucher entry will be completed. in the vouchers if you want to enter stock items you can do these things – double click on ledger name of Purchase account (that you entered in second ledger name). After it you placed in stock sheet, there you can enter stock item details with there godown and batches. For multiple stock enter cell address (I3 or I4 etc) more than one time.
Then back to Adv Item Voucher and click on generate button. You see your entries will be processed for generating XML file.
After few minutes your xml file will be generate and save where is your Excel2Tally software.
open xml file – copy the path (ctrl+c) and open tally – goto Import – voucher – paste (alt+ctrl+v) and press enter.
You will see your all entries imported in Tally.
Note: Ledgers and Stock Items you entered in Excel sheet should be created in Tally.
You can also create ledgers and stock items with this software.
If you want to save your precious time you can download it from below link:
In a business sometime some liabilities are created like creditors, tax payments etc. and also assets like sundry debtors, to collect the payments. And it is important to follow these things to clear your liabilities and assets. But sometime we forget and not follow on time, this effects our business and money. So you must do everything on time with a clear schedule to prevent loss in business.
But now you can make it better with this VBA enabled outstanding tracker excel sheet. In this you can maintain your debtors or creditors outstanding with all details, and also you can highlight your followed customer with one click.
It is also very useful for call centers or who follow customers.
It possible through simple VBA codings. By these codings you can make your own templates according to your work.
These are some simple coding for this macro enabled workbook:
In Excel Sheet1 –
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Intersect(Target, Range(“b4:b17”)) Is Nothing Then If Target.Count > 1 Then Exit Sub If Target.Value = “þ” Then Target.Value = “o” Else: Target.Value = “þ” End If End Sub
In Module – Sub CheckAll() With Sheet1 If .CheckBoxes(“Check Box 1”).Value = 1 Then .Range(“b4:b17”).Value = “þ” Else: .Range(“b4:b17”).Value = “o” End If End With End Sub
———————————————————————————————————-
But before paste these codes in your workbook you must do some important things like adding some formula with conditional formatting tab of excel. For complete tutorial you must see above video.
If you want to download this Outstanding Tracker go through below download button: –
If you find it useful for you or want some more modification in the sheet please comment below.
If we can highlighted a row in excel can see easily all details related to row and decrease wrong calculations. In this sheet you can highlight a row with color. So you find exactly all details that you entered in excel sheet.
It is very easy process through a VBA coding and conditional formatting with some easy formula.
In Excel all official work is possible that you can think. It’s all about your great effort and your hard work with cleverness. Some time excel saves our life. So lets go with this thing.
We all normally use excel for reporting and maintain a summary of our work.
Sometime we need to open some files to show the detail of our summary and need to attached files in our worksheet. It will be an Invoice, Photo or other file format.
In Excel you can attach these file easily with your summary sheet or in a cell.
It will become very useful for your data presentation.
How it will possible
It is very process. Lets follow these steps :
1. Open your summary sheet in Excel
2. Go to insert tab
3. You see text between links and symbol (Excel 2016)
4. Click on small arrow under Text
5. There you will find Object
6. Click on it
7. An Object window will open
8. Click on Create from file
9. Click on Browse
10. Choose the file that you want to insert
11. Now you can select your showing format by clicking on Link to file or Display as icon
12. You can set file area by drag its corners.
Also you can see the above video.
If you want Invoice generator that shows in video can download it from link that provided in video description.
or You can comment your email id in below comment section to get file.
THESE SHORTCUT KEYS MAKE YOU BEST IN TALLY ACCOUNTING
Why we use Tally instead of other software, because in Tally we can do fastest entries other than another software. After know these shortcut keys, you can make an impression in your office.
All the shortcuts are very useful and make you a successful Tally operator.
GO THROUGH THE BELOW SHEETS. IT IS JUST EXCEL SHEET. ALSO YOU CAN DOWNLOAD IT. IF YOU WANT TO KNOW ABOUT SOME MORE SPECIAL KEYS, WATCH THE ABOVE VIDEO
The Goods and Services Tax (GST) now running in India and levied at multiple rates ranging from 0 per cent to 28 per cent. GST Council finalised a four-tier GST tax structure of 5%, 12%, 18% and 28%, with lower rates for essential items and the highest for luxury and de-merits goods that would also attract an additional cess.
In India mostly businesses use Tally software for accounting. And in Tally some features are hidden, they not show at voucher entry time. When we take sales voucher entry, required Item name, there GST rate and GST amount etc. But for an item, there rates are hidden and not shows at entry time.
By this GST detail TDL you can see all GST rates and HSN codes of Items and this will be very helpful for you.
You can download GST details at voucher entry TDL with below download link :
After download fallow these steps to install in Tally :
1. Copy the TDL file path (right click on TDL file – Property – Security – Select path and copy)
2. Open Tally – Press F12
3. Goto Product and Features
4. Press F4
5. Paste the path in blank area (Alt+Ctrl+V to paste) and press enter.
Now your file ready to use. When you go to your sales or purchase vouchers and enter stock item name, there shows Item HSN and it’s GST percentage.
Excel sheet, we use every day at our workplace. Without Excel can not finish our work properly. And every Excel user need some tips and trick to do work perfectly. After learning some Excel tricks and formulas we can save our lots of time. I have listed here some top formulas and excel tricks for you.
In this segment we learn about Pivot Table, Text to Column, Vlookup formula, Transpose, Special filter, Go to Special and much more excel tricks.
PIVOT TABLE:
Pivot table is one of most powerful feature of Excel. By this you can filter and generate a significance data table with a summary. You will find it in Insert Tab of Excel. Just select your data and click on Insert and then Pivot.
You can modified your summarized report as you want.
TEXT TO COLUMN :
Text to column is also a very useful excel feature. By this you can define or separate texts to another cells separately. You will find it in Data Tab of Excel. You can separate your text with it’s delimited or Fixed Width feature. Just select your excel column and goto data and text to column.
VLOOKUP FORMULA:
Vlookup formula is most powerful formula of excel. By this you can search and find any number or text within a criteria. It is must learn formula of Excel. If you learn it correctly, you become master of Excel.
GO TO SPECIAL :
Go to Special feature is also very useful excel feature. if you want to fill blank cells or do any other special things, it will help you lots.
After that some more useful features of Excel is Transpose, Special filter etc.
You can see all these Excel tips and trick in above video.
