Brett Wuth at 13:57, 17 November 2008

2008-11-17T13:57:48Z

New page

The FinancialStamentsTask is not yet done on a regular
basis.

The intent is to produce financial staments about PCSAR for the
board on a regular basis.

[[BrettWuth]] has set up a very similar
process for another organization (SASCI) and in preparation for
supporting this process has cut and paste the instruction for SASCI
here. The instructions will have to be modified slightly for
PCSAR.

How To Produce Financial Statements
-----------------------------------

open the current books using gnucash

* make sure the accounts are reconciled* choose menu: Account/Check & Repair/Check & Repair All
* check to see if there any accounts named: Orphan
if there are:

* move each transaction from these accounts to the account where
they belong* delete the accounts* start again from the start of this step (Check & Repair
All)* select the report "Balance Sheet"
* choose "Options"
==under "Accounts" choose:==
depth: all

always show subaccounts: yes

account: all

==under "Display" choose:==
show balances for parent accounts: yes

show subtotals: yes

show foreign currency: yes

show exchange rates: no

==under "General" choose:==
Report Name: Balance Sheet

Stylesheet: Default

To: checked

Date: (last day of the month for report, e.g. 2004-02-29)

Report's currency: CAD

Price Source: Weighted Average (actually doesn't matter)

click "OK"

* Click "export", name the file "balance-sheet.html"* select the report "Profit and Loss"
* choose "Options"
==under "Accounts" tab choose:==
depth: all

always show subaccounts: yes

account: all

==under "Display" tab choose:==
group the accounts: yes

show balances for parent accounts: yes

show subtotals: yes

show foreign currency: yes

show exchange rates: no

==under "General" tab choose:==
Report Name: Income and Expense Year to Date

Stylesheet: Default

===From: checked===
Date: (start of financial year, e.g. 2003-09-01)

===To: checked===
Date: (last day of the month for report, e.g. 2004-02-29)

Report's currency: CAD

Price Source: Weighted Average (actually doesn't matter)

click "OK"

* Click "export", name the file
"income-and-expense-year-to-date.html"* select ''another'' report "Profit and Loss"
* choose "Options"
==under "Accounts" choose:==
depth: all

always show subaccounts: yes

account: all

==under "Display" choose:==
group the accounts: yes

show balances for parent accounts: yes

show subtotals: yes

show foreign currency: no

show exchange rates: no

==under "General" choose:==
Report Name: Income and Expense Last Month

Stylesheet: Default

===From: checked===
Date: (first dat of the month, e.g. 2004-02-01)

===To: checked===
Date: (last day of the month for report, e.g. 2004-02-29)

Report's currency: CAD

Price Source: Weighted Average (actually doesn't matter)

click "OK"

* Click "export", name the file
"income-and-expense-last-month.html"* exit from gnucash* run openoffice
* open financial-statements.sxc* when OpenOffice prompts you "This file contains
links to other files. Should they be update?", click Yes.* choose worksheet (bottom of window): Balance Sheet* verify that cell A1 shows correct date of report* hide and display the rows you want in the printed report* Add notes to column E* choose worksheet (bottom of window): Income and Expense* verify that cells D2 and K2 shows correct dates of report* Add notes to column J* save* select menu File/Page Preview* select toolbar Page Format
under tab "Page" choose:

* Format: letter* Orientation: Landscape* Table alignment: horizontal and verticalunder tab "Sheet" choose:

* Grid: yes* click "OK"* Print to Minolta* Save the file as the report for the given month

FinancialStatementsTask - Revision history

Brett Wuth at 13:57, 17 November 2008