Prepare the bank reconciliation statement as at June 30, 2017.

Use the bank reconciliation statement to record the relevant reconciling items in the general journal.

Bank reconciliation statement ~ May

Bank Reconciliation Statement May 31, 2017

Balance per bank:				$100,841
Add:
deposit in transit from Jerry Technology		$3,235
deposit in transit from Handys Electronics		1,100		4,335
				105,176
Deduct:
outstanding check	No. 309	$6,500
outstanding check	No. 310	610		7,110
Adjusted balance per bank				$98,066
Balance per book:				$97,657
Add:
interest earned				420
				98,077
Deduct:
bank service charge				11
Adjusted balance per book				$98,066

Bank statement ~ June

Date

Particulars

Debit

Credit

Balance

JUN 1

BALANCE BROUGHT FORWARD

$100,841 CR

JUN 1

DEPOSIT - Jerry Technology

$3,235

$104,076 CR

JUN 1

310

$610

$103,466 CR

JUN 4

LOAN

$48,000

$151,466 CR

JUN 4

DEPOSIT - Handys Electronics

$1,100

$152,566 CR

JUN 6

312

$13,226

$139,340 CR

JUN 6

311

$9,400

$129,940 CR

JUN 6

309

$6,500

$123,440 CR

JUN 8

314

$339

$123,101 CR

JUN 9

313

$2,386

$120,715 CR

JUN 9

DEPOSIT - Radio Hut

$2,442

$123,157 CR

JUN 9

315

$731

$122,426 CR

JUN 12

DEPOSIT - Handys Electronics

$3,141

$125,567 CR

JUN 12

318

$12,905

$112,662 CR

JUN 13

DEPOSIT - Cash sales

$2,808

$115,470 CR

JUN 15

319

$4,975

$110,495 CR

JUN 17

317

$3,611

$106,884 CR

JUN 18

316

$3,250

$103,634 CR

JUN 20

DEPOSIT - Hypertronics

$3,600

$107,234 CR

JUN 20

320

$12,707

$94,527 CR

JUN 21

NSF CHECK - Hypertronics

$3,600

$90,927 CR

JUN 23

DEPOSIT - Cash sales

$34,848

$125,775 CR

JUN 26

321

$13,214

$112,561 CR

JUN 30

DEPOSIT - Jerry Technology

$3,237

$115,798 CR

JUN 30

DEPOSIT - Cash sales

$10,272

$126,070 CR

JUN 30

DEPOSIT - Cash sales

$14,040

$140,110 CR

JUN 30

INTEREST

$814

$140,924 CR

JUN 30

SERVICE CHARGE

$11

$140,913 CR

Last statement to 05/31/17

This statement to 06/30/17

Total debits

$87,465

Total credits

$127,537

Final balance

$140,913 CR

CASH RECEIPTS JOURNAL

Date		Account	Post Ref.	Debit		Credit			Cost of Goods Sold
				Cash	Sales Discounts	Sales Revenue	Accounts Receivable	Other Accounts
Jun	1	Bank Loan Payable	250	48,000				48,000
Jun	3	ARC - Radio Hut	110-5	2,442			2,442
Jun	9	ARC - Handys Electronics	110-1	3,141	349		3,490
Jun	12	Sales Revenue	X	2,808		2,808			1,248
Jun	17	ARC - Hypertronics	110-6	3,600			3,600
Jun	19	Sales Revenue	X	34,848		34,848			25,520
Jun	26	Sales Revenue	X	10,272		10,272			5,856
Jun	27	ARC - Turbo Tech	110-3	26,930			26,930
Jun	29	ARC - Jerry Technology	110-4	3,237			3,237
Jun	29	Sales Revenue	X	14,040		14,040			7,200
Total				149,318	349	61,968	39,699	48,000	39,824
Post reference				(100)	(402)	(400)	(110)	(X)	(500)/(120)

CASH PAYMENTS JOURNAL

Date		Account	Check No.	Post Ref.	Debit				Credit
					Accounts Payable	Merchandise Inventory	Wages Expense	Other Accounts	Cash
Jun	1	Prepaid Rent	311	140				9,400	9,400
Jun	4	Wages Payable	312	220			6,530	6,696	13,226
Jun	5	APC - Pony	313	210-6	2,386				2,386
Jun	5	Office Supplies	314	130				339	339
Jun	6	Electricity Payable	315	221				731	731
Jun	11	APC - Moon Megasystems	316	210-2	3,250				3,250
Jun	11	APC - JCN Electrical	317	210-5	3,611				3,611
Jun	11	Wages Expense	318	X			12,905		12,905
Jun	13	APC - Big Telco	319	210-1	4,975				4,975
Jun	18	Wages Expense	320	X			12,707		12,707
Jun	25	Wages Expense	321	X			13,214		13,214
Jun	28	APC - Big Telco	322	210-1	20,760				20,760
Jun	30	Merchandise Inventory	323	X		12,768			12,768
Jun	30	Salary Expense	324	545				4,700	4,700
Total					34,982	12,768	45,356	21,866	114,972
Post reference					(210)	(120)	(516)	(X)	(100)

The Digital Village Bank Reconciliation Statement June 30, 2017

		$		$
Balance per bank:
Add:
bank service chargedeposit in transitNSF checkinterest earnedinterest payable on the bank loanoutstanding check
bank service chargedeposit in transitNSF checkinterest earnedinterest payable on the bank loanoutstanding check
bank service chargedeposit in transitNSF checkinterest earnedinterest payable on the bank loanoutstanding check
Deduct:
bank service chargedeposit in transitNSF checkinterest earnedinterest payable on the bank loanoutstanding check	No.
bank service chargedeposit in transitNSF checkinterest earnedinterest payable on the bank loanoutstanding check	No.
bank service chargedeposit in transitNSF checkinterest earnedinterest payable on the bank loanoutstanding check	No.
Adjusted balance per bank
Balance per book
Add:
bank service chargedeposit in transitNSF checkinterest earnedinterest payable on the bank loanoutstanding check
bank service chargedeposit in transitNSF checkinterest earnedinterest payable on the bank loanoutstanding check
bank service chargedeposit in transitNSF checkinterest earnedinterest payable on the bank loanoutstanding check
Deduct:
bank service chargedeposit in transitNSF checkinterest earnedinterest payable on the bank loanoutstanding check
bank service chargedeposit in transitNSF checkinterest earnedinterest payable on the bank loanoutstanding check
bank service chargedeposit in transitNSF checkinterest earnedinterest payable on the bank loanoutstanding check
Adjusted balance per book