Account Analysis Report: Transaction Detail (UFS) - Excel Version, Lecture notes of Accounting

The procedure for generating an account analysis report in the ufs system, specifically the transaction detail (ufs) - excel version. The report provides detailed information about individual transactions from modules such as accounts payable and accounts receivable, and is suitable for exporting to excel for further analysis.

Typology: Lecture notes

2021/2022

Uploaded on 07/05/2022

allan.dev
allan.dev 🇦🇺

4.5

(86)

1K documents

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
Detailed Procedure
Account Analysis Report
Version: 1 Page 1 of 4
Account Analysis Reports
The Account Analysis reports provide detailed information about individual transactions that have been posted to the general ledger from other
modules such as Accounts Payables (invoiced expenditure), Payroll and Accounts Receivable (sales invoices and income received). It is
recommended that you run these reports for specific account combinations where you want to study the transactions that make up a
particular balance perhaps a balance that you are querying from a higher level general ledger report.
Versions available
There are four versions of the Account Analysis Report with layouts to suit differing needs each with a slightly different emphasis, and probably
appealing to different audiences. The table below shows which columns each report contains.
Full Field
Transaction Detail 1
(CAPSA)
Transaction Detail 3
(CAPSA)
Transaction Detail (UFS)
Excel Version
Good for information
about the source of the
transaction
Good all round report
especially for information on
transactions from AP
Report limits data for each
transaction to a single line, to
assist with downloading into
Excel and subsequent sorting
etc.
Directly exports in to Excel,
enabling the data to be
interpreted and manipulated
more easily.
Source of transaction
(eg Payables, Receivables)
Category
(e.g. Purchase invoice, Journal)
Batch name
pf3
pf4

Partial preview of the text

Download Account Analysis Report: Transaction Detail (UFS) - Excel Version and more Lecture notes Accounting in PDF only on Docsity!

Account Analysis Report

Account Analysis Reports

The Account Analysis reports provide detailed information about individual transactions that have been posted to the general ledger from other

modules such as Accounts Payables (invoiced expenditure), Payroll and Accounts Receivable (sales invoices and income received). It is

recommended that you run these reports for specific account combinations where you want to study the transactions that make up a

particular balance – perhaps a balance that you are querying from a higher level general ledger report.

Versions available

There are four versions of the Account Analysis Report with layouts to suit differing needs each with a slightly different emphasis, and probably

appealing to different audiences. The table below shows which columns each report contains.

Full Field Transaction Detail 1 (CAPSA) Transaction Detail 3 (CAPSA) Transaction Detail (UFS) – Excel Version Good for information about the source of the transaction Good all round report especially for information on transactions from AP Report limits data for each transaction to a single line, to assist with downloading into Excel and subsequent sorting etc. Directly exports in to Excel, enabling the data to be interpreted and manipulated

more easily.

Source of transaction (eg Payables, Receivables)

Category (e.g. Purchase invoice, Journal)

Batch name 

Account Analysis Report

Full Field Transaction Detail 1 (CAPSA) Transaction Detail 3 (CAPSA) Transaction Detail (UFS) – Excel Version Journal name  Posted Date    Flexfield     Flexfield Description  Description of transaction    always the journal line description as held in the General Ledger

Reference 1 Display depends on the category of the transaction (Eg. AP Invoices/AR invoices/AR Misc. receipts)

supplier/customer name

supplier/customer name

Supplier/customer/comments

Reference 2 Display depends on the category of the transaction (Eg. AP Invoices/AR invoices/AR Misc. receipts)

Supplier’s invoice number/ AR invoice number/paid from

Supplier invoice number/ AR sales invoice/paid from PO Number if matched    Debit column  Credit column  Amount column   Suitable for exporting to Excel  Automatically outputs to Excel

Account Analysis Report

f) Once all fields completed, click OK and the parameter screen will display again.

g) The last field that needs completing is the currency field. The currency you need to enter is ‘GBP’.

h) Click OK to return to the submit request screen

3. Options – click button to ensure that printer setting is set to ‘0’ prints

4. Submit the report.

5. Once the report has completed, click on View output which will open the file directly in to Excel.

Below is a preview of how the report will be presented. You can now make any alterations or changes should you need to manipulate the data