How GL Account Inquiry Works
A typical inquiry begins with selecting the relevant general ledger account and specifying the period or date range to review. Users then examine the displayed balance and transaction details available in their Sage 100 environment. The exact fields and navigation steps can vary by version, permissions, and installed modules.
A GL Account represents a specific category in the general ledger, such as cash, accounts receivable, sales revenue, or office expenses. Reviewing the account alongside its transaction history helps accountants understand whether activity agrees with supporting records and expected business operations.
For example, if the office supplies expense balance is higher than expected, an accountant can review the account's posted entries, identify large or unfamiliar transactions, and compare them with invoices, purchase documentation, and approval records. The inquiry supports investigation; the accountant determines whether an adjustment or correction is appropriate.
Key Information to Review
When examining a general ledger account, focus on the information that explains the balance and supports reconciliation. Depending on the inquiry screen and configuration, useful details may include:
- Account number and description: Confirm that the selected account matches the financial statement line or reconciliation schedule being reviewed.
- Accounting period and date: Verify that the transaction belongs to the intended reporting period and that period-end cut-off requirements are followed.
- Debit and credit amounts: Review how each entry affects the account balance and whether the posting direction is appropriate.
- Source and reference details: Use available journal, batch, document, or transaction references to trace entries to their supporting records.
- Opening and ending balances: Compare the starting position with period activity and the resulting balance to understand the account's movement.
For an expense review, the Expense GL Account should align with the nature of the purchase and the company's chart-of-accounts policy. Consistent classification makes departmental reporting and variance analysis more meaningful.
Using Inquiry During Reconciliation and Close
GL Account Inquiry is useful when a general ledger balance does not agree with a bank reconciliation, accounts receivable schedule, fixed asset listing, or another supporting report. Begin by confirming that both records use the same reporting date, entity, account scope, and accounting period. Then trace the difference to individual transactions and determine whether it reflects timing, classification, a missing entry, or an incorrect posting.
Consider a cash account with an opening balance of $25,000. During the month, posted debits total $18,000 and posted credits total $21,500. The calculated ending balance is $25,000 + $18,000 − $21,500 = $21,500. If the corresponding reconciliation shows $20,900, the $600 difference requires investigation. Outstanding transactions, bank fees, timing differences, or posting errors may explain the variance; the accountant should verify the evidence before recording an adjustment.
Inquiry results should be reviewed alongside source documents and reconciliation schedules. A displayed balance alone does not establish that every transaction is correctly classified or supported.
Account Structure and Data Quality
Reliable inquiry depends on a well-maintained chart of accounts, consistent posting practices, and clear account descriptions. GL Account Creation should follow an established numbering structure and naming convention, with account purpose, financial statement classification, and reporting requirements defined before new accounts are introduced.
When finance workflows extend across systems, Keep Your GL Codes Aligned in Any ERP System provides relevant guidance on maintaining consistent account relationships during ERP integration or system changes. Teams using sage intacct alongside other finance systems should also define mapping rules so that transactions retain the intended account meaning when data moves between platforms.
Accurate gl coding during invoice processing helps transactions reach the correct expense or balance sheet account before posting. Guidance such as GL Coding Simplified: Boost Reporting & Audit Ease can support consistent coding practices and clearer audit trails. Reviewers should confirm account assignments, approval evidence, and posting status when investigating unexpected activity.
Automation and Review Controls
Finance teams can use the Hyperbots Platform to support finance workflows and company-specific configurations, including ERP connections, roles, approval paths, and general ledger structures. Its Process Specific Capabilities can be applied to defined finance tasks, while Ready to Deploy Capabilities support implementation through pre-trained agents and ERP connectors where applicable.
Self Learning Capabilities can help automation workflows adapt based on human feedback and improve coding recommendations over time. With Human in the Loop review, unusual entries or uncertain classifications can be routed to authorized finance staff for a decision. These controls complement Sage 100 inquiry by helping teams maintain consistent transaction data and preserve accountability for accounting judgments.
For invoice-related workflows, GL Coding Simplified: Boost Reporting & Audit Ease highlights how clear coding and review practices contribute to more useful reports. Finance teams should establish who can view accounts, who can post adjustments, and how supporting evidence is retained.
Summary
Sage 100 GL Account Inquiry helps finance professionals investigate account balances, trace posted activity, and support reconciliations and period-end reporting. Effective use involves selecting the correct account and period, reviewing transaction references, comparing balances with supporting records, and documenting the resolution of differences. Combined with disciplined account maintenance and appropriate review controls, inquiry improves visibility into general ledger activity and supports dependable financial reporting.