Why does the total sum for earnings of all reservations are not matching for channels and room view?

The answer is because Rooms are summing only the price/earn of the room's section in the reservation while channels view includes Extras, City Tax (entire reservation) so the rooms will always be a lower number.