|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Spreadsheet or any program to manage contracts from which I can create invoices
Hi everyone, I was hoping if someone can point me to the right direction. So I have a whole bunch of service contracts from the customers, each differ slightly. Each parent company has many sub companies and each sub company has it's own service contract for services performed. So what I would like to do is input all the information (parent company, sub company, date to invoice (monthly, bi-weekly), length of contract, expiry of contract) from there have a dashboard which tells me which invoices I have to bill out first of the month and etc, along with automatically stopping the list of companies that have reached their expiry date for their contract. I am not sure if there's something out there like this, but If someone can direct me to either a free program or a spreadsheet. That will be extremely helpful. I am not the greatest with excel formulas however if someone can quickly walk through how to create it and what formulas to use, that would be really helpful as well. Thanks in advance! |
#2
|
||||
|
||||
Hi
the idea of free forums is to provide free help when you get stuck in a project, not develop an entire project. So, first thing is to search the web for something as near as possible to your request, try to adapt it, and come back for help if you get into trouble. Everyone will be happy to help
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Wasn't implying on anyone to develop the whole program, was hoping someone could guide me through the process. What formulas I should be using and what sort of template to create. I should've clarified, I did look online and couldn't find anything related to what I was looking for. Or else I would've linked to that spreadsheet and asked how I should go about modifying it.
|
#4
|
|||
|
|||
When I googled "excel free invoice template" I got a whole bunch of possibilities.
Find one that suits you or that puts you on the right track to make your own. |
#5
|
|||
|
|||
Thanks for your response jolivanes, but I am not looking for an invoice template. Excel even offers free invoice templates on their home screen. I need something to manage contracts and which in turn enables me to figure out when to invoice the clients.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
I want to continue a spreadsheet I did not create | jgrubby | Excel | 2 | 10-01-2015 04:15 PM |
Create macro program to automatically email outlook with a visible cell range | BillMaintenance | Excel Programming | 19 | 03-11-2015 03:19 PM |
Would like to mail merge excel spreadsheet with word doc and create new page when a catagory changes | esherwood | Mail Merge | 1 | 07-21-2014 09:55 PM |
Creating Invoices using data from a spreadsheet | tjcusick | Excel Programming | 3 | 12-05-2013 08:36 AM |
Create template that auto-fills from excel spreadsheet | m.buskirk5 | Publisher | 0 | 07-02-2012 03:09 PM |