Appendix 3

For Microsoft Word

System data

   [#Date#]                             Today's date

              [#Firm#]                             Your firm's name

              [#Firm Add 1#]                   Your firm's address line 1

              [#Firm Add 2#]                   Your firm's address line 2

              [#Firm Add 3#]                   Your firm's address line 3

              [#Firm Add 4#]                   Your firm's address line 4

              [#Firm Add 5#]                   Your firm's address line 5

              [#Reference#]                    Document file name (prefix only)

              [#Title#]                             Document title

              [#Author#]                         Document author

Client data

              [#Code#]                            Client's audit pack code

              [#Name#]                           Client's name

              [#Add 1#]                           Address line 1

              [#Add 2#]                           Address line 2

              [#Add 3#]                           Address line 3

              [#Add 4#]                           Address line 4

              [#Add 5#]                           Address line 5

              [#Address#]                       Client's address

              [#Name/Add#]                   Client's name and address

              [#Incorp#]                          Date of incorporation

              [#Day#]                               Day of accounting reference date

              [#Month#]                         Month of accounting reference date

              [#Trading#]                        Trading as

              [#Secretary#]                     Company secretary

              [#Activity#]                        Principal activity

              [#Period end#]                   Current period end date

              [#Period start#]                 Current period start date

              [#Part init#]                        Partner's initials

              [#Part name#]                    Partner's name

              [#Man init#]                       Manager's initials

              [#Man name#]                   Manager's name

              [#Sen init#]                        Senior's initials

              [#Sen name#]                     Senior's name

Reference data

              [#RO*#]                              Registered office

              [#AR*#]                              Accounting records location

              [#SB*#]                               Statutory books location

              [#L1*#]                               Client location 1

              [#L2*#]                               Client location 2

              [#L3*#]                               Client location 3

              [#BP*#]                               Bankers - primary

              [#B1*#]                               Bankers - secondary 1

              [#B2*#]                               Bankers - secondary 2

              [#SO*#]                              Solicitors

              [#IB*#]                                Insurance brokers

              [#SS*#]                               Software suppliers

              [#TO*#]                              Main tax office

              [#PY*#]                               PAYE office

              [#VO*#]                              VAT office

Where * may be

              NAM                                   Name

              AD1 to AD4                        Address lines

              CON                                    Contact

              REF                                     Reference

              PHN                                    Phone number

              FAX                                     Fax number

For Microsoft Excel

System data

[#Date#]                                Today's date

[#Firm#]                                Your firm's name

 [#Reference#]                      Document file name (prefix only)

[#Title#]                                Document title

[#Author#]                            Document author

Client data

[#Code#]                                    Client audit pack code

[#Name#]                                   Client name

[#Period end#]                           Current period end date

[#Part init#]                                Partner's initials

[#Part name#]                            Partner's name

[#Man init#]                                Manager's initials

[#Man name#]                           Manager's name

[#Sen init#]                                Senior's initials

[#Sen name#]                            Senior's name

Extended codes

Four extended codes are included to allow you to embed planning information in working papers. These are different from previous codes in that they embed more than just one figure or date. The codes, which must be entered in column 1 of the spreadsheet, are as follows:

[#Equ_AAAA#]	Where AAAA is the code of an equation in the equation editor. This will cause the system to insert the results of the specified equation. The name of the equation will appear in the cell where the code was entered and the results will be inserted in columns 2 to 11. Column 2 holding the latest year, 3 the previous year, etc.
[#Budget#]	This code will cause the summary information, shown on the first page of the budget report from the planning section, to be inserted. The row on which the code appeared will be replaced by headings and this will be followed with the totals for each staff member, totals and the calculation of the projected surplus or deficit.
[#Materiality#]	This coded will be replaced by the contents of the materiality calculation. The system inserts the same information as included on the printed report.
[#Risk#]	This code results in the risk table being inserted together with any comments that have been made on the audit approach for each area.

As the information is inserted, you do not have to leave space for each section, the system will expand the spreadsheet as required.