Create a report to reconcile Bloomerang Payments payouts with QuickBooks Online.
In this article:
Bloomerang Payments and QuickBooks Online
Bloomerang CRM syncs the Name, Date, 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.
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.
Click Reports.
Click New Report.
Click Build a report from scratch.
Click Transactions.
In the Include section, click Add Filter.
Search for and select QuickBooks Online Status, add Synced in the field, and click OK.
In the Include section, click Add.
Search for and select Payout Date.
Note: At this point, 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.
Click OK.
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.
Click Add Column and then search for and select Payout Date, Payout Id, and Fee Amount. Click Add 3 columns.
Click the blue column header for Payout Id, select Group by this column, and click OK.
You should now have a report that shows all of your transactions that have synced to QuickBooks Online, grouped by their Payout Id. Remove any columns that are not needed in the report by clicking the blue column header and then Delete. Drag and drop the columns into your preferred order.
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.
Click Save And to save your report. Choose Export to Excel to immediately download it, or, Schedule Report to send it at a scheduled time to any valid email address.