How do I Configure the QuickBooks Integration?

Updated on January 2, 2020 04:07AM by Admin

In Apptivo, We can set up an Invoice /Expense Report that has been synced with QuickBooks. In order to successfully sync the journal records with QuickBooks go through the following 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 the enabled state.
    toggle enabled

Current Account Period

  1. Go to Ledger's home page.
  2. Click on the "Accounting Periods" dropdown.
  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://answers.apptivo.com/questions/13089/how-do-i-integrate-invoices-with-quickbooks
Once done, follow the steps 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 the "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 recent transactions.
  4. We can find synced journal entries from Recent Transactions.
    journal entry