Chart of Accounts Integration

Chart of Accounts Integration Guide

Complete guide to configuring and managing Chart of Accounts mappings for automatic synchronization with your accounting software.

Table of Contents

1. Overview
2. Connecting an Accounting Provider
3. Importing Chart of Accounts
4. Mapping Expense Categories
5. Mapping Revenue Accounts
6. Validating Mappings
7. Managing Mappings
8. Troubleshooting

Overview

The Chart of Accounts (COA) integration enables automatic synchronization of financial data between the notarial platform and your accounting software. By mapping expense categories and revenue types to corresponding accounts in QuickBooks, Xero, or other supported providers, you eliminate manual data entry and ensure accurate financial records.

Benefits

• Automatic Sync: Expenses and payments sync automatically to the correct accounts
• Error Reduction: Eliminate manual data entry mistakes
• Time Savings: Hours saved each month on duplicate data entry
• Audit Trail: Complete history of all synced transactions
• Multi-Provider Support: QuickBooks (available), Xero, FreshBooks, Wave, Sage (coming soon)

How It Works

1. Connect your accounting provider via secure OAuth
2. Import your Chart of Accounts from the provider
3. Map expense categories to corresponding accounts
4. Configure revenue accounts for invoice sync
5. Validate mappings to ensure completeness
6. Sync financial data automatically

Connecting an Accounting Provider

Before importing accounts, you must connect your accounting provider.

Supported Providers

Connection Steps (QuickBooks)

1. Navigate to Settings > Integrations > Accounting
2. Click Connect Provider
3. Select QuickBooks from the dropdown
4. Click Connect to QuickBooks
5. You will be redirected to Intuit's authorization page
6. Sign in with your QuickBooks credentials
7. Authorize the application to access your company data
8. Select the QuickBooks company to connect (if you have multiple)
9. Click Connect

The connection will be established and your OAuth tokens stored securely.

Connection Status

After connecting, you will see:

• Provider name (QuickBooks)
• Connection status (Connected)
• Last sync timestamp
• Company name/ID from QuickBooks

Importing Chart of Accounts

Once connected, import your Chart of Accounts to begin mapping.

Import Process

1. Navigate to Integrations > Accounting > Chart of Accounts
2. Click the Import Accounts button
3. The system will:
   • Validate your connection
   • Fetch all active accounts from QuickBooks
   • Filter accounts by type (Expense, Income, Asset, Liability, Equity)
   • Store accounts in the platform
4. Review the import summary:
   • Total: Number of accounts found
   • Imported: Number successfully imported
   • Failed: Number that failed to import
   • Errors: Any error messages

What Gets Imported

For each account, the following information is imported:

• Account GUID (unique identifier from QuickBooks)
• Account Name
• Account Type (Expense, Income, Asset, Liability, Equity)
• Account Subtype (e.g., ParkingAndTolls, OperatingIncome)
• Account Code/Number
• Current Balance (optional)
• Active/Inactive status

Imported Account Status

Newly imported accounts are initially:

• Unmapped: Not yet assigned to a category
• Inactive: Not used for sync until mapped

You must map accounts to categories before they become active.

Re-Importing

You can re-import at any time to:

• Update account names and details
• Add new accounts created in QuickBooks
• Sync account status changes
• Refresh account balances

Existing mappings are preserved during re-import.

Mapping Expense Categories

Map each expense category to the corresponding account in your accounting system.

Expense Categories

The following categories require mapping:

Mapping Steps

1. Navigate to Chart of Accounts > Expense Mappings
2. For each category:
   • Click Edit next to the category
   • Select the account from the dropdown
   • The dropdown shows all imported accounts filtered by type (Expense)
   • Click Save
3. The mapping becomes active immediately

Multiple Categories to One Account

You can map multiple expense categories to the same account. For example:

• parking and tolls can both map to "Parking and Tolls Expense"
• shipping and courier can both map to "Delivery Expense"

Account Selection Tips

• Use the Account Code to identify the correct account
• Review the Account Subtype for additional context
• Check with your accountant if unsure which account to use
• Consistency is key for accurate reporting

Mapping Revenue Accounts

Configure revenue accounts for invoice and payment synchronization.

Default Revenue Account

You must configure at least a default revenue account:

1. Navigate to Chart of Accounts > Revenue Mappings
2. Click Configure Default Revenue
3. Select an Income-type account from the dropdown
4. Click Save

The default revenue account is used for all invoices and payments unless an order-type-specific account is configured.

Order Type Specific Revenue (Optional)

For agencies that want to track revenue by order type:

1. Click Add Order Type Mapping
2. Select the Order Type (e.g., Real Estate Closing, Loan Signing)
3. Select the Revenue Account for that order type
4. Click Save

Order type specific accounts take precedence over the default account.

Revenue Account Hierarchy

Invoice Sync → Order Type Specific Account (if configured)
              → Default Revenue Account (fallback)

Example:

• Real Estate Closing invoices → "Real Estate Revenue" account
• All other invoices → "Service Revenue" account (default)

Validating Mappings

Validate your mappings to ensure all required categories are configured.

Run Validation

1. Navigate to Chart of Accounts > Validation
2. Click Run Validation
3. The system checks:
   • All required expense categories are mapped
   • Default revenue account is configured
   • Mapped accounts have valid GUIDs
   • No duplicate mappings exist

Validation Results

Validation shows:

Missing Mappings

If any required mappings are missing, you will see a list:

• Missing expense mappings (e.g., "parking", "supplies")
• Missing revenue mappings (e.g., "default")

Click on any missing mapping to configure it.

Fixing Invalid Mappings

Invalid mappings occur when:

• Account GUID is "PENDING_SETUP" (placeholder)
• Account was deleted in QuickBooks
• Account is inactive in QuickBooks

To fix:

1. Click Edit on the invalid mapping
2. Select a different account
3. Or re-import from QuickBooks to get updated account list

Managing Mappings

Editing Mappings

1. Navigate to the mapping (Expense or Revenue)
2. Click Edit next to the mapping
3. Select a different account
4. Click Save

The change takes effect immediately for future syncs. Historical syncs are not changed.

Deactivating Mappings

To temporarily disable a mapping without deleting it:

1. Click Edit on the mapping
2. Toggle Active to off
3. Click Save

Inactive mappings are not used for sync.

Deleting Mappings

1. Click Delete next to the mapping
2. Confirm the deletion

Deleted mappings cannot be recovered. You must recreate them if needed.

Viewing Mapping History

All mapping changes are logged in the audit trail:

1. Click History on the mapping
2. View:
   • Creation date and user
   • Modification history
   • Previous and new account assignments
   • Deactivation/deletion events

Troubleshooting

Import Issues

Import Fails with "No Accounting Provider Connected"

Cause: Accounting provider is not connected or connection was revoked.

Solution:

1. Navigate to Integrations > Accounting
2. Check connection status
3. If disconnected, click Connect Provider and re-authenticate

Import Returns 0 Accounts

Cause: QuickBooks company has no accounts, or wrong company selected.

Solution:

1. Verify you selected the correct QuickBooks company
2. Check that your QuickBooks Chart of Accounts is not empty
3. Ensure your QuickBooks user has permission to view accounts

Import Partial Failure

Cause: Some accounts failed to import due to API errors or rate limits.

Solution:

1. Review the error messages in the import summary
2. Wait a few minutes and try importing again
3. Contact support if errors persist

Mapping Issues

Cannot Find Account in Dropdown

Cause: Account was not imported, or is filtered out.

Solution:

1. Re-import Chart of Accounts to refresh the list
2. Check that the account is active in QuickBooks
3. Verify the account type (only Expense accounts shown for expense mapping, Income for revenue)

"PENDING_SETUP" Account GUID

Cause: Placeholder mapping created before import.

Solution:

1. Re-import Chart of Accounts
2. Edit the mapping and select a real account
3. Click Save to update the GUID

Mapping Shows as Invalid

Cause: Account was deleted or deactivated in QuickBooks.

Solution:

1. Re-import to sync account status
2. Edit the mapping and select a different account
3. Contact your accountant if unsure which account to use

Sync Issues

Expenses Not Syncing to QuickBooks

Cause: Category is not mapped or mapping is inactive.

Solution:

1. Run validation to identify unmapped categories
2. Check that the mapping is active
3. Verify the account GUID is valid (not "PENDING_SETUP")

Wrong Account Used for Expense

Cause: Incorrect mapping configuration.

Solution:

1. Check the expense category used
2. Verify the mapping for that category
3. Edit mapping to correct the account

Revenue Syncing to Wrong Account

Cause: Order type mapping misconfigured.

Solution:

1. Check if the order type has a specific mapping
2. Verify the default revenue account
3. Adjust mappings as needed

Validation Issues

Validation Fails with "Duplicate Mapping"

Cause: Two mappings exist for the same category and order type.

Solution:

1. Review the duplicate mappings
2. Deactivate or delete one of them
3. Re-run validation

Required Mapping Shows as Missing

Cause: Required category was never mapped or was deleted.

Solution:

1. Review the list of missing mappings
2. Configure each missing mapping
3. Re-run validation to confirm all are present

Provider-Specific Issues

QuickBooks Token Expired

Cause: OAuth token expired and auto-refresh failed.

Solution:

1. Navigate to Integrations > Accounting
2. Click Reconnect Provider
3. Re-authenticate with QuickBooks
4. Existing mappings are preserved

QuickBooks Company Not Found

Cause: Company was deleted in QuickBooks or wrong realm ID.

Solution:

1. Verify the company exists in your QuickBooks account
2. Disconnect and reconnect with the correct company
3. Confirm mappings after reconnection

Best Practices

Initial Setup

1. Import First: Always import accounts before creating manual mappings
2. Consult Accountant: Work with your accountant to select the correct accounts
3. Document Mappings: Keep a record of which categories map to which accounts
4. Validate Early: Run validation before relying on sync

Ongoing Maintenance

1. Re-import Periodically: Refresh account details monthly or quarterly
2. Review Validation: Run validation before key reporting periods
3. Audit Logs: Review mapping changes regularly
4. Monitor Sync Errors: Address sync errors promptly

Accounting Professional Tips

• Consistency: Use the same accounts for similar expense types
• Granularity: Balance between too many and too few accounts
• Separation: Keep personal and business expenses in separate accounts
• Documentation: Add descriptions to mappings for clarity

Related Articles

• Accounting Integration Overview
• Payment Processing Guide
• Invoice Management Guide
• Financial Reports
• Integrations Dashboard