Admin Cum Accounts Officer
+2 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Dear All,
Can anyone suggest me... im working in a Manufacturing company, Apart from Tally sofware can you all suggest any excel format where we can enter all the Invoice and payment received details and pending amount reflects automatically or any software for the same.
Thanks in advance
T N Madhumathi

From India, Chennai
I understand your requirement. It may simply be designed in excel. Considering your requirement I have developed one excel file which definitely meet your requirement. To get access the same please visit my blog site: (
From India, Kolkata
You may download the attached file. Read the instruction page carefully and start your work.
From India, Kolkata

Attached Files
File Type: xls Payment_Tracker.xls (514.5 KB, 498 views)

Hi Pradip, Thank you for your reply. can we add sales tax and service tax details in to this excel as we need to make the invoices for the same. Regards Madhumathi.
From India, Chennai
Dear, I probably can guess that you have problems with your existing payroll system. I can suggest you one of the best online HR/Payroll software available. It not only has solution to your payroll problem but has so many other extensive modules in it. Nevertheless You can try it out for free for 8 employees. In case you like the system you always can upgrade your plans. The pricing is very genuine. Please visit once.
From India, Delhi
it is great if you can develop a .xls format your self
2 go boldly at it. dont be scared .
3 you are the best judge for what you want .
4. after filling up your input data , please go to formulas and select what you want for an answer . there are super formulas which will help you .
5. you can contact me at for any help to work out the formulas.
6. you can add sales tax , excise tax anything you want as long as you know the rates .
7. on one click you will get what you want
dr ram

From India, Indore
Hi Madhumathi, you can add on Sales Tax, Service Tax details also. If you let me know how would you like to incorporate the information in excel report, then accordingly I will try to resolve the issue
From India, Kolkata
There may be little change in formula which incorporated in this attached file
From India, Kolkata

Attached Files
File Type: xls Payment_Tracker.xls (596.5 KB, 410 views)

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™