Import Account Receivables

  1. Home
  2. Import
  3. Account Receivables

Import Account Receivables from Excel

Instructions

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

Expected Format:

  • Header columns: 序号, 应收单号, 应收日期, 客户, 发票号, 合同号, 订单号, 到期日期, 币种, 汇率, 总金额, 已付金额, 未付金额, 状态, 付款条件, 创建人, 付款日期, 结算日期, 备注
  • Item columns: 存货编码, 存货名称, 规格型号, 单位, 数量, 单价, 金额, 税率, 税额, 价税合计, 描述

Maximum file size: 10MB

Note: The system will automatically create customers if they don't exist. Rows with the same receivable number will be grouped together.

Back