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>.blubilling.com/integration/integrationSettings]
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"