Commerce Xero

Commerce Xero provides integration between Drupal Commerce and Xero.com online accounting.

Xero provides an online accounting system, which makes it easy to ingest bank statements, payments, invoices, transactions, etc... This makes reconciliation of e-commerce payments or transactions with bank statements painless.

Basic usage

• Configure Xero API.
• Visit Administration > Commerce > Configuration > Xero Accounting Integration > Strategies, and add a new Xero strategy. A Xero strategy allows you to customize how a Commerce order will be processed in Xero given
  • Payment Gateway: Stripe, Paypal, Authorize.net, etc...
  • Xero Bank Account: The bank that processes the payment method.
  • Xero Revenue Account: Your user-defined account code
  • Xero Type: Bank Transaction or Invoice
    • Depending on your Xero accounting work flow it may be easier to reconcile e-commerce bank statements via bank transactions. A more robust work flow might post these as invoices with invoice payments.
  • A number of processors for the strategy including adding tracking categories, posting Commerce transactions as payments on an Invoice and looking up existing invoices.
• When a Payment is received, Commerce Xero will add the payment and strategy to the Queue for processing. This will most-likely occur during cron runs, but can be manually run with actions, Queue Manager, Views Bulk Operations among others.
• A Bank Transaction, Invoice or Invoice and Payments will be added in your Xero organization. For instance, you can check the Bank Account to see bank transactions and payments that are not reconciled. You should then be abl eto use Xero's “auto-match” functionality to easily reconcile bank transactions to bank statements. Some experiences with reconciliation:
  • Paypal posts statements per transaction, are verbose, and very easy to reconcile.
  • Some other bank statements may not be as verbose, but auto-match should work by date and amount to match up multiple transactions to the statement.
• Note: Xero querying problems will be logged to watchdog by the Xero API module. Please report issues regarding commerce xero here.