Overview
Main Account Categories group together Main Accounts for high-level financial reporting.
Main Account Categories are used to support financial reporting and Key Performance Indicator calculation capabilities and act as summary level Income Statement (Revenue and Expense) and Balance Sheet (Asset, Liability, Equity) account categories to which individual main accounts are assigned.
Microsoft provide standard embedded Power BI Content via the Financial Analysis workspaces to present Income Statement, Balance Sheet and KPI values based on a pre-defined set of main account categories.
Note: Main Account Categories can be renamed, but not deleted – although new categories can be added. Editing the Main Account Categories can adversely impact the standard analytic reports
Default Main Account Categories
| Main Account Category | Description |
|---|---|
| CASH | Cash |
| CASHEQUIV | Cash Equivalents |
| SHORTTERMINVEST | Short-term investments |
| AR | Accounts Receivable |
| INV | Inventory |
| NOTESREC | Notes Receivables |
| WIP | Work in Process |
| PREPAIDEXP | Prepaid Expenses |
| OTHERCA | Other Current Assets |
| LONGTERMINVEST | Long-term investments |
| PPE | Property Plant and Equipment |
| ACCUDEP | Accumulated Depreciation |
| INTANASSET | Intangible Assets |
| OTHERASSET | Other Assets |
| AP | Accounts Payable |
| NOTESPAY | Notes Payable |
| CURRENTMATLTD | Current maturities on long-term debt |
| TAXPAY | Taxes Payable |
| INTPAY | Interest Payable |
| DIVPAY | Dividends Payable |
| LEASEPAY | Leases Payable (Current) |
| OTHERCURLIA | Other Current Liabilities |
| LONGTERMDEBT | Long-term debt |
| COMMONSTOCK | Common Stock |
| PREFERREDSTOCK | Preferred Stock |
| RETEARN | Retained Earnings |
| COMMONDIV | Common Dividends |
| PREFERREDDIV | Preferred Dividends |
| SALES | Sales |
| SALERETDIS | Sales Returns and Discounts |
| COGS | Cost of Goods Sold |
| SELLEXP | Selling Expense |
| ADMINEXP | Administrative Expense |
| MANUEXP | Manufacturing Expense |
| TANDEEXP | Travel and Entertainment Expenses |
| PROJEXP | Project Operation Expense |
| SALARYEXP | Salaries Expense |
| OTHEREMPEXP | Other Employee Expenses |
| INTEXP | Interest Expense |
| TAXEXP | Tax Expense |
| DEPREXP | Depreciation Expense |
| INCTAXEXP | Income Tax Expense |
| OTHEREXP | Other Expenses |
| OTHERINC | Other Income |
| GAINLOSSASSET | Gain or loss on asset disposal |
| AMORTINTAGASSET | Amortization of intangible assets |
| STATISTICAL | Statistical Accounts |
| ENCUMBRANCE | Encumbrance |
| PRE-ENCUMBRANCE | Pre-encumbrance |
| SHAREFUND | Shareholders Funds |
| NONCURLIAB | Non-Current Liabilities |
| CURLIAB | Current Liabilities |
| NONCURASS | Non-Current Assets |
| CURASS | Current Assets |
| REV | Revenue |
| EXP | Expense |
| TAXREC | Tax receivable |
Reporting Samples
