We have a big issue!! Our organization receives upwards of 8,000 checks (contributions from members) in the the mail every month. We scan them as they come in, in batches of 100 or so and upload them to the bank. The bank downloads them back to us in a CSV file and we post them to each members record/account. For what ever reason our implementation vendor set this process up using the cash sale module. I suppose because it's hitting a customer account? Seems to me the deposit module makes more sense assuming there is an option to not allow it to create a negative receivable? So anyway the issue is the bank is depositing these as a batch (100 check total) but they show up in the GL individually and and we have to try and match 8,000 transactions to batched total on the bank rec. Not to mention 8,000 lines of detail in our income account. We also have an on line NetSuite integrated contributions site where batched deposits are sent tot he bank but the integration is also populating our GL with individual transactions.
Can anyone offer any solutions to this?
Thanks,
Bob