Module Catalogues, Xi'an Jiaotong-Liverpool University   
Module Code: ACC102
Module Title: Information System for Accountants
Module Level: Level 1
Module Credits: 5.00
Academic Year: 2020/21
Semester: SEM2
Originating Department: Department of Accounting
Pre-requisites: N/A
The aims of this module are twofold:

•To build on the book-keeping techniques used in ACF103 and apply them using computerised financial accounting software.

•To extend the planning and decision-making methods covered in ACF108 and apply them in constructing budgetary financial models using spreadsheets.
Learning outcomes 
Students completing the module successfully should:

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

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

C.Produce reliable information from Sage using standard reports and design suitable non-standard reports

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

E.Make a formal presentation of a financial model to a specified audience
Method of teaching and learning 
The module will be delivered by an initial introductory lecture followed by a series of two-hour workshops. Each workshop will incorporate demonstrations of the information technology and also include opportunities for students to practice the techniques through various examples. The classroom contact will be backed-up by directed reading, learning material and links on VITAL, and consultation hours.
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' NI

The imprest system

The Chart of Accounts

Coding: key considerations

Setting up a new company in Sage: setting-up product, supplier, customer, department details
Processing transactions using Sage: sales and purchase orders, invoices and credit notes, bank payments and receipts, bank reconciliation, petty cash, wages, period-end adjustments.

The Fixed Asset Register

Audit/control considerations: internal controls, reconciliations, data validation, suspense accounts and mispostings

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

Model specification: tree diagrams, bubble diagrams, rules tables

Designing a spreadsheet model: good spreadsheet practice

Building a spreadsheet model: key considerations

Enhancing spreadsheet models using inbuilt features of Excel: basic, intermediate and more advanced features

Logical functions: IF, AND, OR and NOT

Introduction to macroprogramming

Testing the reliability of a model

Reports, the Run Pack, and presenting your model

Documentation: technical and operation

Delivery Hours  
Lectures Seminars Tutorials Lab/Prcaticals Fieldwork / Placement Other(Private study) Total
Hours/Semester 2       26    122  150 


Sequence Method % of Final Mark
1 Coursework 40.00
2 Computer-Based Exam 60.00

Module Catalogue generated from SITS CUT-OFF: 12/2/2020 4:58:58 AM