The computerized accounting cycle

Learning goals

• Configure and test a computerized file for a service or merchandising company.
• Record an Ontario HST transaction and verify the tax-control accounts.
• Use batch reports, audit trails, permissions, and reconciliations as controls.
• Explain which judgements software cannot make for the accountant.

Prerequisite check

Name the stages software accelerates but does not eliminate: source capture, journalizing, posting, trial balance, adjustments, statements, and closing. A computer can post a wrong entry perfectly; evidence and review still matter.

Vocabulary

• Control account: general-ledger account supported by a detailed subledger.
• Audit log: dated record of users' entries and changes.
• Batch: group of transactions processed and reviewed together.
• HST recoverable: input tax credit receivable on eligible business purchases.
• HST payable: tax collected from customers for remittance.
• Role-based access: permissions limited to a user's duties.

Core idea

A reliable computerized cycle combines configuration, accurate master data, controlled entry, reconciliation, and review. Automation replaces repeated arithmetic and posting; it does not replace recognition, estimates, ethics, or professional judgement.

Why this treatment makes sense

Subledgers let a company know both the total Accounts Receivable and each customer's balance. HST control accounts separate the business's revenue and expenses from tax collected or recoverable. Audit logs and access limits make errors traceable and reduce the opportunity for one person to create, approve, and conceal a transaction.

A repeatable method

1. Create a test company with correct fiscal dates, currency, HST settings, and chart of accounts.
2. Enter opening balances and confirm the opening trial balance.
3. Build customers, suppliers, inventory items, payment terms, and tax codes.
4. Enter a small known batch from source documents.
5. Run the journal, tax report, receivable/payable aging, and trial balance.
6. Reconcile subledger totals to control accounts and bank data to Cash.
7. Post authorized adjustments, generate statements, lock the period, and back up.

Worked example

On May 6, Pixel North Ltd. sells inventory for $2,000 plus 13% HST on account. The inventory cost is $1,180 and the company uses a perpetual system.

Table: Perpetual credit sale with Ontario HST

The invoice, customer subledger, and control account must all show $2,260. Revenue excludes HST because the $260 is collected for the government. Gross profit is $820, not $1,080.

Pixel North then buys eligible office supplies for $400 plus $52 HST in cash: debit Supplies $400, debit HST Recoverable $52, credit Cash $452. If these are the only HST transactions, net HST payable is $260 − $52 = $208.

Journal, ledger, and statement connection

The sales module can generate the journal entry and update the customer record, general ledger, inventory quantity, and cost of goods sold. The statement of financial position reports net HST payable $208 and receivables $2,260; the income statement reports sales $2,000 and cost of goods sold $1,180. Run the journal report to prove what the module posted rather than assuming its label was configured correctly.

Common mistakes

• Including HST in revenue or inventory cost when an input tax credit is available.
• Letting Accounts Receivable differ from the customer subledger total.
• Deleting an error instead of preserving an audit trail with a reversal/correction.
• Sharing administrator credentials or allowing the same user to create and approve suppliers.
• Trusting imported spreadsheet dates, signs, or duplicate invoice numbers without validation.

Guided practice

A service invoice is $1,500 plus $195 HST. The customer pays immediately by card; the processor deposits $1,656 and charges a $39 fee. Record debit Cash $1,656, debit Card Processing Expense $39, credit Service Revenue $1,500, and credit HST Payable $195. Reconcile the $1,656 deposit to the processor report.

Independent practice

1. Record a cash purchase of eligible inventory costing $3,000 plus 13% HST.
2. A customer subledger totals $18,420 but Accounts Receivable is $18,240. Name two reports to inspect.
3. Design one preventive and one detective control for supplier payments.
4. Explain why a locked period should be reopened only through approval.

Self-check and solutions

1. Debit Inventory $3,000; debit HST Recoverable $390; credit Cash $3,390.
2. Compare the receivable aging/subledger report with the general-ledger detail and the batch or audit log; look for a $180 posting, mapping, or date difference.
3. Preventive: separate supplier creation from payment approval. Detective: an independent reviewer compares the payment batch with invoices and bank activity.
4. Reopening can silently change issued statements and tax reports. Approval and an audit-log explanation preserve accountability.

Retrieval practice

1. Is HST collected revenue?
2. What should equal the Accounts Receivable control account?
3. Name one judgement software cannot automate reliably.

Answers: no; the customer subledger total; examples include whether revenue is earned, an asset is impaired, or an estimate is reasonable.

Exam-style application

The controller can create vendors, approve purchases, release electronic payments, and edit the audit log. Write a control recommendation and explain the risk.

Model response: Separate vendor maintenance, purchase approval, and payment release among authorized people, and make the audit log immutable to ordinary users. Current access lets one person create a fake supplier, approve a false invoice, pay it, and conceal the trail. A monthly independent vendor-change and payment review adds a detective control.

Lesson summary

Computerized accounting is reliable only when configuration, evidence, subledger reconciliations, HST logic, access, and audit trails work together. Automation changes speed and scale, not the need for accounting reasoning.