This article will cover:
- How Does The Integration Work?
- How To Sync CAKE To A QuickBooks Online Account
- How To Set An Expense Account And Expense Class Name
- How To Link/Unlink Affiliate (Vendor) Or Buyer (Customer) Contacts
- How To Import Bills
- FAQ
How Does The Integration Work?
This integration allows you to match Affiliates with their associated Vendor name and Buyers with their associated Customer name in your QuickBooks Online account. Alternatively, you can import existing Affiliates and Buyers from CAKE to be created as new entities in the QuickBooks system. Once the entity mapping is completed, any bills generated in CAKE can then be imported into QuickBooks for ease of paying and invoicing these partners.
How To Sync CAKE To A QuickBooks Online Account
To connect your QuickBooks Online Account, follow these steps:
Navigate to Third Party Integrations Settings under Setup > Settings
Click Connect to QuickBooks green button
In the Intuit sign-in window, enter your Email or Quickbooks User ID and Password
After the screen refreshes, verify the Connection field lists the Company name associated with your QB account.
Note:
If you have an existing QuickBooks Online Integration with CAKE, you may need to disconnect it from the QuickBooks side under Apps > Action > Disconnect.
How To Set An Expense Account And Expense Class Name
Below the Connection field, you will see a dropdown to choose an Expense Account Name and Expense Class Name. These correspond to the areas in QuickBooks where your CAKE billing data will be filled. Each QuickBooks Online account will have a list of default Expense Account Names you can choose from if you have not already created one in QuickBooks.
Note:
Expense Class Name drop down will be blank unless you already have Class names added in Quickbooks. This field is only required if you leverage CAKE Lead Gen and wish to sync Buyer bills to your QuickBooks Online account. Please contact QuickBooks support if you need additional guidance on how to create Expense Account or Class Names.
How To Link/Unlink Affiliate (Vendor) Or Buyer (Customer) Contacts
All linking/unlinking is done via the Match Quickbooks card. It will display the names of any Vendors or Customers that were added in your QuickBooks Online account and next to each name, a link icon. Once the card is launched, you can search names if you need to filter through large lists of accounts or click Import New Vendor/Customer to create a new, linked contact in your QuickBooks system.
To link an Affiliate to a Vendor in your QuickBooks Online account, follow these steps:
Open an Affiliate Card
Navigate to the Home tab
Click on the Billing & Payments sub tab
Click the hyperlink on the last field called QuickBooks Link
Search the name of the associated Vendor
Click the Link icon
To link a Buyer to a Customer in your QuickBooks Online account, follow these steps:
Open a Buyer Card
Navigate to the Home tab
Click on the Advanced sub tab
Click the hyperlink on the last field called QuickBooks
Search the name of the associated Customer
Click the Link icon
Note:
Linking can also be done in the Account tab once you generate invoices for Affiliates or Buyers. The far right column titled Quickbooks will say Quickbooks Unlinked on accounts that have not yet been linked. Clicking on this will launch that same Match Quickbooks card.
How To Import Bills
Once a link has been established and a bill generated for that Affiliate or Buyer, the QuickBooks column in the Accounting tab will show the hyperlink option to Import. Click on this to import that bill amount
Successfully imported bills will change from the hyperlink of "Import" to text of "Imported - [Date of Import]"
Note:
If you need to make an adjustment on a bill that has already been imported, you will need to delete the invoice in QuickBooks, delete the line item in CAKE and then regenerate the bill. Adjustments do not automatically get reflected in QuickBooks.
FAQ
Does the QuickBooks Online Integration Support Advertiser Bills?
No, the integration does not support Advertiser Bills however, there is a field on the Advertiser card > Info tab called QuickBooks ID so you know the ID
You may also be interested in: