I want to do something similar to TSI Audit system.
How this should be done is each charge in the excel data should be linked to a charge in our system. Of course there will be some charges in our system that wont be linked to the CSV data such as Setup charges, modem purchases etc.etc.
but service related charges should be linked to a charge in the specific customers account.
For example if we sell [url removed, login to view] DSL service and our cost is $15.61 for that and we charge that specific customer $34.95 then it should be linked. when when i want to run audit report there should be discrepencies shown. what we are trying to sort out is if they are charging us properly. what we are finding out is (or might be finding out maybe we are wrong) is that customer might be charged for a full month by our provider meanwhile customer cancelled in middle of month in our system. we should apply for a credit in that case.