The current year postings are to be entered from working papers rather than entering a trial balance.
Select Posting | New to add a new posting entry
Enter the Description as 2008 Working Papers
Leave the Currency set to UK Pound - £
Select the magnifying glass next to the Account period end field. The Accounting Periods panel will appear. Select the period ending 31/3/08
Select the magnifying glass next to Previous account period end date and select 31/03/2007.
Select OK again to accept the post file entry screen.
Start a batch of Document type 1 and select OK
You will be asked if you want to generate opening balances, reply Yes.
A panel asks you to select the year you wish to bring forward the opening balances from. Make sure that last year (2007) is highlighted and click OK.
A panel asks you to confirm the date for the opening balance postings. The default date provided, the first day of the accounting period, is correct so select OK.
You will see the opening balances being generated on the posting screen. Once the opening balances have been run we can start making the postings from the working papers using double entry document types.
The document type selected when a new batch is started determines the treatment of postings made in that batch. To post the trial balance for the comparative year we used a journal document type and made all the postings manually.
To post the control accounts we can use double entry document types. These document types allow you to post one side of an entry and Accounts Production automatically makes the corresponding debit or credit to the nominated control account.
Accounts Production is issued with some pre-set document types. A list of these can be displayed by using the magnifying glass next to the document type number field when starting a new batch.
When in the postings screen select Batch control | New to display the Specify Posting Batch panel.
Use the magnifying glass next to the Document Type field to display the list of all document types.
Select document type 4 CB Cash Book This completes the document type field on the screen.
Select OK to accept the details of the new batch. You are taken back into the postings option, but now the document type at the top left of the screen is for cash book postings.
We can now start making the cash book postings using the double entry document type. Only one side of each posting needs to be entered. Accounts Production automatically makes the other side of the posting to the nominated control account.
All postings on the credit side of the bank control account are posted as debits on the postings screen (i.e. you are posting the debit to the expense account, IRIS posts the credit to the control account).
Shown below is the working paper for the bank account with the description of each of the totals, the account to which the posting should be made and the amount to be posted. Make the postings accordingly.
Notice how before you begin posting the balance displayed for the DE Balance field (account 692) is £4000. As the postings for the control account are made the balance changes to show you the current balance on the bank control account. When the cash book postings are complete this balance should be £10174.
Make the posting for the first of the items in the bank control account as follows:
Amount |
236133.00 |
Dr/Cr field |
D |
Account |
737 |
Narrative |
Bank control account postings |
Date |
31/3/08 |
For the directors' remuneration and national insurance, the account numbers are marked with a *1 or *2, which matches the accounting order of the director that figure is in relation to.
Description |
A/C |
£ |
Description |
A/C |
£ |
Balance B/F |
B/F |
4,000 |
Purchase payments |
737 |
236,133 |
Sales receipts |
586 |
368,910 |
Hire purchase payment |
909 |
2,944 |
Car receipt |
392/14 |
1,260 |
Directors' remuneration |
254/1*1 |
24,000 |
Rent received |
89 |
3,000 |
Directors rem |
254/1*2 |
24,000 |
Interest |
130 |
320 |
Directors NI |
254/5*1 |
2,496 |
|
|
|
Directors NI |
254/5*2 |
2,496 |
|
|
|
Employees wages |
44 |
25,007 |
|
|
|
Employees NI |
45 |
2,600 |
|
|
|
Corporation tax |
747 |
825 |
|
|
|
Deposit re car |
525/52 |
1,000 |
|
|
|
Subs |
291/1 |
100 |
|
|
|
HMC & E |
755 |
20,715 |
|
|
|
Loan repayment |
849 |
20,000 |
|
|
|
Loan interest |
414 |
5,000 |
|
|
|
Balance C/D |
C/D |
10,174 |
|
|
377,490 |
|
|
377,490 |
|
|
|
|
|
|
Once the bank account postings have been entered we can move on to post the other working papers. Before posting the next control account you must change the document type.
Select Batch control | New. Complete the Specify posting batch screen with document type 6 PDB Purchase Day Book. Now you are posting the debit side to the expense accounts and IRIS posts the credit to the control account.
Remember to alter the narrative.
Description |
A/C |
£ |
Description |
A/C |
£ |
|
|
|
Balance B/F |
B/F |
25,000 |
Payments per cash book (already entered) |
|
236,133 |
Purchases |
27 |
192,550 |
|
|
|
Equipment additions |
523/2 |
1,000 |
|
|
|
VAT |
735 |
33,550 |
|
|
|
Sundries |
280 |
135 |
|
|
|
Accountancy |
285 |
1,500 |
|
|
|
Legal |
290 |
500 |
|
|
|
Light & heat |
233 |
2,090 |
|
|
|
Repairs |
234 |
1,820 |
|
|
|
Telephone |
263 |
835 |
|
|
|
Insurance |
232 |
430 |
|
|
|
Motor |
267 |
1,630 |
|
|
|
Postage |
264 |
187 |
Balance C/D |
C/D |
25,094 |
|
|
|
|
|
261,680 |
|
|
261,680 |
|
|
|
|
|
|
The next control account to be completed is the sales control. Select Batch control | New. This time start a batch of document type 7 SDB Sales Day Book double entry postings.
Remember to alter the narrative.
Description |
A/C |
£ |
Description |
A/C |
£ |
Balance B/F |
B/F |
2,000 |
Receipts (already entered) |
|
368,910 |
Sales |
1 |
315,260 |
|
|
|
Vat |
735 |
55,170 |
|
|
|
|
|
|
Balance C/D |
C/D |
3,520 |
|
|
372,430 |
|
|
372,430 |
|
|
|
|
|
|
Accruals and prepayments can be made using a document type that reverses when opening balances are run next year. Select Batch control | New. This time start a batch of document type 8 ACC Accruals.
Delete the narrative.
Make the following postings. Note that only the debit side of the posting needs to be made. Accounts Production automatically posts the credit side of the posting to accruals in the balance sheet.
Nominal Description |
Dr A/c No |
Dr £ |
Light and heat |
233 |
560 |
Telephone |
263 |
190 |
Accountancy |
285 |
1,700 |
Being the accruals for 2001 |
Select Batch control | New. This time start a batch of document type 9 PRE Prepayments.
Make the following postings.
Nominal Description |
Cr A/c No |
Cr £ |
Motor expenses |
267 |
25 |
Insurance |
232 |
130 |
Being the prepayments for 2001 |
When asked the question 'Debit expected, credit entered. Change amount?' Click No.
Now that the main control accounts and reversing entries have been posted some journal entries need to be made. Select Batch control | New. This time start a batch of document type 11 JNL Journals.
Nominal Description |
A/c No |
Dr £ |
Cr £ |
Motor vehicle expenses |
267 |
25 |
|
Insurance |
232 |
125 |
|
Prepayments |
614 |
|
150 |
Accruals |
786 |
2,200 |
|
Telephone |
263 |
|
200 |
Light & heat |
233 |
|
500 |
Accountancy |
285 |
|
1,500 |
Directors’ remuneration |
254/1*1 |
|
521 |
Directors’ remuneration |
254/1*2 |
|
521 |
Directors’ NI |
254/5*1 |
|
192 |
Directors’ NI |
254/5*2 |
|
192 |
Employees’ wages |
44 |
|
477 |
Employees’ N.I |
45 |
|
200 |
PAYE & NI creditor |
755 |
2,103 |
|
Being the reversal of 2000 accruals and prepayments |
Freehold depreciation P&L |
390/1 |
2,000 |
|
Freehold depreciation BS |
512/22 |
|
2,000 |
Machinery and Equipment depreciation P&L |
66/1 |
3,450 |
|
Machinery and Equipment depreciation BS |
523/22 |
|
3,450 |
Motor vehicle depreciation P&L |
390/14 |
3,250 |
|
Motor vehicle depreciation BS |
525/22 |
|
3,250 |
Being depreciation charge for year |
Motor vehicle accumulated depreciation |
525/23 |
8,204 |
|
Motor vehicle disposal |
392/14 |
3,796 |
|
Motor vehicle cost |
525/3 |
|
12,000 |
Being disposal of motor vehicle |
Stock - balance sheet |
569 |
15,000 |
|
Stock - profit and loss account |
74 |
|
15,000 |
Being stock adjustment |
Tax charge - profit and loss |
442 |
3,971 |
|
Tax creditor |
747 |
|
3,971 |
Being tax charge for the year |
Loans |
857 |
20,000 |
|
Loans due within one year |
849 |
|
20,000 |
Being adjustment for correct disclosure |
Directors’ remuneration |
254/1*1 |
521 |
|
Directors’ remuneration |
254/1*2 |
521 |
|
Directors’ NI |
254/5*1 |
192 |
|
Directors’ NI |
254/5*2 |
192 |
|
Employees’ wages |
44 |
470 |
|
Employees’ NI |
45 |
200 |
|
PAYE & NI creditor |
755 |
|
2,096 |
Being creditor for PAYE and NI as at the year end. |
The final journals to be entered are regarding the motor vehicle purchased on hire purchase during the year. The control account is laid out below. The repayments have already been posted from the Bank Control Account so we need to journal in the remaining entries, splitting the amounts as appropriate for the disclosure requirements.
Description |
A/C |
£ |
Description |
A/C |
£ |
Interest |
|
1,248 |
Car cost and interest |
|
13,248 |
Repayments |
|
2,944 |
Interest charge |
|
487 |
Creditor C/D |
C/D |
10,304 |
Interest C/D |
C/D |
761 |
|
|
14,496 |
|
|
14,496 |
|
|
|
|
|
|
Nominal Description |
A/c No |
Dr £ |
Cr £ |
Interest paid |
426 |
487 |
|
Leased motor vehicles additions |
525/52 |
12,000 |
|
Hire purchase - interest due within 1 year |
912 |
506 |
|
Hire purchase - interest due in more than one year |
913 |
255 |
|
Hire purchase - liability falling due within 1 year |
909 |
|
2,944 |
Hire purchase - liability falling due within 1 year |
909 |
|
4,416 |
Hire Purchase - liability falling due after more than 1 year |
910/1 |
|
5,888 |
Being the hire purchase agreement taken out during the year |
Select Close to exit the Posting option.