Using Iterative Macro to Add Values in Column to Yield a Value in Another Table

[alexlat11]

Hi,

I am trying to match cartain amounts in one table to another table when there is no reference between the two tables to link the numbers up. I figure that using an Iterative Macro would be the best route to go but I don't know how to go about setting it up.

Transaction Date	Amount
8/12/2021	34.17
8/26/2021	117.00
8/6/2021	130.23
8/11/2021	270.00
8/2/2021	351.23
8/10/2021	468.00
8/3/2021	750.00
8/27/2021	758.35
8/11/2021	849.50
8/6/2021	920.00
8/5/2021	950.00
8/2/2021	1,875.00
8/3/2021	2,043.75
8/5/2021	2,563.74
8/11/2021	3,073.16
8/13/2021	3,391.05
8/10/2021	3,915.00
8/6/2021	3,997.41
8/12/2021	4,234.19
8/5/2021	4,265.00
8/12/2021	4,280.64
8/11/2021	5,271.00
8/13/2021	6,375.00
8/13/2021	6,750.00
8/2/2021	8,129.36
8/12/2021	8,400.00
8/30/2021	8,481.00
8/2/2021	8,500.00
8/2/2021	8,954.52
8/6/2021	9,339.49
8/10/2021	9,475.00
8/13/2021	9,975.00
8/4/2021	11,362.00
8/5/2021	13,500.00
8/2/2021	14,875.00
8/9/2021	15,030.99
8/13/2021	15,250.00
8/9/2021	15,450.00
8/18/2021	17,324.94
8/2/2021	18,342.50
8/3/2021	23,580.42
8/6/2021	24,250.00
8/4/2021	24,475.00
8/4/2021	25,144.94
8/6/2021	27,053.00
8/11/2021	30,683.04
8/6/2021	31,600.00
8/2/2021	40,300.00
8/2/2021	41,015.00
8/6/2021	41,230.02
8/4/2021	46,583.18
8/2/2021	47,250.00
8/5/2021	51,480.00
8/3/2021	53,915.16
8/11/2021	59,076.99
8/2/2021	66,432.61
8/13/2021	69,050.00
8/10/2021	72,314.16
8/13/2021	111,366.33
8/3/2021	132,600.00
8/13/2021	458,766.00
Total	1,728,189.07

and

Posting Date	Amount
8/31/2021	(604.70)
8/31/2021	9,961.05
8/26/2021	17,324.94
8/19/2021	1,701,507.78
Total	1,728,189.07

Notice how both the totals equal eachother but I'm trying to figure out which rows in the first table match with which numbers on the latter table. 

Thanks,

Alex

[mst3k]

i think you're going to run into 1 problem since one of your totals has a negative number but none of the original values is negative?

the only way i can think to do this efficiently would be to treat it like knapsack problem and use the optimization tool. however i'm not really sure how to set up the optimization tool for a knapsack problem..

[DawnDuong]

hi @alexlat11 

It appears that you are trying to reconcile the GL to some manual management adjustments.

This is not reconcilable based on the available information - for instance, you can see that there is no negative value in the GL export, but there is a negative value in the manual management adjustments.

I think you will need to enquire / obtain the breakdown for the summary table and/or understand how the data flows between different financial data sources first.

Dawn.