Computerized Accounting

Junior accountant, accounting assistant, bookkeeper using accounting software — I record, classify and reconcile transactions in accounting software, not only in a spreadsheet.

Modules

M1 — From the spreadsheet to the ledger

Why accounting software is not just a bigger spreadsheet, and how SYSCOHADA accounts are organised.

• What accounting software actually does — Journals, ledgers, trial balance, and why the software enforces double entry.
• The SYSCOHADA chart of accounts in software — Account classes, grouping, auxiliary ledgers, and the difference between PCG and SYSCOHADA menus.
• Setting up a company file — Fiscal year, currency, VAT regime, users and backup policy.

M2 — Excel as an accounting control tool

Use spreadsheets to prepare, check and present data before and after entering it in the ledger.

• Clean data entry tables — Validation, drop-down lists, dates and numbers that import correctly.
• Reconciliation helpers — VLOOKUP/XLOOKUP, INDEX/MATCH, conditional formatting for unmatched items.
• Pivot reports for accountants — Summarise transactions by account, month, customer or supplier before importing.
• Macros that save time without breaking the file — Record and edit a simple macro to format an import file.

M3 — Daily operations in Odoo and Sage

Record the transactions that happen every day: sales, purchases, cash, bank, expenses.

• Customer invoices and receipts — Create invoices, record payments, match receipts and chase aged balances.
• Supplier invoices and payments — Purchase orders, bills, payment terms, withholding tax and supplier credits.
• Cash and petty cash — Petty cash journals, expense claims and cash counts.
• Bank reconciliation — Import a statement, match items, clear differences and post adjustments.

M4 — Month-end, reports and compliance

Close the month, correct errors, produce the documents the accountant and the tax office expect.

• Adjusting and closing entries — Depreciation, accruals, prepayments, VAT adjustments and error corrections.
• The general ledger, trial balance and supporting schedules — Run the reports, check balances and prepare an audit trail.
• Export, backup and archiving — What to print, what to export, how long to keep it, and how to hand it over.

Capstone

Month-end close for a SYSCOHADA practice company

You receive a starter file, thirty days of transactions and a bank statement. You must enter all transactions in Odoo Community, reconcile the bank, post adjusting entries, and produce a clean general ledger, trial balance and aged receivables/payables report.

What you earn

• Free completion records from the open providers, in their own name
• The LES Institute OHADA Bridge workbook and your assessed capstone file
• An LES Institute Certificate — Computerized Accounting (SYSCOHADA)

Requirements

• Secondary school completion
• Basic bookkeeping or completion of Accounting Level 1 (recommended)
• A laptop or desktop computer (accounting software is not practical on a phone)
• Teaching in French or English, your choice