Viewing Account Statements
To generate the Account Summary as a PDF file select the option from the Actions menu then press Perform Action:
To open the account details page for a child organisation click the corresponding View link:
To extract the data to Microsoft Excel 2007, Microsoft Excel 2003, Tab separated values (TSV) or Comma separated values (CSV) formats click the Download data link.
The following tables indicate the data fields included in the Download data extract
Summary View
...
This screen provides a summary of the entire registration accounts in the hierarchy within a certain data range.
To view a detailed account of each child organisation, click on the Detail link:
This will display registration account details:
Click Generate Report to view the Detail Download Report. The data fields included in the Detail Download Report include:
Field | Description |
---|---|
ent_trans_id | The ID of the entity that initiated the download. |
cp_transaction_date | The date the most recent transaction was recorded. |
entity_id | The ID of the child organisationlast_transorganisation that the current user is logging into. |
cp_entity_id | The ID of the most recent transaction for the child organisation. |
currbalance_after | The balance of the account after each transaction. |
amount | The current balance of the child organisation's account. |
lastamount_amountdebit | The amount of the most recent transaction |
transaction_date | The date the most recent transaction was recorded |
entitydebited from the account balance by each transaction. | |
amount_credit | The amount credited to the account by each transaction. |
trans_type_name | The name of the child organisation |
Detail View
Field | Description |
---|---|
TransID | The ID of eachtransaction |
Date | The date of each transaction |
Type | The type of each transaction |
Description | A description of each transaction |
Debit | The amount debited from the account balance by each transaction |
Credit | The amount credited to the account by each transaction |
Balance | The balance of the account after each transaction.type. |
trans_journal | Details of the transaction. |
cp_entity_name | The name of the child organisation. |