End of Year Journals Workbook

Description

End of Year Journals Workbook

The End of Year Journals Workbook is a structured Excel tool designed to support accountants and bookkeepers in preparing, reviewing, and finalizing annual journal adjustments before financial statements are produced. It provides a centralized place to enter key adjustments such as accruals, prepayments, depreciation, and provisions, and automatically reconciles these against the trial balance.

Purpose & Objectives

• Streamline Year-End Close: Provide a standardized framework for recording adjustments required to finalize accounts.
• Ensure Accuracy: Automate calculations for depreciation, accruals, provisions, and tax adjustments.
• Audit Readiness: Maintain clear documentation and audit trails for journal entries.
• Reconcile Accounts: Tie adjustments back to the trial balance, ensuring financial statements are balanced.
• Support Compliance: Ensure that all required adjustments are reflected before statutory reporting or tax filing.

Workbook Structure

• Input Tab (Trial Balance + Opening Figures)
  • Import or paste the year-end trial balance.
  • Provides starting point for adjustments and reconciliation.

• Journal Adjustments Tabs
  • Dedicated tabs for different types of adjustments:
    • Accruals & Prepayments – Records timing adjustments for expenses and income.
    • Depreciation & Amortization – Calculates charges on fixed assets and intangibles.
    • Provisions – Records doubtful debts, warranty liabilities, and other provisions.
    • Tax Adjustments – Estimates current tax and deferred tax.
    • Other Adjustments – For one-off entries such as asset disposals or reclassifications.

• Consolidated Journals Tab
  • Summarizes all adjustments in a single table.
  • Each line shows account code, debit, and credit totals.
  • Ready for posting into accounting software or reporting packages.

• Reconciliation Tab
  • Matches adjusted balances against trial balance.
  • Confirms that all debits equal credits.
  • Flags differences if the workbook is out of balance.

• Final Accounts Preview
  • Provides a draft Income Statement and Balance Sheet after adjustments.
  • Ensures that adjustments have been reflected correctly.

Key Calculations & Outputs

• Depreciation & Amortization Schedules based on asset cost and useful life.
• Accruals & Prepayments Reversals that roll into the new year.
• Provision Percentages (e.g., % of receivables for doubtful debts).
• Tax Payable Estimates based on adjusted profit.
• Balanced Journal Entries ready to post to the ledger.

Who Should Use It

• Accountants & Bookkeepers – for preparing year-end accounts.
• Auditors – to review adjustment schedules and reconciliations.
• Business Owners – to understand the adjustments behind their annual accounts.