Scribd
Upload
278 views4 pages

7 Bucket Aging Report

This document provides instructions for running an Aging Seven Buckets report in 3 steps: 1) Select the report from the list of values, 2) Populate the required parameters such as the as of date and internal transactions flag, 3) Submit the request and view the output which groups outstanding invoices and amounts by aging buckets (time periods). The report highlights all outstanding invoices and departments should review overdue items and prioritize credit control actions.

Uploaded by

Ravi Shankar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
278 views4 pages

7 Bucket Aging Report

This document provides instructions for running an Aging Seven Buckets report in 3 steps: 1) Select the report from the list of values, 2) Populate the required parameters such as the as of date and internal transactions flag, 3) Submit the request and view the output which groups outstanding invoices and amounts by aging buckets (time periods). The report highlights all outstanding invoices and departments should review overdue items and prioritize credit control actions.

Uploaded by

Ravi Shankar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

AR Detailed Procedure

How to run an Aging Seven Buckets report

Aging Seven Buckets – by Account Report


(UFS)
This report will show all transactions that have a balance outstanding (i.e. invoices, credit
memos and unapplied receipts). It will list all past due invoices and group the outstanding
amount by bucket (time period). It also provides an overall figure of your department’s
external debtors and you have the facility to include internal invoices too.

Navigate: Request → Run

1. Click OK to a single request.

2. Click into the Name field and use the list of values to select the Aging – 7 Buckets –
By Account Report – (UFS)

Use
List of
Values

Version: 3.0 Jan-19 Page 1 of 4


Detailed Procedure
How to run an Aging Seven Buckets report

3. Upon selecting the Aging – 7 Buckets – By Account Report – (UFS) a parameters


box will appear. The following fields you will need to be populated:

 Report Summary – Invoice Summary


 Report Format – Brief
 As of Date – Will default in with date of running but can adjust to a specific date
 Aging Bucket Name – Collections
 Internal Transactions – N if you don’t want to include this transaction type or Y if
you do.

The following fields will default in:


 Reporting Level – Operating Unit
 Reporting Context – Cambridge University
 Set of Books Currency – GBP
 Show Receipts At Risk - Do Not Show

Upon completing these fields click OK. The Submit Request screen displays.

Version 3 Jan-19 Page 2 of 4


Detailed Procedure
How to run an Aging Seven Buckets report

4. Click on Options to enter the printer number and number of copies you wish to print.
(As the report can be several pages long so you may wish to set it to zero copies to
view on screen first and then reprint directly from the report)

5. Click OK. The Submit Request screen displays.

6. Click Submit.

This will take you to the request screen. Occasionally click Refresh Data till your
request has completed. Once the phase displays as Completed click on View
Output.

An example of the report is shown below. The report will highlight all outstanding
invoices but this does not necessarily mean they are overdue. Review any invoices
that are overdue and prioritise accordingly in terms of actioning. Remember
departments are responsible for credit control in the first instance, should you need to
escalate the situation then contact the Credit Control team.

Version 3 Jan-19 Page 3 of 4


AR Detailed Procedure
How to run an Aging Seven Buckets report

Version: 3.0 Jan-19 Page 4 of 4

You might also like