Start by pulling the disbursement report:

  1. Log into the BBMS web portal
  2. Under Reports, click Disbursement
  3. Click Export under Detailed Report, for the report you want to export.


Next, set up a query in eTapestry for the transactions processed through BBMS:

  1. Log into eTapestry
  2. Click Queries in the menu bar
  3. Under the Tasks menu, click New Category
  4. Enter the Name as BBMS Queries
  5. Click Save Category
  6. Under the Tasks menu, click New Query
  7. Use the disbursement date on your report to name your query, example: 10/15/2015 Disbursement
  8. Under Starting Query, leave it set to Base/All Constituents
  9. Under Results, set the Data Return Type to Journal Entries
  10. Under Criteria Matching, select Match each criteria
  11. Choose Commonly Used Fields from the Browse Fields drop down menu and click Journal Entry Date
  12. Set the Range Type to Custom Range and enter the date range listed on your disbursement report, example: 10/8/2015 - 10/15/2015
  13. Choose Journal from the Browse Fields drop down menu and click Transaction Processors
  14. Mark the checkbox next to your BBMS processor
  15. Click Save And View Queries


Now, set up a report in eTapestry to use with your BBMS queries:

  1. Click Reports in the menu bar
  2. Under the Tasks menu, click New Category
  3. Enter the Name as BBMS Reports
  4. Click Save Category
  5. Click on BBMS Reports to enter the category
  6. Under the Tasks menu, click New Report
  7. Name the report BBMS Reconciliation Report
  8. Under Group Results, for Group By choose Do Not Group
  9. Choose Commonly Used Fields from the Browse Fields drop-down menu and click Account Name, Date, and Received
  10. Choose Gift Type Fields from the Browse Fields drop-down menu and click Credit/Debit Card Name on Card, Credit/Debit Card Number, and Credit/Debit Card Type
  11. Arrange the columns into order by clicking on the middle of the field column and dragging up or down
    Recommended order:
    • Date
    • Credit/Debit Card Type
    • Account Name
    • Credit/Debit Card Name on Card
    • Credit/Debit Card Number
    • Received
  12. Click on the menu icon to the left of the Date column and click on the A icon to sort in ascending order
  13. Under the Tasks menu, click Save and Run
  14. At the top of the launch page select BBMS Queries as the Category
  15. Under Query, select the query you just built
  16. At the bottom of the launch page select a Report Format
  17. Click Submit

 Use this report and the disbursement report from BBMS to help reconcile your transactions.
 

Note: Transactions processed within the BBMS web portal will not be automatically added to your eTapestry database.