import org.apache.poi.xssf.usermodel.XSSFWorkbook;</BUG>
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.io.*;
import java.math.BigDecimal;
<BUG>import java.time.LocalDate;
import java.time.OffsetDateTime;
import java.util.List;
import java.util.Map;

import java.util.Optional;
import java.util.Set;</BUG>
import java.util.function.Function;

import com.gearservice.model.request.AnalyticsPreferences;
import com.gearservice.model.cheque.Payment;
import com.gearservice.model.repositories.ExchangeRateRepository;
import com.gearservice.model.repositories.PaymentRepository;
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.*;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.io.*;
import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.ZoneId;
import java.util.*;
import java.util.function.Function;
