Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Account Activity Analysis Reports, Lecture notes of Financial Accounting

Curtin University (CU)Financial Accounting

The AAA report designed to provide country offices with tools to analyze balance sheet accounts and derived accounting records of business.

Typology: Lecture notes

2021/2022

Uploaded on 07/05/2022

lee_95
lee_95 🇦🇺

4.6

(59)

999 documents

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
AAA report February 2007
Account Activity Analysis (AAA) Reports
1. Introduction
The AAA report is designed to provide Country Offices with a tool to analyze
balance sheet accounts. The report gives details of all transactions from various
modules for a given account and Operating Unit (OU) for a chosen period. The report
selects activities from source systems (AP, AR, GL, etc.) within a fiscal year based on
the posting date of the journal tied to the activity. The report can be run for the OU,
specified on the run control. Country offices should run generally for one OU
only.
2. Running the report
2.1. Navigation:
UN Reports>Financial Management Reports>Accounts Management Reports>Account
Activity Analysis
pf3
pf4

Partial preview of the text

Download Account Activity Analysis Reports and more Lecture notes Financial Accounting in PDF only on Docsity!

Account Activity Analysis (AAA) Reports

1. Introduction

The AAA report is designed to provide Country Offices with a tool to analyze

balance sheet accounts. The report gives details of all transactions from various

modules for a given account and Operating Unit (OU) for a chosen period. The report

selects activities from source systems (AP, AR, GL, etc.) within a fiscal year based on

the posting date of the journal tied to the activity. The report can be run for the OU,

specified on the run control. Country offices should run generally for one OU

only.

2. Running the report

2.1. Navigation:

UN Reports>Financial Management Reports>Accounts Management Reports>Account

Activity Analysis

2.2. Parameters to be used:

 General Ledger Unit : UNDP

 Account : please select account to be analyzed, for example 16005 (NEX

advance) or 21020 (other accounts payable) etc.

 Accounting date from and to : Please insert the Date from and to which activity

will be reported. It is recommended that you run from 01/01/2004 to 31/12/

to get the correct balance of your balance sheet account

 Operating Unit : Please select one and insert the OU of your Country Office.

 Include all fund codes : Please use this checkbox to select fund codes related to a

chosen account. Once this checkbox is unchecked, non-UNDP fund codes such as

12000 (non-ATLAS Agency) and 13999 (UNODC) will be excluded. It is

recommended that you always check this checkbox to include all fund codes

when running this report.

2.3. Data File Load to Excel

The default format of this report is CSV, to load into Excel, please follow these steps:

1. Run the report with CSV as the output format.

2. When retrieving the output via Process Monitor, choose to save the file to disk.

Do not open directly into Excel as you will not be able to specify the appropriate

conversion options. Use the default filename with TXT extension, or choose

another filename but keep the TXT extension.

3. Open Microsoft Excel.

4. Choose to Open a document from the menu or toolbar.

5. Select the file saved previously. Excel will open the Text Import Wizard.

6. Select Delimited as data type, then choose Next.

7. Unselect all existing delimiters (such as Tab). Then, select other as the delimiter

and enter the pipe (|) character as the delimiter. Select Next.

8. If needed, you can select the type for each column, but this is not required.

9. Select Finish.

The first row of the file will include the column headings. All remaining rows will

contain the data. Please remember that Excel has a 65535 row limit, so if you open larger

files, the data beyond row 65535 will not appear.

3. Additional Notes

 The report does not populate any opening balance carried forward from previous

fiscal year, because the opening balance is only available in GL not in sub-

systems. To get the correct balance of a balance sheet account, it is recommended

that you run the report from 01/01/2004.

 The report does not populate any pre-ATLAS converted balance, again because

converted balance is only available in GL except for NEX advance account

16005. To get the pre-ATLAS balance converted to GL, please go to General

15 Activity Id^ Activity ID of the transaction 16 Analysis Type^ Analysis type of the transaction (if applicable) 17 Vendor Id^ Vendor for vouchers 18 Vendor Name^ Vendor name for vouchers 19 Related Voucher^ Related voucher for journal and adjustment vouchers 20 Description^ Additional description field depending on source system 21 Description 2^ Additional description field depending on source system 22 Journal Ref^ Journal reference for GL journals 23 Journal ID^ Journal ID posted to GL 24 Journal Date^ Journal date posted to GL 25 Local Curr Amount^ Local currency amount of transaction 26 Local Curr^ Currency of Transaction 27 USD Amount^ Base amount (USD) of transaction