|
part 1, part 3, part 4
Creditors Ledger
With the transactions shown in part 1, let us produce the ledger card for the Service & Parts Co. We will also assume that we owed them €500 at the beginning of the year.
|
SER01 - Service & Parts Co.
|
|
|
|
DR |
|
|
|
CR |
| Date |
Details |
Folio |
Amount |
Date |
Details |
Folio |
Amount |
| 14/1/06 |
Cheque 1045 |
BP1 |
500.00 |
1/1/06 |
Balance b/f |
|
500.00 |
| 31/1/06 |
Balance c/f |
|
121.00 |
3/1/06 |
Invoice 39516 |
PB1 |
121.00 |
|
|
|
________ |
|
|
|
________ |
|
|
|
621.00 |
|
|
|
621.00 |
|
|
|
________ ________ |
|
|
|
________ ________ |
|
|
|
|
1/2/06 |
Balance b/f |
|
121.00 |
|
|
|
|
|
|
|
|
The folio reference points back to the bank payments daybook (BP1 - Bank Payments, Page 1) and to the purchase invoices daybook (PB1 - Purchase Invoices, Page 1) The layout of the card with balance b/f (brought forward) on the credit side and balance c/f (carried forward) on the debit side ensures that you can always calculate how much you owe a supplier. The balance c/f is always the balancing amount on the ledger card i.e. when you subtract the debits from the credits (payments from the invoices) this is how much you owe the supplier. When you create a list of suppliers you owe money to you always take the balance b/f amount. So for the 31st January, the amount owed is the balance b/f for the next month being the 1st February (1/2/06).
Debtors Ledger
With the transactions shown in part 1, let us produce the ledger card for JB & Co. and Red Tails Ltd and we will also assume that at the beginning of the year they owed us €1135 and €1210 respectively.
|
JBC01 - JB & Co.
|
|
|
|
DR |
|
|
|
CR |
| Date |
Details |
Folio |
Amount |
Date |
Details |
Folio |
Amount |
| 1/1/06 |
Balance |
b/f |
1135.00 |
9/1/06 |
Receipt |
BR1 |
1135.00 |
| 2/1/06 |
Invoice 101 |
SI1 |
1210.00 |
|
|
|
|
| 10/1/06 |
Invoice 102 |
|
1135.00 |
31/1/06 |
Balance c/f |
|
2345.00 |
|
|
SI1 |
________ |
|
|
|
________ |
|
|
|
3480.00 |
|
|
|
3480.00 |
|
|
|
________ ________ |
|
|
|
________ ________ |
| 1/2/06 |
Balance b/f |
|
2345.00 |
|
|
|
|
|
|
|
|
|
|
|
|
|
RED01 - Red Tails Ltd.
|
|
|
|
DR |
|
|
|
CR |
| Date |
Details |
Folio |
Amount |
Date |
Details |
Folio |
Amount |
| 1/1/06 |
Balance |
b/f |
1210.00 |
15/1/06 |
Receipt |
BR1 |
1210.00 |
| 21/1/06 |
Invoice 103 |
SI1 |
605.00 |
31/1/06 |
Balance c/f |
|
605.00 |
|
|
|
________ |
|
|
|
________ |
|
|
|
1810.00 |
|
|
|
1810.00 |
|
|
|
________ ________ |
|
|
|
________ ________ |
| 1/2/06 |
Balance b/f |
|
605.00 |
|
|
|
|
|
|
|
|
|
|
|
|
The folio reference points back to the bank receipts daybook (BR1 - Bank Receipts, Page 1) and to the Sales invoices daybook (SI1 - Sales Invoices, Page 1) The layout of the card with balance b/f (brought forward) on the debit side and balance c/f (carried forward) on the credit side ensures that you can always calculate how much a customer owes you. The balance c/f is always the balancing amount on the ledger card i.e. when you subtract the credits from the debits (receipts from the invoices) this is how much the customer owes you. When you create a list of customers who owe you money, you always take the balance b/f amount. So for the 31st January, the amount owed is the balance b/f for the next month being the 1st February (1/2/06).
Bank Account Ledger
We will now add an additional transaction for wages to the transactions shown in part 1, and produce our bank account ledger card. We will assume that we had €2,500 in our bank account at the beginning of the year.
The Bank Payments Daybook, page 1
| Date |
Payee |
No. |
Folio |
Amount |
| 14/1/06 |
Service & Parts Co. |
1045 |
SER01 |
500.00 |
| 30/1/06 |
Wages |
1046 |
NL713 |
1900.00 |
|
|
|
|
|
|
TOTALS |
|
|
2400.00 |
|
|
|
|
|
NL713 is the nominal ledger for net wages (wages paid)
|
NL601 - AIB Bank Current A/c
|
|
|
|
DR
|
|
|
|
CR
|
| Date |
Details |
Folio |
Amount
|
Date |
Details |
Folio |
Amount
|
| 1/1/06 |
Balance b/f |
|
2500.00
|
31/1/06 |
Total Payments |
BP1 |
2400.00
|
| 31/1/06 |
Total Receipts |
BR1 |
2345.00
|
31/1/06 |
Balance c/f |
|
2445.00
|
|
|
|
________
|
|
|
|
________
|
|
|
|
4845.00
|
|
|
|
4845.00
|
|
|
|
________ ________
|
|
|
|
________ ________
|
| 1/2/06 |
Balance b/f |
|
2445.00
|
|
|
|
|
Note: We could also enter each receipt and payment individually in this bank account instead of the totals. Entering the totals makes it quicker.
The folio reference points back to the bank receipts daybook (BR1 - Bank Receipts, Page 1) and to the bank payments daybook (BP1 - Bank Payments, Page 1) The layout of the card with balance b/f (brought forward) on the debit side and balance c/f (carried forward) on the credit side ensures that you can always calculate how much is in your bank account. The balance c/f is always the balancing amount on the ledger card i.e. when you subtract the credits from the debits (receipts from the payments) this is how much money you have in the bank. When you create a list of your bank accounts (you can have more than one, but usually the list contains only one), you always take the balance b/f amount. So for the 31st January, the amount is the balance b/f for the next month being the 1st February (1/2/06).
So we now have the following lists at 31/1/06
|
Dr |
Cr |
|
| BANK ACCOUNTS |
|
|
|
| AIB Bank Current A/c |
2445.00 |
|
|
| DEBTORS |
|
|
|
| JB & Co. |
2345.00 |
|
|
| Red Tails Ltd |
605.00 |
|
|
| CREDITORS |
|
|
|
| Service & Parts Co. |
|
121.00 |
|
So from this list we now know
- How much money we have
- How much we are owed
- How much we owe
What we don't know is how much money we have made. We need a profit & loss statement and for that we need to create nominal ledger accounts. We also need to know our wages costs and with the addition of a wages payment to our bank account, we need to record wages transactions in the General Journal daybook.
General Journal Daybook, Page 1
| Date |
Details |
Folio |
Dr |
Cr |
| 30/1/06 |
Gross Wages |
NL330 |
3000.00 |
|
| 30/1/06 |
Employers PRSI |
NL331 |
300.00 |
|
| 30/1/06 |
Employee Prsi |
NL712 |
|
500.00 |
| 30/1/06 |
Employee Tax |
NL712 |
|
600.00 |
| 30/1/06 |
Employee Net Pay |
NL713 |
|
1900.00 |
| 30/1/06 |
Employers Prsi |
NL712 |
|
300.00 |
|
|
|
_______ |
_______ |
|
|
|
3300.00 |
3300.00 |
|
|
|
_______ _______ |
_______ _______ |
| being wages for the month of January 2006 |
Now we are ready for part 3 to build our nominal ledger and create our profit and loss statement and balance sheet.
article:100028
(c) Nilsson Denver Ltd 2007
|