Using the fact scenario below, please respond in Excel to the following two exercises: Prepare the journal entries to reflect the transactions on the City of San Franciscos books.

Prepare the journal entries to reflect the transactions on each recipient countys books.

Facts:

The City of San Francisco assesses a 15-cent telecommunications tax per call on calls initiated and terminated within the jurisdiction.

During 2017, there were approximately 978,000,000 calls upon which the tax should be imposed.

In addition, the city also collects sales taxes for the 3 counties that are part of incorporated San Francisco.

Those taxes collected are $12,000,000 for County A, $7,500,000 for County B, and $4,130,000 for County C.

Assume the amount of both taxes assessed were collected in their entirety.

Fees for the collection services are 2% of tax collected.

Residual cash after the fees assessed was disbursed to the counties.