Download gateway statements in QuickBooks or Xero

Problem Statement

You need to download payment gateway statements from Chargebee for use in reconciling payments with QuickBooks or Xero.

Solution

Gateway statements are generated from Chargebee and then uploaded or matched in your accounting software. Generate the statement first, then download it.

Steps to Set It Up

1. Go to Settings → Third-Party Integrations → select QuickBooks or Xero.
2. Open the Reconciliation section. If reconciliation is not set up yet, complete Set up reconciliation first.
3. Click Generate New Statement.
4. In the Generate Gateway Statement dialog:
   • Select the gateway account (and currency if applicable).
   • Choose the date range (e.g. last reconciliation to current, or a custom start and end date).
   • Optionally enable Include pending transactions (for in-progress charges, payments, refunds) and Include unsettled payouts (for in-progress settlements and bank transfers).
5. Click Generate. When the statement is ready, download it and use it in QuickBooks or Xero for reconciliation.

Additional Information

For a full walkthrough, see this video.