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!

Our Quickbooks Online integration with Business Importer gives you a free B-importer account. Ideal for advisors serving about 15+ clients, the integration 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'll 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 requires that it is  8-12 characters long and contains at least one number, one alphabetic character, and one special character (@#!$%^&+=).

Once you register, you'll 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'll 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.

Income accounts track the source of your company's income while expense accounts track what your company is spending. Unlike balance sheet accounts, income and expense accounts do not have their own registers.

  • Income/ Other Income
  • Expense/ Other Expense

For most businesses, the standard Chart of Accounts provided during the initial QuickBooks Online account setup will meet your needs, but there may be times when you'll need to add to, edit, or delete accounts from your Chart of Accounts due to the changing requirements of your business (see below):

Workaround to Capture Fees directly in your Quickbooks Online account:
  • 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.    Go to Bookkeeping and select Chart of accounts
    • b.    Select New
    • c.    Select the appropriate account type from the Account Type dropdown menu
    • d.    Select the appropriate Detail Type from the dropdown menu
    • e.    Fill in all remaining fields and select Save and Close

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. 👍 If it's helpful, here is a great Quickbooks article with step by step instructions!

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? While we don't currently offer support for setting up your Xero integration, we would love to help point you to some additional resources! 

Still need help? Contact Us Contact Us