Import Account Payables

Instructions

Upload an Excel file (.xlsx or .xls) containing Account Payables data.

Expected Format:

• Columns: 序号, 年, 月, 日, 凭证号, 供应商编码, 供应商名称, 科目编码, 科目名称, 摘要, 借方金额, 贷方金额, 方向, 余额金额

Column Details:

• 序号 (Serial Number): Row number
• 年/月/日 (Year/Month/Day): Transaction date components
• 凭证号 (Voucher No.): Required - Unique voucher identifier
• 供应商编码/名称 (Supplier Code/Name): Required - Supplier information
• 科目编码/名称 (Account Code/Name): Required - Account information
• 摘要 (Summary): Transaction description
• 借方金额/贷方金额 (Debit/Credit Amount): Transaction amounts
• 方向 (Direction): 借 (Debit), 平 (Balanced), or 贷 (Credit)
• 余额金额 (Balance Amount): Running balance

Maximum file size: 10MB

Note: The system will automatically create suppliers if they don't exist. Aggregation rows (小计, 合计) will be automatically skipped.