Application of Excel and VBA in the context of preparation of ledger accounts is significant in two ways. One relates to preparation of ledger and the other with respect to collection and analysis of information from the ledger accounts.