top of page

How can I quickly categorise bank transactions using Excel?


Data validation can be used to create a drop down box showing categories that can be easily allocated to individual transactions.

This can be useful when carrying out a bank statement reconciliation and isolating certain payments for investigation. Examples of possible categories include areas of business or geographical locations.

Here is an article that provides more information: http://excelsemipro.com/2011/02/create-a-cell-drop-down-list-in-excel-with-data-validation

#Excel #All

Recent Posts

See All

Revisited starter script from January 2021: Split Excel file into separate files Excel is essential, and Python is the future - forcing ourselves to practice the latter by automating some of the commo

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm

bottom of page