Sage XRT Advanced Predefined Views
Cash
Data Model | View |
---|---|
Cash Flow Ledger |
1 - Transaction Amount 1- Debit vs Credit (Company) 1- Debit vs Credit (Bank) 1- Debit vs Credit (Account) 1- Cash Flow Ledger 1- Histogram 1- Intercompany Accounts 2 - Countervalue Amount 2- Debit vs Credit (Company) 2- Debit vs Credit (Bank) 2- Debit vs Credit (Account) 2- Cash Flow Ledger 2- Histogram 2- Intercompany Accounts 2- Cash Flow Currencies 3 - Converted at Chosen Rate 3- Debit vs Credit (Company) 3- Debit vs Credit (Bank) 3- Debit vs Credit (Account) 3- Cash Flow Ledger 3- Histogram 3- Intercompany Accounts 3- Cash Flow Currencies 3- Non-Reconciled Aging |
Cash Flow Balance |
1 - Countervalue Amount 1- Cash Balance By Date 1- Country Balance 1- Company Balances 1- Account Balances 1- Average Balances 1- Policies 1- Cash Balance by End of Month 2 - Converted at Chosen Rate 2- Cash Balance By Date 2- Country Balance 2- Company Balances 2- Account Balances 2- Average Balances 2- Policies 2- Cash Balance by End of Month |
Cash Reconciliation Result |
All Cash Results Not Reconciled Aging Not Reconciled Aging (Historical) Reconciliation PTD vs YTD |
Currency Rate |
Currency Rate (worksheet) Currency Rate (chart) Rates Comparison |
Debts & Investments
Data Model | View |
---|---|
All Transactions - Schedule |
All Transactions - Schedule |
Term Borrowing Schedule |
Term Borrowing Schedule Amortization Schedule Graph |
Bullet Borrowing Schedule |
Bullet Borrowing Schedule Amortization Schedule Graph |
Bullet Borrowing Flows | Bullet Borrowing Flows |
Movable Leasing Flows | Movable Leasing Flows |
Outstanding & Net Treasury |
Outstanding Outstanding - Bank Net Treasury Net Treasury - Bank |
Bond Credit Schedule |
Bond Credit Schedule Bond Credit Schedule Graph |
GL Reconciliation
Data Model | View |
---|---|
GL Entry |
All GL Entries GL Entries Not Reconciled |
Bank Entry |
All Bank Entries Bank Entries Not Reconciled |
GL Reconciliation Result |
All GL Results Non-Reconciled Balance Aging |
Bank Area
Data Model | View |
---|---|
Bank Transactions | Bank Transactions |
Bank File Statement | Bank File Statement |