There are a few different reasons why these reports may not match.  The following steps walk you through a process to determine the transactions causing the reports not to match: 
  1. Run BBMS Disbursement report for each week in the month.  You can download your disbursement report directly from BBMS or download it from Altru.
  2. Run the Total Revenue Report for each of those same periods in the month with the box marked to show payment method distribution. 
    1. Go to Revenue
    2. Under Reports, select Total Revenue and Payments. 
    3. Note: Mark “Show Taxes,” “Show Security Deposits,” and “Show revenue that moved from unearned to earned.”  This way all payments and revenue are included on your report.
Total Revenue Report including checkboxes
  1. Compare the BBMS Disbursement Grand Total Gross Amount at the bottom of the report to the Revenue by Payment Method Credit Card Total on the bottom of the Total Revenue Report.  If the two numbers match, there is no further reconciliation necessary.  If they do not match, note the difference.  Note: Do not look at net amounts on the Disbursement Report, as this takes out the BBMS fees and will not match Altru. BBMS Disbursement Report Grand TotalTotal Revenue Report  Credit card total amount
  2. For each of these periods that is off, in Altru, go to Treasury > reconcile transactions and disbursements.  Tip: This feature automatically uploads disbursement reports from BBMS and matches transactions from Altru to the BBMS Disbursement.  It then identifies which credit card transactions in Altru are not included in the disbursement or which items are in the disbursement that don’t match a transaction in Altru.  Read more about this feature and how to use it.  To enable this feature, refer to our help guide.
  3. In Treasury > reconcile transactions and disbursements, go to the View by Altru transaction tab.  Filter on Show Pending transactions and Transactions for the specific disbursement dates.  Click Apply.  This will help you identify pending transactions that are in Altru but not in the BBMS Disbursement. Note: These could include back office credit card payments where no one marked the box to Authorize card on save so the card was not charged, or payments in a batch that were not run through Credit Card Processing and an authorization code was manually entered.  View by Altru Transaction
  4. Next, in Treasury > Reconcile Transactions and Disbursements, go to the Unmatched Disbursements tab. Again, filter on Transactions for the specific dates of your disbursement. On the Unmatched Disbursements tab, look for any transaction that doesn’t wash out.  You’ll frequently see one amount then the same negative amount right in a row with the same date—this is a canceled Daily Sales order and washes itself out—but we want to look for a single line that doesn’t have another match on this page that wouldn’t wash out.  These are charges or refunds that are in Blackbaud Merchant Services that aren’t in Altru.  Note: This could include transactions entered directly into the BBMS Web Portal or Mobile Pay.  This could also include refunds done directly through BBMS.  This could include back office Altru credit card payments that were deleted (since there is no longer a record of the payment in Altru).  There are steps in our Knowledgebase on doing additional investigation into charges in BBMS that are not in Altru.   Unmatched Disbursements
  5. If there is amount off between Altru and BBMS but nothing shows in the Unmatched disbursements tab AND your organization is not in Eastern Standard time (EST), look at the very top of your Disbursement report for transactions between 12am-5pm on the first day of your disbursement.  Because the Altru database is in not EST (and in your time zone) but BBMS is in EST, a transaction in Altru at 11pm CST, for example, falls in BBMS on 12am EST the next day.  If this day happens to be the start of the disbursement period, it could cause Altru and BBMS to be off by the amount of the transaction.  These transactions do not show in unmatched disbursements as Altru knows that BBMS is in EST and accounts for that.  If Altru is more than BBMS, look at the next disbursement report to see if that money is the first transaction on the next report.  If BBMS is more than Altru, look at the prior Total Revenue Report to see if that money is in the Total Revenue Report for the last period.  Also look at last transaction in that period in case it is in Altru but falls on the next day in BBMS due to being late at night.
  6. Finally, on the disbursement reports, look for chargebacks.  There is a specific page in the Disbursement Report that details any chargebacks in that period.  Chargebacks can cause BBMS to be less than Altru because there is a $15 fee associated with them, and Altru does not display chargeback fees in the Altru database.  They are only in BBMS.
  7. If these steps do not reveal the transactions or chargebacks that are causing the discrepancy, run the Daily Transactions Report and compare it against the Total Revenue Report (refer to step 2) for one day to find individual transactions that may be causing the lingering discrepancy.
Once you go through the reconciliation steps, here are some causes of discrepancies: 
  • Blackbaud Merchant Services is based in Eastern Standard Time, which is the time zone that will show on the disbursement report. In Altru the transaction date for your payment will show on the record and Total Revenue and Payments report the time in the time zone that you have set in your Altru database. If a transaction was processed late in the evening in your time zone, it could fall under the following day in Eastern Standard Time for your disbursement report. For example: A transaction made on 7/19 10:00 PM Pacific Time would show with that date and time on your Altru transaction record and the Total Revenue and Payments report. However, BBMS would have the transaction listed as 7/20 1:00 AM Eastern Standard Time, which would be the date on your disbursement report.
  • If you enter payments through an Enhanced Revenue Batch, the transaction date should show in Altru as the date you entered the payment into the batch, and not the date that you actually commit the batch. BBMS will see the transaction on the date that the batch payment is committed, which is what will be on your disbursement report. For example: You enter a payment into an Enhanced Revenue Batch on 3/14, but don't commit the batch until 3/15. The Altru record and Total Revenue and Payments report will list that transaction on 3/14, while the BBMS disbursement will have it listed under the commit date of 3/15.