What is Batch Support?
Batch Deposit Support is a method of grouping together payments in QuickBooks Online to help you account for processors who batch all payments for a day and deposit them in a lump sum into your bank account - making it hard to match individual order payments to this lump deposit.
Batch Support in our sync will real-time sync order payments from WooCommerce to QuickBooks Online - but will sync them to your Undeposited Funds account.
Then, when your processor batches your transactions for the day (and you set the batch support setting to run at this same time), our integration will automatically make a Bank Deposit in QuickBooks Online that will group the payments together from Undeposited Funds and deposit them into the bank account you set in Map > Payment Methods. At this time, it will also deduct transaction fees from this batch, if this is turned in in Map > Payment Methods as well. This results in easily "matching" your credit card deposit to this Bank Deposit in QuickBooks:
Batch Support will only be triggered for current days sales. This means that our integration cannot retroactively create batches for orders placed/synced over to QuickBooks Online before Batch Support was enabled in your Payment Method Mappings. To learn more about this, visit Batch Support for pre-existing orders.
How do I configure Batch Support?
- Enable this setting on the Map > Payment Methods page (click Show Advanced Options) - and choose the time of the Batch Support deposit, the Undeposited Funds and Bank Account the funds will be going into.
- Visit MyWorks Sync > Connection tab. This lets our integration know what time to create the deposit. Simply loading this page is all that's needed.
Below is an example of this configuration.
Once the above has been set, the first deposit will be created in QuickBooks Online within 24 hours. Batch Support only applies to "today's" orders - and days going forward. It will not retroactively create bank deposits for previous days.
Do you use Stripe as a payment processor? Read more here about additional configuration for Stripe.
Transaction Fee Handling
When our integration syncs payments over to QuickBooks Online for a gateway that has Batch Support enabled in Map > Payment methods, the transaction fees will not be individually recorded as journal entries in QuickBooks Online. This is because when our integration creates the Bank Deposit in QuickBooks Online at the end of the day, the transaction fees are then added as a separate line at the bottom of the deposit.
The reason for this is to ensure that the bank deposit correctly matches the actual deposit that your processor sends to your bank account for that day's sales. You can see what an actual bank deposit created by our integration would look like here:
If you are pushing over old orders, and would like the transaction fees to be synced to QuickBooks Online, read the Batch Support for pre-existing orders to learn how to do this.