Hero image
Resources for teachers (and students) of bookkeeping and accountancy
Costing-Manufacturing account activities x4
rodbexrodbex

Costing-Manufacturing account activities x4

(0)
Relevant for students of AAT Level 2 Elements of Costing. Four tasks on a spreadsheet, presenting assorted data that needs to be rewritten in the sequence of a Manufacturing account. Last two tasks also require subtotals to be calculated. Answers provided, on page 2 so can be printed with or without.
Costing: Stock record card completion activity (FIFO/LIFO/AVCO)
rodbexrodbex

Costing: Stock record card completion activity (FIFO/LIFO/AVCO)

(0)
Relevant to AAT Level 2 Elements of Costing. This activity requires students to complete a stock record card-calculating an issue price, and the balance of inventory value. Three sections-FIFO, LIFO, AVCO. Additional task requires students to calculate Sales, Cost of Sales and Gross Profit under the three methods. Illustrates which method may give highest inventory value, highest profit, etc. Students can complete on paper or in Excel. Answer is provided.
Bookkeeping-categorising ledger accounts activity
rodbexrodbex

Bookkeeping-categorising ledger accounts activity

(0)
Relevant to AAT Level 2 Bookkeeping Transactions unit. Task 1 asks students to match the definitions with the correct accounting category (Income, Expense, Asset, Liability, Capital), while task 2 presents 19 ledger accounts to be similarly categorised. Task appropriate for early stages of bookkeeping course.
Invoice input exercise for Sage
rodbexrodbex

Invoice input exercise for Sage

(0)
Relevant to students of AAT Level 2 Using Accounting Software. This activity requires users to set up a new company, amend General Ledger account names, and input by Journal the owners Capital Introduction. The main tasks then are to create 4 Supplier records and input 6 purchase invoices, followed by 5 Customer records, and 6 sales invoices. Users can then self check a Trial Balance. Useful as a reinforcement or extension activity.
Opening balances activity for Sage
rodbexrodbex

Opening balances activity for Sage

(0)
Relevant for students of AAT Level 2 Using accounting software. This activity requires the user to set up a new company, enter and code 5 customer records, and 4 supplier records, each with opening balances. Further activity requires account names to be amended, and general ledger opening balances to be entered. The last task requires the Trial balance to be self checked by the user. Useful as reinforcement or as an extension activity.
Bank reconciliation activity for Sage
rodbexrodbex

Bank reconciliation activity for Sage

(0)
Relevant for AAT Level 2 **Using accounting software **unit. Good as demonstration, short reinforcement, or extension activity (textbooks often only offer this activity as part of a larger and long project). The exercise requires students to set up a company, enter bank payments and receipts, calculate the initial difference between bank statement and Sage, reconcile transactions and produce a report. It is appropriate for use after initial guidance on these steps. Can be self checked by students as the calculation should agree with the report.
Accounts preparation-Trial balance & ETB cut out activity
rodbexrodbex

Accounts preparation-Trial balance & ETB cut out activity

(0)
Relevant for AAT Level 3 students of Accounts Preparation unit. This is a traditional cut-out-and arrange game. Account names and balances on one sheet are to be cut out and jumbled up. Instructions sheet provided. Task 1 is to arrange the cut-outs into an initial trial balance (2 columns). Task 2 is to arrange the cut-outs into an extended trial balance (4 columns). Answers provided.
Initial self-assessment of skills in using Sage
rodbexrodbex

Initial self-assessment of skills in using Sage

(0)
Relevant for students of AAT Level 2 Using accounting software. Simple self assessment for users of their previous experience in using Sage software. Contains sixteen questions. To be used and analysed at start of the unit.