Skip to main content

Account Summary (SI)

The Account Summary (SI) data model for Sage 300 contains financial account balances and performance metrics across various time frames and reports. It includes opening and ending balances, periodic and year to date postings, cash flow details, actual and budgeted amounts, and variances for accounts. The views are Trial Balance, Income Statement, Cash Flow, and Balance Sheet.

important

This data model is mainly used for the conversion from Sage Intelligence (SI) to SEI.

How to use the account summary (SI) data model​

  • Read account status, performance, and liquidity in the Trial Balance, Income Statement, Cash Flow, and Balance Sheet views.
  • Compare performance metrics across various time frames.
  • Report on account balances and variances with opening and ending balances and periodic and year to date postings.
  • Break down segments and groupings by company code, GL account code, fiscal year, and account type.
  • Plan forecasts and budgets with key financial indicators such as report actual, reporting budget actual, and cash flow period posting.

Available views​

View nameType of viewWhat it shows
Balance SheetWorksheetSummarizes assets, liabilities, and equity at a specific date.
Income StatementWorksheetShows revenue, expenses, and profits for a given period.
Cash FlowWorksheetTracks cash inflows and outflows to evaluate liquidity.
Trial BalanceWorksheetDisplays current account balances.