营业报表模板.xls

资金流水账日期摘要项目收入支出余额20120401 付货款华美1,800.00-1,800.0020120402 付货款至诚1,500.00-3,300.0020120406 收货款0401-04054,500.001,200.0020120408 付电话费费用200.001,000.0020120411 收货款0406-04103,200.004,200.0020120415 付工资费用1,200.003,000.0020120417 收货款0411-04161,500.004,500.004,500.004,500.004,500.004,500.004,500.004,500.004,500.004,500.004,500.004,500.004,500.004,500.00累计9,200.004,700.004,500.00收入累计13,470.00资金余额4,500.00成本累计12,375.00应收款300.00毛利累计1,095.00应付款490.00费用累计1,400.00毛利率8.13%净利润-305.00净利率-2.26%进销利台账订单日期发货日期 物流号品名型号商家买家数量进货情况应付货款2012040120120405 00156鞋柜翻转型黑色华美苏洲2230.002012040120120405 00165床圆型6513华美上海15,400.002012040120120405 00165床圆型6513至诚苏洲15,400.002012040820120410 00213鞋柜对拉门6122至诚绵阳1330.002012040820120405 00155鞋柜翻转型黑色至诚上海1230.002012040920120410 00156鞋柜翻转型白色至诚绵阳1240.00合计11,830.00累计应付款销售情况单笔毛利累计毛利应付运杂费已付货款应收款已收款10.00240.00280.00280.0040.0040.00200.005,600.006,100.006,100.00500.00540.00300.005,700.006,100.006,100.00400.00940.0015.00345.00400.00400.0055.00995.0010.00290.00290.0050.001,045.0010.00300.0050.001,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00-1,095.00545.0011,885.0013,470.0013,170.001,095.001,095.00490.00应收款300.00进货情况