Static Balance Ageing Monitor

Paste the monthly GL list → age it → chase the reconcilers
Offline · single file · nothing leaves this page
1

Paste the GL list

Copy the rows straight out of Excel (including the header row) and paste below. Tab, comma, semicolon or pipe separated all work.
2

Map the columns

3

Ageing settings

If your extract already has a days outstanding column, map it under Days outstanding in step 2 and it will be used instead of calculating from a date.

Summary

Value by ageing bucket

{{reconciler}} {{firstname}} {{count}} {{total}} {{oldest}} {{table}} {{asof}} {{threshold}} {{duedate}} {{me}} {{ccy}}