the BBMS detailed disbursement report displays a gross disbursement amount whereas the summary disbursement report only totals the transactions and reversals but not the resulting figure, e.g, the gross disbursement amount from which the processing fees are subtracted to yield the 'net proceeds' for example if i have transactions totally $8683.09 then reversals of 263.60... there is no place on the summary report that states my gross disbursement as $8420.38. Can you please fix this??
Guest
We're looking to implement this on BBMS Disbursement Summary reports but want to make sure of one thing: if we insert the gross proceeds column into the middle of the report as Dan outlined below, will this break any of your Excel formulas or references that you have already set up? It will shift the Processing Fees and Net Proceeds columns to the right so any formulas you have that reference a column may have to change. Is that a concern at all?
Great point Helen, this would be a really helpful fix!
Hello Dan
Yes, the sample you provided would be an improvement! It includes the transaction total, reversals total, gross proceeds, fees, and net disbursement after fees as I suggested.
With thanks
Helen
Helen Hubbard-Davis
Director of Finance & Administration
In office: Mon (PM), Tues (PM), Wed & Fri
Phone 202 580 7320 Cell 202 329 4453
Sent from Outlook Mobile
Thanks for the feedback! I've checked the reporting and it appears, as stated, that we have gross disbursement amount on the detail report but not the summary. If we added a feature where there was a column between Reversals and Processing fees that summed up the amounts for each row and then carried on into the totals would that meet the need?
Rough prototype:
Gross disbursements on both summary report and detailed disbursement report would be an easy fix and useful double check for the customer as another point to confirm all balances. Thank you for fixing.
I fully support this idea! Would be incredibly helpful!!