Hi All
I’m an IT Manager who has recently been asked to provide some help on a dogs breakfast accounting process.
My predecessor issued invoices with a fairly random approach to transaction allocations and I am trying now to reconcile the old invoices with the transaction history - to make sure everything was billed properly.
Each month my he would split the 100+ transactions in a fairly inconsistent manner, which meant the company internal invoices that went out for salaries, travel and general expenses had very little consistency. All of the journals for these transactions have 1-3 levels of transaction type that can be applied depending on source and customer.
The first thing I did was stop the randomness and apply a solid and reproducible methodology. This is working well now and i will soon be automating this process in VB. But i still have a heap of old invoices that may not have been processed properly. I can not be 100% sure that all input costs were charged out.
So, i now want to take 1000+ journals and split & balance them to the old invoices.
My first thought doing this was using a recursive and brute force coding technique. I was wondering if any experts have a better suggestion. So far i am using a pivot table and have 6 months balanced - but they were all of my own accounts. The jigsaw of my predecessor is however not going to be so easy even with 500+ journals to work with.
Would love some advice on an approach ? I dare say lookups wont be enough for this task right ?
Thanks kindly in advance
T
Bookmarks