Example of a GL report on a Consolidation book
Related information
Related topicsAbout the example GL report on a Consolidation book
The following example General Ledger (GL) report shows the transactions that are posted to accounts related to the selected consolidation book on which the report ran. The Txn amt column shows highlighted transaction amounts, indicating the ability to drill down to the source of the transaction.
Report details
The transaction amounts in this example GL report include:
15,000, for account 1000
70,000, for account 1200
40,000, for account 2000
95,000, for account 4000
| Account | Date posted | Memo | Beginning balance | Debit | Credit | Ending balance |
|---|---|---|---|---|---|---|
| 1000-Bank | Nov. 30 | Consolidation | 0.00 | 15,000 | 0.00 | 15,000 |
| 1200-AR | Nov. 30 | Consolidation | 0.00 | 70,000 | 0.00 | 70,000 |
| 2000-AP | Nov. 30 | Consolidation | 0.00 | 0.00 | 40,000 | (40,000) |
| 4000-Sales | Nov. 30 | Consolidation | 0.00 | 0.00 | 95,000 | (95,000) |
Selecting the link for the transaction posted to account 1000 in the amount of 15,000 enables drilling down to the source accrual entry:
| Line | Account | Location | Debit | Credit |
|---|---|---|---|---|
| 1 | 1000-Bank | E101-E101 | 15,000 | 0.00 |
| 2 | 2000-AP | E101-E101 | 0.00 | 40,000 |
| 3 | 1200-AR | E101-E101 | 70,000 | 0.00 |
| 4 | 4000-Sales | E101-E101 | 0.00 | 95,000 |
| 5 | 5000-COGS | E101-E101 | 50,000 | 0.00 |
| Total | No value | E101-E101 | 135,000 | 135,000 |
By drilling down to the source, you can observe the source accrual transaction details listed in the GL report. The transaction amount of 15,000 is posted to account 1000 as a debit. Intacct lists other entries by account in the Debit or Credit columns. The totals for debits and credits are at the bottom of the table, indicating a balance between them.
Drilling down further enables viewing details of the source journal entry.
| Account | Debits | Credits |
|---|---|---|
1000 | 15,000.00 | 0.00 |
2000 | 0.00 | 40,000.00 |
1200 | 70,000.00 | 0.00 |
4000 | 0.00 | 95,000.00 |
5000 | 50,000.00 | 0.00 |
Total | 135,000 | 135,000 |
Having reviewed and verified the source accrual or user-defined book data, you save time and boost confidence in your numbers during the audit process.
Regional availability
The GL report drill-down feature when reporting on Consolidation books is generally available in the following regions:
All regions
