Using Excel for Accounts Payable - Comprehensive
 

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.

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.

If you are in the US you can get Pachtree accounting or Quickbooks preatty
cheap
I would never use Excel for this even if I had a tiny company

--

Regards,

Peo Sjoblom

"Niek Otten" wrote in message
...
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.