Hi I have an activity that I just don't understand, they want me to prepare a bank account with an incomplete records. Any help will be appreciated. Thank you :-)

Here is the problem;

Arthur is sole owner of an electrical spares shop;He needs to prepare a bank account for 31/03/12

Assets and Liabilities for the year 31 March 2011/2012;

2011

Bank Bal 1500
Debtors 9100
Rent paid advance 100
Stock 4400
Expenses unpaid wages 350
Heating 135
Creditors 5215
Vehicle 9000
Prov for dep 900
Capital 17500

2012

Bank Bal 2000
Debtors 9900
Rent paid advance 200
Stock 5300
Expenses unpaid wages 440
Heating 145
Creditors 6205
Vehicle 9000


1. Vehicle is to be depreciated at 10% per annum; new fittings purchased during the year also to be depreciated.

2. Arthur took $100 worth of goods from stock for personal use.

3 Payments made during the year included;

Purchases of electrical goods 34000
Rent 3000
Light 805
Motor Expenses 1150
New fittings 750
Wages 2000
Bank Charges 105

All the receipts have been banked with the exception of $11000 which he has retained for his own use.

Now they want me to prepare a bank account, trading and profit/loss as well as balance sheet at 31 March 2012, showing clearly the calculations of sales and purchases??

I can do the trading and profit/loss acct as well as the balance sheet no problem but regarding bank acct? I just don't understand what they meant.

Any help is much appreciated! Thank you!

Regards,
Sarah x