Veeqo offers a third party integration with QuickBooks. This will allow you to sync:
Customers
Products
Orders
Additional records
from Veeqo to QuickBooks Online.
To connect your Veeqo account to QuickBooks online, follow these steps:
Go to the Veeqo Marketplace and click “Get app” to register for the integration.
A request form will be generated, which you will need to fill in.
You will receive an email to verify your email address. Once this is done you will be redirected to the connections page
Enter your Veeqo API key and click Save to connect Veeqo with GenieLabs.
You will then need to connect QuickBooks with Genie labs by clicking the connect button below.
Click connect to agree to all relevant terms of service
Once both accounts are connected you can click on the Verify button.
This will redirect you to a checklist of the requirements you need to meet to connect your QuickBooks account with GenieLabs, you will need to ensure the following points are ticked. If any of these points show a cross there will be a link to configure your settings as needed for this connection.
Once your QuickBooks settings above are verified, click continue to select the settings related to how your data will sync.
Click “Save”.
If you have any queries or issues with this third party app please contact GenieLab, LLC
Support email* - support@thegenielab.com
Support number - +44 2921 28 0699
NOTE: our customer support team cannot provide you with tax information or tax advice, it is your responsibility to ensure any taxable income is correctly reported. If in doubt, you should seek independent professional advice.
QuickBooks Features
When integrated with QuickBooks, there are two phases of data transfer:
The Initial transfer - this transfers all records of Products and Customers from the last 20 years as well as records of Invoices and Purchase orders from 1 day before. The full transfer of invoices can be requested individually upon request.
The daily transfer - this executes a midnight push of all records to the queue that occurred on that day and transfers it.
As all the records follow the queue, the length of time it takes to complete the transfer is dependent on the volume of the data and can take up 12 hours. If any invoices fail to go through, we can manually push these invoices across if you provide us with the invoice IDs.
Information Synced to QuickBooks
Customer data
Customer data
We transfer the following fields to QuickBooks:
Email Address
Phone
Mobile
Billing Address & Shipping Address
First Name
Last Name
Email
Phone
Company
Address Line 1
Address Line 2
City
Country
State
Zip Code/ Post Code
The following information MUST be present for customer data to sync to QuickBooks:
First Name, Last Name and Email Address are required.
As QuickBooks needs a unique First & Last Name for every customer, in instances where we find duplicate names, we concatenate the postcode of the customer to the last name to make the customer unique.
The Email Address field is used as the ‘unique identifier’ to check if customer needs to be updated or created.
Where any of the required fields (i.e First Name, Last Name & Email Address) are not pulled in from Veeqo, we will use the customer’s unique ID from Veeqo to fill the required field to have a successful transfer. E.g: In case of Email Address we will use 1234567@veeqo.com. (Need Implementation)
Please note that QuickBooks is very strict with what data it accepts whereas Veeqo is more flexible, in some instances there will be customers which are not transferred into QuickBooks.
Product Data
Product Data
We transfer the following fields to QuickBooks:
Name
Description
SKU
Purchase Cost (cost_price)
Type (Inventory)
Unit Price (Price)
TrackQtyOnHand (True/False Track Inventory on QuickBooks side or not. Currently its true always but we will make it false) (Need Implementation)
QtyOnHand (The total Quantity in all locations)
SalesTaxIncluded (True/False will depend on the tax_rate value in Veeqo)
Taxable (True/False will depend on the tax_rate value in Veeqo)
Asset Account Reference (Selected from setting/configuration form)
Expense Account Reference (Selected from setting/configuration form)
Income Account Reference (Selected from setting/configuration form)
Inventory Start Date (Only passed when product created in QuickBooks)
The following information MUST be present for Veeqo to sync Product data to QuickBooks:
As QuickBooks use the product title as the ‘unique identifier’, in order to make the title unique we have provided an option on the settings/configuration form to concatenate SKU in the title or not. Due to the length limitation from QuickBooks we are ONLY using 100 characters from the title.
We are using SKU as unique identifiers to check that the product needs to be updated or created.
If the Quantity of the product is updated in Veeqo, the daily sync process will transfer the updated Quantity to QuickBooks. (In future no more tracking of Inventory on QuickBooks side ) (Need Implementation)
An ‘Income Account’ is required which can be selected via the settings/configuration form. If this is not selected then the default “SalesOfProductIncome” account will be used.
An ‘Inventory Account’ is required which can be selected via the settings/configuration form. If it is not selected then default “Inventory” account will be used.
A ‘Cost Of Goods’ account required which can be selected via the settings/configuration form. If it is not selected then default “SuppliesMaterialsCogs” account will be used.
Invoice Data
Invoice Data
We transfer the following fields to QuickBooks
Document Number (The invoice number from Veeqo)
Currency Reference (Currency Code e.g GBP)
Line Items
ID (The item id from QuickBooks)
Line Num (The item number in the order)
Description (The product title/name)
Amount (Price * Quantity)
Sales Line Item Detail
Item Reference
Unit Price
Qty
Tax Code Reference
Customer Reference
Billing Address
Address Line 1
Address Line 2
City
Country
State
Postal Code
Tax Detail
Total Tax
Tax Code Reference
Tax Line
Amount
Tax Line Detail
Tax Rate Reference
Percent Based
Tax Percent
Net Amount Taxable
Txn Date (Invoice Created Date)
Shipping Address
Address Line 1
Address Line 2
City
Country
State
Postal Code
The following information MUST be present for Veeqo to sync invoice data to QuickBooks:
The Invoice number from Veeqo is used to identify the invoice that needs to be updated or created in QuickBooks.
As a customer is required to be associated with an invoice, we will first check by Email Address to find the customer on QuickBooks. If the customer cannot be found then we will look for First Name and Last Name.
If a customer cannot be found on QuickBooks, then we will use the default customer with email pos@veeqo.com but in future if Email Address is not coming from Veeqo then we will use Veeqo Customer ID @veeqo.com as email. E.g 123456@veeqo.com. (Coming Soon)
Product is required and we use the Full Title to find the the product in QuickBooks.
In order to transfer the delivery cost we create a product of service type in QuickBooks and include it as line Item in the invoice.
In order to transfer discounts from Veeqo we have enabled an option to select the ‘QuickBooks Discount Account’ from the settings/configuration screen so that we can add the discount amount and discount account reference in invoices.
The Tax rate is also transferred by using the ‘Tax Account’ selected on settings/configuration screen. The tax percentage is dependent on your tax settings on the QuickBooks side.
Purchase Order Data
Purchase Order Data
We transfer the following fields to QuickBooks:
Supplier Reference
Billing Address
Address Line 1
Address Line 2
City
Country
Postal Code
Company Name
Display Name
Primary Phone
Primary Email Address
APA Account Reference (We are using the default “AccountsPayable” from QuickBooks )
PO Status: (In case of Pending, Ordering, Shipping, Receiving, Returning we use “open” in QuickBooks and in case of returned / completed we use “closed” in QuickBooks)
Domain (Veeqo)
Currency Reference
Total Amount
Line Items
FAQs
FAQs
1) How do you write off stock in Veeqo?
You can’t currently write off stock in Veeqo. You would reduce the stock levels in Veeqo to ensure you don't oversell on your platforms but in terms of accounting, this would need to be managed directly in Quickbooks.
2) How are COGs calculated?
Set cost prices in Veeqo for your products and every time an order is exported, we will create a journal in Quickbooks to decrease your stock value and put into your COGS on your profit & loss in Quickbooks. So you get accurate profits showing in Quickbooks. If you use Veeqo for creating Purchases Orders then we will automatically recalculate the average Cost Price of your products.
3) Alongside the physical cost, we have other elements that make up the GOGs including packaging, royalty and a fulfilment house service charge. How do all these get rolled up into COGs?
Veeqo, as standard, handles only the average “cost price” to you as a business to purchase the physical product. You would need to either manually adjust the cost price of your products in Veeqo to include any additional costs or periodically add manual entries for any additional costs with regards to order processing.
4) I have a direct feed from my sales channel into our accounting software, but I still need some information to come across from Veeqo, how can I manage this?
If Quickbooks is integrated to Veeqo then we will create Sales Invoices & Payable Bills for Suppliers for ALL Orders and Purchase Orders raised in Veeqo. You cannot select which information is/isn't synced.
5) How often is data synched to our accounting software?
The sync will occur daily at 00:00 UTC.
6) What will the invoice number be in QuickBooks?
The order created date you see in Veeqo will be the date that you will see in QuickBooks
7) What date will be against my invoices in QuickBooks?
The order created date you see against the order in Veeqo, will be the same date that will be sent to QuickBooks
8) How do I push stock to QuickBooks?
By default pushing inventory from Veeqo to Quickbooks is turned OFF. To turn this on, please contact the support team. The support team will then contact Genie Labs to have this enabled for you.