Excel Spreadsheet on Purchase Ledger
 

Hi, i am just starting up a small business and was wondering if anyone could
guide me the correct way of having control of the suppliers and their payment
terms on excel. I want to make sure i pay the suppliers on their correct
payment terms and not earlier.
Unfortunately, this is a very manual system but as i am starting up i donot
have the funds to buy a computerised system yet!!
Any help would be grateful
Thanks

Excel Spreadsheet on Purchase Ledger
 

Try this:-

SupplierName (column A)

a
b
c
d
e

AmountDue (column B)

1,000.00
2,000.00
3,000.00
4,000.00
5,000.00

DateDue (column C)

- dates here in European format (not US)

24/11/2009
24/11/2009
24/11/2009
24/11/2009
24/11/2009

DatePaid (column D)

- dates here in European format (not US)

23/11/2009
24/11/2009
25/11/2009
26/11/2009
27/11/2009

Early (Positive) / Late (Negative) (column E)

1
0
-1
-2
-3

There are many ways to do this: the above is just a suggestion.

If my comments have helped please hit Yes.

Thanks!



"Naz" wrote:

Hi, i am just starting up a small business and was wondering if anyone could
guide me the correct way of having control of the suppliers and their payment
terms on excel. I want to make sure i pay the suppliers on their correct
payment terms and not earlier.
Unfortunately, this is a very manual system but as i am starting up i donot
have the funds to buy a computerised system yet!!
Any help would be grateful
Thanks

Excel Spreadsheet on Purchase Ledger
 

Office Template Gallery will surely have what you need.

http://office.microsoft.com/en-us/te...595491033.aspx

See the results of a search for "ledger".

http://office.microsoft.com/en-us/te...dger&av=TPL000


Gord Dibben MS Excel MVP

On Tue, 24 Nov 2009 13:14:01 -0800, Naz
wrote:

Hi, i am just starting up a small business and was wondering if anyone could
guide me the correct way of having control of the suppliers and their payment
terms on excel. I want to make sure i pay the suppliers on their correct
payment terms and not earlier.
Unfortunately, this is a very manual system but as i am starting up i donot
have the funds to buy a computerised system yet!!
Any help would be grateful
Thanks