FinancialStatementsTask

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

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

they belong* delete the accounts* start again from the start of this step (Check & Repair All)* select the report "Balance Sheet"
 * move each transaction from these accounts to the account where
 * 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"

"income-and-expense-year-to-date.html"* select another report "Profit and Loss"
 * Click "export", name the file
 * 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"

"income-and-expense-last-month.html"* exit from gnucash* run openoffice 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:
 * Click "export", name the file
 * open financial-statements.sxc* when OpenOffice prompts you "This file contains


 * 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