Recording Transactions: Manual Methods and ICT (Spreadsheets)

1. The Accounting Process Overview

The accounting process is a series of steps businesses undertake to record, classify, summarize, and report financial transactions to provide useful information for decision-making. The accounting process consists of three stages:
1. Source Documents: Collecting and verifying evidence of transactions.
2. Recording: Sorting, classifying, and summarizing data into accounting records.
3. Reporting: Preparing financial statements to communicate financial information.

KEY TAKEAWAY: The accounting process transforms raw financial data into useful information for stakeholders.

2. Source Documents

• Definition: Original records that provide evidence that a transaction has occurred.
• Examples:
  • Cash Receipt: Proof of cash received from customers.
  • Cheque Butt: Record of payment made by cheque.
  • Invoice: Request for payment for goods or services sold on credit.
  • Credit Note: Document issued to a customer when goods are returned or an allowance is granted.
  • Debit Note: Document issued to a supplier when goods are returned or an allowance is being requested.
• Importance:
  • Verifiability: Provides objective evidence to support transactions.
  • Accuracy: Ensures data recorded is reliable.
  • Audit Trail: Creates a traceable record of transactions.

REMEMBER: Source documents are the foundation of the accounting process. “No document, no entry!”

3. Recording Transactions: Manual Methods

3.1. Journals

• Definition: A chronological record of all transactions. Also known as the book of original entry.
• Purpose:
  • Chronological Order: Records transactions in date order.
  • Double-Entry Accounting: Ensures every transaction affects at least two accounts.
• Types of Journals:
  • General Journal: Used for all types of transactions, especially those not handled by special journals.
    • Format:
      • Date
      • Account Name and Explanation
      • Folio (Ledger Page Number)
      • Debit (\$)
      • Credit (\$)
  • Special Journals: Used to record specific types of transactions:
    • Cash Receipts Journal (CRJ): Records all cash inflows.
    • Cash Payments Journal (CPJ): Records all cash outflows.
    • Purchases Journal (PJ): Records all credit purchases of inventory.
    • Sales Journal (SJ): Records all credit sales of inventory.

3.2. Ledgers

• Definition: A collection of all the accounts of a business.
• Purpose:
  • Summarize Transactions: Groups transactions by account.
  • Calculate Balances: Determines the current balance of each account.
• Types of Ledgers:
  • General Ledger: Contains all asset, liability, owner’s equity, revenue, and expense accounts.
    • T-Account Format:
      • Left Side: Debit
      • Right Side: Credit
    • Running Balance Format: Shows the balance after each transaction.
  • Subsidiary Ledgers: Provide detailed information for specific accounts in the general ledger:
    • Accounts Receivable Ledger: Lists individual customer accounts.
    • Accounts Payable Ledger: Lists individual supplier accounts.
• Posting: The process of transferring information from journals to ledgers.

EXAM TIP: Understand the flow of data: Source Document -> Journal -> Ledger -> Financial Statements

3.3. The Trial Balance

• Definition: A list of all general ledger accounts and their balances at a specific date.
• Purpose:
  • Verify Accuracy: Checks if total debits equal total credits, ensuring the accounting equation is in balance (Assets = Liabilities + Owner’s Equity).
  • Preparation for Financial Statements: Provides a summary of account balances used to prepare the Income Statement and Balance Sheet.
• Limitations:
  • Does not guarantee complete accuracy. Errors like transposing numbers or omitting transactions can still occur.
  • Only detects errors in the equality of debits and credits.

COMMON MISTAKE: Confusing the Trial Balance with the Balance Sheet. The Trial Balance is internal and used to check equality; the Balance Sheet is a financial statement presented to external users.

4. Recording Transactions: ICT (Spreadsheets)

4.1. Advantages of Using Spreadsheets

• Efficiency: Automates calculations and reduces manual effort.
• Accuracy: Minimizes errors through formulas and data validation.
• Speed: Processes large volumes of data quickly.
• Flexibility: Easily customizable to suit specific business needs.
• Reporting: Generates reports and charts automatically.

4.2. Spreadsheet Functions in Accounting

• Data Entry: Entering transaction data into cells.
• Formulas: Performing calculations (e.g., SUM, AVERAGE, IF).
• Functions: Using built-in functions for accounting tasks (e.g., calculating GST, depreciation).
• Filtering and Sorting: Analyzing data by specific criteria.
• Pivot Tables: Summarizing large datasets for reporting.
• Charting: Creating visual representations of financial data.

4.3. Spreadsheet Applications in Accounting

• General Ledger: Creating and maintaining ledger accounts.
• Trial Balance: Preparing trial balances to ensure accuracy.
• Financial Statements: Generating Income Statements, Balance Sheets, and Cash Flow Statements.
• Budgeting: Developing and monitoring budgets.
• Inventory Management: Tracking inventory levels and costs.
• GST Calculations: Calculating and tracking GST payable and receivable.

4.4. Example: Using Spreadsheets for GST Calculation

1. Set up Columns: Create columns for Date, Description, Amount, GST, and Total.
2. Enter Data: Input transaction details, including the pre-GST amount.
3. Calculate GST: Use the formula =Amount*0.1 in the GST column (assuming GST is 10%).
4. Calculate Total: Use the formula =Amount+GST in the Total column.
5. Summarize GST: Use the SUM function to calculate total GST payable and receivable.

APPLICATION: Spreadsheets are widely used in small businesses for managing their finances and preparing reports for tax purposes.

4.5. Example: Using Spreadsheets for a Trial Balance

1. Set up Columns: Create columns for Account Name, Debit, and Credit.
2. Enter Data: Input each account name and its respective debit or credit balance from the General Ledger.
3. Calculate Totals: Use the SUM function to calculate the total debits and total credits.
4. Verify Accuracy: Ensure that the total debits equal the total credits.

4.6. Example: Using Spreadsheets for a Bank Reconciliation

1. Set up Columns: Create columns for Bank Statement Balance, Add: Deposits in Transit, Less: Outstanding Cheques, Adjusted Bank Balance, and other relevant details.
2. Enter Data: Input the Bank Statement Balance.
3. Enter Deposits in Transit: Input the amounts for deposits not yet recorded by the bank.
4. Enter Outstanding Cheques: Input the amounts for cheques issued but not yet cleared by the bank.
5. Calculate Adjusted Bank Balance: Use the formula =Bank Statement Balance + Deposits in Transit - Outstanding Cheques.

STUDY HINT: Practice creating spreadsheets for different accounting tasks to develop proficiency.

5. The Goods and Services Tax (GST)

5.1. What is GST?

• Definition: A 10% tax on most goods, services and other items sold or consumed in Australia.
• Purpose: A broad-based consumption tax.

5.2. Accounting for GST

• GST on Sales (GST Collected): The business collects GST from customers on taxable sales and holds it on behalf of the ATO (Australian Taxation Office). This is a liability account.
• GST on Purchases (GST Paid): The business pays GST on taxable purchases. This is an asset account.
• GST Clearing Account: A temporary account used to record GST collected and GST paid.
• BAS (Business Activity Statement): A form lodged with the ATO to report GST obligations.

5.3. GST Journal Entries

• Credit Purchase:
  • Debit Inventory (Ex GST amount)
  • Debit GST Paid
  • Credit Accounts Payable
• Credit Sale:
  • Debit Accounts Receivable
  • Credit Sales Revenue (Ex GST amount)
  • Credit GST Collected
• Cash Payment for Expenses:
  • Debit Expense (Ex GST amount)
  • Debit GST Paid
  • Credit Cash
• Cash Receipt for Sales:
  • Debit Cash
  • Credit Sales Revenue (Ex GST amount)
  • Credit GST Collected
• Payment of GST to ATO:
  • Debit GST Collected
  • Credit GST Paid
  • Credit Cash (for the net amount paid to the ATO)

VCAA FOCUS: VCAA frequently tests the understanding of GST journal entries and the impact of GST on financial statements.