QuickBooks Integration

You can integrate QuickBooks Online with Asset Panda Pro to enable the calculation of asset depreciation and the direct transfer of depreciation values into QuickBooks as journal entries. The process eliminates manual entry, reduces errors, and ensures financial records remain accurate and current. Depreciation data synchronized between both platforms supports efficient accounting workflows and reliable financial reporting.

Prerequisites

• Active Asset Panda Pro subscription

• Active QuickBooks Online account

• Administrator access to both Asset Panda Pro and QuickBooks Online

QuickBooks Developer Portal setup

1. Log into your Intuit Developer account at Intuit Developer.

2. Click Create an app and select QuickBooks Online and Payments.

3. Name the app and select the Accounting option, then complete app creation.

4. Navigate to the Keys & OAuth section under Production settings.

5. Verify your email and complete account profile details as required.

6. Provide URLs for the End User License Agreement (EULA) and privacy policy in Production settings.

7. Set the API Scope to accounting and save.

8. Copy and secure the generated Client ID and Client Secret.

9. Add the Redirect URI: https://login.assetpanda.com/integrations/quick_books.

Do not modify this URI.

Set up the QuickBooks integration in Asset Panda Pro

1. Log into Asset Panda Pro with an administrator account

2. Navigate to Settings > Account Management.

3. Expand the appropriate account and module.

4. Click Manage in the Integrations card.

5. Select Integrations Store.

6. In the QuickBooks tile, click Add. The Integrations in this module tab is displayed.

7. In the QuickBooks tile, click Configure.

8. Enter the Client ID and Client Secret from your Intuit Developer app.

9. Click Authorize. The Realm ID and Company ID are populated automatically.

10. Click Test and save connection.

11. If the test is successful, click Continue with mapping.

12. Enter a Mapping Name for your configuration.

13. Select the collection (for example, Assets) in which depreciation values are calculated for your records.

14. Choose the appropriate Credit GL and Debit GL accounts for journal entries.

15. Use Group records by for advanced grouping and aggregation:

    • Aggregate depreciation by asset or by collection to enable consolidated financial reporting.

    • Group entries by custom fields (such as category, location, or department) for tailored sync and reporting, allowing single journal entries for each group or summary type.

    • Leave the grouping blank to generate individual journal entries for each record.

The following mappings are configured by default:

• Depreciation Date in QuickBooks maps to Depreciation date in Asset Panda Pro.

• Line Amount in QuickBooks maps to Depreciation amount in Asset Panda Pro.

1. Select a Memo field from the available Asset Panda Pro fields. Use the Memo field for descriptions, notes, or free-text information in QuickBooks journal entries.

2. Click Save.