ULMS Electronic Module Catalogue

The information contained in this module specification was correct at the time of publication but may be subject to change, either during the session because of unforeseen circumstances, or following review of the module at the end of the session. Queries about the module should be directed to the member of staff with responsibility for the module.
Title INFORMATION SYSTEMS FOR ACCOUNTANTS
Code ACFI116
Coordinator Mr LW Gordon
Finance and Accounting
L.W.Gordon@liverpool.ac.uk
Year CATS Level Semester CATS Value
Session 2022-23 Level 4 FHEQ Second Semester 15

Pre-requisites before taking this module (other modules and/or general educational/academic requirements):

 

Modules for which this module is a pre-requisite:

 

Programme(s) (including Year of Study) to which this module is available on a required basis:

 

Programme(s) (including Year of Study) to which this module is available on an optional basis:

 

Teaching Schedule

  Lectures Seminars Tutorials Lab Practicals Fieldwork Placement Other TOTAL
Study Hours 1

    12

  11

24
Timetable (if known) 60 mins X 1 totaling 1
 
    60 mins X 1 totaling 12
 
  60 mins X 1 totaling 11
 
 
Private Study 126
TOTAL HOURS 150

Assessment

EXAM Duration Timing
(Semester)
% of
final
mark
Resit/resubmission
opportunity
Penalty for late
submission
Notes
             
CONTINUOUS Duration Timing
(Semester)
% of
final
mark
Resit/resubmission
opportunity
Penalty for late
submission
Notes
Assessment 1: Financial Modelling Assessment Type: Practical Assessment Coursework Duration/Size: Preparation of a financial model and 10 minute PowerPoint presentation Weighting: 40% Reassessm    40       
Assessment 2: Sage Report Assessment Type: Coursework Size: Processing transactions and adjustments through Sage reports and a 1000 word written report Weighting: 60% Reassessment Opportunity:     60       

Aims

The module also aims:
to build on the book-keeping techniques used in ACFI101 and apply them using computerised financial accounting software.
to develop an approach for financial modelling using Microsoft Excel and apply this approach by constructing models that can be used for financial analysis and decision-making.


Learning Outcomes

(LO1) Demonstrate understanding of how to account for all the typical transactions of a small business including transactions involving PAYE, NI and VAT.

(LO2) Process all types of standard business transactions and adjustments through commonly-used financial accounting software (Sage).

(LO3) Produce reliable information from Sage using standard reports and design suitable non-standard reports.

(LO4) Design, build and test spreadsheet models, suitable for use by third parties, that aid planning and decision-making.

(LO5) Formal presentation of a financial model to a specified audience.

(S1) Problem solving skills

(S2) Numeracy

(S3) Commercial awareness

(S4) Teamwork

(S5) Organisational skills

(S6) Communication skills

(S7) IT skills


Teaching and Learning Strategies

Teaching Method: Lecture
Scheduled Directed Student Hours: 1
Attendance Recorded: Yes

Teaching Method: Lab
Scheduled Directed Student Hours: 12
Attendance Recorded: Yes

Teaching Method: Workshop
Scheduled Student Hours: 11
Attendance Recorded: No

Self-Directed Learning Hours: 126
Description: These independent learning hours are aimed at supporting the directed student learning. The module leader will provide guidance in the form of suggested readings and topics to examine with the expectation that students are well prepared to contribute to the tutorial activities and to understand the content of lectures. Self-Directed Learning will include research activity, developing academic writing skills, and wider reading to support the module

Skills/Other Attributes Mapping

Skills / attributes: IT skills
How this is developed: These particular skills will all be developed further by working on both of the case study as signments
Mode of assessment (if applicable): Practical assessment

Skills / attributes: Communication skills
How this is developed: This skill will be developed further in the financial modelling case study assignment
Mode of assessment (if applicable): Practical Assessment and coursework

Skills / attributes: Organisational skills
How this is developed: These particular skills will all be developed further via students' private study and by working on both of the case study assignments
Mode of assessment (if applicable): Practical assessment and coursework

Skills / attributes: Teamwork
How this is developed: These particular skills will all be developed further by working on both of the case study assignments
Mode of assessment (if applicable): Practical assessment and coursework

Skills / attributes: Commercial awareness
How this is developed: These particular skills will all be developed further by working on both of the cas e study assignments
Mode of assessment (if applicable):

Skills / attributes: Numeracy
How this is developed: These particular skills will all be developed further by working on both of the case study assignments
Mode of assessment (if applicable): coursework

Skills / attributes: Problem solving skills
How this is developed: These particular skills will all be developed further by working on both of the case study assignments
Mode of assessment (if applicable): Practical assessment and coursework


Syllabus

 

The functions and purposes of accounting software: Financial Accounting Systems and Management Information Systems (MIS)

Financial accounting software:

VAT: background, rates, basic regulations and accounting;
Accounting for payroll: PAYE income tax, employers' and employees' National Insurance (NI);
The imprest system;
The Chart of Accounts;
Coding: key considerations;
Setting up a new company in Sage: setting-up product, supplier, customer and bank details;
Processing transactions using Sage: sales and purchase orders, invoices and credit notes, bank payments and receipts, petty cash, wages, period-end adjustments;
The Fixed Asset Register;
Audit/control considerations: internal controls, reconciliations, data validation, suspense accounts and mispostings;
The correction of errors in Sage;
Incorporation of budget figures;
Producing standard reports: Nominal Activity, Audit Trail, Trial Balance, Income Statement , Balance Sheet;
Designing new reports that are clear, relevant and useful.

Financial Modelling:

What is a financial model?;
Introduction to flexible modelling;
Spreadsheet modelling best practice;
Defining the scope of your model;
Building a spreadsheet model: key considerations.
Navigation and shortcuts using Excel;
Enhancing spreadsheet models using the inbuilt features of Excel: Intermediate and more advanced features;
Modelling mountain approach;
Expanded models with debt, depreciation and dividends;
Dealing with negative bank balances using IF functions;
AVERAGE, MAX and MIN commands;
Circularities and iterations;
Testing the reliability of a model;
Good presentation when saving your model.


Recommended Texts

Reading lists are managed at readinglists.liverpool.ac.uk. Click here to access the reading lists for this module.