Quickbooks Online (via Business Importer)

Only available for set up by the Account Owner, Full-Access Advisor, or a firm Admin user on our Professional and Enterprise Platforms. It is not available on the Essential plan. Read more about our plans here!

Ideal for advisors serving about 15 or more clients, our Quickbooks Online integration with Business Importer is a fantastic way to improve efficiency and help you spend less time in bookkeeping tasks and more time in what you love -- helping people with their financial planning!

If you decide to take advantage of the B-importer integration, you will no longer have to manually enter invoices and sales receipts into Quickbooks Online. Instead you can accurately import the data for gross payments, meaning the data on your books will match your invoices! 

The fees associated with each transaction will also be imported, providing you with a complete record of the gross payment amount, the fees, and the net amount. 

Not a Quickbooks Online user? This integration provides you with a free Business Importer account, which also allows you to sync with Xero, Sage Business Cloud Accounting (Sage One), or MYOB! At this time we do not have an integration with Quickbooks Desktop. Download your transaction reports to obtain a CSV of your payouts and individual client payments!

Let's get started!

Step 1: 

Set up your Business Importer account at  Firm Settings > Integrations. Click Connect to begin the registration process for your free account:

On the sign up page, b-importer will automatically pull in your name (which is editable) and your AdvicePay account email (which is not editable). When setting and confirming your own password, b-importer will require that it is  8-12 characters long and it contains at least one numberone alphabetic character, and one special character (@#!$%^&+=).

Once you register, you will receive an email from Business Importer asking you to confirm your account. Follow the link you receive to finalize the account and log in!

Step 2: 

If you use the Discount Feature in Quickbooks Online then you will need to skip this section and manually enter the fees later.  However by using this workaround the fees are captured as Merchant Account Fees and posted to the Profit and Loss Statement as an expense.  This will post the fees in the discount line on the Invoices and Sales Receipts.
Workaround to Capture Fees
  • 1.     Log into Quickbooks Online
  • 2.     Click on the gear icon in upper right of screen

  • 3.     Click on Company Settings
  • 4.     Click on Sales
  • 5.     Turn on Discounts
    • a.     Click on Pencil
    • b.     Check Discounts to turn on
    • c.     Save
  • 6.     Go to Chart of Account
    • a.     Find Discounts and Refunds
    • b.     Change Account Type from Income to Expenses
    • c.     Change Detail Type from Discounts/Refunds Given to Other Miscellaneous Service Cost  
    • d.     Change Name from Discounts/Refunds Given to Merchant Fees

Your QuickBooks account is now ready for using the software to bring in AdvicePay Income and related Merchant Fees!

Note: This is a one-time set up. 👍

Step 3: 

Log in to AdvicePay.

  • 1.     Download your Transactions Reports, adjusting the dates for the time period you need to upload.
  • 2.     Add two columns.  One for the Product/Service you are billing for and one for the deposit account (always use Undeposited Funds).  These have to match your spelling in QB exactly.

  • 3.     Save as: .CSV file

Step 4: 

Open Business Importer.

  • 1.     Click on Import
  • 2.     Upload the saved transaction file
  • 3.     Entity to import:  Sales Receipts
  • 4.     Match to Spreadsheet
    • a.     Customer to Client Name
    • b.     Product Name to Product/Service
    • c.     Sale Receipt # to AdvicePay Invoice #
    • d.     Deposit to – Undeposited Funds
    • e.     Amount to Gross Amount
    • f.      Description to Invoice Description
    • g.     Discount to Fee
    • h.     Sales Receipt Date to Paid Date
  • 5.     Click Next
  • 6.     Preview
  • 7.     Click Start Import

Looking for help using B-importer to integrate with Xero instead? We don't currently offer support for setting up your Xero integration, however we would love to help point you to some additional resources! 

B-Importer also works with Sage Business Cloud Accounting (Sage One) and MYOB.  It is not available for Sage Intacct. 

Still need help? Contact Us Contact Us