Tracking Current Account

An Excel file that teaches how to perform Making Current Account Tracking operation.

Excel Solution: Tracking Current Account

Collection and payment records are separated. Value dates are kept in separate fields. Balance movements are calculated dynamically. Past due dates are reported with alerts. Summary reports are prepared for sharing.

Hope it is useful.