I need a spreadsheet for one particular job I just finished, and to be used as a template for other jobs similiar to this one. My current invoices just don't allow the room or the detail the owners want for this project. I use Rent Manager, but their maintenance invoices just aren't cutting it.
I'm trying to create one on my own, but I really suck at this. Was wondering if I could enlist some help and maybe you could send me something I could integrate with the one I'm working on? If I use it, I can slip you a $20 for your effort and time.
Here's what I need from any sucker... er, I mean volunteers:
On the top, a heading with my invoice number, company name, license number, address, fax, etc.
Then, I know I'll need colums broken down into the following categories:
On sheet 1:
Date
Credit (payment)
Labor
Material
Is this a change order to bid? (with enough space for Y or N)
Then, on sheet 2:
Date
Receipt number
Line number
Description (EG: Kitchen floor preparation and leveling)
Sheet 3:
Date
Notes (EG: Includes tearout of existing floor and patching; change order number XXXXX-XX)
Then, on each sheet, I need running totals that track credits (as payments/deposits), incurred costs that separate material and labor, and a final total that deducts credits from incurred costs. This will give me an amount due and running total per sheet, plus a final total per book.
Anyone up for the challenge for a measly $20? Sorry, it's all I have to offer right now.
Of course, I'd like all columns to be automatic, and the final to have subtracted the credits from the incurred sum of material and labor.
My email is richardh247 AT cox.net, and anything anyone can offer in the way of a template would be greatly appreciated!