GL Account Transactions

The GL Account Transactions data model provides transaction-level detail from the general ledger. It includes measures like debit amount, credit amount, beginning balance, ending balance, posting amount, and net income across individual journal entries and transactions. You can drill into specific transactions, trace journal entries back to source documents, and audit account activity at the most granular level.

Benefits of this data model

• Compare income and expenses to assess financial performance and understand profitability trends.
• Analyze long-term assets held for extended use rather than immediate conversion to track fixed asset composition.
• Validate account accuracy by reviewing total debits and credits in each account before period close.
• Review revenue and expenses by period to understand financial performance over time.
• Check financial position with snapshots of assets, liabilities, and equity at specific points in time.

Available views

View	Type	Description
Account Transactions Details	Worksheet	Shows detailed records of individual transactions with debits, credits, and posting amounts for analysis and auditing.
Trial Balance	Worksheet	Summary of credits and debits in each account to ensure accuracy before closing a period.
Income Statement	Worksheet	Overview of revenues and expenses during a specific period with net income calculation.
Balance Sheet	Worksheet	Snapshot of assets, liabilities, and equity at a specific point in time.
Income vs Expenses	Vertical Bar	Compares revenue against costs over time to assess financial performance.
Long Term Assets	Vertical Bar	Breaks down assets held for long-term use by category rather than immediate conversion.