MUMC Finance
Level 3

Reports and accounting

Thanks for all the various inputs. I resolved the issue doing the following:

 

  1. Opened the bank register and selected each reconciled transaction that included a deposit that had a processing fee. I used an external report that showed the processing fee transactions.
  2. I de-selected reconcile (changed to blank) from the register entry and saved entry.
  3. I created sales receipts for individual donors and for donors included in a bulk deposit and deposited to Undeposited Funds for each affected register entry.
  4. I then edited the entry in the register, to include processing fees to the bank fee income account in the bank deposit form.
  5. I then selected "R" in the register, to reoncile the edited entry and saved entry.

 

After trial and error with all of the recommendations, this appeared to be more efficient. Working from the register was more expedient because the register was always open when I created sales receipts and I was able to go directly to the bank deposit form from the register. It resolved the issue I was having with duplicate entries reflecting gross and net amounts on reports. This took quite some time since I had several months of data to correct. 

View solution in original post