Docs
Chargebee plugin for QBO not reconciling
Need help running the Chargebee chrome plugin for QBO reconciliation. Currently not matching transactions.
Summary
To ensure reconciling happens between Chargebee and Quickbooks. Please follow the below steps
Download Gateway Statement from Chargebee
Upload Gateway Statement in QuickBooks
Start Reconciliation Process
Review the Reconciled Payments
Map the Gateway Processing Fees
Transfer Settlement Amount to a Bank Account
Solution
If you have not enabled reconciliation during the initial configuration, you can begin the setup and select a clearing account.
Connect your Chargebee and QuickBooks accounts. Click Settings > Third-Party Integrations > QuickBooks > Reconciliation to navigate to the QuickBooks integration sync settings page
Click Generate New Statement under the Reconciliation tab. The Reconciliation tab displays up to five recently generated gateway statements. You can also view the generated time and the date range of these statements.
Select the date range for which the statement should be downloaded. You can choose to download from Last reconciliation till current date or select start and end date, as required.
You can optionally select Include pending transactions for charges, payments and refunds that are in in-progress status to be included in the reconciliation statement.
Similarly, select Include unsettled payouts to include settlements and bank transfers that are in in-progress status to be included in the reconciliation statement.
If you have an existing gateway account in QuickBooks to manage the gateway statement, you can use that, or you can create a new bank chart of account and import the Gateway statement.
Note: When you upload the gateway statement and map the bank account fields with the CSV file fields, make sure that the date format is in sync with the date format selected while generating the payment gateway statement in Chargebee
Chargebee's plugin is compatible with the current reconciliation logic and User Interface (UI) of QuickBooks. Any further updates on the QuickBooks reconciliation logic or UI will not be supported automatically by the plugin and might disrupt the reconciliation process.
Note: If a match is not found, the extension will skip the entry and proceed to the next transaction. The extension will not match Gateway Fees and Settlement/transfers to Bank, these should be reconciled as explained in the following steps
After the Payments and refunds are reconciled, the settlement entries should be reconciled. You need to transfer the lump sum amount from the Gateway account to an actual Bank Account.
Now run the Reconciliation process for the Bank Account as well. Reconciliation is now complete and all entries are processed.
Click here to know more.
Articles & FAQ