Making Current Account Tracking

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

Excel Solution: Making Current Account Tracking

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.