Skip to main content

Bloomerang CRM to QuickBooks Online: Reconcile Bloomerang CRM Payments

Create a report to reconcile Bloomerang Payments payouts in Bloomerang CRM with QuickBooks Online.

Bloomerang Payments and QuickBooks Online

Bloomerang CRM syncs the Name, Date, Payment Method, and transaction details (including the total dollar amount of the transaction without deducting fees) to QuickBooks Online, based on how you configure your mapping rules. Transaction notes in Bloomerang CRM sync to the Memo field in QuickBooks.

Bloomerang CRM does not sync Bloomerang Payments payout data (Payout Date, Payout Id, or Fee Amount) to QuickBooks Online. This means that the transaction amounts synced with QuickBooks Online need to be reconciled against the fact that payout fees have not been deducted from the amounts in QuickBooks Online.

Create a Reconciliation Report

Build a transaction report to see all of the fee amounts for the transactions you have synced to QuickBooks Online. Then schedule the report or export it to download it as an Excel file to share it.

To create a reconciliation report:

  1. Click Reports.

  2. Click New Report.

  3. Click Transaction (Start from Scratch).

  4. Click Start Report.

  5. In the Include section, click Add Filter.

  6. Search for and select QuickBooks Online Status.

  7. From the Values list, select Synced in the field.

  8. Click Apply.

  9. In the Include section, click Add.

  10. Search for and select Payout Date.

  11. Select the time period for which you would like to reconcile. This is likely dependent on how often your accountant does reconciliation. The default is During Last Week, so without any changes you'll see all transactions from the previous calendar week.

  12. Click Apply.

The report now shows all transactions that synced with QuickBooks Online and have a payout date in your desired date range. Next, add columns for Payout Date, Payout Id, and Fee Amount.

To add report columns to your report:

  1. In your report, click Columns.

  2. Search for and select Payout Date.

  3. Click Add.

  4. Search for and select Payout Id.

  5. Click Add.

  6. Search for and select Fee Amount.

  7. Click Add.

  8. Click Apply.

  9. In your report, click the Payout Id column.

  10. Click Group by This Column. Grouping by the Payout Id column combines all of the transactions that were paid out at one time. It also totals the Fee Amount for each payout.

  11. Click Apply.

  12. To remove any columns that you don't need in your report:

    1. Click Columns.

    2. In the Active Columns list, click X to remove that column.

    3. Click Apply.

  13. To reorder columns, drag and drop them.

  14. Click Save.

  15. (Optional) To export and download your report:

    1. Click More.

    2. Click Export.

    3. Click a file format: PDF, CSV, or Excel.

    4. Click Export.

    5. After your report generates, click Download.

  16. (Optional) To schedule your report:

    1. Click More.

    2. Select Schedule.

    3. Configure the schedule and click Save. For detailed steps, read Schedule Reports.

You should now have a report that shows all of your transactions that have synced to QuickBooks Online, grouped by their Payout Id.

Related

Did this answer your question?