Step 4 - Entering current year postings - Limited Company tutorial (ELTD)

 

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.

 

Running opening balances

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.

 

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 image\ebd_34.gif next to the document type number field when starting a new batch.

 

Starting a new batch

When in the postings screen select Batch control | New to display the Specify Posting Batch panel.

Use the magnifying glass image\ebd_35.gif 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.

 

Posting the control accounts

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.

 

Bank control account

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.

 

Purchases control account

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.

 

Sales control account

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

 

 

 

 

 

 

 

Reversing journals

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.

 

Journal Entries

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.

 

Hire Purchase Account

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.