上傳人:地**
編號(hào):1304441
2024-12-19
13頁(yè)
77.50KB
該文檔所屬資源包:
財(cái)務(wù)行政管理EXCEL模板
1、科目名稱(chēng)憑證號(hào)數(shù)據(jù)財(cái)務(wù)費(fèi)用低值易耗品 固定資產(chǎn) 管理費(fèi)用現(xiàn)金銀行存款1 求和項(xiàng):借方金額5000求和項(xiàng):貸方金額50002 求和項(xiàng):借方金額求和項(xiàng):貸方金額3 求和項(xiàng):借方金額8000求和項(xiàng):貸方金額4 求和項(xiàng):借方金額求和項(xiàng):貸方金額5 求和項(xiàng):借方金額求和項(xiàng):貸方金額6 求和項(xiàng):借方金額10000求和項(xiàng):貸方金額100007 求和項(xiàng):借方金額2000求和項(xiàng):貸方金額20008 求和項(xiàng):借方金額200求和項(xiàng):貸方金額2009 求和項(xiàng):借方金額求和項(xiàng):貸方金額50010 求和項(xiàng):借方金額20求和項(xiàng):貸方金額2011 求和項(xiàng):借方金額5000求和項(xiàng):貸方金額12 求和項(xiàng):借方金額6200求和項(xiàng):2、貸方金額13 求和項(xiàng):借方金額求和項(xiàng):貸方金額求和項(xiàng):借方金額匯總20200010000200500019200求和項(xiàng):貸方金額匯總270015020應(yīng)付賬款 應(yīng)收賬款 營(yíng)業(yè)費(fèi)用 原材料主營(yíng)業(yè)務(wù)成本主營(yíng)業(yè)務(wù)收入 總計(jì)5000500020002000200020008000800080006000600060006000500050005000500010000100002000200020020050050050020205000500050006200620062005000500050005000500050020001100054920200050001100019200 54920科目3、代碼 科目名稱(chēng)101現(xiàn)金102銀行存款109其他貨幣資金113應(yīng)收賬款114壞賬準(zhǔn)備125原材料126低值易耗品130固定資產(chǎn)131累計(jì)折舊201短期借款203應(yīng)付賬款205應(yīng)交稅金301實(shí)收資本302盈余公積321本年利潤(rùn)322利潤(rùn)分配501主營(yíng)業(yè)務(wù)收入502主營(yíng)業(yè)務(wù)成本503主營(yíng)業(yè)務(wù)稅金及附加504營(yíng)業(yè)費(fèi)用510管理費(fèi)用511財(cái)務(wù)費(fèi)用555所得稅記記賬賬憑憑證證日期憑證號(hào)摘要科目代碼科目名稱(chēng)借方金額貸方金額2005/7/181提取現(xiàn)金101現(xiàn)金5000.002005/7/181提取現(xiàn)金102銀行存款5000.002005/7/192采購(gòu)原材料125原材料2000.002005/7/192采4、購(gòu)原材料203應(yīng)付賬款2000.002005/7/203銷(xiāo)售產(chǎn)品102銀行存款8000.002005/7/203銷(xiāo)售產(chǎn)品501主營(yíng)業(yè)務(wù)收入8000.002005/7/224結(jié)轉(zhuǎn)成本502主營(yíng)業(yè)務(wù)成本6000.002005/7/224結(jié)轉(zhuǎn)成本125原材料6000.002005/7/255銷(xiāo)售產(chǎn)品113應(yīng)收賬款5000.002005/7/255銷(xiāo)售產(chǎn)品501主營(yíng)業(yè)務(wù)收入5000.002005/7/266購(gòu)買(mǎi)設(shè)備130固定資產(chǎn)10000.002005/7/266購(gòu)買(mǎi)設(shè)備102銀行存款10000.002005/7/267購(gòu)買(mǎi)模具126低值易耗品2000.002005/7/267購(gòu)買(mǎi)模具101現(xiàn)金2005、0.002005/7/278辦公用品510管理費(fèi)用200.002005/7/278辦公用品101現(xiàn)金200.002005/7/279運(yùn)輸費(fèi)504營(yíng)業(yè)費(fèi)用500.002005/7/279運(yùn)輸費(fèi)101現(xiàn)金500.002005/7/2810手續(xù)費(fèi)511財(cái)務(wù)費(fèi)用20.002005/7/2810手續(xù)費(fèi)102銀行存款20.002005/7/2911收回賬款102銀行存款5000.002005/7/2911收回賬款113應(yīng)收賬款5000.002005/7/3012銷(xiāo)售產(chǎn)品102銀行存款6200.002005/7/3012銷(xiāo)售產(chǎn)品501主營(yíng)業(yè)務(wù)收入6200.002005/7/3013結(jié)轉(zhuǎn)成本502主營(yíng)業(yè)務(wù)成本6、5000.002005/7/3013結(jié)轉(zhuǎn)成本125原材料5000.0054920.0054920.00科目代碼科目名稱(chēng)101現(xiàn)金102銀行存款109其他貨幣資金113應(yīng)收賬款114壞賬準(zhǔn)備125原材料126低值易耗品130固定資產(chǎn)131累計(jì)折舊201短期借款203應(yīng)付賬款205應(yīng)交稅金301實(shí)收資本302盈余公積321本年利潤(rùn)322利潤(rùn)分配501主營(yíng)業(yè)務(wù)收入502主營(yíng)業(yè)務(wù)成本503主營(yíng)業(yè)務(wù)稅金及附加504營(yíng)業(yè)費(fèi)用510管理費(fèi)用511財(cái)務(wù)費(fèi)用555所得稅科目代碼 科目名稱(chēng)101現(xiàn)金102銀行存款109其他貨幣資金113應(yīng)收賬款114壞賬準(zhǔn)備125原材料126低值易耗品130固定資產(chǎn)131累計(jì)折舊7、201短期借款203應(yīng)付賬款205應(yīng)交稅金301實(shí)收資本302盈余公積321本年利潤(rùn)322利潤(rùn)分配501主營(yíng)業(yè)務(wù)收入502主營(yíng)業(yè)務(wù)成本503主營(yíng)業(yè)務(wù)稅金及附加504營(yíng)業(yè)費(fèi)用510管理費(fèi)用511財(cái)務(wù)費(fèi)用555所得稅記記賬賬憑憑證證日期憑證號(hào)摘要科目代碼科目名稱(chēng)借方金額貸方金額2005/7/181提取現(xiàn)金101現(xiàn)金5000.002005/7/267購(gòu)買(mǎi)模具101現(xiàn)金2000.002005/7/278辦公用品101現(xiàn)金200.002005/7/279運(yùn)輸費(fèi)101現(xiàn)金500.00101101 匯匯總總5000.002700.002005/7/181提取現(xiàn)金102銀行存款5000.002005/7/208、3銷(xiāo)售產(chǎn)品102銀行存款8000.002005/7/266購(gòu)買(mǎi)設(shè)備102銀行存款10000.002005/7/2810手續(xù)費(fèi)102銀行存款20.002005/7/2911收回賬款102銀行存款5000.002005/7/3012銷(xiāo)售產(chǎn)品102銀行存款6200.00102102 匯匯總總19200.0015020.002005/7/255銷(xiāo)售產(chǎn)品113應(yīng)收賬款5000.002005/7/2911收回賬款113應(yīng)收賬款5000.00113113 匯匯總總5000.005000.002005/7/192采購(gòu)原材料125原材料2000.002005/7/224結(jié)轉(zhuǎn)成本125原材料6000.0020059、/7/3013結(jié)轉(zhuǎn)成本125原材料5000.00125125 匯匯總總2000.0011000.002005/7/267購(gòu)買(mǎi)模具126低值易耗品2000.00126126 匯匯總總2000.000.002005/7/266購(gòu)買(mǎi)設(shè)備130固定資產(chǎn)10000.00130130 匯匯總總10000.000.002005/7/192采購(gòu)原材料203應(yīng)付賬款2000.00203203 匯匯總總0.002000.002005/7/203銷(xiāo)售產(chǎn)品501主營(yíng)業(yè)務(wù)收入8000.002005/7/255銷(xiāo)售產(chǎn)品501主營(yíng)業(yè)務(wù)收入5000.002005/7/3012銷(xiāo)售產(chǎn)品501主營(yíng)業(yè)務(wù)收入6200.005015010、1 匯匯總總0.0019200.002005/7/224結(jié)轉(zhuǎn)成本502主營(yíng)業(yè)務(wù)成本6000.002005/7/3013結(jié)轉(zhuǎn)成本502主營(yíng)業(yè)務(wù)成本5000.00502502 匯匯總總11000.000.002005/7/279運(yùn)輸費(fèi)504營(yíng)業(yè)費(fèi)用500.00504504 匯匯總總500.000.002005/7/278辦公用品510管理費(fèi)用200.00510510 匯匯總總200.000.002005/7/2810手續(xù)費(fèi)511財(cái)務(wù)費(fèi)用20.00511511 匯匯總總20.000.00總總計(jì)計(jì)54920.0054920.00明明細(xì)細(xì)賬賬科科目目代代碼碼科科目目名名稱(chēng)稱(chēng)月月初初余余額額本本月月發(fā)發(fā)生11、生額額月月末末余余額額借借方方貸貸方方101現(xiàn)金37790.005000.002700.0040090.00102銀行存款12000.0019200.0015020.0016180.00109其他貨幣資金0.000.000.00113應(yīng)收賬款15000.005000.005000.0015000.00114壞賬準(zhǔn)備2500.000.000.002500.00125原材料5460.002000.0011000.00-3540.00126低值易耗品2000.000.002000.00130固定資產(chǎn)12500.0010000.000.0022500.00131累計(jì)折舊-7500.000.000.0012、-7500.00201短期借款-9000.000.000.00-9000.00203應(yīng)付賬款-8500.000.002000.00-10500.00205應(yīng)交稅金-5250.000.000.00-5250.00301實(shí)收資本-50000.000.000.00-50000.00302盈余公積0.000.000.00321本年利潤(rùn)0.000.000.00322利潤(rùn)分配0.000.000.00501主營(yíng)業(yè)務(wù)收入0.0019200.00-19200.00502主營(yíng)業(yè)務(wù)成本11000.000.0011000.00503主營(yíng)業(yè)務(wù)稅金及附加0.000.000.00504營(yíng)業(yè)費(fèi)用500.000.00500.013、0510管理費(fèi)用200.000.00200.00511財(cái)務(wù)費(fèi)用20.000.0020.00555所得稅0.000.000.00總總賬賬總總賬賬科科目目科科目目代代碼碼科科目目名名稱(chēng)稱(chēng)月月初初余余額額借借方方合合計(jì)計(jì)貸貸方方合合計(jì)計(jì)月月末末余余額額101101現(xiàn)金37790.005000.002700.0040090.00102102銀行存款12000.0019200.0015020.0016180.00109109其他貨幣資金0.000.000.000.00113113應(yīng)收賬款15000.005000.005000.0015000.00114114壞賬準(zhǔn)備2500.000.000.00250014、.00125125原材料5460.002000.0011000.00-3540.00126126低值易耗品0.002000.000.002000.00130130固定資產(chǎn)12500.0010000.000.0022500.00131131累計(jì)折舊-7500.000.000.00-7500.00201201短期借款-9000.000.000.00-9000.00203203應(yīng)付賬款-8500.000.002000.00-10500.00205205應(yīng)交稅金-5250.000.000.00-5250.00301301實(shí)收資本-50000.000.000.00-50000.00302302盈余公積015、.000.000.000.00321321本年利潤(rùn)0.000.000.000.00322322利潤(rùn)分配0.000.000.000.00501501主營(yíng)業(yè)務(wù)收入0.000.0019200.00-19200.00502502主營(yíng)業(yè)務(wù)成本0.0011000.000.0011000.00503503主營(yíng)業(yè)務(wù)稅金及附加0.000.000.000.00504504營(yíng)業(yè)費(fèi)用0.00500.000.00500.00510510管理費(fèi)用0.00200.000.00200.00511511財(cái)務(wù)費(fèi)用0.0020.000.0020.00555555所得稅0.000.000.000.00科目代碼 科目名稱(chēng)101現(xiàn)金1016、2銀行存款109其他貨幣資金113應(yīng)收賬款114壞賬準(zhǔn)備125原材料126低值易耗品130固定資產(chǎn)131累計(jì)折舊201短期借款203應(yīng)付賬款205應(yīng)交稅金301實(shí)收資本302盈余公積321本年利潤(rùn)322利潤(rùn)分配501主營(yíng)業(yè)務(wù)收入502主營(yíng)業(yè)務(wù)成本503主營(yíng)業(yè)務(wù)稅金及附加504營(yíng)業(yè)費(fèi)用510管理費(fèi)用511財(cái)務(wù)費(fèi)用555所得稅記記賬賬憑憑證證日期憑證號(hào)摘要總賬科目科目代碼科目名稱(chēng)借方金額2005/7/181提取現(xiàn)金102102銀行存款2005/7/203銷(xiāo)售產(chǎn)品102102銀行存款8000.002005/7/266購(gòu)買(mǎi)設(shè)備102102銀行存款2005/7/2810手續(xù)費(fèi)102102銀行存款200517、/7/2911收回賬款102102銀行存款5000.002005/7/3012銷(xiāo)售產(chǎn)品102102銀行存款6200.00總總計(jì)計(jì)19200.0093320.00貸方金額5000.0010000.0020.0015020.0084960.00總總賬賬總總賬賬科科目目科科目目代代碼碼科科目目名名稱(chēng)稱(chēng)月月初初余余額額借借方方合合計(jì)計(jì)貸貸方方合合計(jì)計(jì)月月末末余余額額101101現(xiàn)金37790.005000.002700.0040090.00102102銀行存款12000.0019200.0015020.0016180.00109109其他貨幣資金0.000.000.000.00113113應(yīng)收賬款1518、000.005000.005000.0015000.00114114壞賬準(zhǔn)備2500.000.000.002500.00125125原材料5460.002000.0011000.00-3540.00126126低值易耗品0.002000.000.002000.00130130固定資產(chǎn)12500.0010000.000.0022500.00131131累計(jì)折舊-7500.000.000.00-7500.00201201短期借款-9000.000.000.00-9000.00203203應(yīng)付賬款-8500.000.002000.00-10500.00205205應(yīng)交稅金-5250.000.000.19、00-5250.00301301實(shí)收資本-50000.000.000.00-50000.00302302盈余公積0.000.000.000.00321321本年利潤(rùn)0.000.000.000.00322322利潤(rùn)分配0.000.000.000.00501501主營(yíng)業(yè)務(wù)收入0.000.0019200.00-19200.00502502主營(yíng)業(yè)務(wù)成本0.0011000.000.0011000.00503503主營(yíng)業(yè)務(wù)稅金及附加0.000.000.000.00504504營(yíng)業(yè)費(fèi)用0.00500.000.00500.00510510管理費(fèi)用0.00200.000.00200.00511511財(cái)務(wù)費(fèi)用0.0020.000.0020.00555555所得稅0.000.000.000.00試試算算平平衡衡表表借方金額貸方金額二者差額是否平衡54920.0054920.000.00平衡
其它
上傳時(shí)間:2023-12-20
30份
其它
上傳時(shí)間:2023-12-21
29份
建筑結(jié)構(gòu)
上傳時(shí)間:2022-07-28
14份
建筑結(jié)構(gòu)
上傳時(shí)間:2022-06-08
18份
CAD圖紙
上傳時(shí)間:2024-07-29
12份
培訓(xùn)課件
上傳時(shí)間:2022-06-15
11份