General Ledger & EOM/EOQ/EOY Balances

Worked example! A simple 10-column worksheet (small company) MSExcel spreadsheet showing an initial trial balance with balances as per the ledger at the end of year (EOY) and showing simple adjustments to the final figures for pre-paid expenses, accrued expenses, accrued income, accrued special fees and charges, accrued unearned income, bad and doubtful debts written off, and depreciation, and highlighting adjustments using colour.

A Trial Balance (in MSExcel) based on the Chart of accounts for a company Ltd or Pty (public or private).

A detailed 10-column EOY worksheet (MSExcel spreadsheet) based on properly developed chart of accounts for a non-profit NGO organization (Federal Council professional body Ltd), in preparation for publication of Financial Report under

Worked example! Two simple 10-column worksheets (small companies) MSExcel spreadsheets showing initial trial balances for each company with balances as per the ledger at the end of year (EOY) and showing simple adjustments to the final figures for each company for pre-paid expenses, accrued expenses, accrued income, accrued special fees and charges, accrued unearned income, bad and doubtful debts written off, and depreciation, and highlighting adjustments using colour and linking to a 12-column consolidation worksheet. Adjustments in consolidation are not included.

Worked example! A simple 10-column worksheet (sole trader) MSExcel spreadsheet showing an initial trial balance with balances as per the ledger at the end of year (EOY) and showing simple adjustments to the final figures for pre-paid expenses, accrued expenses, accrued income, accrued special fees and charges, accrued unearned income, bad and doubtful debts written off, and depreciation, and highlighting adjustments using colour. Simplified but useful.

A Trial Balance (in MSExcel) based on the Chart of accounts for a small business involved in providing service (above). (C-1178)

A detailed 10-column EOY worksheet (MSExcel spreadsheet) based on properly developed chart of accounts for a company Ltd or Pty (public or private) trading in goods, in preparation for publication of Financial Report under