Hello everyone,
I was wondering whether it is possible to consolidate and / or compare two different trial balances in Excel without the use of macros that are out of my league to edit for future use if too complex.
For those who do not know, a trial balance follows an arithmetic logic, starting from the smaller and going up to the higher number code, which are usually separated by either "." or "-". An example of what I am talking about is in this file: Trial Balance Consolidation Example
1. In the "Consolidation Example.xlsx" file there are two trial balances in two different sheets.
2. Split comparison serves the purpose of comparing the two trial balances and adding gaps according to differences in codes. They both meet up in the end and all intermediary codes that are missing are being left alone with an empty row in the corresponding trial balance. If a code jumps from .07 to .10, it is not required to have every other in between, the comparison should only affect the codes present in the files, not the ones that could exist in-between.
3. Consolidation shows how the two trial balances would merge to be one if that was required.
It is more important to keep track of code separation rather than description separation. However, if two descriptions match on a different code during consolidation, I would like to be able to know that if possible.
Do you think what I am trying to do is possible?
Thank you for reading!
I was wondering whether it is possible to consolidate and / or compare two different trial balances in Excel without the use of macros that are out of my league to edit for future use if too complex.
For those who do not know, a trial balance follows an arithmetic logic, starting from the smaller and going up to the higher number code, which are usually separated by either "." or "-". An example of what I am talking about is in this file: Trial Balance Consolidation Example
1. In the "Consolidation Example.xlsx" file there are two trial balances in two different sheets.
2. Split comparison serves the purpose of comparing the two trial balances and adding gaps according to differences in codes. They both meet up in the end and all intermediary codes that are missing are being left alone with an empty row in the corresponding trial balance. If a code jumps from .07 to .10, it is not required to have every other in between, the comparison should only affect the codes present in the files, not the ones that could exist in-between.
3. Consolidation shows how the two trial balances would merge to be one if that was required.
It is more important to keep track of code separation rather than description separation. However, if two descriptions match on a different code during consolidation, I would like to be able to know that if possible.
Do you think what I am trying to do is possible?
Thank you for reading!