Why Every GL Account in Sage 100 Contractor Needs a Category
The General Ledger in Sage 100 Contractor organizes your entire financial picture — assets, liabilities, equity, revenue, and expenses. Each GL account has an account type field that tells Sage where it belongs on the financial statements. When this field is blank or incorrect, reports break in ways that are difficult to diagnose.
What Happens Without Account Type Mapping
- Balance Sheet is incomplete. Accounts without a type are excluded from the standard Balance Sheet report. Cash might not show up. A liability might be missing. The Balance Sheet won’t balance, and the cause is not obvious.
- Income Statement is wrong. Revenue and expense accounts without a type may be excluded from the P&L, leading to understated revenue or missing expenses.
- Financial ratios are unreliable. Current ratio, working capital, and debt-to-equity calculations depend on accounts being properly classified as current assets, fixed assets, current liabilities, etc.
- DataXcel reporting is affected. DataXcel’s AI analysis reads the account type to categorize GL data. Unmapped accounts appear as anomalies or are excluded from category summaries.
The Standard Account Types in Sage 100 Contractor
Sage 100 Contractor uses these account types (set in 1-1 Ledger Accounts):
- Cash Accounts — Checking, savings, petty cash
- Current Assets — Accounts receivable, prepaid expenses, retention receivable
- WIP Assets — Work in progress, underbilling
- Fixed Assets — Equipment, vehicles, buildings, accumulated depreciation
- Other Assets — Deposits, long-term receivables
- Current Liabilities — Accounts payable, accrued expenses, overbilling, retention payable
- Long-Term Liabilities — Notes payable, equipment loans
- Equity — Owner’s equity, retained earnings, distributions
- Revenue — Contract revenue, service revenue, other income
- Cost of Revenue — Direct job costs, labor burden, subcontract costs
- Overhead/Expense — G&A expenses, office costs, insurance, taxes
Construction-Specific Accounts to Watch
Construction companies need several GL accounts that other industries may not use:
- Work in Progress (WIP) — Tracks costs incurred on jobs where revenue has not yet been recognized. Must be classified as a WIP Asset.
- Overbilling / Underbilling — The difference between billings and earned revenue. Overbilling is a Current Liability; Underbilling is a WIP Asset or Current Asset.
- Retention Receivable — Amounts withheld by customers until project completion. Current Asset.
- Retention Payable — Amounts you withhold from subcontractors. Current Liability.
How to Fix Unmapped Accounts
- Go to 1-1 Ledger Accounts in Sage 100 Contractor.
- For each flagged account, set the Account Type field to the correct category from the list above.
- Verify the account appears on the correct financial statement after the change.
- For new accounts, always set the type at creation time. Never leave it blank.
How DataXcel Helps
The Sage Setup alerts automatically flag GL accounts that have a non-zero balance but no account type assigned. These are accounts actively holding money that are invisible on your financial statements. Fixing them is usually a one-time cleanup that takes minutes per account but dramatically improves the accuracy of every financial report going forward.