Cash balance per bank, July 31, $8,238. 2. July bank service charge not recorded by the depositor $58. 3. Cash balance per books, July 31, $8,274. 4. Deposits in transit, July 31, $3,610. 5. $2,926 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, $706
a. Prepare a bank reconciliation on July 31, 2017.
b. Journalize the adjusting entries for Sunland Company.

Excel allows you to take a lot of data and organize it in one document. what are some of the features you can use to clarify, emphasize, and differentiate your data?

Depreciation on the company's equipment for 2017 is computed to be $18,000.the prepaid insurance account had a $6,000 debit balance at december 31, 2017, before adjusting for the costs of any expired coverage. an analysis of the company's insurance policies showed that $1,100 of unexpired insurance coverage remains. the office supplies account had a $700 debit balance on december 31, 2016; and $3,480 of office supplies were purchased during the year. the december 31, 2017, physical count showed $300 of supplies available. two-thirds of the work related to $15,000 of cash received in advance was performed this period. the prepaid insurance account had a $6,800 debit balance at december 31, 2017, before adjusting for the costs of any expired coverage. an analysis of insurance policies showed that $5,800 of coverage had expired. wage expenses of $3,200 have been incurred but are not paid as of december 31, 2017.

Explain how can you avoid conflict by adjusting