Chart of Accounts & Financial Reporting
The chart of accounts is the skeleton of your financial system. Every transaction posts to a GL account. Learn how to structure accounts, use categories for reporting, and build financial reports.
What is the Chart of Accounts?
The chart of accounts is like the table of contents in your company’s financial story.
Every chapter (account) has a purpose: Cash in Bank, Accounts Receivable, Sales Revenue, Office Rent, Salaries. When a transaction happens, it writes into the correct chapters. If your table of contents is messy, the story is impossible to follow.
Olivia at Coastal Traders has 85 GL accounts — enough to see detail, not so many that reports become overwhelming. Each account belongs to a category (Assets, Liabilities, Income, Expense) that powers the financial statements.
GL account structure
Each GL account has these key properties:
| Field | Purpose | Example |
|---|---|---|
| No. | Account number (drives sort order) | 1100 |
| Name | Descriptive name | Cash in Bank |
| Income/Balance | Income Statement or Balance Sheet | Balance Sheet |
| Account Type | Controls behaviour | Posting, Heading, Total, Begin-Total, End-Total |
| Account Category | Financial reporting classification | Assets |
| Account Subcategory | Finer classification | Cash |
| Direct Posting | Can users post directly to this account? | Yes/No |
| Gen. Posting Type | Sale, Purchase, or blank | (used with posting groups) |
Account types explained
| Type | Can Post? | Purpose | Example |
|---|---|---|---|
| Posting | Yes | Regular account that holds transaction data | 1100 Cash in Bank |
| Heading | No | Section header for visual grouping | 1000 CURRENT ASSETS |
| Total | No | Shows sum of a defined range | 1999 TOTAL CURRENT ASSETS |
| Begin-Total | No | Marks the start of a totalling range | 1000 Begin Current Assets |
| End-Total | No | Marks the end and calculates the total | 1999 End Current Assets |
Indent accounts under headings to create a visual hierarchy. The chart should be readable at a glance, even with 100+ accounts.
Income/Balance classification
Every GL account is either:
- Income Statement — Revenue and expenses (resets to zero at year-end via Close Income Statement)
- Balance Sheet — Assets, liabilities, and equity (carry forward into the next year)
This is fundamental. When Olivia asks “Why doesn’t my trial balance from last year match?”, the answer is often that income statement accounts were zeroed out by the year-end close, and the net result moved to Retained Earnings.
Account categories and subcategories
Account categories classify GL accounts for financial reporting. They map to the standard financial statement structure:
| Category | What It Represents | Financial Statement |
|---|---|---|
| Assets | What the company owns | Balance Sheet |
| Liabilities | What the company owes | Balance Sheet |
| Equity | Owner’s stake (assets minus liabilities) | Balance Sheet |
| Income | Revenue earned | Income Statement |
| Cost of Goods Sold | Direct costs of goods sold | Income Statement |
| Expense | Operating expenses | Income Statement |
Subcategories
Each category has subcategories that provide finer detail:
| Category | Subcategory Examples |
|---|---|
| Assets | Cash, Accounts Receivable, Inventory, Prepaid Expenses, Fixed Assets |
| Liabilities | Current Liabilities, Payables, Long-term Liabilities, Tax Liabilities |
| Equity | Common Stock, Retained Earnings |
| Income | Sales Revenue, Service Revenue, Interest Income |
| COGS | Materials, Labour, Manufacturing Overhead |
| Expense | Rent, Salaries, Utilities, Depreciation, Marketing |
Why categories matter
Categories power the Account Schedule (financial reporting) system:
- Balance Sheet report pulls accounts by category (Assets, Liabilities, Equity)
- Income Statement pulls by category (Income, COGS, Expense)
- No need to manually maintain formulas — add a new GL account with the right category and it automatically appears in reports
Exam tip: Categories vs account ranges
Business Central supports two reporting approaches:
- Category-based — reports sum accounts by their assigned category/subcategory (recommended, automatic)
- Range-based — reports sum accounts by number ranges (e.g., 1000..1999 = Assets) (legacy, manual)
The exam favours the category-based approach. When asked about “preparing financial reporting with account categories,” this is the answer — assign categories to accounts, and the built-in reports aggregate automatically.
Financial reporting (Account Schedules)
Financial Reports (formerly Account Schedules) are Business Central’s tool for building custom financial statements.
Components of a financial report
| Component | What It Defines | Example |
|---|---|---|
| Row Definition | What to show (which accounts/categories) | Revenue, COGS, Gross Profit, Expenses, Net Income |
| Column Definition | How to show it (periods, comparisons) | Actual, Budget, Variance, Prior Year |
| Financial Report | Combines row + column definitions | P&L Report: Actual vs Budget for Q1 2026 |
Row definition elements
| Row Type | Source | Example |
|---|---|---|
| GL Account | Specific account(s) | 4100..4199 (all revenue accounts) |
| Account Category | Sum of a category | Income (sums all accounts with Income category) |
| Formula | Calculated | Row 1 - Row 2 = Gross Profit |
| Total | Sum of rows | Total Revenue + Total Other Income |
Building a simple Income Statement
Olivia creates a financial report:
Row Definition:
- Revenue (Account Category: Income) — sum of all income accounts
- Cost of Goods Sold (Account Category: COGS)
- Gross Profit (Formula: Row 1 - Row 2)
- Operating Expenses (Account Category: Expense)
- Net Income (Formula: Row 3 - Row 4)
Column Definition:
- Column A: Net Change (current period)
- Column B: Net Change (same period last year)
- Column C: Variance (A - B)
- Column D: Variance % ((A - B) / B * 100)
The power of categories: when Olivia adds a new revenue account “Consulting Revenue” and assigns it the Income category, it automatically appears in the Revenue row of every financial report. No report maintenance needed.
Knowledge check
Olivia adds a new GL account '4350 - Consulting Revenue' to the chart of accounts. She assigns it the account category 'Income' and subcategory 'Service Revenue'. What happens to her existing financial reports?
Priya is setting up the chart of accounts for a new client. She creates account 2100 'Accounts Payable' as a Balance Sheet account with Direct Posting = No. Why would she disable direct posting?
🎬 Video coming soon
Next up: You have GL accounts — but how does Business Central know WHICH GL account to use when posting a sales invoice or purchase order? That’s the job of posting groups.