/
Consolidated Trial Balance Report in Excel
Consolidated Trial Balance Report in Excel
Issue/Symptom/Question
I need a Consolidated Trial Balance Report in Excel format. I typically use the Consolidated Trail Balance PENTA report (code CONSOLIDATEDTB), but it does not allow me to export to Excel.
Applies To
PENTA for Windows > PENTA Reports by Module > Financial & Accounting > Journals & Ledgers > Consolidated Trial Balance (CONSOLIDATEDTB)
Workbench > AC: Accounting Reporting Center > Trial Balance report
Resolution/Fix/Answer
- Add the AC: Accounting Reporting Center panel to your Workbench dashboard.
- Set the panel parameters to pull back the desired data.
- Open the Trial Balance Report.
- Format the report to match the formatting of the PENTA Consolidated Trial Balance.
- Choose the following columns to include:
- Account Class Description
- Account Description
- Account Number
- Beginning Balance
- Credit Activity
- Debit Activity
- Ending Balance
- Net Activity
- Group by Account Class Description, then by Account Number.
- Add a Sum aggregate to the following columns:
- Beginning Balance
- Credit Activity
- Debit Activity
- Ending Balance
- Net Activity
- Choose the following columns to include:
- Export the formatted report to Excel.
, multiple selections available,
Related content
How to view Account Balances and Detail that make up the Balance
How to view Account Balances and Detail that make up the Balance
More like this
Standard Crystal Report - Summary Balance Sheet
Standard Crystal Report - Summary Balance Sheet
More like this
Running Trial Balance without year-end closing entries
Running Trial Balance without year-end closing entries
More like this
Payroll Report with Labor Distribution exportable to Excel
Payroll Report with Labor Distribution exportable to Excel
More like this
How do I run a profitability report for an OU?
How do I run a profitability report for an OU?
More like this
How do I run a report that will breakdown revenue by OU for a specific Customer?
How do I run a report that will breakdown revenue by OU for a specific Customer?
More like this