EXCEL TO TALLY – ATTENDANCE

Payroll accounting in Tally software now most easy process and you can maintain Salary, Salary Slips, Employee Details, Attendance, Salary Payments etc. easily.

In a firm, Company or personal business if you have employee and maintain daily or monthly salary, then it is for you. 
When book salary of employees, you need to maintain employee details, working hours or day, there bank details, PF, ESIC, and payment details etc.
And all in these things there is most important roll of attendance. If you not maintain attendance, you never make correct salary. So we maintain excel sheets etc to provide correct salary to employees.
But in Tally you can book all details related to salary in easy way.
If you use tally I have Excel to Tally attendance software for you.
By this you can book attendance directly in your tally with this excel sheet.

This sheet is very simple. Just copy and paste or write your employee names and there attendance details like – absent , present, leave etc and write voucher date. By pressing generate button you got xml file of your filling data, that you can import in your tally.

How to use Excel2Tally – Attendance sheet :

1. Open the utility.
2. Enable Macro setting of Excel (Excel option – Trust Center – Trust Center Setting – Macro Setting – Tick on Enable all macros and press OK)
3. Fill Date and Voucher Number in Attendance Sheet.
4. Double Click on Voucher Number (You replaced in EmpAttendance Sheet)
5. Fill here Employee details and there absent or present in there own column.
6. Fill Voucher cell address (in 1st Cell like – B2)
7. Back to Attendance Sheet
8. Click on Generate

Now you got XML file named attendance (It save there where is your software)

How to import XML file in Tally : 

1. Write click on XML file that you generated
2. Goto Property – Security
3. Select and copy the path
4. Go to Tally – Import Data
5. Paste the Path (Alt + CTRL + V)
6. Press Enter

Now your attendance imported in Tally.

How to Find this Utility:

If you want this utility goto this Link https://youtu.be/_rvQjPuiYiI 
and Give your Email id in comment box. I will mail you.

For more information please watch this video : 

EXCEL TO TALLY – RECEIPT NOTE AND DELIVERY NOTE

Receipt Note and Delivery Notes play most important role for accounting. Via Receipt Note you can know receive goods detail with there quantity and price and also check same things in Delivery Note.
If you use Tally accounting software it will become your time saving thing, because by entered these notes you can take purchase voucher and sales vouchers entry very easily. By entering  tracking number of Receipt Note and Delivery Note you can fill all details in your sale and purchase vouchers in Tally. For this you need only select your Note number and you will find all details related to invoices.

If you want to enter these vouchers in huge amount, you can use this Excel to Tally software. It will become triumph for your work. By this you can easily import Receipt Note and Delivery Note Vouchers in Tally from excel data. And easily can generate Sales and Purchase vouchers with stock Items with there godowns and batches.
By this software you can import all things like Ledgers, Stock Items, Bank entries, Expense Vouchers, etc. related to your GST accounting as you want.
This software will help you prepare your work on time.
This is very useful software and free for life time with there updates.

Just fill the details . Generate XML
Goto Tally – Import of Data – Vouchers – Paste XML file path with file name and .XML

You can download it with this Link :

For more details, Please watch this video: 

EXCEL TO TALLY – Order Vouchers

In a business if you purchase or sale the goods, you must maintain purchase or sale order vouchers.
If you use Tally accounting voucher this is for you.
For proper complete accounting you must try purchase order or sales order vouchers. By these vouchers you can track rates and quantitative details of goods that you want to sale or purchase.
But some time it become lengthy process to take order vouchers entry.
But by this Excel2Tally software you can Import order vouchers with multiple godowns and batches and with all GST details and other expenses that you want to enter in a voucher.
You can also create an order voucher with order number and tracking details that help you when you take purchase or sale entries.
You can import two thousand entries at one time.

Also can import all type accounting vouchers, Inventory vouchers, Order vouchers along with Debit Notes and Credit Notes as per GST rules.
And also you can import Stock Masters, Ledger Masters with all GST details.

You can save you precious time with this easy to use Excel to Tally software.
You can use it lifetime, because it converts XML file from Excel and you can import it in all versions of Tally (Tally 7.2, Tally 9, Tally ERP, Tally ERP 9, Tally ERP 9 GST ready latest versions )

Your all works will be complete smoothly. You can properly set your mind in business without any tension, because we are with you. You can call any time for any type help related to software.

Go completely tension free and set your mind in your work.
You can also send your data to us for importing in tally with a minimal amount.
We will complete your work in time as you want.

If you want to download this software you can download it through Excel to Tally tab in this website or you can go through below download link :

For How to import Order vouchers please see the below video:

STOCK ITEM TRACKER

Sometime when we want to know about stock items details like we search for bills that what was the rate, same for size, tax details etc.
But now with this Stock Item Tracker you can find everything related to stock details in one click.
It will become a true friend in your business. Now you will tension free in your business with this automatic excel Stock Item Tracker.

In this VBA Excel Macro enabled sheet you will find details of item like Item Name, Number, HSN Code, Tax Rate, Group, Size, Unit, Godown, Batch, Purchase Rate, Sales Rate, Balance Quantity and Quantity Amount.

How to use the Sheet:
(Open the sheet  – enable macro)

  1. Add Item Details:
First place you curser in first blank cell where you want to enter stock details.
For adding Item details click on Add item Details. Now a form will be open, enter your all required details in own fields that you want. Then press enter. Same you can enter all items.
      2. Search Item Details

For search Item details enter keyword under heading section then press green color filter button. You will find that your all item details will filter with entered keyword details.
      3. Clear Search

For clearing search details press blue color clear button. You will find that all your filter will be clear and shows all details again.
This sheet is enabled with VBA codings. If you have some knowledge about VBA you can modified it with your won and alos comment about your modified sheet that you created.
if you want to know about the coding, download this sheet open and Press F11. Now you will find all coding and user form related to this document.
For know more you can see the below video:

You can download by clicking with below button

EXCEL TO TALLY – STOCK JOURNAL IMPORT

Some time we tired to take Stock Journal entries in Tally because there is lots of items that consumed during manufacturing a material. But via this software you can enter pre decided Stock names and Vouchers with there godown details, Batch details, Voucher Numbers, Dates and with additional costs.
You can aslo create Manufacturing Stock Journal with this simple software.

See how to import stock journal and manufacturing journal from Excel to Tally.
Also Via this software you can import all type Vouchers with stock Items or Without stock items. and also can import Ledger Masters and Stock Masters with all GST Details. You can download this Manufacturing Edition Software from Below Link: http://imojo.in/8c0728

Tally ERP 9 – Latest Release 6.4.7 | Full Review ☑️

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

Excel to Tally – Import Reconciled Bank Statement with Billwise Detail ☑️

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


Excel VBA – Auto Filter and Auto Clear | RTO Sheet

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


EXCEL TO TALLY – ADVANCE PURCHASE WITH STOCK AND GODOWN ☑️

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: 

Excel VBA – Outstanding Tracker ☑️

          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.
Thanks!