Utilising the data validation tool in excel, we can create dropdown boxes for our ledger. This can save time keying manually and increases accuracy.
Create a new sheet, name it "chartOfAccounts"
Populate the sheet with account names
Go back to your ledger sheet.
And select the accounts column.
Click on Data > Data Tools > Data Validation
Change the fields as follows:
You might want to disable error alert by clicking on Error Alert and unchecking "Show error alert after invalid data is entered"
Now you can select any cell in the account column and a dropdown box will appear.
You can also do something similar for the date column to save time entering today's date.
Simply by creating a new sheet with the formula "=now()" and using data validation steps above.