Use this report to print balances by account segment and a secondary segment, list the contra account for each journal entry, and list the subledger document number for transactions imported from subledgers. You can print this report by date range, accounting flexfield range, contra account, and amount range.
When you request this report, General Ledger prompts you to enter the following:
Ledger/Ledger Set (optional): Choose the ledger for your report output.
Currency (required): Choose the primary ledger currency for your ledger or STAT.
Posting Status (optional): Choose a status.
Start/End Date (required): Enter the date range for your report. Date range selection will be done using the line effective date.
Sequence Name (optional): Enter the document sequence name for which you want to report.
Start/End Document Number (optional): Enter the start/end document sequence number for which you want to report.
Account From/To: Enter the accounting flexfield range for your report.
Additional Segment (optional): Select the segment which will be used for grouping and page break. If you do not define this value, only the balance and account segment will be used as the grouping segment.
Debit/Credit (optional): Choose Debit or Credit by which to select an amount.
Amount Low/High (optional): Enter the amount range for your report. If you use the Debit or Credit parameter to select an amount, you must enter a value in the Amount Low/Amount High.
Contra Account Name (optional): Enter the Contra Account Name for which you want to report.
Subledger Document Sequence (optional): Enter the subledger document sequence name for which you want to report.
Subledger Sequence Number (optional): Enter the subledger document sequence number for which you want to report.
Refer to the selected heading descriptions below for additional information.
Accounting Date: accounting date of the journal line.
Sequence: the document name associated with the document number below.
Number: the document number for each journal entry associated with the document sequence you specified.
Line: the line number for each line of the journal entry.
Cost Center/Description: the cost center name (displayed only if you are using the cost center segment as one of the report parameters.
Subledger Sequence: the subledger document sequence name of the journal entry lines.
Contra Account Name: the contra account name of the journal entry lines.
Debit/Credit: the amount of the journal lines.
Beginning/End Balance - The beginning balance is the balance as of the starting accounting date for the specified balance, natural account, and secondary segment value. The beginning balance will only be calculated if you specify a Posting Status of Posted. Otherwise, the beginning balance will be displayed as 0.
Note: Line and ending balances are based on user set parameters and may not be equal to what balances are stored in the database.
Contra Account - For debit lines, the contra accounts are all other lines in the journal which have a credit amount, and for credit lines, the contra accounts are all lines which have a debit amount.
For example,
Line 1: Accounts Payable (CR) 1,050
Line 2: Travel Expense (DR) 1,000
Line 3: Tax (DR) 50
The contra account for both line 2 and 3 is Accounts Payable. Line 1 has two contra accounts in this example, so line 1 will print Multiple as the contra account.
By using the subledger document sequences and detail method of import, this report will present more accurate contra account information.
For example, Subledger Document Name = AP Invoices
Line 1: Accounts Payable (1) (CR) 1,050
Line 3: Travel Expense (1) (DR) 1,000
Line 4: Tax (1) (DR) 50
Line 2: Accounts Payable (2) (CR) 1,000
Line 5: Meals (2) (DR) 1,000
If you do not specify a document sequence in the subledgers, the contra account for line 2 will be Multiple since there is no way to distinguish the contra account line 5 from line 3, 4. If you specify a subledger document sequence, the report will select the contra account with the same subledger document sequence number. In the above example, the contra account for line 2 is Meals.
Exceptions:
When a line has both debits and credits (<>0)
The report will not display the contra account for that line.
When a line has only debits and negative debits, or credits and negative credits.
The report will display No Contra Account for both lines.