How Sage 100 Updates Retained Earnings
Sage 100 maintains retained earnings through its general ledger and fiscal year-end closing process. During an accounting period, revenue and expense accounts record business activity. At year-end, closing procedures transfer the net result of these temporary accounts into the retained earnings account configured for the company. Revenue and expense accounts are then prepared for the next fiscal year, while balance sheet accounts generally carry their balances forward.
The exact account used for the closing entry depends on the company’s General Ledger setup and version-specific configuration. Before closing the year, finance teams should verify the designated retained earnings account, confirm that transactions for the period are posted, and review relevant reports. The closing process should follow the organization’s documented accounting procedures and Sage 100 guidance.
How the Retained Earnings Balance Is Calculated
The standard calculation is straightforward: beginning retained earnings plus net income, minus net loss where applicable, and minus dividends or owner distributions. More precisely, use net income or net loss as a single signed amount:
Ending retained earnings = Beginning retained earnings + Net income (or loss) − Dividends and distributions
For example, assume a company begins the year with $125,000 in retained earnings, earns $48,000 in net income, and distributes $15,000 to its owners. The ending balance is $125,000 + $48,000 − $15,000 = $158,000. This calculation assumes no other adjustments to retained earnings. Any prior-period adjustments or other applicable equity transactions should be accounted for separately according to the company’s accounting policy.
Reports and Reconciliation Checks
Finance teams should compare the retained earnings account in the general ledger with the balance sheet and supporting equity schedules. A Statement Of Retained Earnings summarizes the opening balance, period profit or loss, distributions, adjustments, and ending balance. The statement provides a clear bridge between the previous year’s equity position and the current reporting period.
A Retained Earnings Rollforward supports this reconciliation by documenting each movement in the balance. When figures do not agree, review the fiscal year selected, the closing status, posted journal entries, the designated account, and any manual adjustments. Also confirm that financial statements use the intended reporting period and that all relevant transactions have been posted before finalizing reports.
Common Issues and Practical Controls
Retained earnings differences can arise when the closing account is configured incorrectly, a period contains unposted transactions, or an adjustment has been recorded directly to equity. A disciplined review before and after year-end closing helps finance teams maintain consistent financial reporting.
- Verify the retained earnings account in the General Ledger setup before closing the fiscal year.
- Reconcile net income or loss to the income statement for the same reporting period.
- Review dividends, owner distributions, and authorized equity adjustments.
- Compare the general ledger balance with the balance sheet and equity rollforward.
- Retain closing reports and supporting journal entries for audit documentation.
Use a consistent review process each year, and document any approved corrections so that future reporting periods begin with a supported opening balance.
Supporting Sage 100 Finance Workflows
Accurate retained earnings depend on reliable transaction coding, approvals, and general ledger records throughout the year. The Hyperbots Platform supports company-specific configurations, including ERP integration, workflows, roles, and GL structures. Its Process Specific Capabilities are designed around finance workflows, while Ready to Deploy Capabilities support implementation through pre-trained agents and ERP connectors.
Self Learning Capabilities allow Hyperbots co-pilots to learn from human actions and refine workflows, including GL coding. With Human in the Loop oversight, exceptions can be routed for review and approvals. For readers exploring related ERP finance workflows, AI Copilots for Sage 300 provides additional context on how AI assistance can support finance productivity and accuracy; Sage 300 and Sage 100 remain distinct products.
Summary
Sage 100 retained earnings track accumulated business profits and losses retained in equity after distributions and applicable adjustments. The balance is influenced by period-end closing, general ledger configuration, and accurate transaction posting. Finance teams can support reliable reporting by checking the designated account, reconciling net income and distributions, reviewing equity reports, and retaining year-end documentation. A well-supported retained earnings balance helps stakeholders understand accumulated performance and make informed financial decisions.