Periodic Trial Balance report is used to list the periodic Debit, Credit and Balance totals of accounts. The filter options used in the Trial Balance Between Two Dates reports are:
Filter | Value |
Listing Method | By G/L Account / By Organizational Unit |
Trial Balance Date | Date Range |
Approval Date | Date Entry |
Account Code | Group / Range |
Account Description (1) | Group / Range |
Account Description (2) | Group / Range |
Status | Active / Inactive |
Account Level | Level range |
Account Auxiliary Code | Group / Range |
Account Authorization Code | Group / Range |
Unit Name | Group / Range |
List Items Without Transaction | List / Do not list |
Accounts Without Balance | List / Do not list |
Virtual Accounts | List / Do Not List |
Account Description | In first language / In second language |
Opening Amount | Yes / No |
Analysis Dimension Code | Group / Range |
Analysis Detail Amounts | All / Distributed Amounts / Undistributed Amounts |
Project Code | Group / Range |
Project Description | Group / Range |
Division | |
Department Number | Group / Range |
Amounts in F.C. | Reporting Currency / Transaction Currency |
Transaction Currency | Currency options |
Currency | Local Currency / All Currency / Transaction Currency |
Slip Type | Opening / Collection / Payment / Journal / Exc. Rate Difference / Closing / Adjustment |
Slip Status | Unapproved / G/L Approved / Cancelled |
Source Slip Type | AR/AP Slip / Purchase/Sales Invoice / Safe Deposit Slip / Receipt/Dispatch / Material Slip / Bank Slip / Check/Promissory Note Slip / Post Payroll Accruals to G/L / Post Asset Depreciation and Revaluation Transactions to G/L / Post Credit Interest Accruals to G/L / Post Credit Exchange Rate Differences to G/L / Post Bond Interest Accruals to G/L / Distribution Slips / CGS G/L Slip / Asset Transfer Slip / Asset Inflation Differences / Guarantee Slip / Asset Inflation Differences / Post Travel Allowances to G/L / Asset Count Transactions / Posting Inflation Differences to G/L / Asset Usage Termination / Cross Organizational Unit Bank Slip / G/L Slip |
Source Slip Status | Draft / Approved / G/L Approved / Cancel |
Balance Type | Debit / Credit / Debit + Credit |
Account Plan | Main Chart of Accounts / Second Chart of Accounts / Third Chart of Accounts |
Reporting Resource | G/L Slips / Approved G/L Slips |
Auxiliary Code | Group / Range |