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 2021-22 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           12

12

24

48
Timetable (if known)           60 mins X 1 totaling 12
60 mins X 1 totaling 12
 
 
Private Study 102
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: Group Presentation Assessment Type: Practical Assessment Coursework Duration/Size: 10 minute presentation plus additional materials Weighting: 40% Reassessment Opportunity: Ye  10 minute presentati    40       
Assessment 2: Group Report Assessment Type: Coursework Size: 1000 word report plus additional materials Weighting: 60% Reassessment Opportunity: Yes Penalty for Late Submission: Standard U  1000 word report plu    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 50 Accounts).

(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) Make a 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 Delivery: Mixed, hybrid delivery with social distancing on campus

Teaching Method: Online Asynchronous Learning Materials
Unscheduled Directed Student Hours: 24
Attendance Recorded: No

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

Teaching Method: Group Study
Description: Weekly 1 hour session to foster student community and engagement by working with others on their ‘active learning’ activities
Scheduled Student Hours: 12
Attendance Recorded: No

Self-Directed Learning Hours: 102
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 inclu de 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 assignments
Mode of assessment (if applicable): Group Presentation and Group Report

Skills / attributes: Communication skills
How this is developed: This skill will be developed further in the second case study assignment
Mode of assessment (if applicable): Group Presentation

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)

Skills / attributes: Teamwork
How this is developed: These particular skills will all be developed further by working on both of the case study assig nments
Mode of assessment (if applicable): Group Presentation and Group Report

Skills / attributes: Commercial awareness
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): Group Presentation and Group Report

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): Group Presentation and Group Report

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): Group Report


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.