EXCEL賬務處理系統(tǒng)(新制度版)

1、記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年3月31日憑證號：0001摘 要會計科目借 方 金 額貸 方 金 額楊子江報銷交通費.差旅費，辦公費管理費用/交通費206.00楊子江報銷交通費.差旅費，辦公費管理費用/差旅費340.00楊子江報銷交通費.差旅費，辦公費管理費用/辦公費249.10楊子江報銷交通費.差旅費，辦公費庫存現(xiàn)金795.10 附單據(jù)數(shù) 張合計：柒佰玖拾伍元壹角整￥795.10￥795.10財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = =

2、= = = = = = = = = = =2013年3月31日憑證號：0002摘 要會計科目借 方 金 額貸 方 金 額計提2013年1-3月工資管理費用/工資8,400.00計提2013年1-3月工資應付職工薪酬/應付工資8,400.00 附單據(jù)數(shù) 張合計：捌仟肆佰元整￥8,400.00￥8,400.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年3月31日憑證號：0003摘 要會計科目借 方 金 額貸 方 金 額發(fā)放2013年1-3月工資應付職工薪酬/應付工資8,400.0

3、0發(fā)放2013年1-3月工資庫存現(xiàn)金8,400.00 附單據(jù)數(shù) 張合計：捌仟肆佰元整￥8,400.00￥8,400.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年3月31日憑證號：0004摘 要會計科目借 方 金 額貸 方 金 額往來款庫存現(xiàn)金50,000.00往來款其他應收款50,000.00 附單據(jù)數(shù) 張合計：伍萬整￥50,000.00￥50,000.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = =

4、= = = = = = = = =2013年3月31日憑證號：0005摘 要會計科目借 方 金 額貸 方 金 額收郵政第一季度利息財務費用/利息-0.46收郵政第一季度利息銀行存款/基本戶0.46 附單據(jù)數(shù) 張合計：￥.00￥.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年3月31日憑證號：0006摘 要會計科目借 方 金 額貸 方 金 額結轉期間損益本年利潤9,194.64結轉期間損益管理費用/ 工資8,400.00結轉期間損益管理費用/ 辦公費249.10結轉期間損益管理

5、費用/ 差旅費340.00結轉期間損益管理費用/交通費206.00附單據(jù)數(shù) 張合計：￥9,194.64￥9,195.10財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年3月31日憑證號：0006摘 要會計科目借 方 金 額貸 方 金 額結轉期間損益財務費用/ 利息-0.46 附單據(jù)數(shù) 張合計：玖仟壹佰玖拾肆元陸角肆分￥9,194.64￥9,194.64財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = =

6、 = = = = =2013年6月30日憑證號：0001摘 要會計科目借 方 金 額貸 方 金 額楊子江報銷交通費管理費用/交通費654.00楊子江報銷交通費管理費用/交通費654.00 附單據(jù)數(shù) 張合計：陸佰伍拾肆元整￥654.00￥654.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年6月30日憑證號：0002摘 要會計科目借 方 金 額貸 方 金 額計提2013年4-6月工資管理費用/工資10,200.00計提2013年4-6月工資應付職工薪酬/應付工資10,200.0

7、0 附單據(jù)數(shù) 張合計：壹萬零貳佰元整￥10,200.00￥10,200.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年6月30日憑證號：0003摘 要會計科目借 方 金 額貸 方 金 額發(fā)放2013年4-6月工資應付職工薪酬/應付工資10,200.00發(fā)放2013年4-6月工資庫存現(xiàn)金10,200.00 附單據(jù)數(shù) 張合計：壹萬零貳佰元整￥10,200.00￥10,200.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = =

8、= = = = = = = = = = = = =2013年6月30日憑證號：0004摘 要會計科目借 方 金 額貸 方 金 額付廣州天河區(qū)財之友會計師事務所審計費管理費用/其他2,000.00付廣州天河區(qū)財之友會計師事務所審計費庫存現(xiàn)金2,000.00 附單據(jù)數(shù) 張合計：貳仟元整￥2,000.00￥2,000.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年6月30日憑證號：0005摘 要會計科目借 方 金 額貸 方 金 額收郵政第二季度利息財務費用/利息-1.64收郵政第二

9、季度利息銀行存款/基本戶1.64 附單據(jù)數(shù) 張合計：￥.00￥.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年6月30日憑證號：0006摘 要會計科目借 方 金 額貸 方 金 額付廣州天河區(qū)財之友會計師事務所報告費管理費用/其他1,500.00付廣州天河區(qū)財之友會計師事務所報告費庫存現(xiàn)金1,500.00 附單據(jù)數(shù) 張合計：壹仟伍佰元整￥1,500.00￥1,500.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = =

10、 = = = = = = = = = = =2013年6月30日憑證號：0007摘 要會計科目借 方 金 額貸 方 金 額付北京萬網(wǎng)志成科技有限公司域名網(wǎng)絡費管理費用/辦公費1,176.00付北京萬網(wǎng)志成科技有限公司域名網(wǎng)絡費庫存現(xiàn)金1,176.00 附單據(jù)數(shù) 張合計：壹仟壹佰柒拾陸元整￥1,176.00￥1,176.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年6月30日憑證號：0008摘 要會計科目借 方 金 額貸 方 金 額存現(xiàn)金銀行存款/基本戶37,000.00存現(xiàn)金

11、庫存現(xiàn)金37,000.00 附單據(jù)數(shù) 張合計：叁萬柒仟元整￥37,000.00￥37,000.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年6月30日憑證號：0009摘 要會計科目借 方 金 額貸 方 金 額存現(xiàn)金銀行存款/基本戶33,000.00存現(xiàn)金庫存現(xiàn)金33,000.00 附單據(jù)數(shù) 張合計：叁萬叁仟元整￥33,000.00￥33,000.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = =

12、 = = = = = =2013年6月30日憑證號：0010摘 要會計科目借 方 金 額貸 方 金 額提取備用金庫存現(xiàn)金36,000.00提取備用金銀行存款/基本戶36,000.00 附單據(jù)數(shù) 張合計：叁萬陸仟元整￥36,000.00￥36,000.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年6月30日憑證號：0011摘 要會計科目借 方 金 額貸 方 金 額提取備用金庫存現(xiàn)金33,000.00提取備用金銀行存款/基本戶33,000.00 附單據(jù)數(shù) 張合計：叁萬叁仟元整￥3

13、3,000.00￥33,000.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年6月30日憑證號：0012摘 要會計科目借 方 金 額貸 方 金 額支付手續(xù)費財務費用/手續(xù)費12.20支付手續(xù)費銀行存款/基本戶12.20 附單據(jù)數(shù) 張合計：壹拾貳元貳角整￥12.20￥12.20財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年6月30日憑證號：0013摘 要會計科目借

14、 方 金 額貸 方 金 額結轉期間損益本年利潤15,540.56結轉期間損益管理費用/ 工資10,200.00結轉期間損益管理費用/辦公費1,176.00結轉期間損益管理費用/交通費654.00結轉期間損益管理費用/ 其他3,500.00附單據(jù)數(shù) 張合計：￥15,540.56￥15,530.00財務主管：記賬： 復核：制單：經(jīng)辦人：記賬憑證= = = = = = = = = = = = = = = = = = = = = = = = = = =2013年6月30日憑證號：0013摘 要會計科目借 方 金 額貸 方 金 額結轉期間損益財務費用/ 利息-1.64結轉期間損益財務費用/ 手續(xù)費12.

15、20 附單據(jù)數(shù) 張合計：壹萬伍仟伍佰肆拾元伍角陸分￥15,540.56￥15,540.56財務主管：記賬： 復核：制單：經(jīng)辦人：核算單位： XXXXXXXX有限公司啟用年月： 201607平衡平衡67,595.1067,595.10年-月-日 憑證號摘要科目編碼總帳科目明細科目借方貸方數(shù)量單價2013/3/11揚子江報銷差旅費660208管理費用差旅費206.002013/3/11揚子江報銷差旅費660208管理費用差旅費340.002013/3/11揚子江報銷辦公費660206管理費用辦公費249.102013/3/11庫存現(xiàn)金1001庫存現(xiàn)金795.102013/3/12計提1-3月工資6

16、60201管理費用工資8,400.002013/3/12計提1-3月工資221101應付職工薪酬應付工資8,400.002013/3/13發(fā)放1-3月工資221101應付職工薪酬應付工資8,400.002013/3/13發(fā)放1-3月工資1001庫存現(xiàn)金8,400.002013/3/14往來賬款1001庫存現(xiàn)金50,000.002013/3/14往來賬款1221其他應收款50,000.00科科目目匯匯總總表表核算單位：XXXXXXXX有限公司期期間間：20162016年年0707月月 至至 20162016年年0707月月科目名稱科目代碼借貸上期余額本期發(fā)生額期末余額借方貸方利利 潤潤 表表20162016年