QBO Link > QuickBooks Online Link - Initialize it


QuickBooks Online Link - Initialize it

[FOR AMICUS ADMINISTRATOR ONLY]

Before using the QuickBooks Online Link on a day-to-day basis, you must first perform some configuration steps and a first exchange. The Amicus QuickBooks Online Link Wizard guides you through this process.


Note: The following radio button must be enabled from within your browser:


This topic covers:

        Before you start

        Run the Link Wizard

        STEP 1 Connect to QuickBooks Online

        STEP 2: Customer Preferences

        STEP 3: Transaction Preferences

        STEP 4: Customer Mapping

        Initialize the Link

Before you start

Before running the link wizard you may want to add service items and general ledger accounts in QBO for these transactions if they do not already exist:

        Billed Fees

        Expenses

        Retainer

        Tax 1 and Tax 2

        Write Off, if you intend to credit a single service item for write offs

        And optionally add the following general ledger accounts for Trust:

o        Trust Liability

o        Trust Check (if you intend to print check in QuickBooks Online.

1.     Log into QuickBooks.

2.     Click the Gear icon at top of the screen to display the following menu:

        Please refer to your QuickBooks Online help for information on how to add service items and general ledger accounts.

3.     Map all Amicus accounts to QuickBooks General Ledger accounts.


Note: You can map multiple Amicus accounts to the same QuickBooks account if you wish.


        Click on a menu item to display a list. Click New and fill out the corresponding form in QuickBooks. Click Save and close to complete the process.

The basic Amicus accounts are General Bank, Fees Revenue, and Expense. If you've set the Link to exchange trust transactions, then two Trust Bank categories are listed for each Trust Bank Account defined in Amicus: a Trust Checks account and a Trust Receipts account. If taxes are enabled in any Amicus files, then a Tax 1 Liability account (and a Tax 2 Liability account if necessary) will be listed.

Amicus Accounts

QuickBooks Accounts (suggested)

General Bank

Undeposited Funds (Asset) account.

TIP: We recommend subsequently depositing funds to the appropriate General Bank account in QuickBooks.

Fee

Legal Fee Revenue account.

Expense

Typically, an Expense or Asset account.

[Trust Bank Accounts]

Trust Bank Accounts (as specified in your Options > Billing > Trust Accounts list), and only if you've configured the Link to exchange Trust transactions.

For each Trust Bank Account specified in Amicus, two are provided for mapping: a Trust Check account and a Trust Receipt account.

If you wish to use the Undeposited Funds (Asset) account, you should map Trust Checks and Trust Receipts to different QuickBooks accounts.

TIP: If you wish to use a single account for both Trust Checks and Trust Receipts, consider mapping both Amicus accounts to a QuickBooks clearing (exchange) account. This enables a QuickBooks user to print checks and receipts against this clearing account, upon which the funds would be transferred as appropriate.

Trust Liability Account GL

Client Funds in Trust

Only shown if you've configured the Link to exchange Trust transactions.

Trust Liability Account

Tax 1 Account GL
Only if Tax 1 is applied by the firm for one or more non-closed, billable files.

A clearing (exchange) Liability account.

Tax 2 Account GL

Only if Tax 2 is applied by the firm for one or more non-closed, billable files.

A clearing (exchange) Liability account.

Limitation Requirements

I.         Character fields cannot be longer than 21 characters

Run the Link Wizard

1.     Choose Options > QuickBooks Link to display the QuickBooks Link Wizard Initialization window:

        Select the Enable Amicus Cloud Integration with checkbox to enable the QuickBooks Online option

2.     Click the Go to QuickBooks Link Wizard Initialization bar to display the Go to QuickBooks Overview wizard:

         Click the STEP buttons to start, resume, or redo the steps.

STEP 1: Connect to QuickBooks Online

1.     On the first window that appears for STEP 1, click the Connect to QuickBooks button.



2.     The following window appears:

        Enter your Intuit ID and Password and click the Sign In button.
NOTE: You might not see this window if you are already signed in to QuickBooks Online.

3.      On the next window that appears, click the Authorize button to establish a connection.


4.     You are returned to the QuickBooks Link Wizard Initialization screen. The message complete appears under STEP 1. You are ready to go to the next step in the wizard.

Note: After connecting to QuickBooks Online you can use this step (STEP 1) to disconnect the QuickBooks Online Link.

STEP 2: Customer Preferences


Note: Conflicts are resolved based on the Link priority options set by Amicus Administrator.


1.     In the window that appears for STEP 2, select which database has more accurate client data (Amicus Cloud or QuickBooks Online) from the dropdown menu to determine which program’s records will overwrite the other in cases where matching records exist in both programs. This affects initialization but not subsequent exchanges.

2.      Click the Save & Close button and you are ready to go to the next step in the wizard.

STEP 3: Transaction Preferences

1.     On the first window that appears for STEP 3, choose a posting start date from the Calendar control field for Amicus Invoice, Payment, Write off/Credit Memo, and (optionally) Trust transactions to be exchanged to QuickBooks Online.

         Click the Next button.

2.     The next window appears. If you do not want to post trust transactions to QuickBooks Online, no changes need to be made to this window and you can click the Next button. If you do want to post trust transactions to QuickBooks Online, check the Post Trust transactions to QuickBooks option, complete the remaining fields by selecting items from the dropdown menus. Click the Next button.

        Starting Date to post Trust Transactions: Only trust transactions for this date or later will be transferred to QuickBooks Online.

        Trust Liability General Ledger Account: The General Ledger account (typically a liability account with a credit balance) that holds the trust liability balance.

NOTE: Changing this account after the QuickBooks Online link has been established will not retroactively change entries already posted.

        Post Amicus Trust Check in QuickBooks as: Select either Checks to be printed or General Journal Entry.

Selecting Checks to be printed displays all Amicus Trust Bank Accounts where you can map Amicus Trust bank accounts to QuickBooks Online bank accounts.

Selecting General Journal Entry displays the QuickBooks Online chart of accounts. Selected trust checks create a general journal entry with a debit against the QuickBooks Trust liability General Ledger account and a credit to the selected General Ledger account. When this option is selected, then you need to create a check manually in QuickBooks Online and choose the selected General Ledger account.

3.     On the next window, you can choose how items on bills are handled.

Note: Write-offs are only handled for US QuickBooks Online customers.

Please click on the appropriate link
.

        US QuickBooks Online Users

        Canadian QuickBooks Online Users


US QuickBooks Online Users

Transaction Mapping

Match Amicus Invoice items to a Service in QuickBooks

        Billed Fees: Bills created in Amicus may have many fees and time entries. When bills are posted in QuickBooks Online, Amicus invoices list one service item for the combined total of the fees/time entries (net of discounts or adjustments). The Billed Fees option lets you choose the single service item to be used on invoices for fees/time entries.

NOTE: Each service item in QuickBooks Online must be associated with a General Ledger account (typically an income account).  This ensures that when a client pays a bill that the proper account is credited.

        Expenses: Bills created in Amicus may have many expenses. When bills are posted in QuickBooks Online, Amicus invoices list one service item for the combined total of the expenses. The Expenses option lets you choose the single service item to be used on invoices for expenses.

        Retainer: If a client makes an advance payment prior to being invoiced or makes an overpayment on a bill and it is deposited to the general bank account, then this is considered a retainer. The Retainer option lets you choose the QuickBooks service item for retainer.

        Tax 1, Tax 2: When bills are posted in QuickBooks Online, taxes appear as service line items on the bill. The Tax options let you choose the service items to be used on invoices for taxes.

Invoice Write offs:

        A write off in Amicus creates a credit memo in QuickBooks Online to be applied to the customer’s outstanding invoices.

For this option you can select Credit single service item or Credit remaining outstanding items proportionally.

o        If you select Credit single service item, a drop-down list appears where you can select a service item. When bills are written off, this service item is used to create a single line item for the amount of fees and expenses that are being written off (net of taxes).

o        If you select Credit remaining outstanding items proportionally, the amount of the write off for fees and expenses (net of taxes) is determined in proportion of the amount of fees and expenses on the original invoice.

Canadian QuickBooks Online Users

Transaction Mapping

Match Amicus invoice items to a Service and Tax in QuickBooks

        Billed Fees: Bills created in Amicus may have many fees and time entries. When bills are posted in QuickBooks Online, Amicus invoices list one service item for the combined total of the fees/time entries (net of discounts or adjustments). The Billed Fees option lets you choose the single service item to be used on invoices for fees/time entries.

NOTE: Each service item in QuickBooks Online must be associated with a General Ledger account (typically an income account).  This ensures that when a client pays a bill that the proper account is credited.

        Expenses: Bills created in Amicus may have many expenses. When bills are posted in QuickBooks Online, Amicus invoices list one service item for the combined total of the expenses. The Expenses option lets you choose the single service item to be used on invoices for expenses.

        Retainer: If a client makes an advance payment prior to being invoiced or makes an overpayment on a bill and it is deposited to the general bank account, then this is considered a retainer. The Retainer option lets you choose the QuickBooks service item for retainer.

QuickBooks Tax Rates for:

Optionally, select a Tax Rate created in QuickBooks Online from the dropdown list in the appropriate field.

o        The dropdown lists default to "Select QuickBooks Tax Rate".

Invoice Write offs

        Write-offs in Amicus Cloud are not exchanged with QuickBooks Online. The write-offs must be performed in both applications.

 

4.     Click the Finish button and you are ready to go to the next step in the wizard.

Step 4: Customer Mapping

The Customer Mapping window lets you map Amicus Clients to QuickBooks Online customers.

 


 

1.     Click the Auto Map button. The system maps the unmapped records where it is possible. The names must be exactly the same.

        Clients/Customer records in:

o        Grey have been matched and mapped.

o        Bold indicates that no match was found in QuickBooks Online.

o        Red indicates matching problems (for example, multiple corresponding matches in QuickBooks Online).

        Hover over a Client/Customer record for more information about the conflict.

2.     Map remaining unmapped records and conflicts manually. Highlight an unmapped record and then highlight a corresponding record and click the Map button (or Unmap button as appropriate).

3.     Click the Save & Close button and you are ready to initialize the link.

Initialize the Link

1.     Once the four steps are completed, the Initialization Complete option is active. Click this option.


2.     The following message appears. Click OK to complete the initialization process.

        The initialization process can take some time. You can continue your work in Amicus Cloud as you wish.

        To check your initialization status, click the Status button.

        When the initialization process is complete, a notification message appears in the window. If the process failed, a link providing the option to retry initialization appears.

        QuickBooks Online Link - What is it?

        QuickBooks OnlineLink - How to use it

        QuickBooks OnlineLink - What does it exchange?

        Importing QuickBooks customers into Amicus


Amicus Cloud (July 2023)

Copyright