How do I reconcile Brushfire to my bank deposits?

There is no short answer...

Unfortunately, this is a very complicated answer because it depends greatly on the payment gateway in use, the schedule at which that gateway batches to the processor, the payment processor that the gateway is connected to, the schedule at which the payment processor settles to your bank account, and your bank account.  Additionally, other seemingly insignificant factors such as the type of credit card used -- and whether that card is a rewards card or a corporate card -- can also have a fairly dramatic effect.

 

What to do?

Our general recommendation is that you do not attempt to reconcile Brushfire directly to your bank deposit statements. 

We recommend that you use report R210 to reconcile Brushfire against your payment gateway's reports. Once you have verified the accuracy of Brushfire against your payment gateway's reports, you can then use other reports provided by your payment gateway to reconcile from them to your bank deposits.  Unfortunately, not all payment gateways provide an interface for Brushfire to track a given transaction ID all the way to your bank deposit settlement.

 

There is good news!

If you use one of our recommended payment gateways (Square or Stripe), the process is simplified greatly. For both Square and Stripe, you control the deposits of funds from your Brushfire transactions. The most common option is for daily deposits. If someone makes a purchase on July 7th in Brushfire then your deposit on July 8th contains those funds. This means you can reconcile a daily report for July 7th in Brushfire with your deposit for July 8th in your bank. The only exceptions are rare and they involve weekends and holidays where the dates might need to be adjusted slightly.  But even in those cases, a given day in Brushfire will still match the appropriate day in your bank deposits.