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:

#Excel #All

Message us or

Call us on +44 (0)20 3287 8283

Mon to Fri: 8am-8pm

Weekends: 10am-6pm