Difference between revisions of "Information Systems:Auditors - Expenses"
| Line 1: | Line 1: | ||
| − | This is not a simple procedure. The extract will have to run several times, and the spreadsheets combined. |
+ | This is not a simple procedure. The extract will have to be run several times, and the spreadsheets combined. |
Go to InfoNet / Finance / Summarize/Extract G/L Transactions. |
Go to InfoNet / Finance / Summarize/Extract G/L Transactions. |
||
Revision as of 15:56, 1 February 2016
This is not a simple procedure. The extract will have to be 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 periods 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 main account number, then 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
