The following information pertains to Sunland Company.

1.		Cash balance per bank, July 31, $7,688.
2.		July bank service charge not recorded by the depositor $47.
3.		Cash balance per books, July 31, $7,724.
4.		Deposits in transit, July 31, $3,060.
5.		$2,376 collected for Sunland Company in July by the bank through electronic funds transfer. The collection has not been recorded by Sunland Company.
6.		Outstanding checks, July 31, $695.

Prepare a bank reconciliation at July 31, 2017. (List items that increase balance as per bank & books first.)

SUNLAND COMPANY Bank Reconciliation For the Year Ended July 31, 2017July 31, 2017For the Month Ended July 31, 2017
Electronic funds transfer receivedDeposits in transitBank service chargeCash balance per bank statementOutstanding checksAdjusted cash balance per bank			$
AddLess :	Adjusted cash balance per bankElectronic funds transfer receivedBank service chargeDeposits in transitCash balance per bank statementOutstanding checks
AddLess :	Electronic funds transfer receivedCash balance per bank statementOutstanding checksDeposits in transitBank service chargeAdjusted cash balance per bank
Cash balance per bank statementBank service chargeAdjusted cash balance per bankDeposits in transitElectronic funds transfer receivedOutstanding checks			$
Outstanding checksCash balance per booksDeposits in transitAdjusted cash balance per booksElectronic funds transfer receivedBank service charge			$
LessAdd :	Deposits in transitOutstanding checksElectronic funds transfer receivedCash balance per booksBank service chargeAdjusted cash balance per books
LessAdd :	Deposits in transitBank service chargeOutstanding checksElectronic funds transfer receivedCash balance per booksAdjusted cash balance per books
Adjusted cash balance per booksElectronic funds transfer receivedCash balance per booksOutstanding checksDeposits in transitBank service charge			$

SHOW LIST OF ACCOUNTS

Prepare a tabular analysis for the adjustments at July 31 on the books of Sunland Company. Include margin explanations for the changes in revenues and expenses. (If a transaction results in a decrease in Assets, Liabilities or Stockholders' Equity, place a negative sign (or parentheses) in front of the amount entered for the particular Asset, Liability or Equity item that was reduced.)

Assets

=

Liabilities

+

Stockholders Equity

Cash

Accts. Rec.

+

=

+

Rev.

-

Exp.

July 31

Cash over and shortMiscellaneous expenseSales revenueBank charges expense

31

Cash over and shortMiscellaneous expenseSales revenueBank charges expense