Browse Help articles!

BigCommerce + Xero bank feed reconciliation

Overview

  • This guide will cover how to reconcile BigCommerce transactions with the bank feed in Xero for those using the BigCommerce + Xero integration.
  • Allocate your payment deposits recorded in BigCommerce to the clearing accounts.

Reconcile BigCommerce clearing accounts by allocating payment deposits (No Stripe bank feed in Xero)

Follow the steps in this section if you do not have Stripe integrated with Xero. However, if you're using your Stripe account exclusively for your BigCommerce account, it is recommended that you to integrate Stripe with Xero for reconciliation purposes. If you do have Stripe integrated, follow the steps in the section below this one instead.

For each payment type, you need to take note of what clearing account it has been mapped to. Then, you'll need to go through the following steps for each payment type to complete the bank reconciliation process. To view the clearing accounts mapped to the payment types, follow this guide on accounts mapping.

Laura Tien July 31, 2023

BigCommerce + MYOB bank feed reconciliation

Overview

  • This guide will cover how to reconcile BigCommerce transactions with the bank feed in MYOB for those using the BigCommerce + MYOB integration.
  • Allocate your payment deposits recorded in BigCommerce to the clearing accounts.

Reconcile BigCommerce clearing accounts by allocating payment deposits

For each payment type, you need to take note of what clearing account it has been mapped to. Then, you'll need to go through the following steps for each payment type to complete the bank reconciliation process. To view the clearing accounts mapped to the payment types, follow this guide on accounts mapping.

Laura Tien July 31, 2023

BigCommerce + QuickBooks Online bank feed reconciliation

Overview

  • This guide will cover how to reconcile BigCommerce transactions with the bank feed in QuickBooks Online for those using the BigCommerce + QuickBooks Online integration.
  • Allocate your payment deposits recorded in BigCommerce to the clearing accounts.

Reconcile BigCommerce clearing accounts by allocating payment deposits

For each payment type, you need to take note of what clearing account it has been mapped to. Then, you'll need to go through the following steps for each payment type to complete the bank reconciliation process. To view the clearing accounts mapped to the payment types, follow this guide on accounts mapping.

Laura Tien July 31, 2023

WooCommerce + MYOB bank feed reconciliation

Overview

  • This guide will cover how to reconcile WooCommerce Payments/PayPal/Stripe transactions with the bank feed in MYOB for those using the WooCommerce + MYOB integration.
  • All sales and fees will need to be matched manually. If you’re using multiple payment processors, you need to go through the following process for each. Through the integration, we’re able to provide multi-currency support.

Reconciling WooCommerce sales

The WooCommerce Clearing Account is created automatically by the integration and is used as a clearing account for WooCommerce Payments transactions in your local currency.

Laura Tien July 24, 2023

WooCommerce + QuickBooks Online bank feed reconciliation

Overview

  • This guide will cover how to reconcile WooCommerce Payments/PayPal/Stripe transactions with the bank feed in QuickBooks Online for those using the WooCommerce + QuickBooks Online integration.
  • All sales and fees will need to be matched manually. If you’re using multiple payment processors, you need to go through the following process for each. Through the integration, we’re able to provide multi-currency support.

Reconciling local currency WooCommerce sales

The WooCommerce Clearing Account is created automatically by the integration and is used as a clearing account for WooCommerce Payments transactions in your local currency.

Laura Tien July 21, 2023

Square + MYOB bank feed reconciliation

Overview

  • Match the Square deposit to the synced payout transfer
  • Allocate other payment types to the clearing accounts

How to reconcile Square transfers

When the Square payout appears in the bank transactions, you must match this to the transfer transaction synced by the integration.

Laura Tien July 19, 2023

Square + QuickBooks Online bank feed reconciliation

Overview

  • This guide will cover how to reconcile Square transactions with the bank feed in QuickBooks Online for those using the Square + QuickBooks Online integration
  • Match the Square deposit to the synced payout transfer
  • Allocate other payment types to the clearing accounts

Reconciling Square transfer

  1. Log in to QuickBooks Online.

    Laura Tien July 19, 2023

Squarespace + Xero bank feed reconciliation

Overview

  • This guide will cover how to reconcile Squarespace transactions with the bank feed in Xero for those using the Squarespace + Xero integration.
  • Allocate your payment deposits recorded in Squarespace to the clearing accounts.

Reconcile Squarespace clearing accounts by allocating payment deposits

For each payment type, you need to take note of what clearing account it has been mapped to. Then, you'll need to go through the following steps for each payment type to complete the bank reconciliation process. To view the clearing accounts mapped to the payment types, follow this guide on accounts mapping.

Laura Tien July 19, 2023

Squarespace + QuickBooks Online bank feed reconciliation

Overview

  • This guide will cover how to reconcile Squarespace transactions with the bank feed in QuickBooks Online for those using the Squarespace + QuickBooks Online integration.
  • Allocate your payment deposits recorded in Squarespace to the clearing accounts.

Reconcile Squarespace clearing accounts by allocating payment deposits

For each payment type, you need to take note of what clearing account it has been mapped to. Then, you'll need to go through the following steps for each payment type to complete the bank reconciliation process. To view the clearing accounts mapped to the payment types, follow this guide on accounts mapping.

Laura Tien July 19, 2023

Squarespace + MYOB bank feed reconciliation

Overview

  • This guide will cover how to reconcile Squarespace transactions with the bank feed in MYOB for those using the Squarespace + MYOB integration.
  • Allocate your payment deposits recorded in Squarespace to the clearing accounts.

Reconcile Squarespace clearing accounts by allocating payment deposits

For each payment type, you need to take note of what clearing account it has been mapped to. Then, you'll need to go through the following steps for each payment type to complete the bank reconciliation process. To view the clearing accounts mapped to the payment types, follow this guide on accounts mapping.

Laura Tien July 19, 2023