Hi
I am trying to get an Excel template where I can categorise bank statement data. Say I have a bank statement with 1000 entries covering a year of data in Excel I would like to get some kind of lookup formula that would look at the bank statement and then from a list of possible categories in a lookup table then put that data in a monthly income and expenditure list so that I can see at a glance what categories the funds are coming in and going out over a year.
The lookup list needs to extract parts of the description field as the entries are varied, even form the same type of category and can be variable. I would if possible like to do this for multiple accounts so I can see the income and expenditure for personal and business accounts downloaded into Excel automatically rather than have to manually go to each entry.
Example of the data
<tbody>
</tbody>
Can anyone point me in the right direction?
Many thanks
Kev
I am trying to get an Excel template where I can categorise bank statement data. Say I have a bank statement with 1000 entries covering a year of data in Excel I would like to get some kind of lookup formula that would look at the bank statement and then from a list of possible categories in a lookup table then put that data in a monthly income and expenditure list so that I can see at a glance what categories the funds are coming in and going out over a year.
The lookup list needs to extract parts of the description field as the entries are varied, even form the same type of category and can be variable. I would if possible like to do this for multiple accounts so I can see the income and expenditure for personal and business accounts downloaded into Excel automatically rather than have to manually go to each entry.
Example of the data
Date | Account | Description | Amount | Balance |
01/12/2015 | 123456 | Cash deposit ATM | 5000 | 20000 |
02/12/2015 | 123456 | Debit Tesco | -50 | 19950 |
<tbody>
</tbody>
Can anyone point me in the right direction?
Many thanks
Kev