Seeking Advice: How Do You Track Invoices and Payments Without Tally Software?

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

You may download the attached file. Read the instruction page carefully and start your work.

---
You may download the attached file. Read the instruction page carefully and start your work.

Hi Pradip,

Thank you for your reply. Can we add sales tax and service tax details into this Excel as we need to make the invoices for the same?

Regards,
Madhumathi.

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

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.

There may be little change in the formula which is incorporated in this attached file.