Sage Intacct Predefined Analyses
When you install the Sage Intacct template, you get a collection of predefined analyses built for Sage Intacct: data models, views, dashboards, and workbooks. Everything listed below is ready to use and can be customized to fit your needs.
Data Models
Data models organize and structure your Sage Intacct data. Each data model includes one or more views that display the data visually through charts, KPIs, gauges, worksheets, maps, and more.
Real TimeReal time financial data and budget information.
General LedgerGL summaries, transactions, budgets, financial KPIs, and cash conversion cycle.
Accounts ReceivableAR invoices, adjustments, payments, and transaction reports.
Accounts PayableAP bills, adjustments, payments, credit card transactions, and reports.
Inventory ControlItem activity and inventory transactions.
Cash ManagementDeposits, other receipts, and funds transfers.
Order EntrySales analysis and invoice comparisons (TY vs LY).
PurchasingPurchase transactions and details.
ProjectsProject summaries, details, and account group mapping.
Common DataCustomers, financial periods, currency rates, and reporting codes.
CREAP and AR aging, retainage balances, and project cost and estimate data.
OLAP CubesPreconfigured cubes for sales invoices, financial KPIs, and cash conversion cycle.
Dashboards
Dashboards display multiple views on a single screen. Views inside a dashboard typically share a common theme, like finance or sales, so related data appears together.
Workbooks
Workbooks are spreadsheets built inside SEI. They support formulas, pivot tables, slicers, sparklines, and data extractions to analyze your Sage Intacct data in a spreadsheet format.
Real TimeReal time trial balance, profit and loss, balance sheet, and cash flow.
Trial BalanceDebit and credit balances by account.
Balance SheetAssets, liabilities, and equity with a rolling 12 month view.
Profit and LossMultiple layouts including forecast, budget vs. actual, and multi year comparisons.
Cash FlowCash flow statements with current and forecast views.
DashboardsP&L, financial performance, and expense dashboards in workbook format.
Accounts Payable (CRE)Bill aging, retainage balance, and open bills by project.
Accounts Receivable (CRE)Invoice aging, retainage balance, and detail reports by customer.
Projects (CRE)Job cost detail, project cost overview, and estimate vs. actual cost.
Revenues & Expenditures (Not for Profit)Basic, forecast, yearly comparison, and actual vs. budget layouts.
Financial Position (Not for Profit)Current and forecast financial position statements.
Cash Flow (Not for Profit)Direct and indirect method cash flow statements with forecast views.
Grants (Not for Profit)Grant positions (inception to date) and revenue vs. expenditure budget analysis.
Writeback
Data from Sage Intacct can be retrieved into a workbook for review and adjustment. Writeback then sends that data back to Sage Intacct, creating or updating records such as journal entries, budgets, and invoices directly from the workbook.
Journal EntryBalanced journal entries for accruals, reclassifications, and GL adjustments.
AP Bills EntryVendor bills for invoices and other accounts payable expenses.
Annual BudgetAnnual GL budgets by account, location, department, and class.
Forecast Revision / Rolling ForecastForecast revisions using actuals and baseline budget data.
Project EstimateProject estimates, including cost codes, quantities, and amounts.
Create Project ContractNew project contracts and their related contract lines.
Update Existing Project ContractExisting project contracts, including billing settings, retainage, and GL accounts.