# 财务数据处理系统配置文件

[Excel]
# Excel文件配置
input_file = data/data.xlsx
sheet_name = Sheet1
data_start_row = 2

# 列索引配置 (1-based)
col_received_amount = 6   # F列: 实收金额
col_handling_fee = 7      # G列: 手续费
col_order_num = 8         # H列: 订单号
col_amount = 9            # I列: 金额
col_account_name = 15     # O列: 账户名

[Output]
# 输出文件配置
json_output = res.json
excel_output = AccountingEntries.xlsx
validation_report = validation_report.txt

[Processing]
# 数据处理配置
amount_tolerance = 0.01   # 金额匹配容差
skip_empty_orders = true  # 跳过空订单

[Accounting]
# 会计分录配置
default_exchange_rate = 7.1072
exchange_rate_file = exchange_rate.txt

# 科目代码配置
account_code_bank = 1002.02
account_code_fee = 5603.03
account_code_receivable = 1122

# 科目名称配置
account_name_bank = 银行存款 - 中行USD
account_name_fee = 财务费用-手续费
account_name_receivable = 应收账款

[Logging]
# 日志配置
log_level = INFO
log_format = %(asctime)s - %(levelname)s - %(message)s
log_file = processing.log