ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Creating an invoice accounting system (https://www.excelbanter.com/excel-discussion-misc-queries/3602-creating-invoice-accounting-system.html)

Sir Paul

Creating an invoice accounting system
 
I have a client, who wants me to set up an invoicing system for about 450
invoices per month, with around 100 clients, which will also give her a
report each month on client movement, product movement and a consolidated
report on individual invoices created during each month.

Would you create a file for each month? Is there a way to get the invoices
to reproduce themselves whenever a new invoice is required and still carry
the information?

Your help would be appreciated

JulieD

Hi

personally i would look at investing in an "off the shelf" invoicing system
(e.g. MYOB which starts at A$99 for something like this), having said this,
if you'ld like to email me direct i have a sample invoicing workbook set up
in excel that if you decide you're going to use excel for this, it might
give you some useful ideas.

Cheers
JulieD
julied_ng at hcts dot net dot au

"Sir Paul" wrote in message
...
I have a client, who wants me to set up an invoicing system for about 450
invoices per month, with around 100 clients, which will also give her a
report each month on client movement, product movement and a consolidated
report on individual invoices created during each month.

Would you create a file for each month? Is there a way to get the invoices
to reproduce themselves whenever a new invoice is required and still carry
the information?

Your help would be appreciated





All times are GMT +1. The time now is 02:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com