财务对账自动生成系表

对账单,对账单位:xxx公司对账日期:43795.0,客户编号:kh001客户名称客户001,序号订单编号开票日期主要产品销售价格对账金额备注,应付金额已付金额欠款金额,1.0dd00143795.0产品13000.03000.02500.0500.0,2.0dd00643800.0产品65945.05945.03212.02733.0,3.0dd01143805.0产品1135689.035689.015000.020689.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,合计:(欠款人民币大写),贰万叁仟玖佰贰拾贰元整44634.020712.023922.0,制表单位:制表人:对账单位(盖章),备注:如确认有差异,请尽快联系我司,如无异议,请盖章后回传.,销售明细表,销售日期辅助列3客户编号客户名称订单编号开票日期主要产品销售价格销售员回款状态辅助列辅助列2备注,43795.0kh001回款进行1客户001dd00143795.0产品13000.0小张1,43796.0kh002回款进行1客户002dd00243796.0产品250000.0小张2,43797.0kh003回款进行1客户003dd00343797.0产品360000.0小张3,43798.0kh004回款完毕1客户004dd00443798.0产品44230.0小张4kh004回款完毕,43799.0kh005回款进行1客户005dd00543799.0产品55678.0小张5kh005回款进行,43800.0kh001回款进行2客户006dd00643800.0产品65945.0小张6,43801.0kh002回款进行2客户007dd00743801.0产品712454.0小张7,43802.0kh003回款进行2客户008dd00843802.0产品8122145.0小张8,43803.0kh004回款进行1客户009dd00943803.0产品9122323.0小张9kh004回款进行,43804.0kh005回款进行2客户010dd01043804.0产品1015484.0小张10kh005回款进行,43805.0kh001回款进行3客户011dd01143805.0产品1135689.0小张11,43806.0kh002回款进行3客户012dd01243806.0产品1254612.0小张12,43807.0kh003回款进行3客户013dd01343807.0产品1312345.0小张13,43808.0kh004回款完毕2客户014dd01443808.0产品1412245.0小张14kh004回款完毕,43809.0kh005回款完毕1客户015dd01543809.0产品1512223.0小张15kh005回款完毕,回款表,回款日期客户编号客户名称订单编号订单总金额回款金额经办人备注,43795.0客户001dd0013000.02500.0小李1,43796.0客户002dd00250000.030000.0小李2,43797.0客户003dd00360000.050000.0小李3,43798.0客户004dd0044230.04230.0小李4,43799.0客户005dd0055678.0500.0小李5,43800.0客户006dd0065945.03212.0小李6,43801.0客户007dd00712454.01221.0小李7,43802.0客户008dd008122145.01122.0小李8,43803.0客户009dd009122323.012000.0小李9,43804.0客户010dd01015484.015000.0小李10,43805.0客户011dd01135689.015000.0小李11,43806.0客户012dd01254612.05000.0小李12,43807.0客户013dd01312345.05000.0小李13,43808.0客户014dd01412245.010000.0小李14,43809.0客户015dd01512223.010000.0小李15,43808.0客户014dd01412245.011245.0小李14,43809.0客户015dd01512223.011223.0小李15,客户信息表,客户编号客户名称联系人联系电话传真联系地址备注,kh001客户001小张市区001号,kh002客户002小李市区002号,kh003客户003小花市区003号,kh004客户004小白市区004号,kh005客户005小图市区005号