Hi All,
Need some help with a large data set that my team handles each month (sample attached). It is rather manual and I have tried, and failed to overcome the manual aspect so am reaching out to anyone that may have had an issue like this in the past or if not, has any good suggestions.
Currently I receive data on bonuses each month from corporate. A vendor (in our example “ABC”) pay be due a bonus on a specific invoice transaction, however if the customer (in our example “XYZ”) has not yet paid my company for the deal the vendor has done then it will be listed as “0%” in the %Paid column.
This is where the manual part comes into play. Until the status of the %Paid changes to 100%, (i.e. the customer has paid my company so it is okay to now pay the vendor), corporate keep sending the same data each month - as we keep reporting this due bonus to the vendor until the customer pays.
For month end purposes the liability of the bonus needs to be calculated each month, so a member of my team will go and manually look at each invoice transaction (Column F) and tag the duplicate lines and retain the latest months information. This is so that the accounting entries are not doubled or tripled.
This can take a long time and would be a big help if this can be overcome some way shape or form, so that the items that need to be tagged as “duplicate” do so in an automated manner. I’m not sure if access is the way but if it is then great, if there’s a better way then let me know
Thanks!
Need some help with a large data set that my team handles each month (sample attached). It is rather manual and I have tried, and failed to overcome the manual aspect so am reaching out to anyone that may have had an issue like this in the past or if not, has any good suggestions.
Currently I receive data on bonuses each month from corporate. A vendor (in our example “ABC”) pay be due a bonus on a specific invoice transaction, however if the customer (in our example “XYZ”) has not yet paid my company for the deal the vendor has done then it will be listed as “0%” in the %Paid column.
This is where the manual part comes into play. Until the status of the %Paid changes to 100%, (i.e. the customer has paid my company so it is okay to now pay the vendor), corporate keep sending the same data each month - as we keep reporting this due bonus to the vendor until the customer pays.
For month end purposes the liability of the bonus needs to be calculated each month, so a member of my team will go and manually look at each invoice transaction (Column F) and tag the duplicate lines and retain the latest months information. This is so that the accounting entries are not doubled or tripled.
This can take a long time and would be a big help if this can be overcome some way shape or form, so that the items that need to be tagged as “duplicate” do so in an automated manner. I’m not sure if access is the way but if it is then great, if there’s a better way then let me know

Thanks!