Sample 2 - Column Profit & Loss/Balance Sheet
|
#layout |
|
Title = p&l/balance mtd/ytd |
|
Ruler = off |
|
Format = comma |
|
Width = 132 |
|
Amounts = 16 |
|
Percent = 6,2 |
|
Negative = bracket |
|
* ------------------------------------------------------------------------------ |
|
#header |
|
! [@centre] |
|
Profit & loss statement |
|
|
|
[@yourname] |
|
[@youracn] |
|
|
|
For the period ending [@periodnameend] |
|
|
|
* ------------------------------------------------------------------------------ |
|
#body |
|
! [@nojustify] |
|
* ------------------------------------------------------------------------------ |
|
|
|
! @request(6) |
|
Revenue |
|
monthly current |
|
activity % ytd |
|
|
|
! [@setzero] |
|
[name:#revenue] [period_amt:#revenue] @percent([period_amt:#revenue], [period_amt:@revenue]) [period_bal:#revenue] |
|
! [@setnormal] |
|
-------------------- -------------------- |
|
[period_amt:@revenue] [period_bal:@revenue] |
|
* ------------------------------------------------------------------------------ |
|
|
|
! @request(6) |
|
Other income |
|
monthly current |
|
activity % ytd |
|
|
|
! [@setzero] |
|
[name:#otherincome] [period_amt:#otherincome] @percent([period_amt:#otherincome], [period_amt:@otherincome]) [period_bal:#otherincome] |
|
! [@setnormal] |
|
-------------------- -------------------- |
|
[period_amt:@otherincome] [period_bal:@otherincome] |
|
! @request(2) |
|
-------------------- -------------------- |
|
@add([period_amt:@revenue],[period_amt:@otherincome], &totalsales) @add([period_bal:@revenue], [period_bal:@otherincome], &totalsalebal) |
|
* ------------------------------------------------------------------------------ |
|
|
|
! @request(3) |
|
Less cost of goods sold |
|
|
|
[name:#opening] [period_amt:#opening] [period_amt1:#opening] |
|
-------------------- -------------------- |
|
[period_amt:@opening] [period_amt1:@opening] |
|
|
|
|
|
! [@setzero] |
|
[name:#purchases] [period_amt:#purchases] @percent([period_amt:#purchases], [period_amt:@purchases]) [period_bal:#purchases] |
|
! [@setnormal] |
|
-------------------- -------------------- |
|
[period_amt:@purchases] [period_bal:@purchases] |
|
|
|
|
|
[name:#closing] [period_amt:#closing] [period_amt:#closing] |
|
-------------------- -------------------- |
|
[period_amt:@closing] [period_amt:@closing] |
|
! @add([period_amt:@opening], [period_amt:@purchases], &totalcost) |
|
! @add([period_amt1:@opening], [period_bal:@purchases], &totalcostbal) |
|
! @request(2) |
|
-------------------- -------------------- |
|
Cost of goods sold @subtract([&totalcost], [period_amt:@closing], &totalcost) @subtract([&totalcostbal], [period_amt:@closing], &totalcostbal) |
|
|
|
-------------------- -------------------- |
|
Gross profit @subtract([&totalsales], [&totalcost], &grossprofit) @subtract([&totalsalebal], [&totalcostbal], &totprobal) |
|
* ------------------------------------------------------------------------------ |
|
|
|
! @request(6) |
|
Operating expenses |
|
monthly current |
|
activity % ytd |
|
|
|
! [@setzero] |
|
[name:#expenses] [period_amt:#expenses] @percent([period_amt:#expenses], [period_amt:@expenses]) [period_bal:#expenses] |
|
! [@setnormal] |
|
-------------------- -------------------- |
|
[period_amt:@expenses] [period_bal:@expenses] |
|
! @request(2) |
|
-------------------- -------------------- |
|
Net profit @subtract([&grossprofit], [period_amt:@expenses], &netprofit) @subtract([&totprobal], [period_bal:@expenses], &netprobal) |
|
[@newpage] |
|
* ------------------------------------------------------------------------------ |
|
|
|
! @request(3) |
|
Appropriations |
|
|
|
! [@setzero] |
|
[name:#appropriate] [period_amt:#appropriate] [period_bal:#appropriate] |
|
! [@setnormal] |
|
-------------------- -------------------- |
|
[period_amt:@appropriate] [period_bal:@appropriate] |
|
|
|
! @request(2) |
|
-------------------- -------------------- |
|
Retained earnings @subtract([&netprofit], [period_amt:@appropriate], &retained) @subtract([&netprobal], [period_bal:@appropriate], &retainedbal) |
|
* ------------------------------------------------------------------------------ |
|
#header |
|
! [@centre] |
|
Balance sheet |
|
|
|
[@yourname] |
|
[@youracn] |
|
|
|
For the period ending [@periodnameend] |
|
#body |
|
[@newpage] |
|
* ------------------------------------------------------------------------------ |
|
! [@nojustify] |
|
! @request(6) |
|
Current assets |
|
monthly current |
|
activity ytd |
|
! [@setzero] |
|
[name:#assets] [period_amt:#assets] [period_bal:#assets] |
|
! [@setnormal] |
|
-------------------- -------------------- |
|
[period_amt:@assets] [period_bal:@assets] |
|
* ------------------------------------------------------------------------------ |
|
|
|
! @request(6) |
|
Fixed assets |
|
monthly current |
|
activity ytd |
|
|
|
! [@setzero] |
|
[name:#fixedassets] [period_amt:#fixedassets] [period_bal:#fixedassets] |
|
! [@setnormal] |
|
-------------------- -------------------- |
|
[period_amt:@fixedassets] [period_bal:@fixedassets] |
|
* ------------------------------------------------------------------------------ |
|
|
|
! @request(6) |
|
Current liabilities |
|
monthly current |
|
activity ytd |
|
|
|
! [@setzero] |
|
[name:#liabilities] [period_amt:#liabilities] [period_bal:#liabilities] |
|
! [@setnormal] |
|
-------------------- -------------------- |
|
[period_amt:@liabilities] [period_bal:@liabilities] |
|
* ------------------------------------------------------------------------------ |
|
|
|
! @request(6) |
|
Non-current liabilities |
|
monthly current |
|
activity ytd |
|
|
|
! [@setzero] |
|
[name:#nonliab] [period_amt:#nonliab] [period_bal:#nonliab] |
|
! [@setnormal] |
|
-------------------- -------------------- |
|
[period_amt:@nonliab] [period_bal:@nonliab] |
|
! @request(2) |
|
! @add([period_amt:@assets], [period_amt:@fixedassets], &netassets) |
|
! @add([period_bal:@assets], [period_bal:@fixedassets], &netassetbal) |
|
! @add([period_amt:@liabilities], [period_amt:@nonliab], &totalliable) |
|
! @add([period_bal:@liabilities], [period_bal:@nonliab], &totlbalance) |
|
-------------------- -------------------- |
|
Net assets @subtract([&netassets], [&totalliable], &netassets) @subtract([&netassetbal], [&totlbalance], &netassetbal) |
|
|
|
* ------------------------------------------------------------------------------ |
|
|
|
! @request(3) |
|
Equity |
|
|
|
! [@setzero] |
|
[name:#CAPITAL] [period_amt:#CAPITAL] [period_bal:#CAPITAL] |
|
! [@setnormal] |
|
-------------------- -------------------- |
|
[period_amt:@CAPITAL] [period_bal:@CAPITAL] |
|
|
|
! @request(3) |
|
Retained earnings c/fwd [&retained] [&retainedbal] |
|
-------------------- -------------------- |
|
Total equity @add([period_amt:@CAPITAL], [&retained], &equity) @add([period_bal:@CAPITAL], [&retainedbal], &equitybal) |