Excel Spreadsheet on Purchase Ledger

  • Thread starter Thread starter Naz
  • Start date Start date
N

Naz

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
 
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!
 
Back
Top