Data Detail View

The data detail view provides clearer financial reporting and better categorization of key figures. The view displays distinct Debit, Credit, and Balance columns, making financial data easier to interpret at a glance.

A Total row appears at the top, allowing users to quickly view aggregated values without manually calculating totals from individual cells. These features provide a more efficient and structured financial review, helping users track, analyze, and manage data seamlessly.

Benefits for Financial Analysis

Improved Clarity - The distinct Debit, Credit, and Balance columns make financial data easier to interpret at a glance, reducing the time needed to understand transaction details.

Standard Accounting Format - The three-column structure aligns with standard accounting practices, making the data detail view familiar to finance professionals.

Quick Totals - The Total row provides immediate visibility into aggregated values, eliminating the need for manual calculations during review.

Efficient Review - Users can track, analyze, and manage data seamlessly with structured presentation that supports faster financial reviews.

Better Reconciliation - The separation of debits and credits supports reconciliation processes by clearly showing the components that make up the balance.

Debit, Credit, and Balance Columns

The data detail view displays financial information using standard accounting categorization:

Debit Column - Shows debit amounts for the selected cell, presenting increases to asset and expense accounts or decreases to liability, equity, and revenue accounts.

Credit Column - Shows credit amounts for the selected cell, presenting increases to liability, equity, and revenue accounts or decreases to asset and expense accounts.

Balance Column - Shows the net balance, calculated from the debit and credit amounts, providing the resultant value at a glance.

This three-column structure provides better categorization that aligns with standard accounting practices and makes financial data easier to interpret.

Total Row

A Total row appears at the top of the data detail view, displaying aggregated values across all detail rows. Users can quickly view totals for debits, credits, and balances without manually calculating sums from individual cells. This improves efficiency during financial review and reconciliation processes.

Viewing Data Details

To view the data detail view with Debit, Credit, and Balance columns:

1. Right-click on the required cell in the sheet
2. Select View Data Details from the list
3. The data detail view opens, displaying the Debit, Credit, and Balance columns along with the Total row at the top

Use Cases

Journal Entry Review - When reviewing automatic journal entries or manual journal postings, use the data detail view to verify that debits and credits are properly balanced and posted to correct accounts.

Consolidation Reconciliation - After running group consolidation with currency conversion and intercompany eliminations, drill into cells to review the debit and credit components that make up consolidated balances.

Variance Investigation - When investigating variances between actual and budget or between periods, use the data detail view to understand the underlying debit and credit transactions contributing to differences.

Audit Support - During audit reviews, provide detailed breakdowns of balances showing debit and credit components with aggregated totals for auditor verification.