Preparing an Analysed Cash Book (Junior Cert Business Studies): Revision Notes
Preparing an Analysed Cash Book
An analysed cash book is a fundamental tool for tracking personal and household finances. Understanding how to create and use one will help you monitor where your money comes from and where it goes each month.
What is an analysed cash book?
An analysed cash book is an account that records all of an individual or household's receipts (income) and payments (expenditure) during a specific time period.
The key feature of an analysed cash book is its analysis columns. These special columns break down different types of income and expenditure into specific categories such as:
- Wages (income)
- Groceries (expenditure)
- Electricity bills (expenditure)
- Car expenses (expenditure)
- Phone costs (expenditure)
- Entertainment (expenditure)
This categorisation allows you to see exactly where your money is coming from and where it's being spent, making it easier to manage your finances effectively.
The power of an analysed cash book lies in its ability to transform a simple list of transactions into meaningful financial insights through systematic categorisation.
Structure and layout
An analysed cash book follows a standard double-entry format with two main sides:
Debit side (Dr) - money coming in
- Records all income and receipts
- Located on the left side of the page
- Shows money flowing into your accounts
Credit side (Cr) - money going out
- Records all expenditure and payments
- Located on the right side of the page
- Shows money flowing out of your accounts
Standard columns explained
Every analysed cash book contains these essential columns on both sides:
Basic columns
- Date: Shows when each transaction occurred (entered chronologically from earliest to latest)
- Details: Describes what each transaction was for (e.g. wages, groceries, electricity bill)
- Total: Shows the complete value of cash received or paid out
Analysis columns
These are the specialised columns that make the cash book "analysed". Common categories include:
- Wages/Other: For different types of income
- Groceries: For food shopping expenses
- Electricity: For utility bills
- Car: For vehicle-related costs
- Phone: For mobile and communication costs
- Entertainment: For leisure activities
Each transaction appears in both the Total column and its relevant analysis column, ensuring everything is properly categorised and nothing is missed.
Recording cash-only transactions
When you only deal in cash, your analysed cash book focuses purely on physical money movements. Here's how it works:
Worked Example: Aoife Murphy's October 2023 Cash Transactions
Let's say Aoife Murphy wants to track her October 2023 finances using cash only:
- Oct 1: Opening cash balance €300
- Oct 5: Received wages €450
- Oct 8: Bought groceries €65
- Oct 12: Paid electricity bill €45
- Oct 15: Bought petrol €35
- Oct 20: Received bonus €100
- Oct 25: Bought concert tickets €40
Step-by-step recording process:
- Record the opening balance on the debit side
- Enter wage and bonus income in both the Total column and Wages/Other analysis columns on the debit side
- Record all expenditure in both the Total column and appropriate analysis columns on the credit side
- Calculate totals for each column
- Work out the closing balance
Result: The analysis columns instantly show Aoife that she spent €65 on groceries, €45 on electricity, €35 on car expenses, and €40 on entertainment during October.
Recording bank-only transactions
Modern life often involves electronic payments rather than cash. Bank transactions are recorded in exactly the same way as cash transactions in an analysed cash book.
Worked Example: Liam O'Brien's October 2023 Bank Transactions
Consider Liam O'Brien's October 2023 bank transactions:
- Oct 1: Opening bank balance €500
- Oct 6: Wages paid into bank €1,100
- Oct 10: Phone bill paid from bank €75
- Oct 15: Groceries paid by debit card €95
- Oct 18: Electric Ireland bill from bank €180
- Oct 22: Sold bicycle online, payment into bank €80
- Oct 28: Car tax paid from bank €300
Recording process:
- Income goes on the debit side (wages, bicycle sale)
- Expenditure goes on the credit side (phone, groceries, electricity, car tax)
- Each transaction appears in both Total and relevant analysis columns
- The bank balance is calculated at month-end
Analysis results: Liam spent €95 on groceries, €180 on electricity, €300 on car expenses, and €75 on phone costs.
Benefits of using analysis columns
Analysis columns transform a simple list of transactions into a powerful financial tool:
Key Benefits of Analysis Columns:
- Budget monitoring: See exactly how much you spend in each category
- Trend identification: Spot patterns in your spending habits
- Financial planning: Use the information to create realistic budgets
- Cost control: Identify areas where you might be overspending
- Income tracking: Monitor different sources of income
Recording mixed transactions
In reality, most people use both cash and bank transactions. The same analysed cash book format works perfectly for this situation - you simply record each transaction according to whether it was cash or electronic, maintaining the same column structure throughout.
The beauty of the analysed cash book system is its flexibility - whether you're dealing with cash, bank transactions, or a combination of both, the fundamental recording principles remain consistent.
Key Points to Remember:
- An analysed cash book categorises all your income and expenditure into specific columns
- The debit side records money coming in, the credit side records money going out
- Each transaction appears in both the Total column and its relevant analysis column
- Analysis columns help you understand your spending patterns and manage your budget effectively
- The same format works for cash-only, bank-only, or mixed transactions