| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| General ledger spreadsheet | Excel Worksheet Functions | |||
| Excel 2003 bank ledger spreadsheet background fill shading | Excel Worksheet Functions | |||
| how do i set up a purchase ledger | Excel Discussion (Misc queries) | |||
| Purchase Order/Invoice ledger | New Users to Excel | |||
| sales, expenses and purchase ledger for excel | Excel Worksheet Functions | |||
Hybrid Mode
