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)

 

 



Contents