Hello everyone!
I am using a software suite which produces Trial Balances in a completely problematic and difficult to edit form. It looks like this (partial example, incorrect totals):
View image: TB
Usually, and ideally, a software generated Trial Balance would look like this:
<tbody>
</tbody>
The fact that the cells are separated the way they are makes it incredibly difficult to use the data, a situation enhanced by titles that are on top of each other instead of side to side. In case you have not seen a TB before, the table in the example is separated by the company's name (software - specific) and goes on for many accounts.
Would it be possible that this mess is somehow fixed and rearranged to the ideal format automatically, or at least eliminate the problematic cells / columns so editing and summing is not a frustrating situation with doubtful results?
I have uploaded the file here, since copy pasting it in the forum did not produce the same results: Example in case anyone wants to take a direct look.
Thank you to anyone who replies in advance!
I am using a software suite which produces Trial Balances in a completely problematic and difficult to edit form. It looks like this (partial example, incorrect totals):
View image: TB
Usually, and ideally, a software generated Trial Balance would look like this:
Account | Description | Record | Record Balance | 2014 Y/E | Current Balance | This Period | Year to Date | Current Balance | |||||||
- | - | Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit | Debit | Credit |
12-01-00-0002 | Floor-Separators | 565,77 | 565,77 | 565,77 | 565,77 | ||||||||||
12-01-00-0003 | Door-Separators | 1.584,30 | 1.000,00 | 1.584,30 | 600,00 | 1.584,30 | 1.584,30 | ||||||||
12-01-00-0004 | Lead | 1.454,44 | 1.454,44 | 1.454,44 | 1.454,44 | ||||||||||
12-01-00-0005 | 334,69 | 334,69 | 334,69 | 334,69 | |||||||||||
12-01-00-0006 | Hydralic Installations | 557,53 | 557,53 | 200,00 | 200,00 | 150,00 | 150,00 | 75,00 | 75,00 | 557,53 | 557,53 | ||||
12-01-00-0007 | Crystals | 692,59 | 692,59 | 692,59 | 692,59 | ||||||||||
12-01-00-0008 | WEST POINT | 704,33 | 704,33 | 704,33 | 704,33 | ||||||||||
12-01-00-0009 | Air-condition | 621,76 | 1.000,00 | 621,76 | 700,00 | 621,76 | 621,76 | ||||||||
12-01-00-0010 | Air-condition | 484,97 | 484,97 | 484,97 | 484,97 | ||||||||||
12-01-00-0011 | Monitor R140 | 7.404,18 | 7.404,18 | 7.404,18 | 5.500,00 | 7.404,18 | 1.999,00 | ||||||||
12-06 | Other mechanical equipment | 2.169,56 | 2.169,56 | 2.169,56 | 2.169,56 | ||||||||||
12-06-00 | Other mechanical equipment | 2.169,56 | 2.169,56 | 2.169,56 | 2.169,56 | ||||||||||
12-06-00-0000 | Air-condition | 909,78 | 909,78 | 909,78 | 909,78 |
<tbody>
</tbody>
The fact that the cells are separated the way they are makes it incredibly difficult to use the data, a situation enhanced by titles that are on top of each other instead of side to side. In case you have not seen a TB before, the table in the example is separated by the company's name (software - specific) and goes on for many accounts.
Would it be possible that this mess is somehow fixed and rearranged to the ideal format automatically, or at least eliminate the problematic cells / columns so editing and summing is not a frustrating situation with doubtful results?
I have uploaded the file here, since copy pasting it in the forum did not produce the same results: Example in case anyone wants to take a direct look.
Thank you to anyone who replies in advance!