Information Systems:Auditors

New Process

The old queries have been replaced with InfoNet programs that allow more flexibility, and that Finance can do themselves - maybe even the auditors can.

Accounts Receivable

We want an Excel file of debtor number, name, account type, and balance as of the fiscal year end. Use Summarize A/R From Transactions in InfoNet to get this. This file will have more information that the auditors require, so you can remove some lines and columns.

Sort by 'Original Amount' and delete any lines with a zero balance.

As only one summary level was requested, columns for the second and third levels can be deleted (C, D, E, and F).

The columns for 'transactions', 'remaining amount', 'banner', 'area', and address can be deleted.

Accounts Payable

We want an Excel file of vendor number, name, account type, balance, and preliminary invoices. Use Summarize A/P From Transactions in InfoNet to get this. This file will have more information that the auditors require, so you can remove some lines and columns.

Sort by 'Original Amount' and delete any lines with a zero balance.

As only one summary level was requested, columns for the second and third levels can be deleted (C, D, E, and F).

The columns for 'transactions', 'remaining amount', 'banner', 'area', and address can be deleted.

Inventory

We want an Excel file of warehouse, item number, description, item account group, class, brand, quantity, unit cost, and extended cost. Use Year End Inventory in InfoNet to get this. This file will have more information that the auditors require, so you can remove some lines and columns.

Sales Order Shipping (First and Last of Year)

We want to find the last 10, and first 10 invoices of the year. Use Item Transaction Detail in InfoNet to get the order and pick list number for these. Then use Pick List Status to get the invoice and customer numbers.

Expenses

We want an Excel file of all expense transactions for the year. Use Extract G/L from Transactions to build this.

Purchase Order Receiving (First and Last of Year)

We want to find the last 5, and first 5 purchase order received over the fiscal year end. Use Purchase Order Receiving (Last and First) to identify these, and get all the receiving lines into a spreadsheet.

Sales Comparison

We want to build a spreadsheet for sales and cost of goods sold G/L accounts for the last day of the last three years. Use Sales Comparison to get this.

Trial Balance

We want to build a spreadsheet of opening balances, period totals, and closing balances for all main accounts. Use Trial Balance to build this.

Journal Entries

We want a list of all journal entries (voucher type 50) done for the year. Use Voucher type 50 to get this.

Detail Behind Financial Reports

We want the detail of all the accounts that make up each line on the financial reports. To get this, use Financial Reports (Report Writer)

Superseded Process

Information Systems:Auditors - Superseded Process