Information Systems:Auditors - Expenses

This is not a simple procedure. The extract will have to run several times, and the spreadsheets combined.

Go to InfoNet / Finance / Summarize/Extract G/L Transactions.

The first step to pull out all expense transactions.

Select the accounting period from the beginning of the year, to the end. Select cost centres to include less than 2410. Expense accounts are from 480000 to 910000, excluding 730200 'Out of Balance'. As there are so many entries to that account, it is easier to build two spreadsheets and merge them, than to delete all the records from a single spreadsheet. So do this step in two passes; first pass from 480000 to 730100. The second 740000 to 900970.

Click on 'Detail to Excel' for both of these, and combine into one spreadsheet. Sort by KPMG section, and delete any transactions that are not for -

ADV
AMORT
COMPUTERS
CONSULTING
DIRECTORS
EQUIPMENT
FREIGHT
GL 
INCENTIVES
INSURANCE
INTEREST
MISC
OCCUPANCY
PRINT
PROFF
RM
SAL
TELEUTIL
TRAVEL
WAREHOUSE

Delete any transactions for INCENTIVES for main accounts 480250, 480550, or 480600, with cost centre less than 1120 or greater than 1125.

Add conferences (recovered) by