Deposit Movement Analysis Report
Purpose
Summaries the movement that have happened in the Deposit module for the month
Timing
The
timing of this report is critical
It
will normally be run immediately prior to a month end after all monthly posting
processes have been undertaken, including the cashbook Post
to Other Systems
Access
- Deposit | Print Deposit Movement Analysis Report
Report
The Report Dialog presented is:
Report Layout
Detailed
below is a description of how each of the items on the Deposit Movement
Analysis Report is made up. All of the
amounts detailed except the opening and closing balances should be able to be
reconciled to the Account Transactions Report for the Deposit module for the
month the report is printed. The
transaction report should be printed for the full month by Transaction Type by
input date.
Field | Explanation |
Opening Balance | This is the Opening Balance of the Deposit System as shown on the Deposit Control Details |
Deposit Movements | This is a category heading Below this are shown the details of deposits that have been added to or taken from the deposit system |
Maturing Deposits for Reinvestment | This is the total of all credit transactions with a Transaction Type of
ACCMATTRF where the Maturity Action on the Deposit Account was not equal to Trsf
Account |
New Deposits Added | This is the total of all credits using Transaction Types that where selected in the |
Maturing Deposits for Reinvestment | This is the total of all debit transactions with
a Transaction Type of ACCMATTRF where the Maturity Action on the maturing
Deposit Account was not equal to Trsf Account |
Maturing Deposits Transferred | This
is the total of all debit transactions with a Transaction Type of ACCMATTRF
where the Maturity Action on the maturing Deposit Account was equal to Trsf
Account This
will usually be deposits that have matured to a Call Account |
Early Maturing Deposits | This is the total of all cashbook transactions created with a cashbook Reference = Investment, where the account has the Early Maturity Flag checked on |
Paid out Deposits (DC) | This
is the total of all deposits that have matured and been paid out by Direct
Credit |
Paid Out Deposits (Cheque) | This is the total of all debit transactions using the Transaction Types that were selected in the |
| Interest Movements | This
is a category heading Below
this are shown the details of interest movements in the Deposit system The
total at the end of this section represents the increase in the Deposit ledger
value from compounded interest amounts net of RWT |
Monthly Interest Compounded | Total of interest credited to the account where the |
Quarterly Interest Compounded | Total of interest credited to the account where the |
Other Freq Interest Compounded | Total of interest credited to the account where the |
Interest Paid | Total of interest credited to the account where the |
Interest Transferred | Total of transactions for the period using the Transaction
Type ACCTRFINT as defined on the Account Type field Transfer Trans – Interest |
Monthly Interest Paid DC | Total of interest paid out in the period where The transactions used are those defined in the dialog |
Quarterly paid interest DC | Total of Interest paid out in the period where The transactions used are those defined in the
dialog |
Other Freq. Interest Paid DC | Total
of Interest paid out in the period where The transactions used are those defined in the
dialog |
Early Maturing Interest | This is the total of all cashbook
transactions created with a cashbook Reference = Interest, where the account
has the Early Maturity Flag checked on |
Monthly Interest Paid Cheque | Total
of Interest paid out in the period where
The
transactions used are those defined in the dialog |
Quarterly Interest Paid Cheque | Total
of Interest paid out in the period where |
Other Freq. Interest Paid Cheque | Total
of Interest paid out in the period where |
RWT deducted | Total
of all Transaction Types where the Report RWT flag has been ticked on |
Other Movements | This
is a category heading Below
this are shown the details of other movements in the deposit system that are
not maturity, new deposit or interest related |
Adjustments | This
is the total of all transactions defined on the The
Transaction Types entered here should reflect those that are used to make
manual adjustments to a deposit account such as interest and RWT adjustments |
Unallocated | This
is the total of all transactions processed through the deposit system for the
period that are not included in any of the above categories |
Closing Balance | The
closing balance of the ledger taking into account the month opening balance and
all transactions processed for the month |
Related Articles
Deposit Movement Analysis Report Setup
Purpose Allows the definition of the transaction types that are required to run the report. Access Deposit | Print Deposit Movement Analysis Report Report Four buttons are required to be setup to run the Deposit Movement Analysis Report. Transaction ...Deposit Movement Analysis Report Reconciliation
Purpose To assist with reconciling the Deposit Movement Analysis Report, and resolving any Unallocatable Funds Timing This should be completed as soon as a discrepancy is identified Unallocatable Funds If an amount appears against the Unallocated ...Deposit Cashflow Report
Purpose To predict the expected Cashflow for the business assuming all maturities and interest will be paid out for Deposit accounts Timing The report may be run at any time Access Deposit | Print Deposit Cashflow Report Report Report Specific ...Deposit Account Statement Report
Purpose Prints or Creates a Communication for a Deposit statement for the specified period The statement format is unique to Deposit accounts The current interest rate, Next Interest Date and Maturity Date are detailed Timing Usually following a ...Payables Invoice Analysis Report
Purpose Provide a listing of invoices for each payable account for the required period Access Payable | Print Payable Invoice Analysis Report Report