The following information pertains to Wildhorse Company.


1. Cash balance per bank, July 31, $7,838.

2. July bank service charge not recorded by the depositor $50.

3. Cash balance per books, July 31, $7,874.

4. Deposits in transit, July 31, $3,210.

5. $2,526 collected for Wildhorse Company in July by the bank through electronic funds transfer. The collection has not been recorded by Wildhorse Company.

6. Outstanding checks, July 31, $698.


Required:

Prepare a tabular analysis for the adjustments at July 31 on the books of Wildhorse Company.