Preparation of Accounting Records using Spreadsheets

ACCOUNTING FOR MANAGERS ASSIGNMENT

1
By student name
Professor
University
Date: 25 April 2018.
1 | P a g e

2
Contents
Question 1: Preparation of accounting records – using spreadsheets.........................................................3
Question 2: History of accounting - essay..................................................................................................10
Question 3: ABC Learning Case Study........................................................................................................12
References.................................................................................................................................................15
2 | P a g e

3
Question 1: Preparation of accounting records – using spreadsheets
The financial statements of the entity Flash Cleaning Services have been prepared and shown below
(Alexander, 2016).
Flash Cleaning Services
Appendix 1: Journal Entries
Date Particulars Dr./Cr. Amt.($) Amt.($)
1-Jul-2018 Bank Dr. 30,000
To Capital Cr. 30,000
(Being capital contribution made)
1-Jul-2018 Bank Dr. 20,000
To Loan Cr. 20,000
(Being Loan of $ 20,000 from bank)
1-Jul-2018 Motor Vehicle Dr. 18,000
To Bank Cr. 18,000
(Being motor vehicle purchased)
1-Jul-2018 Prepaid Insurance Dr. 3,600
To Bank Cr. 3,600
(Being insurance paid in advance for whole year)
1-Jul-2018 Cleaning Equipment Dr. 4,800
To Bank Cr. 4,800
(Being Cleaning Equipment purchased)
9-Jul-2018 Purchases Dr. 2,400
To Creditors Cr. 2,400
(Being supplies purchased on credit)
13-Jul-2018 Bank Dr. 500
To Service Revenue Cr. 500
(Being cleaning services provided)
20-Jul-2018 Wages Dr. 1,600
To Bank Cr. 1,600
(Being wages paid)
25-Jul-2018 Bank Dr. 5,500
To Service Revenue Cr. 5,500
(Being cleaning services provided)
27-Jul-2018 Creditors Dr. 2,400
To Discount received 400
3 | P a g e