Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-21-2016, 08:11 AM
midrees midrees is offline Spreadsheet or any program to manage contracts from which I can create invoices Windows 7 64bit Spreadsheet or any program to manage contracts from which I can create invoices Office 2016
Novice
Spreadsheet or any program to manage contracts from which I can create invoices
 
Join Date: Nov 2016
Posts: 3
midrees is on a distinguished road
Default 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!
Reply With Quote
  #2  
Old 11-21-2016, 08:20 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Spreadsheet or any program to manage contracts from which I can create invoices Windows 7 64bit Spreadsheet or any program to manage contracts from which I can create invoices Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,397
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

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
__________________
Please note I am not active on this forum anymore
Reply With Quote
  #3  
Old 11-21-2016, 08:35 AM
midrees midrees is offline Spreadsheet or any program to manage contracts from which I can create invoices Windows 7 64bit Spreadsheet or any program to manage contracts from which I can create invoices Office 2016
Novice
Spreadsheet or any program to manage contracts from which I can create invoices
 
Join Date: Nov 2016
Posts: 3
midrees is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 11-21-2016, 10:49 PM
jolivanes jolivanes is offline Spreadsheet or any program to manage contracts from which I can create invoices Windows XP Spreadsheet or any program to manage contracts from which I can create invoices Office 2007
Advanced Beginner
 
Join Date: Sep 2011
Posts: 89
jolivanes will become famous soon enough
Default

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.
Reply With Quote
  #5  
Old 11-22-2016, 09:51 AM
midrees midrees is offline Spreadsheet or any program to manage contracts from which I can create invoices Windows 7 64bit Spreadsheet or any program to manage contracts from which I can create invoices Office 2016
Novice
Spreadsheet or any program to manage contracts from which I can create invoices
 
Join Date: Nov 2016
Posts: 3
midrees is on a distinguished road
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Spreadsheet or any program to manage contracts from which I can create invoices Create macro program to automatically email outlook with a visible cell range BillMaintenance Excel Programming 19 03-11-2015 03:19 PM
Spreadsheet or any program to manage contracts from which I can create invoices 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
Spreadsheet or any program to manage contracts from which I can create invoices 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


All times are GMT -7. The time now is 02:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft