Learn how to integrate your accounting software seamlessly with your Admin Site to streamline your financial processes and enhance efficiency.
Summary:
Campspot’s accounting integration automates the syncing of daily journal entries between our Property Management System (PMS) and your preferred accounting software. This integration supports both cash and accrual accounting methods, ensuring flexibility for your financial reporting needs. In this article, you will learn how to set up the integration, authenticate with your accounting software, map your accounts effectively, and submit your first sync date for seamless integration.
Uses:
- Time-saving: Say goodbye to manual data entry and tedious reconciliations. Sync journal entries seamlessly, saving valuable time and reducing errors.
- Accuracy: Minimize human error by automating data transfer between Campspot and your accounting software.
- Flexibility: Choose from leading accounting software options, including Quickbooks Online, Sage Intacct, and Netsuite.
- Efficiency: Keep your financial records up-to-date with daily syncing, providing real-time insights into your property's performance.
Introduction to Accounting Software
Campspot’s accounting integration offers seamless syncing with leading accounting software, ensuring compatibility and ease of use for our users. This integration supports the following Accounting Software:
-
Quickbooks Online: A popular choice for small to medium-sized businesses, Quickbooks Online offers robust accounting features and cloud-based accessibility.
-
Sage Intacct: Designed for growing businesses, Sage Intacct provides advanced financial management solutions with customizable reporting and automation capabilities.
-
Netsuite: Ideal for larger enterprises, Netsuite offers comprehensive business management features, including accounting, ERP, CRM, and e-commerce, all in one integrated platform.
- Xero: A cloud-based accounting solution for small to medium-sized businesses, offering invoicing, payroll, expense management, and real-time financial reporting.
Step-by-Step Setup Guide:
Step 1: Submit Activation Request Form
- Fill out this activation request form, providing your information, Park Name / ID, preferred accounting software, and accounting type (cash or accrual).
Unsure of your accounting type? Check out this article:
Step 2: Verify User Permission in your Campspot Admin Site
Before moving forward with the integration setup, ensure the user(s) completing setup in Campspot has the necessary permissions to view and edit integrations. Follow these steps in Campspot:
- Navigate to User Management.
- Click on Roles in the top right corner.
- Find and click on the User Role assigned to the User requiring access to Integrations.
- Click on Customize permissions under Campground Setup.
- Verify the View and Edit Integrations permission is checked.
- Click Save Changes if changes were made.
Step 3: Authenticate with Your Accounting Software
In completing this step, you will be defining the connection between your Admin Site and your Accounting software. This connection will provide your Admin Site an import of accounts from the Accounting software necessary for the next steps.
- Navigate to Campground Setup.
- Click on the Integrations tab.
- Locate the Accounting integration.
- Authenticate using your Accounting Software login credentials.
- Click Confirm.
The example below shows a successful integration and authentication of Quickbooks.
Please Note: You must be successfully authenticated with your accounting software before proceeding to the next step. You will know the authentication is successful when the accounting software card on the integrations page is green and says "Connected."
Step 4: Map Your Admin Site Financial Accounts
- Navigate to Campground Setup.
- Click on the Accounting tab.
- If Step 3 was successful, you will now see a new column: External Accounts.
- Map your imported accounting integration accounts to corresponding Campspot financial accounts.
- Review the Financial Account Best Practices below to ensure efficiency and accuracy.
Important Note for Accrual Journal Entries in QuickBooks Online (QBO)
When syncing accrual journal entries with QuickBooks Online, it is essential to note that the default QBO Accounts Receivable (AR) account cannot be used. To ensure successful synchronization, please follow these steps:
-
Create a New Account in QBO:
- Navigate to your QBO account.
- Create a new account under "Other Asset."
- Name this account "Accounts Receivable" or any preferred name for your AR account.
-
Additional Information Requirements:
- Be aware that some additional information requirements for posting to the QBO AR account are not supported by our journal entries.
Please Note:
Take care to map all active Financial Accounts. If activity is posted to an account that is not mapped to one of your accounting software accounts, the journal entry will not be synced for that day.Financial Account Best Practices:
- Keep only active financial accounts in use in your Admin Site to streamline your financial reporting.
- Deactivate unused accounts and ensure proper mapping to prevent syncing errors.
- Utilize the Financial Account Mapping report to manage account mappings effectively.
- Deferred Accounts - Accrual Basis Accounting Only
-
All Campspot deferred revenue accounts can be mapped to a single integration account, typically one for all deferred revenue activity. However, multiple deferred revenue accounts in your accounting software can be mapped accordingly.
-
Ensure all active deferred revenue accounts are mapped to an integration account to avoid syncing issues. Any deferred revenue accounts not mapped could prevent your journal entry from syncing, so it's crucial to map all financial accounts in use.
-
Step 5: Submit Your First Sync Date
Once all active Campspot financial accounts are mapped, submit your first sync date to initiate the integration by replying to an email received from your Campspot Market Manager.
Most Common FAQ:
Q: Are there any costs to use this integration?
Campspot fees:
Campspot charges a $10 per month per park fee to access select integrations. If you are already taking advantage of another integration for your park, there will be no added setup costs.
Accounting Integration Fees:
Any fees associated to the cost of the integration are discussed with the partner directly.
Q: What accounting software does the integration support?
Campspot's integration supports Quickbooks Online, Sage Intacct, and Netsuite.
Q: Can I choose between cash and accrual accounting methods?
Yes, the integration supports both cash and accrual accounting methods.
Q: How often does the integration sync data?
Data is synced daily, providing real-time updates to your financial records.
Q: If a change is made to my Admin Site Financial Account mapping, how quickly will my Accounting software reflect that change?
New accounts or renamed accounts from the accounting software will sync instantly with Campspot.
Changes made to Admin Site Financial Account mappings will be reflected in the accounting software on the next journal entry sync.
Q: What happens if an account is not mapped properly?
If an account is not mapped correctly, journal entries associated with that account will not be synced for that day.