Hi, hope all well. I am reconciling bankings to a large number of cash entries for different shops. The process to match the cash to all the bankings is too long and needs to be automated as much as possible using Excel formula. At the moment we are using VLOOKUP to pull out the entries from all shops, then VLOOKUP to pull out infomration from bank statements usinf the date and shop number on one page. Then manually matching the cash entries to the bankings which is taking too long. How can the cash entries be matched to actual bankings? We enter the shop number on the bank statement to line the banking under the cash entry. Hope this makes sense.
I know there are templates that can be bought but I would like to use formula or create picot tables myself to do this. Thanks in advance.
I know there are templates that can be bought but I would like to use formula or create picot tables myself to do this. Thanks in advance.