QuickBooks Integration

QuickBooks Online integration with Asset Panda Pro enables 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 in to 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 the generated Client ID and Client Secret and secure them.

9. Add the Redirect URI: https://login.assetpanda.com/integrations/quick_books (do not modify this URI).

Asset Panda Integration Configuration

1. Sign in to Asset Panda as an admin.

2. Navigate to Settings > Account Management.

3. Under the relevant module, click Manage next to Integrations.

4. Open the Integration Store.

5. Locate the QuickBooks tile and click Add.

6. Go to the Integrations in this module tab and click Configure next to QuickBooks.

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

8. Click Authorize; the Realm ID / Company ID will populate automatically.

9. Click Test and save connection.

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

Mapping Fields and Sync Direction

1. Enter a Mapping Name for your configuration.

2. Select the Collection (typically “Asset”) in which depreciation values are calculated for your records.

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

4. 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.

5. The following mappings are configured by default:

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

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

   • 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.

6. Click Save to finalize the mapping configuration.