Darryproduct
New Member
- Joined
- Jul 24, 2013
- Messages
- 8
I'm trying to reconcile accounts that have multiple transactions that net to zero. Often there can be 1-4 numbers in the credit column that equal 1-4 numbers in the debit column. Is there a formula or can I utilize solver to help identify all the numbers that net to 0?
<tbody>
</tbody>
I'm trying to identify which numbers are creating the discrepancy of ($36.21) when it should be $0.
Transaction Date | Journal # | Debit | Credit | Difference |
4/3/19 | 63564 | -127.41 | -127.41 | |
4/9/19 | 63803 | -984.82 | -984.82 | |
4/9/19 | 63804 | -3771.17 | -3771.17 | |
4/9/19 | 63747 | 99.50 | 99.50 | |
4/9/19 | 63747 | 3933.48 | 3933.48 | |
4/9/19 | 63747 | -314.10 | -314.10 | |
4/9/19 | 63747 | -104.40 | -104.40 | |
4/9/19 | 63747 | 1,199.42 | 1,199.42 | |
4/29/19 | 64182 | 91.20 | 91.20 | |
SUM | -$36.21 |
<tbody>
</tbody>
I'm trying to identify which numbers are creating the discrepancy of ($36.21) when it should be $0.