Excel Invoicing

Hi

Has anyone come across a good free excel invoicing spreadsheet?

A family member has decided to go self employed and I am thinking of using an excel sheet which includes a template for invoicing (which will be sent to the customer) but then perhaps a macro button which then sends the invoice to another sheet which lists all invoices and details from the invoice generated.

If one doesn’t exist I will attempt to design one - just want to save a bit of time as I dont know how to write a macro which would "file" an invoice to a archive sheet. By this I mean the invoice will get printed, details stored on the archieve sheet and then the templated cleared

Hi,

I have an excel template for the invoice.

What I would like to do is once the invoice has been completed and a macro run which will enable the details to be stored on the "Datebase sheet"

I have found this code:

Please Login or Register  to view this content.

But it doesnt work - can anyone suggest what i need to adapt? At the moment it is only going to list two items (invoice number and customer number)

It appears that in the code their is no reference to the Database sheet in which i need the data pulled to - how do I correct this?

Can anyone help please?

Try downloading Invoice Master 06 25 09 from the site below and see if it is helpful:

HTML Code: 

Sorry I cant help -Im a complete novice but I love the idea.
I am trying to create invoices (for goods and services provided,which cover several rows of data per invoice) which I then wish to retain in a database for Inland Revenue purposes for end of year and to see my invoice history... I will watch with interest how yours unfolds...
Regards
Tugs

Did you check out the spreadsheet is post number 6?

This is what I want so hopfully it should be the same with you. I do need to format it to suit but other than that it is brilliant.

Thank you ncmay, I checked it out and its great Thank you. Any idea how I can amend the message that populates the email?
Regards
ToniAnne

Hi Toni

this can be done, I have done that also. Do you know how to amend the Email macro? Hit Alt F11 and then down the left hand side select the macro and it can be edited from there

Which version are you using.

By the .xls file extension, it would indicate 2003.

cplmckenzie

Toni,

The attached is a sheet I am doing for my daughter's, Photography business.

This is the original she downloaded, from where I don't know.

I have modified it to correct some incorrect calculations and other visual features particular to her business.

Each row is a line item entry.

The user enter a Quantity, Description and Unit Price.

The amount will be calculated for the user.

Note,.... the discount column is incorrect.

As i said I fixed a number of bugs in the version modification for my daughter.

There are auto calcs for the Invoice totals.

This is done in Excel 2007 as a .xlsm sheet.

If this is simular to what you need, post back and I will go into the details of the modifications I made.

cplmckenzie

If you want to build quality invoice using excel then i only suggest you to visit http://www.fetchflow.com/support/que...ing-Excel.html and generate you type of excel invoice with unique premium features then you will not find any where.

Hi,

Check out the attached Express Invoice programme from NCH Software.

http://www.nchsoftware.com/invoice/index.html

At a very competitive price of £32.00 (plus VAT ?) and a 30 Day money back guarantee.
I have been useing it at 12 Depots for the last 2 years.
(Please note I a not in any way connected with NCH Software other than being a customer)

Regards

peterrc