Summarized Journal Entry - Export

Summarized Journal Entry of Income and Payments can be exported to QuickBooks Online. Steps to be followed are mentioned below:

Initial configuration

  • Login to blubilling using your blubilling account.

  • Go to System > Integration Settings > Accounting / ERP in Main Menu [url: http://<org>]

    • Set Integration Mode as “Summarized Journal Entries”

    • Set ERP/Account Integration as “QuickBooks   Online”

    • Enter values given by blusynergy for QuickBooks App Token, QuickBooks App Consumer Key, QuickBooks App Consumer Secret and click on Update.

  • You will be redirected to Integration home screen

  • Authorize blubilling to connect to your Intuit App

    • Click on “Integration Settings”, you will be redirected to Integration Configuration page. A new connect button would have got added as shown below:

    • Click on the Connect button and follow the steps to Authorize.

    • Click on Authorize.

    • You will be redirected to Integration Configuration page with appropriate status message as shown below

  • Important: You should create a master customer in your QuickBooks online account and enter the customer name and id in the configuration settings. This is a requirement by QuickBooks Online for exporting journal entries. QuickBooks Online will associate all the journal entries with this master customer. Export Journal Entries will work only if this customer is created in QuickBooks online and the details are stored in blubilling.

Import Chart of Accounts

  • Click on Billings > Accounting / ERP Integration in the main menu

  • Click on "Chart of Accounts"

  • Click on "Import Accounts from ERP"

  • Select Start Date and End Date (Date when Accounts were created in QuickBooks)

  • Status of the operation will be displayed under “Previous History” in “Accounting / ERP Integration” page.

  • If the Chart of Accounts are imported successfully, it can be viewed by again clicking on "Chart of Accounts"

  • NOTE: Before importing the Chart of Accounts, make sure "Account No." is assigned in QuickBooks [QuickBooks online does not assign account number by default] if not follow the steps below in QuickBooks (or see this link on the Intuit website):
  • Enable Account Numbers in the settings :
    • Click on Company Settings  under settings
    • Click on "Account Numbers" under "Company". Click on check boxes: "Account Numbers" and "Show Account Numbers"

  • Assign Account Numbers
    • Click on "Chart of Accounts" under Settings
    • Click on "Assign Account Numbers"

  • Enter Account Numbers in the first column

Mapping Chart of Accounts

  • Each Line item charge of all plans should be mapped to a particular account in QuickBooks Online. This can be done while editing the charge by selecting the accounting code.
  • If the Accounts are imported, all accounts of type INCOME / OTHER_CURRENT_ASSET should be shown as dropdown in Accounting code.
  • Note: This mapping is important, journal entries for income are made based on this mapping

Export Income Entries

  • Important: Make sure the master customer is setup as mentioned under "Initial Configuration" of this page
  • Select the Start Date and End Date. [Date when an Invoice was generated in blubilling]
  • Select "Export Income Entries"
  • Click on Export
  • Status will be updated and shown in the "Previous History".

Mapping Transactions with Chart of Accounts

  • Each Transaction type can be mapped to a particular Account in QuickBooks Online, It signifies that Journal entry for all those transactions made using a particular transaction type should be made in a particular account in QuickBooks Online.

Export Payment Entries

    • Important: Make sure the master customer is setup as mentioned under "Initial Configuration" of this page
    • Follow similar steps as "Export Income Entries",  Select "Export Payment Entries" instead of "Export Income Entries"