HELP!!Unit 31

Primble

Hi

I'm looking at a practice similation for unit 31 and it says that I have to fill in the Account code and Cost code but it does not say how they work these codes out and when I have looked at examples before it says a list of different parts of the code to use to make up the proper one. How is this worked out

Also, I am chosing to do the reports on excel but have no idea how to lay them out. (stupid numpty me left it a bit late to realise I needed Sage and i haven't installed it yet) The paper does say that we can do it on excel though.

Hope I make sense

visha

I presume you are referring to Unit 31 part 2

The part 2 is mainly to do with the use of Sage Line 50 accounts package.

Your are asked to write a customer’s/supplier’s account code;

I usually use Alpha/Numeric code;

For Example if the purchase invoice is from Reveal Retail Ltd; I will code as RR1
If the invoice is from say Frank Groomes Ltd; I will code it as FG1 and so on

For the Main Leger/ Cost code you will need to refer to the Sage Line 50 and how it has organised it’s accounts codes:

Fixed Assest between...............001 to 1000
Current Assets Between............1000 to 1999
Current / long term liabilities.......2000 to 2999
Capital...................................3000 to 3999
Sales.....................................4000 to 4999
Purchases...............................5000 to 5999
Other purchase costs................6000 to 6999
Expenses from.........................7000
Wages...................................7000 to 7099
Property expenses...................7100 to 7199
Heat & Light...........................7200 to 7299
Motor expenses.......................7300 to 7399
Travel Expenses......................7400 to 7499
Office expenses......................7500 to 7599
Professional Fees....................7600 to 7699
ETC


Once you have coded the sale/purchase invoice with your choice of accounts codes you will be asked to open the subsidiary accounts with your chosen a/c codes and then post sales/purchase invoices on sage line 50

I do not understand what reports you intend to prepare in excel.

I hope this information helps.