Difference between revisions of "Information Systems:Auditors Accounts Receivable"
Jump to navigation
Jump to search
(Created page with "Go to InfoNet / Finance / Summarize / Extract A/R transactions. File:audit-1.jpg") |
m |
||
| (4 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| + | We want an Excel file of debtor number, name, account type, and balance as of the fiscal year end. |
||
| + | |||
Go to InfoNet / Finance / Summarize / Extract A/R transactions. |
Go to InfoNet / Finance / Summarize / Extract A/R transactions. |
||
| + | An account balance can be calculated for any period by summarizing all transactions up to that point. The 'Remaining Amount' on this display is only correct for the current moment. |
||
| + | |||
| ⚫ | |||
| + | |||
| + | Key in a starting fiscal period that is older than any accounts receivable transaction, and for ending period, the period for which you want the balance. Summarize by debtor. Click on the search button. |
||
| + | |||
| + | [[File:Audit-3.jpg]] |
||
| + | |||
| + | The total 'Original Amount' should agree with the G/L. |
||
| + | *VA/480B* G/L transaction enquiry 1/27/16 10:58:12 FMR01702 |
||
| ⚫ | |||
| + | ------------------------------------------------------------------------------- |
||
| + | Rec. Bal.per/amount 1512 4998385.36 CAD Total sel. |
||
| + | ------------------------------------------------------------------------------- |
||
| + | Main Grou Subg Cost Pro Vou no Vou dt Vt System Amount Per |
||
| + | 120000 7500201 040108 75 172395.85- 0903 |
||
| + | 120000 7500202 040108 75 78744.50- 0903 |
||
| + | 120000 7500202 040108 75 71.84 0903 |
||
| + | 120000 7500203 040108 75 3371.32- 0903 |
||
| + | 120000 7500203 040108 75 13.01 0903 |
||
Latest revision as of 10:15, 15 July 2016
We want an Excel file of debtor number, name, account type, and balance as of the fiscal year end.
Go to InfoNet / Finance / Summarize / Extract A/R transactions.
An account balance can be calculated for any period by summarizing all transactions up to that point. The 'Remaining Amount' on this display is only correct for the current moment.
Key in a starting fiscal period that is older than any accounts receivable transaction, and for ending period, the period for which you want the balance. Summarize by debtor. Click on the search button.
The total 'Original Amount' should agree with the G/L.
*VA/480B* G/L transaction enquiry 1/27/16 10:58:12 FMR01702 ------------------------------------------------------------------------------- Rec. Bal.per/amount 1512 4998385.36 CAD Total sel. ------------------------------------------------------------------------------- Main Grou Subg Cost Pro Vou no Vou dt Vt System Amount Per 120000 7500201 040108 75 172395.85- 0903 120000 7500202 040108 75 78744.50- 0903 120000 7500202 040108 75 71.84 0903 120000 7500203 040108 75 3371.32- 0903 120000 7500203 040108 75 13.01 0903