Skip to main content

GLEntry Posting Reference

This reference explains which business events post to GLEntry, which documents remain operational only, which accounts move, and which posting date the dataset uses.

Students can use it with the process guides and Schema Reference to understand how source documents turn into accounting results.

Non-Posting Documents

These documents are generated for process analysis but do not create GLEntry rows:

  • SalesOrder
  • SalesOrderLine
  • ServiceEngagement
  • ServiceEngagementAssignment
  • ServiceTimeEntry
  • ServiceBillingLine
  • PurchaseRequisition
  • PurchaseOrder
  • PurchaseOrderLine
  • BillOfMaterial
  • BillOfMaterialLine
  • WorkCenter
  • WorkCenterCalendar
  • Routing
  • RoutingOperation
  • WorkOrder
  • WorkOrderOperation
  • WorkOrderOperationSchedule
  • ShiftDefinition
  • EmployeeShiftAssignment
  • TimeClockEntry
  • AttendanceException
  • PayrollPeriod
  • LaborTimeEntry
  • FixedAsset
  • FixedAssetEvent
  • DebtAgreement
  • DebtScheduleLine

Posting Matrix

EventSource tablesPosting date usedDebitCredit
Opening balance journalJournalEntry plus seeded GL rows2026-01-01Asset accounts and selected opening balancesLiability, equity, contra-asset balances, and retained earnings plug
RentJournalEntry plus seeded GL rowsFirst business day of month6070 Warehouse Rent or 6080 Office Rent1010 Cash and Cash Equivalents
UtilitiesJournalEntry plus seeded GL rowsLast business day of month6090 Utilities Expense1010 Cash and Cash Equivalents
Factory overheadJournalEntry plus seeded GL rowsLast business day of month1090 Manufacturing Cost Clearing, or 5080 Manufacturing Variance when the month has no capitalizable direct labor1010 Cash and Cash Equivalents
DepreciationJournalEntry plus seeded GL rows, supported by FixedAssetLast calendar day of month1090 for manufacturing equipment or 6130 for warehouse, office, and showroom assetsaccumulated depreciation accounts such as 1150, 1160, 1170, and 1186
Debt reclassJournalEntry plus FixedAssetEventlinked CAPEX invoice approval date, or asset event date when approval metadata is unavailable2010 Accounts Payable2110 Notes Payable
Debt principal paymentJournalEntry plus DebtScheduleLinePaymentDate2110 Notes Payable1010 Cash and Cash Equivalents
Interest paymentJournalEntry plus DebtScheduleLinePaymentDate7030 Interest Expense1010 Cash and Cash Equivalents
Asset disposalJournalEntry plus FixedAssetEventEventDatecash proceeds when present, accumulated depreciation, and any loss on disposalgross fixed-asset account and any gain on disposal
Month-end accrualJournalEntry plus seeded GL rowsLast business day of monthselected operating expenses2040 Accrued Expenses
Accrual adjustmentJournalEntry plus seeded GL rowsFirst business day on or after the linked invoice approval date for invoice-linked residuals, or a rare later cleanup date for stale uninvoiced accruals2040 Accrued Expensesoriginal accrued expense account
Freight settlementJournalEntry plus seeded GL rowsFirst business day of month2040 Accrued Expenses1010 Cash and Cash Equivalents
ShipmentShipment, ShipmentLineShipmentDateItem COGS account and 5050 Freight-Out ExpenseItem inventory account and 2040 Accrued Expenses for outbound freight
Sales invoiceSalesInvoice, SalesInvoiceLineInvoiceDateAccounts receivableItem revenue account, 4050 Freight Revenue, and sales tax payable
Design-service invoiceSalesInvoice, SalesInvoiceLine, ServiceBillingLineInvoiceDateAccounts receivable4080 Sales Revenue - Design Services and sales tax payable
Cash receiptCashReceiptReceiptDateCash2060 Customer Deposits and Unapplied Cash
Cash receipt applicationCashReceiptApplicationApplicationDate2060 Customer Deposits and Unapplied CashAccounts receivable
Sales returnSalesReturn, SalesReturnLineReturnDateItem inventory accountItem COGS account
Credit memoCreditMemo, CreditMemoLineCreditMemoDate4060 Sales Returns and Allowances, optional 4050 Freight Revenue reversal, and sales tax payable reversalAccounts receivable or 2060 Customer Deposits and Unapplied Cash
Customer refundCustomerRefundRefundDate2060 Customer Deposits and Unapplied CashCash
Sales commission accrualSalesCommissionAccrualAccrualDate, aligned to invoice date6290 Sales Commission Expense2034 Sales Commission Payable
Sales commission adjustmentSalesCommissionAdjustmentAdjustmentDate, aligned to credit memo date2034 Sales Commission Payable6290 Sales Commission Expense
Sales commission paymentSalesCommissionPaymentPaymentDate2034 Sales Commission PayableCash
Goods receiptGoodsReceipt, GoodsReceiptLineReceiptDateItem inventory account2020 Goods Received Not Invoiced
Material issueMaterialIssue, MaterialIssueLineIssueDate1046 Inventory - Work in Process1045 Inventory - Materials and Packaging
Production completionProductionCompletion, ProductionCompletionLineCompletionDate1040 Inventory - Finished Goods1046 Inventory - Work in Process and 1090 Manufacturing Cost Clearing
Work-order closeWorkOrderCloseCloseDateor credit 5080 Manufacturing Variance depending on signoffset 1046 or 1090 residual balances
Payroll registerPayrollRegister, PayrollRegisterLineApprovedDateSalary and wage expense by nonmanufacturing cost center, 6060 nonmanufacturing payroll burden, 1090 capitalizable manufacturing labor plus related burden, and 5080 noncapitalizable manufacturing payroll in no-direct-labor months2030 Accrued Payroll, 2031 Payroll Tax Withholdings Payable, 2032 Employer Payroll Taxes Payable, 2033 Employee Benefits and Other Deductions Payable
Payroll paymentPayrollPaymentPaymentDate2030 Accrued PayrollCash
Payroll liability remittancePayrollLiabilityRemittanceRemittanceDate2031, 2032, or 2033Cash
Purchase invoicePurchaseInvoice, PurchaseInvoiceLineApprovedDateFor receipt-matched inventory lines: GRNI cleared at matched receipt-line basis, purchase variance when needed, and nonrecoverable tax to variance. For capitalized CAPEX lines: the linked fixed-asset gross account such as 1110, 1120, 1130, or 1185. For accrued-service lines: 2040 up to the linked accrued amount and expense for any excess above the estimate; any invoice shortfall is reversed later through a linked accrual adjustment.Accounts payable and purchase variance when needed
DisbursementDisbursementPaymentPaymentDateAccounts payableCash
Year-end close: P&L to income summaryJournalEntry plus seeded GL rowsYYYY-12-31Revenue or expense balances needed to close annual P&L accounts8010 Income Summary
Year-end close: income summary to retained earningsJournalEntry plus seeded GL rowsYYYY-12-318010 Income Summary or 3030 Retained Earnings depending on signoffset retained earnings or income summary

Core Control Accounts

Account numberMeaning
1010Cash and cash equivalents
1020Accounts receivable
1040Inventory - finished goods
1045Inventory - materials and packaging
1046Inventory - work in process
1090Manufacturing cost clearing
1185Manufacturing equipment
1186Accumulated depreciation - manufacturing equipment
2010Accounts payable
2020Goods Received Not Invoiced
2030Accrued payroll
2031Payroll tax withholdings payable
2032Employer payroll taxes payable
2033Employee benefits and other deductions payable
2034Sales commission payable
2040Accrued expenses
2050Sales tax payable
2060Customer deposits and unapplied cash
2110Notes payable
4050Freight revenue
4060Sales returns and allowances
5050Freight-out expense
5080Manufacturing variance
6290Sales commission expense
7020Gain or loss on asset disposal
7030Interest expense
3030Retained earnings
5060Purchase price variance
8010Income summary

Source Traceability

Each operational posting written to GLEntry includes:

  • VoucherType
  • VoucherNumber
  • SourceDocumentType
  • SourceDocumentID
  • SourceLineID
  • PostingDate
  • FiscalYear
  • FiscalPeriod

For design services, SourceDocumentType = 'SalesInvoice' and SourceLineID = SalesInvoiceLineID still hold the revenue trace. ServiceBillingLine is the extra bridge that explains which approved hours created that invoice line.

Sales commissions are a separate O2C payable, not payroll. SalesCommissionAccrual rows use SalesInvoiceLine.LineTotal as the commission base, credit-memo clawbacks use SalesCommissionAdjustment, and monthly settlements use SalesCommissionPayment.