Excel表格模板：车行公司收支统计表(月自动统计-年自动统计).xls

《Excel表格模板：车行公司收支统计表(月自动统计-年自动统计).xls》由会员分享，可在线阅读，更多相关《Excel表格模板：车行公司收支统计表(月自动统计-年自动统计).xls（234页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、收入项目收付项目支出项目洗车已付清生活费保养未付材料费维修未付清电费其它水费房租费员工工资其它日期车型电话号码车牌号大类2018/1/1东风S350155-5555-6666贵D AN236维修2018/1/2江陵155-5555-6667贵D AN237其它2018/1/3东风小康155-5555-6668贵D AN238洗车2018/1/4比亚迪155-5555-6669贵D AN239洗车2018/1/5江陵155-5555-6670贵D AN240洗车2018/1/6东风小康155-5555-6671贵D AN241维修2018/1/7比亚迪155-5555-6672贵D AN242洗

2、车2018/1/8宝马X4155-5555-6673贵D AN243维修2018/1/9中华155-5555-6674贵D AN244保养2018/1/10文老师电动155-5555-6675贵D AN245维修2018/2/1金杯155-5555-6676贵D AN246洗车2018/2/2文老师电动155-5555-6677贵D AN247洗车2018/2/3皮卡155-5555-6678贵D AN248维修2018/2/4长城皮卡155-5555-6679贵D AN249维修2018/2/5冰棍155-5555-6680贵D AN250维修2018/2/6皮卡155-5555-6681贵

3、D AN251洗车2018/2/7长城皮卡155-5555-6682贵D AN252洗车2018/3/1金杯155-5555-6676贵D AN246洗车2018/3/2文老师电动155-5555-6677贵D AN247洗车2018/3/3皮卡155-5555-6678贵D AN248维修2018/3/4长城皮卡155-5555-6679贵D AN249维修2018/3/5冰棍155-5555-6680贵D AN250维修2018/3/6皮卡155-5555-6681贵D AN251洗车2018/3/7长城皮卡155-5555-6682贵D AN252洗车详细项目材料费工时费其它应收实收换喇

4、叭100500150150换漆155006565洗车补胎修锁烟53500103洗车补胎烟5650010656洗车补胎烟106500156156卖密封胶1550065洗车4050090维修烟洗车148500198198洗车烟保养206500256256洗车维修50500100100洗车维修烟86500136136补胎洗车55500105105维修烟333500383300换灯205007070维修洗车烟138500188188洗车烟111500161161洗车补胎烟131500181181洗车维修烟86500136补胎洗车55500105维修烟333500383换灯2050070维修洗车烟138

5、500188洗车烟111500161洗车补胎烟1315001810000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

6、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

7、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

8、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

9、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

10、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

11、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000欠款是否收款0已付清0已付清103未付50未付清0已付清65未付90未付0已付清0已付清0已付清0已付清0已付清83未付清0已付清0已付清0已付清0已付清136未付105未付383未付7

12、0未付188未付161未付181未付000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

13、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

14、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

15、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

16、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

17、000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000

18、0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000/日期支出项目详细摘要金额2018/1/1生活费生活费200.002018/1/2材料费笔记本52300.002018/1/3其它营执240400.002018/1/4水费结算的是1.1-2.1的水费，40吨*52

19、00.002018/1/5员工工资4,000.002018/2/1电费结算的是2.1-3.1的电费，1500*13,000.002018/2/2水费结算的是2.1-3.1的水费，50吨*5250.002018/2/3生活费生活费200.002018/2/4材料费笔记本52300.002018/2/5其它营执240400.002018/2/6水费结算的是1.1-2.1的水费，40吨*5200.002018/2/7员工工资4,000.002018/3/1生活费点的肯德基300.002018/3/2材料费买什么什么东西的350.002018/3/3电费结算的是2.1-3.1的电费，1500*13,0

20、00.002018/3/4水费结算的是2.1-3.1的水费，50吨*5250.002018/3/5员工工资4,000.001、水费电费这些最好写上详细度数，以便下个月查询2、支出明细都要写清楚，以后方便不对的时候查询按月天数明细统计日期应收支出欠款应收利润2018/1/11502000-502018/1/2653000-2352018/1/3103400103-2972018/1/410620050-942018/1/515640000-38442018/1/665065652018/1/790090902018/1/8198001982018/1/9256002562018/1/101000

21、01002018/1/1100002018/1/1200002018/1/1300002018/1/1400002018/1/1500002018/1/1600002018/1/1700002018/1/1800002018/1/1900002018/1/2000002018/1/2100002018/1/2200002018/1/2300002018/1/2400002018/1/2500002018/1/2600002018/1/2700002018/1/2800002018/1/2900002018/1/3000002018/1/3100002018/2/113630000-286420

22、18/2/21052500-1452018/2/3383200831832018/2/4703000-2302018/2/51884000-2122018/2/61612000-392018/2/718140000-38192018/2/800002018/2/900002018/2/1000002018/2/1100002018/2/1200002018/2/1300002018/2/1400002018/2/1500002018/2/1600002018/2/1700002018/2/1800002018/2/1900002018/2/2000002018/2/2100002018/2/2

23、200002018/2/2300002018/2/2400002018/2/2500002018/2/2600002018/2/2700002018/2/2800002018/3/1136300136-1642018/3/2105350105-2452018/3/33833000383-26172018/3/47025070-1802018/3/51884000188-38122018/3/616101611612018/3/718101811812018/3/800002018/3/900002018/3/1000002018/3/1100002018/3/1200002018/3/1300

24、002018/3/1400002018/3/1500002018/3/1600002018/3/1700002018/3/1800002018/3/1900002018/3/2000002018/3/2100002018/3/2200002018/3/2300002018/3/2400002018/3/2500002018/3/2600002018/3/2700002018/3/2800002018/3/2900002018/3/3000002018/3/3100002018/4/100002018/4/200002018/4/300002018/4/400002018/4/500002018

25、/4/600002018/4/700002018/4/800002018/4/900002018/4/1000002018/4/1100002018/4/1200002018/4/1300002018/4/1400002018/4/1500002018/4/1600002018/4/1700002018/4/1800002018/4/1900002018/4/2000002018/4/2100002018/4/2200002018/4/2300002018/4/2400002018/4/2500002018/4/2600002018/4/2700002018/4/2800002018/4/29

26、00002018/4/3000002018/5/100002018/5/200002018/5/300002018/5/400002018/5/500002018/5/600002018/5/700002018/5/800002018/5/900002018/5/1000002018/5/1100002018/5/1200002018/5/1300002018/5/1400002018/5/1500002018/5/1600002018/5/1700002018/5/1800002018/5/1900002018/5/2000002018/5/2100002018/5/2200002018/5

27、/2300002018/5/2400002018/5/2500002018/5/2600002018/5/2700002018/5/2800002018/5/2900002018/5/3000002018/5/3100002018/6/100002018/6/200002018/6/300002018/6/400002018/6/500002018/6/600002018/6/700002018/6/800002018/6/900002018/6/1000002018/6/1100002018/6/1200002018/6/1300002018/6/1400002018/6/150000201

28、8/6/1600002018/6/1700002018/6/1800002018/6/1900002018/6/2000002018/6/2100002018/6/2200002018/6/2300002018/6/2400002018/6/2500002018/6/2600002018/6/2700002018/6/2800002018/6/2900002018/6/3000002018/7/100002018/7/200002018/7/300002018/7/400002018/7/500002018/7/600002018/7/700002018/7/800002018/7/90000

29、2018/7/1000002018/7/1100002018/7/1200002018/7/1300002018/7/1400002018/7/1500002018/7/1600002018/7/1700002018/7/1800002018/7/1900002018/7/2000002018/7/2100002018/7/2200002018/7/2300002018/7/2400002018/7/2500002018/7/2600002018/7/2700002018/7/2800002018/7/2900002018/7/3000002018/7/3100002018/8/1000020

30、18/8/200002018/8/300002018/8/400002018/8/500002018/8/600002018/8/700002018/8/800002018/8/900002018/8/1000002018/8/1100002018/8/1200002018/8/1300002018/8/1400002018/8/1500002018/8/1600002018/8/1700002018/8/1800002018/8/1900002018/8/2000002018/8/2100002018/8/2200002018/8/2300002018/8/2400002018/8/2500

31、002018/8/2600002018/8/2700002018/8/2800002018/8/2900002018/8/3000002018/8/3100002018/9/100002018/9/200002018/9/300002018/9/400002018/9/500002018/9/600002018/9/700002018/9/800002018/9/900002018/9/1000002018/9/1100002018/9/1200002018/9/1300002018/9/1400002018/9/1500002018/9/1600002018/9/1700002018/9/1

32、800002018/9/1900002018/9/2000002018/9/2100002018/9/2200002018/9/2300002018/9/2400002018/9/2500002018/9/2600002018/9/2700002018/9/2800002018/9/2900002018/9/3000002018/10/100002018/10/200002018/10/300002018/10/400002018/10/500002018/10/600002018/10/700002018/10/800002018/10/900002018/10/1000002018/10/

33、1100002018/10/1200002018/10/1300002018/10/1400002018/10/1500002018/10/1600002018/10/1700002018/10/1800002018/10/1900002018/10/2000002018/10/2100002018/10/2200002018/10/2300002018/10/2400002018/10/2500002018/10/2600002018/10/2700002018/10/2800002018/10/2900002018/10/3000002018/10/3100002018/11/100002

34、018/11/200002018/11/300002018/11/400002018/11/500002018/11/600002018/11/700002018/11/800002018/11/900002018/11/1000002018/11/1100002018/11/1200002018/11/1300002018/11/1400002018/11/1500002018/11/1600002018/11/1700002018/11/1800002018/11/1900002018/11/2000002018/11/2100002018/11/2200002018/11/2300002

35、018/11/2400002018/11/2500002018/11/2600002018/11/2700002018/11/2800002018/11/2900002018/11/3000002018/12/100002018/12/200002018/12/300002018/12/400002018/12/500002018/12/600002018/12/700002018/12/800002018/12/900002018/12/1000002018/12/1100002018/12/1200002018/12/1300002018/12/1400002018/12/15000020

36、18/12/1600002018/12/1700002018/12/1800002018/12/1900002018/12/2000002018/12/2100002018/12/2200002018/12/2300002018/12/2400002018/12/2500002018/12/2600002018/12/2700002018/12/2800002018/12/2900002018/12/3000002018/12/310000按 月 统 计2018年应收支出欠款应收利润1月12895100308-38112月1224835083-71263月122479001224-66764月00005月00006月00007月00008月00009月000010月000011月000012月00003737213501615-17613