Account Ageing in Excel

Learning Visual Basic - Excel For Accountants

Ageing of Account Transactions in Excel

Objective:
Account Ageing in Excel – 3 different methods
Purpose of training:

This demonstrate different ways to age transactions in Excel to offer an accurate ageing that takes account of when payments was made and allocate it based the FIFO method.

 

At some point I will do another video to demonstrate allocating payments and credit notes against a specific transaction and getting the ageing to show correctly.

Download Excel File (downloadable as a compressed .zip file):
Ageing-Course-FINAL-METHOD.zip