现金日记账模板(带公式)

Sheet1 现金日记账 现金日记账 2012年 摘要 收入借方金额 付出贷方金额 结存金额 2012年 摘要 收入借方金额 付出贷方金额 结存金额 月 日 月 日 期初余额 借 期初余额 借 yen17140300 付丁雄豪13年短期借款 yen11000000 yen11000000 2 26 收金秋15-1-901刘勇订砖款 500000 yen17640300 付丁雄豪退伙款 yen10981600 yen21981600 26 付店电费 yen70000 yen17570300 付梁炳华退伙款 yen19278100 yen41259700 22 付店国税 yen105000 yen17465300 付蒋云霞退伙款 yen13000000 yen54259700 26 付武宁调货CZ8093AS运费 yen36000 yen17429300 付王华清借款利息 yen2000000 yen56259700 26 付武宁调货CZ8093AS共60件 yen864000 yen16565300 付王华清借款 yen10000000 yen66259700 28 收状元府3-1001徐总订砖款 100000 yen16665300 付陈童敏借款 yen10000000 yen76259700 29 付三轮车运费 yen7500 yen16657800 收股本金 39000000 yen37259700 29 付三轮车运费 yen2500 yen16655300 91000000 yen53740300 yen16655300 yen36600000 yen17140300 3 5 收金秋湖畔21-904雷总订砖款 200000 yen16855300 yen17140300 4 付都昌调货9303227件砖款 yen182600 yen16672700 yen17140300 14 付武宁调CZ8093AS yen936000 yen15736700 yen17140300 14 汇款到厂里 yen1906100 yen13830600 yen17140300 10 收金秋湖畔13-2-101订砖款 200000 yen14030600 yen17140300 10 收渣津朱作林订砖款 100000 yen14130600 yen17140300 10 付宝杭物流运费 yen23500 yen14107100 yen17140300 12 付店里买米 yen2670 yen14104430 yen17140300 12 付店里买纸 yen2090 yen14102340 yen17140300 14 付中午午餐费4-14号 yen17600 yen14084740 yen17140300 13 付盛亮借工资 yen100000 yen13984740 yen17140300 13 付龚师付三轮车运费 yen4000 yen13980740 yen17140300 12 付匡春来三轮车运费 yen5000 yen13975740 yen17140300 6 付匡春来三轮车运费 yen11000 yen13964740 yen17140300 8 付匡春来三轮车运费 yen12500 yen13952240 yen17140300 11 付匡春来三轮车运费 yen10000 yen13942240 yen17140300 10 付匡春来三轮车运费 yen5500 yen13936740 yen17140300 14 付陈红娥暂借午餐生活费 yen56100 yen13880640 yen17140300 12 付武宁调CZ8093AS运费 yen36000 yen13844640 yen17140300 18 收万象新城11-902卢总订砖款 800000 yen14644640 yen17140300 22 收肖老师财富广场2-1501 100000 yen14744640 yen17140300 24 收钟总老城客栈补货 6000 yen14750640 yen17140300 24 收加工厂李总补砖款 20000 yen14770640 yen17140300 18 付厂部经理接待用餐 yen22200 yen14748440 yen17140300 1 付店电费 yen21000 yen14727440 yen17140300 22 付店铺餐巾纸等日用品费 yen5360 yen14722080 yen17140300 20 付三轮车运费 yen11000 yen14711080 yen17140300 15 付店铺打快餐 yen6200 yen14704880 yen17140300 19 付三轮车运费 yen2500 yen14702380 yen17140300 21 付三轮车运费 yen13500 yen14688880Sheet2 现金日记账 现金日记账 2012年 摘要 收入借方金额 付出贷方金额 结存金额 2012年 摘要 收入借方金额 付出贷方金额 结存金额 月 日 月 日 期初余额 借 yen14688800 4 期初余额 借 yen12840900 3 22 付三轮车运费 yen5000 yen14683800 9 收戴总财富广场5-502 300000 yen13140900 22 付三轮车运费 yen5000 yen14678800 9 付横坑仓库租金梁振堂 yen420000 yen12720900 22 付店里买水卡 yen10000 yen14668800 11 付买办公用品 yen2200 yen12718700 17 付星子调货CZ8908ASA67件 yen817000 yen13851800 8 付梁退伙款4万 yen12718700 17 付凯杨水晶砖一件 yen1600 yen13850200 8 付还丁借款6万 yen12718700 20 付双华物流 yen34000 yen13816200 13 付还丁借款5万 yen12718700 20 付双华物流 yen34000 yen13782200 13 付梁退伙款15万 yen12718700 18 付双华物流 yen23000 yen13759200 11 付三轮车运费 yen10500 yen12708200 20 付双华物流 yen26000 yen13733200 12 收中央首府黄总订砖款 100000 yen12808200 19 付星子调货515托运费合计 yen77000 yen13656200 14 付双货物流运费 yen21000 yen12787200 6 付百佳陶资批发80029片 yen24300 yen13631900 14 付三轮车运费 yen5000 yen12782200 4 付店铺3月以前电话费 yen20000 yen13611900 13 付朱作林送货费 yen18000 yen12764200 15 付店国税 yen105000 yen13506900 13 付店门锁及仓库锁 yen19000 yen12745200 26 付双华物流运费 yen10000 yen13496900 13 收朱作林砖款 1000000 yen13745200 27 付店铺用胶布一卷 yen1000 yen13495900 17 付店内办公用品费 yen2000 yen13743200 28 付江平调货托运费120件93032 yen43000 yen13452900 10 付店内拖把费 yen7000 yen13736200 30 代付从加工厂关财富广场5-704 yen7000 yen13445900 18 收邓入账款10万 yen13736200 31 付三轮车运费 yen6000 yen13439900 18 付汇款到厂里 yen10001200 yen3735000 28 收樊总CH8172一片 8000 yen13447900 18 付法雨餐费 yen18900 yen3716100 26 收詹姐浩天大厦1604订砖款 100000 yen13547900 12 付梁退伙款2790元 yen3716100 28 付平江调货款 yen714000 yen12833900 18 付三轮车运费 yen5500 yen3710600 10 收许老板填缝剂2桶 7000 yen12840900 18 收奥林华府3-2-901张金民款 1000000 yen4710600 yen12840900 20 收三都代理付总 228000 yen4938600 yen12840900 20 付三轮车运费 yen2500 yen4936100 yen12840900 21 收填缝剂一桶 2500 yen4938600 yen12840900 21 收圆边2根款 3000 yen4941600 yen12840900 21 付三轮车运费 yen5000 yen4936600 yen12840900 21 付蒋退伙款4万 yen4936600 yen12840900 20 付下货费 yen76500 yen4860100 yen12840900 17 付网购计算器 yen12960 yen4847140 yen12840900 19 付网购店内中厅实木工作台及椅 yen300000 yen4547140 yen12840900 21 付双货物流运费 yen34000 yen4513140 yen12840900 22 付三轮车运费 yen3000 yen4510140 yen12840900 23 付蒋退伙款5万周柳燕账号 yen4510140 yen12840900 23 收梁总翰香苑9-2101砖款 200000 yen4710140 yen12840900 23 付三轮车运费 yen5000 yen4705140 yen12840900 23 收中央首府16-302卢总订砖款 100000 yen4805140 yen12840900 24 付蒋退伙款4万周柳燕账号 yen4805140 yen12840

900 25 付丁退伙款5万王伟华账号 yen4805140 注下欠梁退伙余款12万 下欠丁退伙余款25万 下欠蒋退伙余款5万 合计欠款42万年内不计息Sheet3 现金日记账 现金日记账 2012年 摘要 收入借方金额 付出贷方金额 结存金额 2012年 摘要 收入借方金额 付出贷方金额 结存金额 月 日 月 日 期初余额 借 yen4805140 5 期初余额 借 yen2148360 4 25 收紫竹花苑14-1-601定砖款 300000 yen5105140 1 收奥林华府2-1-1201杨总定金 200000 yen1948360 25 收水木年华邹总定金 100000 yen5205140 1 收紫竹花苑吴美女14-1-601 300000 yen1648360 26 收修江明珠丁总2-803定金 500000 yen5705140 1 付红娥工资 yen300000 yen1948360 26 收修江明珠丁总2-804定金 100000 yen5805140 1 付盛亮工资 yen300000 yen2248360 25 付三轮费用 yen18500 yen5786640 1 付丁退伙款9800元 yen2248360 26 收新城二期4-1-602高总砖款 38000 yen5824640 yen2248360 26 付店电费 yen70000 yen5754640 1 付九江调货CZ8318ASB31件 yen31800 yen2280160 27 付快递费用 yen1500 yen5753140 1 收英丁1-1-102丁总砖款 1000000 yen1280160 26 付客户快餐费用 yen10000 yen5743140 1 付王华清2015年到1651利息2万 yen1280160 26 付双华物流费用 yen19000 yen5724140 1 收程叔凯旋国际19-1508定金 50000 yen1230160 26 付三轮费用 yen2500 yen5721640 2 付三轮车费用 yen20000 yen1250160 26 付三轮费用 yen2500 yen5719140 2 收中央首府16-302卢总砖款 1000000 yen250160 26 付三轮费用 yen5000 yen5714140 2 收卢大安万象新城3-2002砖款 640000 yen389840 27 付中午快餐费 yen4700 yen5709440 2 收卢总布甲中心村定金 1000000 yen1389840 25 收邓现金23万 yen5709440 2 收三都代理付总砖款 961200 yen2351040 28 付店内换样 yen18500 yen5690940 3 收加工厂李总补砖款 7500 yen2358540 29 付三轮费用 yen50500 yen5640440 3 收范教香谢兰庭3-401 500000 yen2858540 29 付店电话费 yen10000 yen5630440 3 收孙强虎中央首府16-601定金 500000 yen3358540 29 付厂里拉货运货51T yen430000 yen5200440 3 付三轮车费用 yen2500 yen3356040 29 付徐素梅门店4-7月租金 yen5561100 yen360660 3 付买门店芝麻 yen2000 yen3354040 29 请师付换样晚餐 yen21600 yen382260 2 付东津路边广告费 yen35000 yen3319040 30 付汇款到厂里 yen2006100 yen2388360 2 付515托运费及三轮费 yen1000 yen3318040 4 1 收金秋湖畔吴章玉砖款 300000 yen2088360 5 付三轮车费用 yen5000 yen3313040 30 收黄华陆浩天大厦1304定金 100000 yen1988360 3 付东华物流及三轮费 yen148000 yen3165040 30 付午餐费 yen3200 yen1991560 4 收肖老师财富广场2-1501 900000 yen4065040 7 付双华物流费用 yen11000 yen2002560 7 收任威状元府4-1-1705定金 300000 yen4365040 5 付三轮费用 yen9000 yen2011560 10 收财富广场5-502戴总 455000 yen4820040 2 付三轮费用 yen15000 yen2026560 10 收梁敏帝王国际1-2-1002 40000 yen4860040 7 付三轮费用 yen8000 yen2034560 11 收曾总万象新城25-801 100000 yen4960040 8 付三轮费用 yen13000 yen2047560 4 付东莞出差费用合计 yen598000 yen4362040 29 付午329-429 yen36600 yen2084160 10 付门店2016年度垃圾处理费 yen72000 yen4290040 3 31 付电话费 yen20000 yen2104160 4 付门店卫生间水箱更换 yen8000 yen4282040 3 27 付中午快餐费 yen4000 yen2108160 3 付门店插座2个 yen3800 yen4278240 20 付中午快餐费 yen12500 yen2120660 8 收填缝剂一桶 3500 yen4281740 27 付三轮费用 yen5000 yen2125660 11 收徐小聪奥林华府7-1-1701 1000000 yen5281740 27 付三轮费用 yen3000 yen2128660 15 收秀水观景阁杨春玲定金 100000 yen5381740 28 付三轮费用 yen5000 yen2133660 15 收填缝剂一桶 2500 yen5384240 30 付双华物流费用2次 yen12500 yen2146160 13 打款到厂里 yen2006100 yen3378140 付顺风 yen2200 yen2148360 13 付快递费 yen1500 yen3376640Sheet4 现金日记账 现金日记账 2012年 摘要 收入借方金额 付出贷方金额 结存金额 2012年 摘要 收入借方金额 付出贷方金额 结存金额 月 日 月 日 期初余额 借 yen3376640 5 期初余额 借 yen2638160 5 16 付门店换样用玻璃胶 yen16800 yen3359840 14 收状元府3-1001徐总余款 427000 yen2211160 14 付晚上换样板加班快餐 yen12800 yen3347040 9 付双华物流和三轮车费用 yen18500 yen2229660 14 付仓库租金33-3-4号 yen450000 yen2897040 10 付三轮车费用 yen5500 yen2235160 12 收李老师奥林华府2-2-1502 245000 yen3142040 10 付双华物流费 yen3000 yen2238160 6 收胡叔凯旋国际11-2-602定金 100000 yen3242040 11 付三轮车费用 yen3500 yen2241660 13 收三都代理付总 75000 yen3317040 11 付光头物流费 yen2000 yen2243660 1 付门店电费 yen68000 yen3249040 12 付三轮车费用 yen5000 yen2248660 2 付门店电脑连接线电视 yen3000 yen3246040 11 付可求物流和三轮车费 yen41000 yen2289660 14 付刘泥工 yen50000 yen3196040 13 付牛元填缝剂 yen22000 yen2311660 17 付九江调货CZ8318ASB31件徐小聪 yen32000 yen3164040 18 付奥林华府3-2-901三轮车费 yen2500 yen2314160 17 付汇曾德平账上进明月山工地 yen4778100 yen1614060 19 付三轮车费用 yen3000 yen2317160 17 付汩罗调货7698200件 yen426000 yen2040060 19 付三轮车费用 yen5500 yen2322660 17 付佛山线条徐小聪用 yen80000 yen2120060 16 付三轮车费用 yen7500 yen2330160 17 收谭立英砖款 500000 yen1620060 2 付店里午餐费 yen26300 yen2356460 17 付佛山波导线样品 yen19200 yen1639260 14 付三轮车费用 yen3000 yen2359460 17 收朱医生南院9-601定金 300000 yen1339260 15 付三轮车费用 yen3000 yen2362460 17 付三轮车费用 yen3000 yen1342260 21 付三轮车费用 yen6000 yen2368460 18 付三轮车费用奥林华府3-2-901 yen2500 yen1344760 15 付店里午餐费 yen22100 yen2390560 18 收陈丹娥奥林华府4-1-503定金 100000 yen1244760 15 付双华物流735和三轮车120 yen85500 yen2476060 19 收晏亚丽中央首府15-1-1001 800000 yen444760 18 付双华物流300三轮30 yen33000 yen2509060 19 收明月山工地款 5450000 yen5005240 19 付515托运费和三轮费 yen1000 yen2510060 19 付去明月山费用 yen60000 yen4945240 20 付托运物流和三轮费 yen7000 yen2517060 19 付明月山用砖运费 yen172700 yen4772540 21 付华东物流和三轮 yen5500 yen2522560 21 付店里午餐费 yen3600 yen4768940 23 付三轮车费用 yen10000 yen2532560 21 汇款到厂里 yen5006100 yen237160 23 付展翼快递600元三轮60 yen66000 yen2598560 21 汇款到朱勇订渣津工地踏步 yen300000 yen537160 28 收张总奥林华府7-2-1002砖款 50000 yen2548560 21 付邓勇茶台款 yen400000 yen937160 28 付三轮车费用

yen18000 yen2566560 22 请泥工师付吃饭包烟酒等 yen304000 yen1241160 29 付童建忠泥工万象新城11-902卢总清 yen100000 yen2666560 22 付鱼米之乡餐费请师付 yen110000 yen1351160 30 付515托运费和三轮费 yen6000 yen2672560 22 付东莞出差过路费合计 yen85000 yen1436160 30 付戴传付泥工财富广场5-502戴总家 yen30000 yen2702560 22 收丁雨露万象新城19-C区201 100000 yen1336160 4 8 朱珊现金350000元 yen2702560 22 收郭长彬万象新城B12-1602 100000 yen1236160 30 付店内买纸巾洗手液等 yen7500 yen2710060 22 收帅佳玉A3303砖款 19000 yen1217160 23 收吴艳屏定金 100000 yen2610060 23 付汇款到马成芳进CH6172300件 yen1260600 yen2477760 30 收刘美玲东方名城2-1-702定金 1000000 yen1610060 23 汇款到高安朱勇渣津医院踏步余款 yen618400 yen3096160 30 付购买胶枪 yen1500 yen1611560 24 付三轮车运费 yen2500 yen3098660 8 付三轮车费用 yen7500 yen1619060 24 付下货费300件CH6172 yen13500 yen3112160 6 付三轮车费用 yen7500 yen1626560 25 收老城廖总 45000 yen3067160 24 付三轮车费用 yen2500 yen1629060 26 收黄总中央首府15-1104余款 429000 yen2638160 27 付购买店里文件夹 yen2500 yen1631560 27 付店里午餐费 yen11500 yen1643060 31 付店里午餐费 yen7000 yen1650060 31 付平安物流费 yen10000 yen1660060 yen1660060Sheet5 现金日记账 现金日记账 2012年 摘要 收入借方金额 付出贷方金额 结存金额 2012年 摘要 收入借方金额 付出贷方金额 结存金额 月 日 月 日 6 期初余额 借 yen1660060 6 期初余额 借 yen7409860 4 收邹总水木清华余款 430000 yen1230060 14 付店里买烟接待芙蓉王硬中华 yen65000 yen7474860 4 收冷姐观景阁B1401定金 100000 yen1130060 14 付店买檀香搞卫生毛巾 yen4000 yen7478860 5 收刘凯旋国际7-2601砖款 220000 yen910060 14 付店内买富贵竹3盆 yen10000 yen7488860 5 收胡姐观景阁B1101砖款 100000 yen810060 15 收老客户英才樊敏余款90003000 900000 yen6588860 5 收匡医生修江明珠2-1301定金 500000 yen310060 11 收老客户金秋畔22-1601余款5000 500000 yen6088860 6 付轻尔易举软件年费 yen432000 yen742060 13 收刘总凯旋国际7-2601 2500 yen6086360 8 收张总奥林华府7-2-1002砖款 300000 yen442060 13 付三轮车运费 yen1000 yen6087360 8 发3月份工资13827-6000 yen782700 yen1224760 15 付三轮运费2车 yen6000 yen6093360 8 发4月份工资 yen1513500 yen2738260 16 收胡志华万象新城B12-1303 100000 yen5993360 8 付端午节发员工红包1200500 yen170000 yen2908260 16 付午餐费2人 yen1400 yen5994760 8 付童建忠泥工奥林华府3-2-901张 yen100000 yen3008260 17 收胡老师金秋湖畔19-2-1001 790000 yen5204760 8 付预支5月工资周国荣 yen200000 yen3208260 17 收段向荣砖款移动基站CH6172 127000 yen5077760 8 付预支5月工资俞珊 yen200000 yen3408260 17 付廖文富泥工状元府4-1-1705 yen50000 yen5127760 10 付郭三星泥工万象新城B12-1602 yen50000 yen3458260 17 付活动X展架1个703活动 yen6000 yen5133760 10 付三轮车费 yen13000 yen3471260 17 付三轮车运费 yen17500 yen5151260 10 付搞活动费用转账徐文辉 yen500000 yen3971260 18 付联盛购买水果等活动用 yen10700 yen5161960 1 付双华物流和三轮 yen13500 yen3984760 18 收程叔砖款 165000 yen4996960 1 付三轮车费 yen16500 yen4001260 18 付三轮车运费 yen22500 yen5019460 4 付三轮车费 yen2500 yen4003760 19 收万桂花奥林华府3-1-1601 1000000 yen4019460 1 付三轮车费代付 yen5000 yen4008760 19 收吴章玉金秋湖畔20-703 500000 yen3519460 5 付双华物流和三轮 yen27000 yen4035760 19 收吴总状元府3-104 50000 yen3469460 6 付双华物流和三轮 yen3000 yen4038760 19 付紫竹吴女士退货运费和下楼费 yen9000 yen3478460 6 付门店买桶装水20桶 yen10000 yen4048760 19 收周洪翰香苑9-1205 100000 yen3378460 6 付三轮车费用 yen13000 yen4061760 19 付退店内吧台椅回厂运费 yen12000 yen3390460 5 付三轮车费用 yen8000 yen4069760 20 收周总金秋湖畔5-1-602 500000 yen2890460 4 付店里午餐费 yen22400 yen4092160 20 付双华物流及三轮 yen28500 yen2918960 6 付三轮车费用 yen6000 yen4098160 20 付罗星林人民医院2014年砍价会款 yen100000 yen3018960 4 付三轮车费用 yen8000 yen4106160 yen3018960 10 付奔马物流260和三轮30 yen29000 yen4135160 yen3018960 10 付午餐费 yen17500 yen4152660 yen3018960 1 收韩总玉龙国际1102砖款 500000 yen3652660 yen3018960 4 付李轩泰和调FP906639件 yen255100 yen3907760 yen3018960 12 付陈旺华泥工紫竹14-1-601吴 yen100000 yen4007760 yen3018960 13 付店里午餐费 yen24800 yen4032560 yen3018960 13 收王建发货款帮忙冲任务 7010000 yen2977440 yen3018960 13 付郑令萍武宁代开CH8802AS297件 yen3465600 yen488160 yen3018960 13 付都昌李总代开CH8802as297件 yen3465600 yen3953760 yen3018960 13 付转账到马可厂里 yen3506100 yen7459860 yen3018960 13 收匡老师奥林华府4-2-1903定金 50000 yen7409860 yen3018960Sheet6 现金日记账 现金日记账 2012年 摘要 收入借方金额 付出贷方金额 结存金额 2012年 摘要 收入借方金额 付出贷方金额 结存金额 月 日 月 日 期初余额 借 期初余额 借 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen000 yen00