现金日记账模板(带公式)教案资料.xls

现现金金日日记记账账 现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额结结存存金金额额20122012年年月月日日月月期期初初余余额额借付丁雄豪13年短期借款110,000.00(110,000.00)2付丁雄豪退伙款109,816.00(219,816.00)付梁炳华退伙款192,781.00(412,597.00)付蒋云霞退伙款130,000.00(542,597.00)付王华清借款利息20,000.00(562,597.00)付王华清借款100,000.00(662,597.00)付陈童敏借款100,000.00(762,597.00)收股本金390,000.00(372,597.00)910,000.00537,403.00366,000.00171,403.003171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00171,403.00摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额结结存存金金额额日日期期初初余余额额借171,403.0026收金秋15-1-901刘勇订砖款5,000.00176,403.0026付店电费700.00175,703.0022付店国税1,050.00174,653.0026付武宁调货CZ8093AS运费360.00174,293.0026付武宁调货CZ8093AS共60件8,640.00165,653.0028收状元府3-1001徐总订砖款1,000.00166,653.0029付三轮车运费75.00166,578.0029付三轮车运费25.00166,553.00166,553.005收金秋湖畔21-904雷总订砖款2,000.00168,553.004付都昌调货93032/27件砖款1,826.00166,727.0014付武宁调CZ8093AS/9,360.00157,367.0014汇款到厂里19,061.00138,306.0010收金秋湖畔13-2-101订砖款2,000.00140,306.0010收渣津朱作林订砖款1,000.00141,306.0010付宝杭物流运费235.00141,071.0012付店里买米26.70141,044.3012付店里买纸20.90141,023.4014付中午午餐费4-14号176.00140,847.4013付盛亮借工资1,000.00139,847.4013付龚师付三轮车运费40.00139,807.4012付匡春来三轮车运费50.00139,757.406付匡春来三轮车运费110.00139,647.408付匡春来三轮车运费125.00139,522.4011付匡春来三轮车运费100.00139,422.4010付匡春来三轮车运费55.00139,367.4014付陈红娥暂借午餐生活费561.00138,806.4012付武宁调CZ8093AS/运费360.00138,446.4018收万象新城11-902卢总订砖款8,000.00146,446.4022收肖老师财富广场2-15011,000.00147,446.4024收钟总老城客栈补货60.00147,506.4024收加工厂李总补砖款200.00147,706.4018付厂部经理接待用餐222.00147,484.401付店电费210.00147,274.4022付店铺餐巾纸等日用品费53.60147,220.8020付三轮车运费110.00147,110.8015付店铺打快餐62.00147,048.8019付三轮车运费25.00147,023.8021付三轮车运费135.00146,888.80 现现金金日日记记账账20122012年年 现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额结结存存金金额额月月日日期期初初余余额额借146,888.00322付三轮车运费50.00146,838.0022付三轮车运费50.00146,788.0022付店里买水卡100.00146,688.0017付星子调货CZ8908AS/A/67件8,170.00138,518.0017付凯杨水晶砖一件16.00138,502.0020付双华物流340.00138,162.0020付双华物流340.00137,822.0018付双华物流230.00137,592.0020付双华物流260.00137,332.0019付星子调货515托运费合计770.00136,562.006付百佳陶资批发8002/9片243.00136,319.004付店铺3月以前电话费200.00136,119.0015付店国税1,050.00135,069.0026付双华物流运费100.00134,969.0027付店铺用胶布一卷10.00134,959.0028付江平调货托运费120件93032430.00134,529.0030代付从加工厂关财富广场5-70470.00134,459.0031付三轮车运费60.00134,399.0028收樊总CH8172一片80.00134,479.0026收詹姐浩天大厦1604订砖款1,000.00135,479.0028付平江调货款7,140.00128,339.0010收许老板填缝剂2桶70.00128,409.00128,409.00128,409.00128,409.00128,409.00128,409.00128,409.00128,409.00128,409.00128,409.00128,409.00128,409.00128,409.00128,409.00128,409.00128,409.00128,409.00128,409.00 现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额月月日日4期期初初余余额额借9收戴总财富广场5-5023,000.009付横坑仓库租金梁振堂4,200.0011付买办公用品22.008付梁退伙款4万8付还丁借款6万13付还丁借款5万13付梁退伙款15万11付三轮车运费105.0012收中央首府黄总订砖款1,000.0014付双货物流运费210.0014付三轮车运费50.0013付朱作林送货费180.0013付店门锁及仓库锁190.0013收朱作林砖款10,000.0017付店内办公用品费20.0010付店内拖把费70.0018收邓入账款10万18付汇款到厂里100,012.0018付法雨餐费189.0012付梁退伙款2790元18付三轮车运费55.0018收奥林华府3-2-901张金民款10,000.0020收三都代理付总2,280.0020付三轮车运费25.0021收填缝剂一桶25.0021收圆边2根款30.0021付三轮车运费50.0021付蒋退伙款4万20付下货费765.0017付网购计算器129.6019付网购店内中厅实木工作台及椅3,000.0021付双货物流运费340.0022付三轮车运费30.0023付蒋退伙款5万（周柳燕账号）23收梁总翰香苑9-2101砖款2,000.0023付三轮车运费50.0023收中央首府16-302卢总订砖款1,000.0024付蒋退伙款4万（周柳燕账号）25付丁退伙款5万（王伟华账号）注下欠梁退伙余款12万下欠丁退伙余款25万下欠蒋退伙余款5万合计欠款42万年内不计息结结存存金金额额128,409.00131,409.00127,209.00127,187.00127,187.00127,187.00127,187.00127,187.00127,082.00128,082.00127,872.00127,822.00127,642.00127,452.00137,452.00137,432.00137,362.00137,362.0037,350.0037,161.0037,161.0037,106.0047,106.0049,386.0049,361.0049,386.0049,416.0049,366.0049,366.0048,601.0048,471.4045,471.4045,131.4045,101.4045,101.4047,101.4047,051.4048,051.4048,051.4048,051.40 现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额结结存存金金额额月月日日期期初初余余额额借48,051.40425收紫竹花苑14-1-601定砖款3,000.0051,051.4025收水木年华邹总定金1,000.0052,051.4026收修江明珠丁总2-803定金5,000.0057,051.4026收修江明珠丁总2-804定金1,000.0058,051.4025付三轮费用185.0057,866.4026收新城二期4-1-602高总砖款380.0058,246.4026付店电费700.0057,546.4027付快递费用15.0057,531.4026付客户快餐费用100.0057,431.4026付双华物流费用190.0057,241.4026付三轮费用25.0057,216.4026付三轮费用25.0057,191.4026付三轮费用50.0057,141.4027付中午快餐费47.0057,094.4025收邓现金23万57,094.4028付店内换样185.0056,909.4029付三轮费用505.0056,404.4029付店电话费100.0056,304.4029付厂里拉货运货51T4,300.0052,004.4029付徐素梅门店4-7月租金55,611.00(3,606.60)29请师付换样晚餐216.00(3,822.60)30付汇款到厂里20,061.00(23,883.60)41收金秋湖畔吴章玉砖款3,000.00(20,883.60)30收黄华陆浩天大厦1304定金1,000.00(19,883.60)30付午餐费32.00(19,915.60)7付双华物流费用110.00(20,025.60)5付三轮费用90.00(20,115.60)2付三轮费用150.00(20,265.60)7付三轮费用80.00(20,345.60)8付三轮费用130.00(20,475.60)29付午3.29-4.29366.00(20,841.60)331付电话费200.00(21,041.60)327付中午快餐费40.00(21,081.60)20付中午快餐费125.00(21,206.60)27付三轮费用50.00(21,256.60)27付三轮费用30.00(21,286.60)28付三轮费用50.00(21,336.60)30付双华物流费用2次125.00(21,461.60)付顺风22.00(21,483.60)现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额月月日日5期期初初余余额额借1收奥林华府2-1-1201杨总定金2,000.001收紫竹花苑吴美女14-1-6013,000.001付红娥工资3,000.001付盛亮工资3,000.001付丁退伙款9800元1付九江调货CZ8318ASB3/1件318.001收英丁1-1-102丁总砖款10,000.001付王华清2015年到16.5.1利息2万1收程叔凯旋国际19-1508定金500.002付三轮车费用200.002收中央首府16-302卢总砖款10,000.002收卢大安万象新城3-2002砖款6,400.002收卢总布甲中心村定金10,000.002收三都代理付总砖款9,612.003收加工厂李总补砖款75.003收范教香谢兰庭3-4015,000.003收孙强虎中央首府16-601定金5,000.003付三轮车费用25.003付买门店芝麻20.002付东津路边广告费350.002付515托运费及三轮费10.005付三轮车费用50.003付东华物流及三轮费1,480.004收肖老师财富广场2-15019,000.007收任威状元府4-1-1705定金3,000.0010收财富广场5-502戴总4,550.0010收梁敏帝王国际1-2-1002400.0011收曾总万象新城25-8011,000.004付东莞出差费用合计5,980.0010付门店2016年度垃圾处理费720.004付门店卫生间水箱更换80.003付门店插座2个38.008收填缝剂一桶35.0011收徐小聪奥林华府7-1-170110,000.0015收秀水观景阁杨春玲定金1,000.0015收填缝剂一桶25.0013打款到厂里20,061.0013付快递费15.00结结存存金金额额(21,483.60)(19,483.60)(16,483.60)(19,483.60)(22,483.60)(22,483.60)(22,483.60)(22,801.60)(12,801.60)(12,801.60)(12,301.60)(12,501.60)(2,501.60)3,898.4013,898.4023,510.4023,585.4028,585.4033,585.4033,560.4033,540.4033,190.4033,180.4033,130.4031,650.4040,650.4043,650.4048,200.4048,600.4049,600.4043,620.4042,900.4042,820.4042,782.4042,817.4052,817.4053,817.4053,842.4033,781.4033,766.40 现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额结结存存金金额额月月日日期期初初余余额额借33,766.40516付门店换样用玻璃胶168.0033,598.4014付晚上换样板加班快餐128.0033,470.4014付仓库租金33-3-4号4,500.0028,970.4012收李老师奥林华府2-2-15022,450.0031,420.406收胡叔凯旋国际11-2-602定金1,000.0032,420.4013收三都代理付总750.0033,170.401付门店电费680.0032,490.402付门店电脑连接线电视30.0032,460.4014付刘泥工500.0031,960.4017付九江调货CZ8318ASB3/1件徐小聪 320.0031,640.4017付汇曾德平账上进明月山工地47,781.00(16,140.60)17付汩罗调货7698/200件4,260.00(20,400.60)17付佛山线条徐小聪用800.00(21,200.60)17收谭立英砖款5,000.00(16,200.60)17付佛山波导线样品192.00(16,392.60)17收朱医生南院9-601定金3,000.00(13,392.60)17付三轮车费用30.00(13,422.60)18付三轮车费用奥林华府3-2-90125.00(13,447.60)18收陈丹娥奥林华府4-1-503定金1,000.00(12,447.60)19收晏亚丽中央首府15-1-10018,000.00(4,447.60)19收明月山工地款54,500.0050,052.4019付去明月山费用600.0049,452.4019付明月山用砖运费1,727.0047,725.4021付店里午餐费36.0047,689.4021汇款到厂里50,061.00(2,371.60)21汇款到朱勇订渣津工地踏步3,000.00(5,371.60)21付邓勇茶台款4,000.00(9,371.60)22请泥工师付吃饭包烟酒等 3,040.00(12,411.60)22付鱼米之乡餐费请师付1,100.00(13,511.60)22付东莞出差过路费合计850.00(14,361.60)22收丁雨露万象新城19-C区2011,000.00(13,361.60)22收郭长彬万象新城B12-16021,000.00(12,361.60)22收帅佳玉A3303砖款190.00(12,171.60)23付汇款到马成芳进CH6172/300件12,606.00(24,777.60)23汇款到高安朱勇渣津医院踏步余款6,184.00(30,961.60)24付三轮车运费25.00(30,986.60)24付下货费300件CH6172135.00(31,121.60)25收老城廖总450.00(30,671.60)26收黄总中央首府15-1104余款4,290.00(26,381.60)现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额月月日日5期期初初余余额额借14收状元府3-1001徐总余款4,270.009付双华物流和三轮车费用185.0010付三轮车费用 55.0010付双华物流费30.0011付三轮车费用 35.0011付光头物流费20.0012付三轮车费用 50.0011付可求物流和三轮车费410.0013付牛元填缝剂220.0018付奥林华府3-2-901三轮车费25.0019付三轮车费用 30.0019付三轮车费用 55.0016付三轮车费用 75.002付店里午餐费263.0014付三轮车费用 30.0015付三轮车费用 30.0021付三轮车费用 60.0015付店里午餐费221.0015付双华物流735和三轮车120855.0018付双华物流300三轮30330.0019付515托运费和三轮费10.0020付托运物流和三轮费70.0021付华东物流和三轮55.0023付三轮车费用 100.0023付展翼快递600元三轮60660.0028收张总奥林华府7-2-1002砖款500.0028付三轮车费用 180.0029付童建忠泥工万象新城11-902卢总清1,000.0030付515托运费和三轮费60.0030付戴传付泥工财富广场5-502戴总家300.0048朱珊现金350000元30付店内买纸巾洗手液等75.0023收吴艳屏定金1,000.0030收刘美玲东方名城2-1-702定金10,000.0030付购买胶枪15.008付三轮车费用 75.006付三轮车费用 75.0024付三轮车费用 25.0027付购买店里文件夹25.0027付店里午餐费115.0031付店里午餐费70.0031付平安物流费100.00结结存存金金额额(26,381.60)(22,111.60)(22,296.60)(22,351.60)(22,381.60)(22,416.60)(22,436.60)(22,486.60)(22,896.60)(23,116.60)(23,141.60)(23,171.60)(23,226.60)(23,301.60)(23,564.60)(23,594.60)(23,624.60)(23,684.60)(23,905.60)(24,760.60)(25,090.60)(25,100.60)(25,170.60)(25,225.60)(25,325.60)(25,985.60)(25,485.60)(25,665.60)(26,665.60)(26,725.60)(27,025.60)(27,025.60)(27,100.60)(26,100.60)(16,100.60)(16,115.60)(16,190.60)(16,265.60)(16,290.60)(16,315.60)(16,430.60)(16,500.60)(16,600.60)(16,600.60)现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额结结存存金金额额月月日日6期期初初余余额额借(16,600.60)4收邹总水木清华余款4,300.00(12,300.60)4收冷姐观景阁B1401定金1,000.00(11,300.60)5收刘凯旋国际7-2601砖款2,200.00(9,100.60)5收胡姐观景阁B1101砖款1,000.00(8,100.60)5收匡医生修江明珠2-1301定金5,000.00(3,100.60)6付轻尔易举软件年费4,320.00(7,420.60)8收张总奥林华府7-2-1002砖款3,000.00(4,420.60)8发3月份工资（13827-60007,827.00(12,247.60)8发4月份工资15,135.00(27,382.60)8付端午节发员工红包1200+5001,700.00(29,082.60)8付童建忠泥工奥林华府3-2-901张1,000.00(30,082.60)8付预支5月工资周国荣2,000.00(32,082.60)8付预支5月工资俞珊2,000.00(34,082.60)10付郭三星泥工万象新城B12-1602500.00(34,582.60)10付三轮车费130.00(34,712.60)10付搞活动费用转账徐文辉5,000.00(39,712.60)1付双华物流和三轮135.00(39,847.60)1付三轮车费165.00(40,012.60)4付三轮车费25.00(40,037.60)1付三轮车费（代？付）50.00(40,087.60)5付双华物流和三轮270.00(40,357.60)6付双华物流和三轮30.00(40,387.60)6付门店买桶装水20桶100.00(40,487.60)6付三轮车费用130.00(40,617.60)5付三轮车费用80.00(40,697.60)4付店里午餐费224.00(40,921.60)6付三轮车费用60.00(40,981.60)4付三轮车费用80.00(41,061.60)10付奔马物流260和三轮30290.00(41,351.60)10付午餐费175.00(41,526.60)1收韩总玉龙国际1102砖款5,000.00(36,526.60)4付李轩泰和调FP9066/39件2,551.00(39,077.60)12付陈旺华泥工紫竹14-1-601吴1,000.00(40,077.60)13付店里午餐费248.00(40,325.60)13收王建发货款帮忙冲任务70,100.0029,774.4013付郑令萍武宁代开CH8802AS/297件34,656.00(4,881.60)13付都昌李总代开CH8802as/297件34,656.00(39,537.60)13付转账到马可厂里35,061.00(74,598.60)13收匡老师奥林华府4-2-1903定金 500.00(74,098.60)现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额月月日日6期期初初余余额额借14付店里买烟接待芙蓉王、硬中华650.0014付店买檀香搞卫生毛巾40.0014付店内买富贵竹3盆100.0015收老客户英才樊敏余款9000+30009,000.0011收老客户金秋畔22-1601余款50005,000.0013收刘总凯旋国际7-260125.0013付三轮车运费10.0015付三轮运费2车60.0016收胡志华万象新城B12-13031,000.0016付午餐费2人14.0017收胡老师金秋湖畔19-2-10017,900.0017收段向荣砖款移动基站CH61721,270.0017付廖文富泥工状元府4-1-1705500.0017付活动X展架1个703活动60.0017付三轮车运费175.0018付联盛购买水果等活动用107.0018收程叔砖款1,650.0018付三轮车运费225.0019收万桂花奥林华府3-1-160110,000.0019收吴章玉金秋湖畔20-7035,000.0019收吴总状元府3-104500.0019付紫竹吴女士退货运费和下楼费90.0019收周洪翰香苑9-12051,000.0019付退店内吧台椅回厂运费120.0020收周总金秋湖畔5-1-6025,000.0020付双华物流及三轮285.0020付罗星林人民医院2014年砍价会款1,000.00结结存存金金额额(74,098.60)(74,748.60)(74,788.60)(74,888.60)(65,888.60)(60,888.60)(60,863.60)(60,873.60)(60,933.60)(59,933.60)(59,947.60)(52,047.60)(50,777.60)(51,277.60)(51,337.60)(51,512.60)(51,619.60)(49,969.60)(50,194.60)(40,194.60)(35,194.60)(34,694.60)(34,784.60)(33,784.60)(33,904.60)(28,904.60)(29,189.60)(30,189.60)(30,189.60)(30,189.60)(30,189.60)(30,189.60)(30,189.60)(30,189.60)(30,189.60)(30,189.60)(30,189.60)(30,189.60)(30,189.60)(30,189.60)现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额结结存存金金额额月月日日期期初初余余额额借0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额结结存存金金额额月月日日期期初初余余额额借0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额结结存存金金额额月月日日期期初初余余额额借0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额结结存存金金额额月月日日期期初初余余额额借0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额结结存存金金额额月月日日期期初初余余额额借0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00 现现金金日日记记账账20122012年年摘摘 要要收收入入（借借方方）金金额额付付出出（贷贷方方）金金额额结结存存金金额额月月日日期期初初余余额额借0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00