Here we are illustrating application of MS Excel and VBA in relation to specific areas of preparation of cash book and bank book