Integrations
QuickBooks Online + Asset Panda Pro
Calculate depreciation in Asset Panda Pro and send journal entries to QuickBooks Online, with mapped accounts and flexible grouping that cuts manual data entry.
Key benefits
-
Reduce manual journal-entry work
Send depreciation values to QuickBooks Online without exporting schedules and re-entering figures by hand.
-
Map entries to your GL accounts
Choose debit and credit accounts and map depreciation dates, amounts, and memo information to the corresponding journal entry fields.
-
Choose the level of reporting detail
Create individual journal entries or group depreciation by asset, collection, or fields such as department, location, and category.
What depreciation data is sent to QuickBooks Online?
The integration sends depreciation journal-entry information from Asset Panda Pro to QuickBooks Online. You choose the source collection and the accounts and fields used for the entry.
| Data or setting | Asset Panda Pro configuration | QuickBooks Online outcome |
|---|---|---|
| Date and amount | Depreciation date and depreciation amount (default mappings) | Journal entry depreciation date and line amount |
| Debit and credit accounts | Select the Credit GL and Debit GL accounts | Journal entry lines use the mapped GL accounts |
| Memo | Choose a field for description or notes | Journal entry memo |
| Entry grouping | One entry per record, or group by asset, collection, or a selected field | Individual or consolidated depreciation entries |
How the QuickBooks Online integration works
-
Prepare your QuickBooks connection
In the Intuit Developer portal, create a QuickBooks Online and Payments app, select the Accounting scope, and obtain the Client ID and Client Secret.
-
Connect QuickBooks in Asset Panda Pro
Open the Integrations Store from Account Management, add QuickBooks, enter your app credentials, authorize the connection, and test and save it.
-
Map depreciation and GL accounts
Choose the collection with depreciation data, select the debit and credit accounts, and set your date, amount, and memo mappings.
-
Save your mapping and run the sync
Choose how to group your depreciation entries and save the mapping. Depreciation journal entries are posted to QuickBooks Online when the configured sync runs, either on a schedule or manually. Make sure each depreciation period is processed only once to avoid duplicate entries.
Detailed setup: QuickBooks Integration Knowledge Base
Requirements
- An active Asset Panda Pro subscription and QuickBooks Online account.
- Administrator access to Asset Panda Pro and QuickBooks Online.
- An Intuit Developer app configured for QuickBooks Online and Payments with the Accounting scope, required OAuth redirect URI, Client ID, and Client Secret.
- An Asset Panda Pro collection where depreciation is calculated, plus the appropriate GL accounts for your journal-entry mapping.
Frequently asked questions
Where is asset depreciation calculated?
Asset Panda Pro calculates depreciation for records in your selected collection. When the configured sync runs, those depreciation values are transferred to QuickBooks Online as journal entries.
Which direction does the QuickBooks Online integration send data?
The depreciation journal-entry workflow sends data from Asset Panda Pro to QuickBooks Online.
Can I choose which QuickBooks accounts receive depreciation entries?
Yes. When creating a mapping, you select the Debit GL and Credit GL accounts used for the journal entries.
Can I group depreciation entries by department or location?
Yes. You can group by a selected field such as department, location, or category, aggregate by asset or collection, or create individual entries per record.
What information can appear in a QuickBooks journal entry?
The integration maps depreciation date and amount, uses your selected GL accounts, and lets you choose an Asset Panda Pro field for the journal-entry memo.
Do I need an Intuit Developer app to connect QuickBooks Online?
Yes. Create an app with the Accounting scope in the Intuit Developer portal, then use its Client ID and Client Secret to authorize the connection in Asset Panda Pro.
How are depreciation journal entries posted to QuickBooks Online?
Depreciation journal entries are posted when the configured sync runs, either on a schedule or manually by clicking Run. Process each depreciation period only once, as running the sync again for the same period can create duplicate journal entries in QuickBooks Online.
About QuickBooks Online
QuickBooks Online is Intuit's cloud-based accounting platform for managing financial records and reporting. Its journal entries help record accounting adjustments such as depreciation. Asset Panda Pro complements QuickBooks Online by calculating depreciation from asset records and sending the resulting amounts into the books.
Connect asset depreciation with your books
Keep depreciation calculations in Asset Panda Pro and record the results in QuickBooks Online with less manual work.