SPREADSHEET ANALYSIS
Another big problem for the company is that they have to keep trace of all the income and expenditure for the company on a monthly and yearly basis. This includes things like Office fees including electricity and heating, phone calls plus smaller things like stationary. Looking at the interview that I did with the company at the start we can refer back and see what other things they need.
"What information do you keep on the customers?"
"We have to have general information like names, addresses, and contact numbers. We also keep more detailed information like trade contact, VAT number, outstanding balance, Fax, and E-mail. Finical Details we have to keep are that of customer credit, credit limits, deadlines, current debt, particular customer turnover with our company, Goods purchased graphs on account activity."
"What information is kept on suppliers?"
" Again we keep the general information as well as
all the information on how much we owe to a particular supplier, Goods Purchased, what individual suppliers sell, details of the suppliers reliability and quantity."
"What Finical information do you keep on your current system?"
We keep a general ledger which deals with our total finacial information going in and out for all things including office equipment and petrol and maintenance for the company cars.
Another big problem for the company is that they have to keep trace of all the income and expenditure for the company on a monthly and yearly basis. This includes things like Office fees including electricity and heating, phone calls plus smaller things like stationary. Looking at the interview that I did with the company at the start we can refer back and see what other things they need.
"What information do you keep on the customers?"
"We have to have general information like names, addresses, and contact numbers. We also keep more detailed information like trade contact, VAT number, outstanding balance, Fax, and E-mail. Finical Details we have to keep are that of customer credit, credit limits, deadlines, current debt, particular customer turnover with our company, Goods purchased graphs on account activity."
"What information is kept on suppliers?"
" Again we keep the general information as well as
all the information on how much we owe to a particular supplier, Goods Purchased, what individual suppliers sell, details of the suppliers reliability and quantity."
"What Finical information do you keep on your current system?"
We keep a general ledger which deals with our total finacial information going in and out for all things including office equipment and petrol and maintenance for the company cars.
