creating a client invoice

needhelp · Apr 18th, 2002, 09:59 PM

I need to create a client invoice with two sections: one for me to keep track of expenses and the other to use as a billing statement for the client

Yogi Anand · Apr 18th, 2002, 10:34 PM

You should provide a little more information about
1) what you would be invoicing ... product sale, services, time and material
2) information on how are you going to be recording the expenses
3) Is it going to be daily, weekly, periodic, random
4) how would you statement be laid out

You should layout everything first, and then perhaps ask for help on formulas and functions that you would be working with.

HTH

nisht · Apr 18th, 2002, 11:57 PM

download file no 14 which shows the example for different ways of giving invoice numbers.

http://www.pexcel.com/download.htm

i hope this will help you.

nishith desai
http://www.pexcel.com

Jack in the UK · Apr 19th, 2002, 12:08 PM

an easy cheat is the microsoft supplied sample called invoice.elt this is custom able on second sheets all macros work.. REALLY the best ive seen

I woul suggets keeping the expences away from invoices i say this as one is sales ledger and the other purchase...

Apr 18th, 2002, 10:34 PM	#2
Yogi Anand MrExcel MVP Join Date: Mar 2002 Location: Michigan USA Posts: 11,452	You should provide a little more information about 1) what you would be invoicing ... product sale, services, time and material 2) information on how are you going to be recording the expenses 3) Is it going to be daily, weekly, periodic, random 4) how would you statement be laid out You should layout everything first, and then perhaps ask for help on formulas and functions that you would be working with. HTH __________________ Regards! Yogi Anand, D.Eng, P.E. Energy Efficient Building Network LLC www.energyefficientbuild.com

Apr 19th, 2002, 12:08 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	an easy cheat is the microsoft supplied sample called invoice.elt this is custom able on second sheets all macros work.. REALLY the best ive seen I woul suggets keeping the expences away from invoices i say this as one is sales ledger and the other purchase... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 18th, 2002, 09:59 PM	#1
needhelp New Member Join Date: Apr 2002 Posts: 1	I need to create a client invoice with two sections: one for me to keep track of expenses and the other to use as a billing statement for the client

Apr 18th, 2002, 11:57 PM	#3
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	download file no 14 which shows the example for different ways of giving invoice numbers. http://www.pexcel.com/download.htm i hope this will help you. nishith desai http://www.pexcel.com