Information Systems:Auditors - Revision history

Norwinu at 19:18, 30 June 2016

2016-06-30T19:18:55Z

New page

==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 [[Auditors - Accounts Receivable|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 [[Auditors - Accounts Payable|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 [[Auditors - Inventory|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 [[Auditors - Sales Order Shipping|Item Transaction Detail in InfoNet]] to get the order and pick list number for these. Then use [[Auditors - Pick List Status|Pick List Status]] to get the invoice and customer numbers.

===Expenses===

We want an Excel file of all expense transactions for the year. Use [[Auditors - Expenses|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 [[Auditors - Purchase Order Receiving|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 [[Auditors - Sales Comparison|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 [[Auditors - Trial Balance|Trial Balance]] to build this.

===Journal Entries===

We want a list of all journal entries (voucher type 50) done for the year. Use [[Auditors - Voucher Type 50|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 [[Auditors - Financial Reports|Financial Reports (Report Writer)]]

==Superseded Process==

[[Information Systems:Auditors - Superseded Process]]

[[Category: Auditors]]

Sheilav: /* Detail Behind Financial Reports */

2016-02-03T01:04:38Z

Detail Behind Financial Reports

Sheilav at 21:59, 2 February 2016

2016-02-02T21:59:38Z

Sheilav at 21:04, 2 February 2016

2016-02-02T21:04:21Z

Sheilav at 23:17, 1 February 2016

2016-02-01T23:17:31Z

Sheilav: /* Purchase Order Receiving (First and Last of Year) */

2016-02-01T21:56:22Z

Purchase Order Receiving (First and Last of Year)

Sheilav at 21:55, 1 February 2016

2016-02-01T21:55:58Z

Sheilav at 21:18, 1 February 2016

2016-02-01T21:18:25Z

Sheilav: /* Expenses */

2016-01-29T00:50:00Z

Expenses

Sheilav at 00:49, 29 January 2016

2016-01-29T00:49:45Z

← Older revision		Revision as of 21:04, 2 February 2016
Line 43:		Line 43:
	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 [[Auditors - Sales Comparison\|Sales Comparison]] to get this.		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 [[Auditors - Sales Comparison\|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 [[Auditors - Trial Balance\|Trial Balance]] to build this.


−	* [[Auditors - Trial Balance\|Trial Balance]]
	* [[Auditors - Financial Reports\|Financial Reports (Report Writer)]]		* [[Auditors - Financial Reports\|Financial Reports (Report Writer)]]

@@ Line 38: / Line 38: @@
 We want to find the last 5, and first 5 purchase order received over the fiscal year end.  Use [[Auditors - Purchase Order Receiving|Purchase Order Receiving (Last and First)]] to identify these, and get all the receiving lines into a spreadsheet.
 * [[Auditors - Trial Balance|Trial Balance]]
 * [[Auditors - Financial Reports|Financial Reports (Report Writer)]]

← Older revision		Revision as of 21:56, 1 February 2016
Line 37:		Line 37:
	===Purchase Order Receiving (First and Last of Year)===		===Purchase Order Receiving (First and Last of Year)===

−	We want to find ~~the last~~ the last 5, and first 5 purchase order received over the fiscal year end. Use [[Auditors - Purchase Order Receiving\|Purchase Order Receiving (Last and First)]] to identify these, and get all the receiving lines into a spreadsheet.	+	We want to find the last 5, and first 5 purchase order received over the fiscal year end. Use [[Auditors - Purchase Order Receiving\|Purchase Order Receiving (Last and First)]] to identify these, and get all the receiving lines into a spreadsheet.

@@ Line 27: / Line 27: @@
 We want an Excel file of warehouse, item number, description, item account group, class, brand, quantity, unit cost, and extended cost.  Use [[Auditors - Inventory|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===
+===Sales Order Shipping (First and Last of Year)===
 We want to find the last 10, and first 10 invoices of the year. Use [[Auditors - Sales Order Shipping|Item Transaction Detail in InfoNet]] to get the order and pick list number for these. Then use [[Auditors - Pick List Status|Pick List Status]] to get the invoice and customer numbers.
@@ Line 34: / Line 34: @@
 We want an Excel file of all expense transactions for the year.  Use [[Auditors - Expenses|Extract G/L from Transactions]] to build this.
 * [[Auditors - Sales Comparison|Sales Comparison]]
 * [[Auditors - Trial Balance|Trial Balance]]

@@ Line 25: / Line 25: @@
 ===Inventory===
-We want an Excel file of warehouse, item number, description, item account group, class, brand, quantity, unit cost, and extended cost.  Use [[Auditors - Inventory|Item Transaction Detail in InfoNet]] to get this.  This file will have more information that the auditors require, so you can remove some lines and columns.
+We want an Excel file of warehouse, item number, description, item account group, class, brand, quantity, unit cost, and extended cost.  Use [[Auditors - Inventory|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===
@@ Line 36: / Line 36: @@
 * [[Auditors - Purchase Order Receiving|Purchase Order Receiving (Last and First)]]
 * [[Auditors - Sales Comparison|Sales Comparison]]

@@ Line 53: / Line 53: @@
 ===Detail Behind Financial Reports===
-We want the detail of all the account that make up each line on the financial reports.  To get this, use [[Auditors - Financial Reports|Financial Reports (Report Writer)]]
+We want the detail of all the accounts that make up each line on the financial reports.  To get this, use [[Auditors - Financial Reports|Financial Reports (Report Writer)]]
 ==Superseded Process==

← Older revision		Revision as of 21:59, 2 February 2016
Line 47:		Line 47:
	We want to build a spreadsheet of opening balances, period totals, and closing balances for all main accounts. Use [[Auditors - Trial Balance\|Trial Balance]] to build this.		We want to build a spreadsheet of opening balances, period totals, and closing balances for all main accounts. Use [[Auditors - Trial Balance\|Trial Balance]] to build this.

		+	===Journal Entries===

		+	We want a list of all journal entries (voucher type 50) done for the year. Use [[Auditors - Voucher Type 50\|Voucher type 50]] to get this.
−	* [[Auditors - Financial Reports\|Financial Reports (Report Writer)]]
		+
		+	===Detail Behind Financial Reports===
		+
		+	We want the detail of all the account that make up each line on the financial reports. To get this, use [[Auditors - Financial Reports\|Financial Reports (Report Writer)]]

	==Superseded Process==		==Superseded Process==

← Older revision		Revision as of 00:50, 29 January 2016
Line 33:		Line 33:
	===Expenses===		===Expenses===

−	We want an Excel file of all expense transactions for the year. Use [[Auditors - Expenses\|Extract G/L from Transactions to build this.	+	We want an Excel file of all expense transactions for the year. Use [[Auditors - Expenses\|Extract G/L from Transactions]] to build this.

← Older revision		Revision as of 00:49, 29 January 2016
Line 31:		Line 31:
	We want to find the last 10, and first 10 invoices of the year. Use [[Auditors - Sales Order Shipping\|Item Transaction Detail in InfoNet]] to get the order and pick list number for these. Then use [[Auditors - Pick List Status\|Pick List Status]] to get the invoice and customer numbers.		We want to find the last 10, and first 10 invoices of the year. Use [[Auditors - Sales Order Shipping\|Item Transaction Detail in InfoNet]] to get the order and pick list number for these. Then use [[Auditors - Pick List Status\|Pick List Status]] to get the invoice and customer numbers.

		+	===Expenses===

		+	We want an Excel file of all expense transactions for the year. Use [[Auditors - Expenses\|Extract G/L from Transactions to build this.