Exporting Payments to your ERP/Accounting System
Learn how to export payments processed in BlueSnap to your ERP/Accounting System.
If you are using the BlueSnap solution for handling payment processing, integrating with BlueSnap’s AR Automation system can help you automate the payments reconciliation process. By using AR Automation as an intermediary between BlueSnap and your ERP/Accounting system you can streamline the process of recording payments in the accounting system by automatically updating invoices and customers' balances.
Supported Accounting Systems
- QuickBooks Online
- QuickBooks Desktop
- Sage Intacct
If you need an AR Automation account, go to the AR site to sign up.
If you need a BlueSnap account, go to the BlueSnap site to get started.
Auth/Capture and Separate Auth and Capture
Built-in Fraud Prevention and Risk Management
Level 2/3 Data
Partner Sandbox Testing
Payment Methods: ACH/ECP, SEPA, Credit/Debit Cards
BlueSnap supports the currencies listed here. We recommend configuring your store to only accept currencies supported by BlueSnap.
BlueSnap supports the countries listed here. If a shopper is located in one of these supported countries, they will be able to purchase with the BlueSnap payment module.
How to Export Payments
Step 1: Create AR Automation account and connect it to BlueSnap
This guide walks you through how to connect your AR Automation account to BlueSnap's payment gateway technology.
Step 2: Connect your ERP/Accounting System to AR Automation
AR Automation can be used in conjunction with your accounting system to synchronize your customers, invoices and payments automatically every two hours (except QuickBooks Desktop, which requires manual launch of synchronization).
Below you will find guides on how to connect your Accounting System to the AR Automation system:
- Connect with QuickBooks Online
- Connect with QuickBooks Desktop
- Connect with Xero
- Connect with Sage Intacct
- Connect with NetSuite
Step 3: Selecting Payment Account for Reconciliation
Payments available in AR Automation are immediately synced with accounting/ERP systems, marking the invoice as paid or partially paid in your accounting system. To ensure your payments are synchronized to your accounting system, make sure to select the payment account where the payment should be deposited in your accounting/ERP system. For example, if your AR Automation account is connected to Quickbooks Online, the payments can be deposited to the Undeposited Funds account or you may select any payment account from the list we import from your accounting system.
Select the Payment Account:
- Click on your initials in the lower-left corner and navigate to Account > Accounting.
- Find the Accounting System Integration settings and select the payment account you would like to deposit funds to from the dropdown list.
If you take payments in many currencies and want to deposit them to separate payment accounts in your accounting/ERP system, go to the payment page and pick the currency of the payments as well as the payment account to which they should be deposited.
Payment Account for QuickBooks Desktop
If you use QuickBooks Desktop, please note that your payments can only be deposited to the Invoice AR account. To push payments to your QuickBooks Desktop account, select the Use Invoice AR Account to record payments checkbox, shown below.
Step 4: Sync Payments with BlueSnap
To ensure that payments processed through BlueSnap will also be synced to AR Automation, it's important to enable the Sync Payments with BlueSnap setting in your AR account.
To enable this setting:
- Click on your initials in the lower-left corner and go to Settings > Preferences.
- On the Preferences page select Payments tab.
- Select the checkbox next to Sync Payments with BlueSnap.
When a payment is created in BlueSnap, it is imported and synced to AR Automation automatically using the supply invoice number from the merchant transaction ID. If there is a corresponding invoice number, it is applied to the correct invoice. If not, the payment syncs as an unapplied payment.
Please note that this syncing process relies on the invoice number from the merchant transaction ID. We will only automatically import payments for a specific invoice if the invoice number is submitted on the merchant transaction ID field and we can match the invoice number with the invoice available in AR Automation.
Step 5: Enabling IPNs
Payments are imported from BlueSnap to the AR Automation account via IPNs (also known as webhooks). To set up IPNs, we set up the server and URL on our end for you and then you need to configure the IPN settings in your BlueSnap account.
You can find your IPN URL in the AR Automation account. Click on your initials in the lower-left corner and go to Account > Payments. You will see a BlueSnap IPN URL section which contains your unique IPN URL.
The next step is to enable IPN settings on your BlueSnap account. Find a step-by-step guide on enabling IPNs here.
Note: The following IPNs need to be enabled on your BlueSnap account settings to ensure payments are imported:
- Charge IPN
- Charge Pending
- Decline IPN
- Auth Only
Best Practices & Tips
Submit Authorized ACH Payment
In your AR Automation account, there is a setting under Preferences > Payments called Submit Authorized ACH Payments to Accounting System.
By default, the AR Automation system can push ACH payments to your accounting system once payments are in a Succeeded or Authorized status. If your account has the setting Submit Authorized ACH Payments to Accounting System disabled, only fully processed ACH charges will be submitted to the accounting system. If this setting is enabled, the ACH payment will be submitted to your accounting system as soon it is initiated and in an Authorized status.
If the authorized ACH payment fails, we will not be able to update the payment status in the accounting system from Authorized to Failed, so your accounting system will not consider the payment as failed. Unless you manually change the status of the payment or delete it, the failed ACH payment stays complete in the accounting system and the invoice is reflected as paid.
Importing Vaulted Shoppers to your Accounting System
Sync BlueSnap Shoppers as Customers
If you're processing payments for new shoppers in BlueSnap and want to import them as customers into your accounting system, you can use AR Automation.
Use the AR Automation setting Sync BlueSnap Shoppers as Customers. With this feature, customers in AR Automation are linked with shoppers in BlueSnap, allowing you to view the associated payment method. If a shopper is created in BlueSnap, but not linked with a customer in AR Automation, then a new customer will be created automatically in AR Automation as well as your accounting system. This happens behind the scenes using the account number or vaulted shopper ID from the merchant transaction ID you pass.
Sync Payment Methods from BlueSnap
If you would like to update payment methods between BlueSnap and AR Automation you can enable setting Sync Payment Methods from BlueSnap. This feature offers the ability to sync payment methods from BlueSnap to AR Automation. If the customer is not already linked to a shopper payment method in BlueSnap, a new customer will not be created. This syncing process also relies on the account number or vaulted shopper ID from the merchant transaction ID.
Both settings can be enabled by navigating to Preferences > Payments.
If you would like to automatically update a shopper’s payment method in AR Automation when their card expires or changes, you can enable the Account Updater IPN in your BlueSnap account.
Updated 10 months ago