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.This screen provides a summary of the entire registration accounts in the hierarchy including within certain data range.
To view detailed account of each child organisations, click on Detail link:
This will generate a registration account details as below
The following tables indicate the data fields included in the Download dataDetail Download Report extract.
Summary View
Field | Description |
---|---|
Field | Description |
entityent_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 organisation last_transthat the current user is logging into |
cp_entity_id | The ID of the most recent transaction of 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 debited from the account balance by each transaction |
transactionamount_datecredit | The date the most recent transaction was recordedentityamount 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 | Thetype | 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 |
trans_journal | Details of the transaction |
cp_entity_name | The name of the child organisation |