HELP!!Unit 31

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

Comments

  • visha
    visha Registered Posts: 218 ? ? ?
    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.
Privacy Policy