No Tags Found!


Dear All,

Can anyone suggest to me? I'm working in a manufacturing company. Apart from Tally software, 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.

Regards,
T N Madhumathi

From India, Chennai
Acknowledge(0)
Amend(0)

You may download the attached file. Read the instruction page carefully and start your work.
From India, Kolkata
Attached Files (Download Requires Membership)
File Type: xls Payment_Tracker.xls (514.5 KB, 566 views)

Acknowledge(0)
Amend(0)

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
Acknowledge(0)
Amend(0)

Developing an Excel Format for Invoices

It is great if you can develop an .xls format yourself. Go boldly at it; don't be scared. You are the best judge of what you want. After filling up your input data, please go to Formulas and select what you want for an answer. There are super formulas that will help you.

You can contact me at [Email Removed For Privacy Reasons] for any help to work out the formulas. You can add sales tax, excise tax, anything you want as long as you know the rates. With one click, you will get what you want.

Blessings,
Dr. Ram

From India, Indore
Acknowledge(0)
Amend(0)

Hi Madhumathi, you can add Sales Tax and Service Tax details as well. If you let me know how you would like to incorporate the information in the Excel report, I will try to resolve the issue accordingly.
From India, Kolkata
Acknowledge(0)
Amend(0)

There may be little change in formula which incorporated in this attached file
From India, Kolkata
Attached Files (Download Requires Membership)
File Type: xls Payment_Tracker.xls (596.5 KB, 516 views)

Acknowledge(0)
Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.







Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2025 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.