How do I Configure the Quickbooks Integration?

Updated on February 4, 2019 04:53AM by Admin

In Apptivo, We can setup an Invoice /Expense Report that has been synced with Quickbooks. In order to successfully sync the journal records with Quickbooks go through the following the steps.

  • Invoices App configuration
  • Journal Entry Creation based on Accounting Rule
  • Journal Entry Sync from Apptivo to QuickBooks

Ledger App Configuration

Before you start with the Quickbooks configuration process, you need to ensure whether the following things are set right in the Ledger App.

  1. Create a Calendar
  2. Security Actions
  3. Current Account Period

Calendar Setup

  1. Access the Ledger App.
  2. Click on "More (...)" icon -> "Settings" -> "Ledger" -> "Calendar".
  3. When you click on "Create" , you can view the create pop up. Fill in the required fields.
    create calendar
  4. You can now view the calendar that you have created.
    calendar setup
    Note: Make sure that your Period status is opened.

Security Actions

  1. Click on "More (...)" icon -> "Settings" -> "Security" -> "Actions".
  2. Make sure that the "Open Period", "Close Management" and "Post Soft Close Journal Entries" are in enabled state.
    toggle enabled

Current Account Period

  1. Go to Ledger's home page.
  2. Click on "Accounting Periods" drop down.
  3. Click on the current account period.(Say, Jun-2017)
  4. Make sure that the period status is in "Opened" status.
    status opened

Invoices App configuration

Follow the specified steps in the post for Account type configuration from the Invoices App: https://www.apptivo.com/answers/questions/13089/how-do-i-integrate-invoices-with-quickbooks
Once done, follow the steps as mentioned below:

  1. Click on "More (...)" icon -> "Settings" -> "Accounting Rule" -> "Invoices" .
  2. An accounting rule will be created automatically in the Invoices App as shown:
    accounting rules
  3. You can see a predefined accounting rule. Set "Status = Paid".
    set criteria
  4. Once all the changes are done, click on "Update" button to complete.

Journal Entry Creation based on Accounting Rule

  1. Create a new invoice.
  2. Click on the "Record Payment" option and mark the Invoice as "Paid".
    record payment
  3. The status will now be automatically set to "Paid".
    paid invoices
  4. Now, according to the accounting rule, a journal will be automatically created in the Ledger App as shown:
    journal entries

Journal Entry Sync from Apptivo to QuickBooks

In general, created Journal in Apptivo will get sync automatically in Quickbooks, but it may take some time.

  1. Go to the Quickbooks Home Page.
  2. Click on Search Icon from Top right header bar.
    search transactions
  3. It will display the recent transactions.
  4. We can find synced journal entries from Recent Transactions.
    journal entry