Scribd
Upload
541 views19 pages

AR Excel Template - Aging Report and Prioritized Worklist

This Excel template provides tools to manage accounts receivable. It includes an aging report and prioritized worklist. Users can paste in customer and invoice data to generate the reports. The aging report shows amounts owed by time period. The prioritized worklist ranks customers based on amount past due. Slicers allow filtering the reports by collector, risk class and other fields.

Uploaded by

Supian Bin Muhammad
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
541 views19 pages

AR Excel Template - Aging Report and Prioritized Worklist

This Excel template provides tools to manage accounts receivable. It includes an aging report and prioritized worklist. Users can paste in customer and invoice data to generate the reports. The aging report shows amounts owed by time period. The prioritized worklist ranks customers based on amount past due. Slicers allow filtering the reports by collector, risk class and other fields.

Uploaded by

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

Free Accounts Receivable Excel Te

Aging Reports and Prioritized Worklist

Ready-to-use Excel Templates ; plug your data and start using

Customer Information

Invoice Information

View Aging Report

View Prioritized Worklist


ble Excel Templates

data and start using!

This is an interactive Dashboard.


Click and browse through!
Customer ID Customer Number Customer Name Risk Class
Collector Credit Limit

< Paste your customer master dat

While pasting please use the option to Past Special and select t
tomer master data here

ption to Past Special and select the option to Paste as Values


Customer Number Invoice Number Amount Due Date
Invoice Date Previous Notes

< Paste your open A/R data here


While pasting please use the option to Past Special and sele
n A/R data here
ption to Past Special and select the option to Paste as Values
Receivable Aging Report

Collector - all -
Risk Class - all -
Aging R
$12

$10

Total Past Due Amount


$8
Aging Bucket Past Due Amount
91+ Days Past Due $6
Total Result $4

$2

$-
91+ Days Total Result
Past Due
Aging Bucket

Note: Once you have pasted your data click on the Table to the left; navigate to the menu on the top; Go to PivotTableA
Aging Report

Past Due Amount

Total Result

Aging Bucket

u on the top; Go to PivotTableAnalyze; then select Refresh > Refresh All


Collector - all -
Risk Class - all -

Prioritized Worklist
Prioritized Worklist Aging Bucket

Customer Name 91+ Days Total Result


#N/A
Total Result
This shape represents a
slicer. Slicers are supported
in Excel 2010 or later.

If the shape was modified


in an earlier version of
Credit limit Previous Notes Add Note Excel, or if the workbook
was saved in Excel 2003 or
earlier, the slicer cannot be
#N/A Expand to see Expand
used.
#N/A Expand to see Expand

This shape represents a


slicer. Slicers are supported
in Excel 2010 or later.

If the shape was modified


in an earlier version of
Excel, or if the workbook
was saved in Excel 2003 or
earlier, the slicer cannot be
used.
ents a
supported
later.

modified
on of
orkbook
el 2003 or
cannot be

sents a
supported
later.

modified
ion of
orkbook
el 2003 or
cannot be

You might also like