Skip to main content

GL Financial Summary

The GL Financial Summary data model combines core financial statements and account details from the general ledger. It includes Trial Balance, Income Statement, Balance Sheet, and Account Balance views that show beginning and ending balances, debits and credits, and period-over-period changes. Use this data model to review financial position, verify accounting accuracy, and track how accounts move over time.

Benefits of this data model

  • Review multiple financial statements in one place instead of running separate reports for Trial Balance, Income Statement, and Balance Sheet.
  • Compare account balances across periods to spot unusual changes or trends that need investigation without exporting to spreadsheets.
  • Verify debits and credits balance before period close using Trial Balance views that highlight discrepancies.
  • See both summary and detail levels by switching between financial statements and underlying account balances without leaving the data model.

Available views

ViewTypeDescription
Trial BalanceWorksheetLists all accounts with debit and credit balances, verifying your books balance before closing a period.
Income StatementWorksheetShows revenue and expenses for a period with net profit or loss for month-end reviews and performance tracking.
Balance SheetWorksheetSnapshot of assets, liabilities, and equity at a point in time for reviewing financial position and health.
Account BalanceWorksheetCurrent balance for each account for quick lookups and balance verification.
Account Balances by PeriodWorksheetAccount balances across multiple periods for spotting trends and comparing performance month over month.