50 lines
1.1 KiB
INI
50 lines
1.1 KiB
INI
# 财务数据处理系统配置文件
|
|
|
|
[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
|
|
|
|
|
|
|