2013年小企业会计准则+ k# e8 ~, ?, |
1.应收账款, I4 j8 q7 R t( i7 w
修改前年初余额公式:=ACCT("1122","JC","",0,1,1)+ACCT("2203","JC","",0,1,1)' F1 W7 Z+ c3 c: z
修改后年初余额公式:=ACCT("1122","C","",0,1,1)2 b; z0 y+ r' r, H, u% {& j
修改前期末余额公式:=ACCT("1122","JY","",0,0,0)+ACCT("2203","JY","",0,0,0)
3 k4 C/ S; h; z9 I1 K6 j修改后期末余额公式:=ACCT("1122","Y","",0,0,0)
4 M k a+ W; y$ S7 l2 ~. N: A2.应付账款
. i8 Y3 K9 P! u* U! Z7 i! ]$ H
9 w1 `! m5 A! `) b) B# t7 ], H修改前年初余额公式:=ACCT("2202","DC","",0,1,1)+ACCT("1123","DC","",0,1,1)7 x- m' a' m# e8 `. x9 B
修改后年初余额公式:=ACCT("2202","C","",0,1,1)
5 w9 M, Z4 y8 f, K. d2 \修改前期末余额公式:=ACCT("2202","DY","",0,0,0)+ACCT("1123","DY","",0,0,0)
?2 |, H$ A: }: Q9 k修改后期末余额公式:=ACCT("2202","Y","",0,0,0)' B& a5 T% d& ?6 [& }( ?6 i7 q
3.预收账款" k l$ G: F7 W/ a# f
" P8 p; U9 M3 z i1 l7 Q
修改前年初余额公式:=ACCT("2203","DC","",0,1,1)+ACCT("1122","DC","",0,1,1)
, c* Y( y) q8 Q v6 l0 J/ X修改后年初余额公式:=ACCT("2203","C","",0,1,1)
3 @- Z5 o- T3 E0 w1 K, T修改前期末余额公式:=ACCT("2203","DY","",0,0,0)+ACCT("1122","DY","",0,0,0)
/ f2 J" @# V$ l! n7 X4 I+ T2 m& N2 u修改后期末余额公式:=ACCT("2203","Y","",0,0,0)
0 I+ o- Z- @* c8 q; g4.预付账款
- p3 s9 j4 C# l( h' v0 s2 d' B2 R. Q1 \% ^
修改前年初余额公式:=ACCT("1123","JC","",0,1,1)+ACCT("2202","JC","",0,1,1)
' e2 ]9 W4 ?+ x5 g5 b3 u修改后年初余额公式:=ACCT("1123","C","",0,1,1)* X& F" ]6 |* w4 U) a
修改前期末余额公式:=ACCT("1123","JY","",0,0,0)+ACCT("2202","JY","",0,0,0)
?$ `4 R" t, S+ s% O& N% @修改后期末余额公式:=ACCT("1123","Y","",0,0,0)) j" ~% q: }( z+ _ n2 H r
5.应交税费
- n( X6 O9 D5 Y# k6 r, ^/ a2 H) O. N; u B& ^) F- D
修改前年初余额公式:=ACCT("2221.02","DC","",0,1,1,"")+ACCT("2221.20","DC","",0,1,1,"")+ACCT("2221.21","DC","",0,1,1,"")+ACCT("2221.22","DC","",0,1,1,"")+ACCT("2221.03:2221.14","DC","",0,1,1,"")++ACCT("2221.01","DC","",0,1,1,"")
9 X# G( Y* F; U修改后年初余额公式:=ACCT("2221.","C","",0,1,1,"")' ^/ M" B `+ C: d/ j l# D7 d
修改前期末余额公式:=ACCT("2221.02","DY","",0,0,0,"")+ACCT("2221.20","DY","",0,0,0,"")+ACCT("2221.21","DY","",0,0,0,"")+ACCT("2221.22","DY","",0,0,0,"")+ACCT("2221.03:2221.14","DY","",0,0,0,"")++ACCT("2221.01","DY","",0,0,0,"")
- A4 N( x+ v* q& Y3 B8 j修改后期末余额公式:=ACCT("2221","Y","",0,0,0,"")
) Z/ l5 I8 |$ x6.其他流动资产
0 ]- [) ^9 ?( z6 F+ c7 l& k' r+ h: J ]0 N可直接删除里面公式+ ^5 W& P5 N% ]. _ O
7.其他流动负债9 G- b) D q0 U' E
可直接删除里面公式
4 T; r6 K4 O2 M5 g: y8.未分配利润
5 @+ w+ F8 R+ s+ C: C3 n4 w3 |8 o% u- W |! _: U( `
修改前年初余额公式:=ACCT("3103","C","",0,1,1)+ACCT("3104.08","C","",0,1,1)
8 @6 L2 o8 a O" F$ k修改后年初余额公式:=ACCT("3103","C","",0,1,1)+ACCT("3104","C","",0,1,1)/ d: K7 J J% R4 l) @4 D- w
修改前期末余额公式:=ACCT("3103","Y","",0,0,0)+ACCT("3104.08","Y","",0,0,0)$ h! Z. o. X+ s$ ^1 |1 ]
修改后期末余额公式:=ACCT("3103","Y","",0,0,0)+ACCT("3104","Y","",0,0,0), y; E/ i5 Q5 n! m8 N" T' F
% w( H2 [+ g& G8 [- a7 F
! @: `- F$ ^7 `) ^- |/ ^$ Y注意:每个单元格务必回车键保存公式设置: b; S) ~$ P" L! V
% s: F) u, \) I; l6 W1 f
# E. I$ n' H9 Y7 H$ ^( s& V( L" c
8 E2 I& P9 }: D' G) \2 E5 }% E1 b
|