如何做好跟踪合同的工作

婧乐

<table cellspacing="0" cellpadding="0" width="1362" border="0" style="WIDTH: 1023pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="42" style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1344;"></col><col span="6" width="72" style="WIDTH: 54pt;"></col><col width="62" style="WIDTH: 47pt; mso-width-source: userset; mso-width-alt: 1984;"></col><col width="28" style="WIDTH: 21pt; mso-width-source: userset; mso-width-alt: 896;"></col><col span="2" width="72" style="WIDTH: 54pt;"></col><col width="51" style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1632;"></col><col width="44" style="WIDTH: 33pt; mso-width-source: userset; mso-width-alt: 1408;"></col><col width="37" style="WIDTH: 28pt; mso-width-source: userset; mso-width-alt: 1184;"></col><col width="34" style="WIDTH: 26pt; mso-width-source: userset; mso-width-alt: 1088;"></col><col width="72" style="WIDTH: 54pt;"></col><col width="43" style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1376;"></col><col width="72" style="WIDTH: 54pt;"></col><col width="48" style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1536;"></col><col span="3" width="72" style="WIDTH: 54pt;"></col><col width="37" style="WIDTH: 28pt; mso-width-source: userset; mso-width-alt: 1184;"></col></colgroup><tbody><tr height="32" style="HEIGHT: 24pt;"><td class="xl24" width="42" height="32" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; WIDTH: 32pt; BORDER-BOTTOM: windowtext 0.5pt solid; HEIGHT: 24pt; BACKGROUND-COLOR: transparent;"><p><font>序号</font></p></td><td class="xl26" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">卖方名称</font></td><td class="xl25" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">供应商编号</font></td><td class="xl25" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">所处位置</font></td><td class="xl25" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">合同编号</font></td><td class="xl28" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">签定日期</font></td><td class="xl26" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">商品名称</font></td><td class="xl26" width="62" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 47pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">所属类别</font></td><td class="xl26" width="28" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 21pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">材质</font></td><td class="xl26" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">规格/型号</font></td><td class="xl29" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">单价（元）</font></td><td class="xl24" width="51" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 38pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">单位</font></td><td class="xl30" width="44" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 33pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">数量</font></td><td class="xl27" width="37" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 28pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">金额</font></td><td class="xl30" width="34" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 26pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">运费</font></td><td class="xl27" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">其他费用</font></td><td class="xl27" width="43" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 32pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">总额</font></td><td class="xl27" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">付款金额</font></td><td class="xl31" width="48" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 36pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">余款</font></td><td class="xl26" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">付款说明</font></td><td class="xl26" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">卖方合同签订人</font></td><td class="xl26" width="72" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 54pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">我方合同签定人</font></td><td class="xl26" width="37" style="BORDER-RIGHT: windowtext 0.5pt solid; BORDER-TOP: windowtext 0.5pt solid; BORDER-LEFT: windowtext; WIDTH: 28pt; BORDER-BOTTOM: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent;"><font face="宋体" size="2">备注</font></td></tr></tbody></table><p></p><p></p><p>我做的工作是跟踪合同，即签订合同后，按照合同约定付款的工作，从签订合同起，首付，期中付和尾款以及质保金都从我这走，每一单合同都是几百万元，不可以弄错的。我做了上面的表来控制合同的摆放位置，以方便找到，每一次付款的记录，但我觉得还是不好用。请财务工作的前辈们帮忙出出主意，怎样让这表更合理管理合同更好更方便一些，谢谢啦。</p>

圈圈2005

<p>可以纵列按合同约定时间付款条件金额打好，然后等付款了再在后面逐一登记累加，约定时间有每笔款发生的间隔时间，或发票收到后付多少比例，质保金一般是等资产到货后两年付（这个时间可以先算出来打在表格上），每笔付款后还要自动算出余额， 表头还要注上每笔单据对应的凭证号，包括到货单，发票等等，总之要细，随时能从表上看到合同约定及执行情况，需要单据对应表格很快能查找到。还要做汇总表将所有合同的约定金额，付款金额作一汇总</p>

婧乐

是的，我就是想达到以上的效果，但实在是想不出头绪来。楼上的老师能否指点迷津给做个表看看，谢谢您了。