월별 재정 일람 편집하기
둘러보기로 가기
검색하러 가기
편집을 되돌릴 수 있습니다. 이 편집을 되돌리려면 아래의 바뀐 내용을 확인한 후 저장해주세요.
최신판 | 당신의 편집 | ||
1번째 줄: | 1번째 줄: | ||
− | + | <table width="720" cellspacing="0" cellpadding="0" border="1" align="" style="border-collapse: collapse;" x:str="" summary=""> | |
− | + | <tr height="15" style="height: 11.25pt;"> | |
− | <table | + | <td height="15" width="111" style="height: 11.25pt; width: 83pt;" class="xl24"> </td> |
− | + | <td width="144" style="border-left: medium none; width: 108pt;" class="xl24"> </td> | |
− | + | <td width="62" style="border-left: medium none; width: 47pt;" class="xl24">~3월</td> | |
− | + | <td width="62" style="border-left: medium none; width: 47pt; text-align: center;" class="xl24">4월</td> | |
− | <td | + | <td width="62" style="border-left: medium none; width: 47pt; text-align: center;" class="xl24">5월</td> |
− | <td | + | <td width="62" style="border-left: medium none; width: 47pt; text-align: center;" class="xl24">6월</td> |
− | <td | + | <td width="62" style="border-left: medium none; width: 47pt; text-align: center;" class="xl24">7월</td> |
− | <td | + | <td width="62" style="border-left: medium none; width: 47pt; text-align: center;" class="xl24">8월</td> |
− | <td | + | <td width="62" style="border-left: medium none; width: 47pt; text-align: center;" class="xl24">9월</td> |
− | <td | + | <td width="62" style="border-left: medium none; width: 47pt; text-align: center;" class="xl24">10월</td> |
− | <td | + | <td width="62" style="border-left: medium none; width: 47pt; text-align: center;" class="xl24">11월</td> |
− | <td | + | <td width="68" style="border-left: medium none; width: 51pt; text-align: center;" class="xl24">12월</td> |
− | <td | ||
− | <td | ||
− | <td | ||
− | <td | ||
</tr> | </tr> | ||
− | <tr | + | <tr height="15" style="height: 11.25pt;"> |
− | + | <td height="45" style="border-top: medium none; height: 33.75pt;" class="xl24" rowspan="3">지출</td> | |
− | <td | + | <td style="border-top: medium none; border-left: medium none;" class="xl24">월세/이자</td> |
− | <td | + | <td x:num="-400000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-400,000</font></td> |
− | <td | + | <td x:num="-400000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-400,000</font></td> |
− | <td | + | <td x:num="-400000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-400,000</font></td> |
− | <td | + | <td x:num="-400000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-400,000</font></td> |
− | <td | + | <td x:num="-400000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-400,000</font></td> |
− | <td | + | <td x:num="-400000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-400,000</font></td> |
− | <td | + | <td x:num="-400000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-400,000</font></td> |
− | <td | + | <td x:num="-400000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-400,000</font></td> |
− | <td | + | <td x:num="-520000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-520,000</font></td> |
− | <td | + | <td x:num="-950000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-950,000</font></td> |
− | |||
− | |||
</tr> | </tr> | ||
− | <tr> | + | <tr height="15" style="height: 11.25pt;"> |
− | <td | + | <td height="15" style="border-top: medium none; border-left: medium none; height: 11.25pt;" class="xl24">기타지출</td> |
− | <td | + | <td x:num="-360000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-360,000</font></td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td x:num="-40000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-40,000</font></td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td x:num="-250000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-250,000</font></td> |
− | + | <td x:num="-17000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-17,000</font></td> | |
− | <td | ||
− | |||
</tr> | </tr> | ||
− | <tr> | + | <tr height="15" style="height: 11.25pt;"> |
− | <td | + | <td height="15" style="border-top: medium none; border-left: medium none; height: 11.25pt;" class="xl24">공과금</td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td x:num="-75330" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-75,330</font></td> |
− | <td | + | <td x:num="-89910" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-89,910</font></td> |
− | <td | + | <td x:num="-78100" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-78,100</font></td> |
− | <td | + | <td x:num="-38490" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-38,490</font></td> |
− | <td | + | <td x:num="-97540" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-97,540</font></td> |
− | <td | + | <td x:num="-180720" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-180,720</font></td> |
− | <td | + | <td x:num="-90620" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-90,620</font></td> |
− | <td | + | <td x:num="-105730" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-105,730</font></td> |
− | <td | + | <td x:num="-182850" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-182,850</font></td> |
− | |||
− | |||
</tr> | </tr> | ||
− | <tr | + | <tr height="15" style="height: 11.25pt;"> |
− | + | <td height="60" style="border-top: medium none; height: 45pt;" class="xl24" rowspan="4">수입</td> | |
− | <td | + | <td style="border-top: medium none; border-left: medium none;" class="xl24">장기투숙자</td> |
− | <td | + | <td x:num="400000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">400,000</td> |
− | <td | + | <td x:num="180000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">180,000</td> |
− | <td | + | <td x:num="490000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">490,000</td> |
− | <td | + | <td x:num="340000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">340,000</td> |
− | <td | + | <td x:num="340000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">340,000</td> |
− | <td | + | <td x:num="370000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">370,000</td> |
− | <td | + | <td x:num="440000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">440,000</td> |
− | <td | + | <td x:num="490000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">490,000</td> |
− | <td | + | <td x:num="630000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">630,000</td> |
− | <td | + | <td x:num="580000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">580,000</td> |
− | |||
− | |||
</tr> | </tr> | ||
− | <tr> | + | <tr height="15" style="height: 11.25pt;"> |
− | <td | + | <td height="15" style="border-top: medium none; border-left: medium none; height: 11.25pt;" class="xl24">분담금</td> |
− | <td | + | <td x:num="111000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">111,000</td> |
− | <td | + | <td x:num="217000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">217,000</td> |
− | <td | + | <td x:num="249000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">249,000</td> |
− | <td | + | <td x:num="238700" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">238,700</td> |
− | <td | + | <td x:num="344000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">344,000</td> |
− | <td | + | <td x:num="208000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">208,000</td> |
− | <td | + | <td x:num="330000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">330,000</td> |
− | <td | + | <td x:num="228000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">228,000</td> |
− | <td | + | <td x:num="-168000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-168,000</font></td> |
− | <td | + | <td x:num="466000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">339,000</td> |
− | |||
− | |||
</tr> | </tr> | ||
− | <tr> | + | <tr height="15" style="height: 11.25pt;"> |
− | <td | + | <td height="15" style="border-top: medium none; border-left: medium none; height: 11.25pt;" class="xl24">기타수입</td> |
− | <td | + | <td x:num="50000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">50,000</td> |
− | <td | + | <td x:num="50000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">50,000</td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td x:num="" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">539</td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td x:num="100000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">100,000</td> |
− | <td | + | <td x:num="100000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">100,000</td> |
− | <td | + | <td x:num="480000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">480,000</td> |
− | <td | + | <td x:num="270752" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">270,752</td> |
− | |||
− | |||
</tr> | </tr> | ||
− | <tr> | + | <tr height="15" style="height: 11.25pt;"> |
− | <td | + | <td height="15" style="border-top: medium none; border-left: medium none; height: 11.25pt;" class="xl24">후원금</td> |
− | <td | + | <td x:num="250000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">250,000</td> |
− | <td | + | <td x:num="400000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">400,000</td> |
− | <td | + | <td x:num="60000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">60,000</td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td x:num="50000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">50,000</td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> | |
− | <td | ||
− | |||
</tr> | </tr> | ||
− | <tr> | + | <tr height="15" style="height: 11.25pt;"> |
− | <td height=" | + | <td height="15" style="border-top: medium none; height: 11.25pt;" class="xl24">수지</td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none;" class="xl24"> </td> |
− | <td | + | <td x:fmla="=SUM(C2:C8)" x:num="51000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">51,000</td> |
− | <td | + | <td x:fmla="=SUM(D2:D8)" x:num="371670" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">371,670</td> |
− | <td | + | <td x:fmla="=SUM(E2:E8)" x:num="309090" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">309,090</td> |
− | <td | + | <td x:fmla="=SUM(F2:F8)" x:num="101139" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">101,139</td> |
− | <td | + | <td x:fmla="=SUM(G2:G8)" x:num="245510" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">245,510</td> |
− | <td | + | <td x:fmla="=SUM(H2:H8)" x:num="80460" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">80,460</td> |
− | <td | + | <td x:fmla="=SUM(I2:I8)" x:num="249280" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">249,280</td> |
− | <td | + | <td x:fmla="=SUM(J2:J8)" x:num="377380" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">377,380</td> |
− | <td | + | <td x:fmla="=SUM(K2:K8)" x:num="66270" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">66,270</td> |
− | + | <td x:fmla="=SUM(L2:L8)" x:num="166902" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">39,902</td> | |
− | |||
</tr> | </tr> | ||
− | <tr> | + | <tr height="15" style="height: 11.25pt;"> |
− | <td height=" | + | <td height="15" style="border-top: medium none; height: 11.25pt;" class="xl24">부채</td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none;" class="xl24"> </td> |
− | <td | + | <td x:num="1300000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">1,300,000</td> |
− | <td | + | <td x:num="-300000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-300,000</font></td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | + | <td x:num="-500000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-500,000</font></td> | |
− | <td | + | <td x:num="-500000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"><font color="#ff0000" style="">-500,000</font></td> |
− | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> | |
− | <td | + | <td style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25"> </td> |
− | <td | ||
</tr> | </tr> | ||
− | <tr> | + | <tr height="15" style="height: 11.25pt;"> |
− | <td height=" | + | <td height="15" style="border-top: medium none; height: 11.25pt;" class="xl24">잔액</td> |
− | <td | + | <td style="border-top: medium none; border-left: medium none;" class="xl24"> </td> |
− | <td | + | <td x:fmla="=SUM(C9:C10)" x:num="1351000" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">1,351,000</td> |
− | <td | + | <td x:fmla="=C11+D9+D10" x:num="1422670" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">1,422,670</td> |
− | <td | + | <td x:fmla="=D11+E9+E10" x:num="1731760" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">1,731,760</td> |
− | <td | + | <td x:fmla="=E11+F9+F10" x:num="1832899" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">1,832,899</td> |
− | <td | + | <td x:fmla="=F11+G9+G10" x:num="2078409" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">2,078,409</td> |
− | <td | + | <td x:fmla="=G11+H9+H10" x:num="2158869" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">2,158,869</td> |
− | <td | + | <td x:fmla="=H11+I9+I10" x:num="1908149" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">1,908,149</td> |
− | <td | + | <td x:fmla="=I11+J9+J10" x:num="1785529" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">1,785,529</td> |
− | <td | + | <td x:fmla="=J11+K9+K10" x:num="1851799" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">1,851,799</td> |
− | + | <td x:fmla="=K11+L9+L10" x:num="2018701" style="border-top: medium none; border-left: medium none; text-align: right;" class="xl25">1,891,701</td> | |
− | |||
</tr> | </tr> | ||
</table> | </table> | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− |