Accounting Working Papers and Report Templates for November 2017

This assignment presents a comprehensive set of accounting working papers, encompassing various financial documents and analyses for the period ending November 30, 2017. It includes a chart of accounts, detailing asset, liability, equity, income, and expense accounts. The document features a general journal with depreciation entries, a sales journal, and a purchases journal to record transactions. Subsidiary ledgers, such as inventory, accounts receivable, and accounts payable, are provided to track specific account details. Furthermore, general ledger accounts for various expenses and income items are included. Reports such as schedules of subsidiary ledgers, a bank reconciliation statement, and a worksheet are also provided. The assignment culminates in a statement of profit or loss, calculating a net loss, and a statement of financial position, presenting the company's assets, liabilities, and equity at the end of the period.

ACCOUNTING WORKING PAPERS AND REPORT TEMPLATES
CHART OF ACCOUNTS
Ac. No. Account AL/IE C/NC
100 Cheque Account – Bendigo Bank Asset Current
105 Petty Cash Asset Current
110 Accounts Receivable Asset Current
120 Merchandise Inventory Asset Current
130 Prepaid Insurance Asset Current
140 Prepaid Rates & Taxes Asset Current
150 GST Paid (outlays) Asset Current
160 Buildings & Improvement (cost) Asset Non-current
161 Accumulated Depreciated - Bldgs & Imp Liability Non-current
170 Motor Vehicles (Cost) Asset Non-current
171 Accumulated Depreciation – Motor Vehicles Liability Non-current
180 Store Equipment (Cost) Asset Non-current
181 Accumulated Depreciation – Store Equip Liability Non-current
200 Accounts Payable Liability Current
210 GST Collected Liability Current
220 PAYG Withholding Payable Liability Current
230 Superannuation Payable Liability Current
240 Wages & Salaries Expense Current
280 Bank Loan Liability Non-current
310 Share Capital Equity Non-current
315 Dividends Paid Equity Non-current
320 Retained Earnings Equity Non-current
400 Sales Income Current
420 Discounts Received Income Current
430 Freight Collected Income Current
500 Cost of Sales Expense Current
520 Freight Expense Expense Current
600 Advertising Expense Current
610 BankCharges Expense Current
615 Cleaning Expense Current
620 Depreciation Expense Current
625 Electricity Expense Current
630 Insurance Expense Current
635 Interest Expense Expense Current
640 Motor Vehicle Expenses Expense Current
650 Postage & Stationery Expense Current
655 Rates Expense Current
660 Repairs & Maintenance Expense Current
670 Staff Amenities Expense Current
675 Superannuation Expense Current
1

680 Telephone Expense Current
685 Wages & Salaries Expense Current
2

GENERAL JOURNAL
Date Description Post Ref Debit Credit
Depreciation 9,086
Acc. Depreciation 9,086
3

SALES JOURNAL
Date Inv
No
Account Terms Sales GST
Collected
Accounts
Receivable
Cost of Sales Dr
Inventory Cr
Sales 69,020 1,750 70 9,337 50 31,160 Dr
12,200 Cr
4

PURCHASES JOURNAL
Date Inv.
No
Account Terms Inventory GST (Paid)
(Outlays)
Freight
Paid
Accounts
Payable
Purchases 12,200 921 20 324 11,454
5

CASH PAYMENTS JOURNAL
Date Account
Post
Ref
Chq
No
Debits Credits
Accounts
Payable
GST Paid
(Outlays) Other
Cash at
Bank
Discount
Received
GST Paid
(Outlays)
Wages &
Salaries
6,600
Freight
Expense
149
Advertising 480
Bank
Charges
42 40
Cleaning 850
Electricity 380 50
Insurance 1,864
Interest
Expense
816
Motor
Vehicle
Expenses
102
Postage &
Stationery
2,200
Rates 75
Repairs &
Maintenanc
e
68 60
6

Staff
Amenities
612
Superannua
tion
426 50
Telephone 380 50
Interest
Expenses
15,750
GST paid 921 20
Discount
received
392 30
7

CASH RECEIPTS JOURNAL
Date Accounts
Post
Ref
Debits Credits
Cash at
Bank
Cost of Sales
Sales
Accounts
Receivable
GST
Collected
Other
8

PETTY CASH JOURNAL
Date Details Post
Ref
Receipts Payments Balance GST Paid
(Outlays)
Postage &
Stationery
Staff
Amenities
Other
Bal b/d 100
9

10

INVENTORYSUBSIDIARY LEDGER
Name: Armour Cricket Pads Acct Code: ACP
Date Explanation Purchases Cost of Sales Balance
Units Cost Total Units Cost Total Units Cost Total
ACP 18 50 900
Name: Blaster Cricket Bat Acct Code: BCB
Date Explanation Purchases Cost of Sales Balance
Units Cost Total Units Cost Total Units Cost Total
BCB 23 60 1,380
Name: Blaze Soccer Ball Acct Code: BSB
Date Explanation Purchases Cost of Sales Balance
Units Cost Total Units Cost Total Units Cost Total
BSB 11 25 275
11

INVENTORYSUBSIDIARY LEDGER
Name: Diablo Golf Balls (Box of 12) Acct Code: DGB
Date Explanation Purchases Cost of Sales Balance
Units Cost Total Units Cost Total Units Cost Total
DGB 32 15 480
Name: Gifford Netball Acct Code: GNB
Date Explanation Purchases Cost of Sales Balance
Units Cost Total Units Cost Total Units Cost Total
GNB 12 20 240
Name: Herrin Football Acct Code: HFB
Date Explanation Purchases Cost of Sales Balance
Units Cost Total Units Cost Total Units Cost Total
HFB 17 75 1,275
12