View Single Post
  #2   Report Post  
Niek Otten
 
Posts: n/a
Default

This doesn't sound like something for Excel at all. I agree you should look
for a good database program or, even better, a standard package.
I would strongly recommend not to use Excel for this.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"MidNiteRaver" wrote in message
...
I am looking at putting together an accounts payable workbook. I was
wondering though if they was one someone had done already, in which case I
wouldn't reinvent the wheel, but simply download it.

I need the workbook to have a main page which would indicate all the
suppliers, the totals owed, days out standing etc.

The individual suppliers sheets would have each invoice entered, along
with
the following data, invoice date, invoice item total, invoice additional
charges total (shipping , packing etc), our purchase order for that
invoice,
the PO date, currency. The sheet must allow for multiple payments on the
same
invoice each showing days from date of invoice due.

Yes essentially I should be using a database program but they tend to be
too
messy, and get worse when things go wrong.