QBOFeed and QBONode howtos.
There are 2 pieces to this puzzle. One is the Online Web App QBONode, and the other is a Thick Client QBOFeed.
Check out the Features page for some pretty pictures on how this rug ties it all together.
Short and sweet.
QBONode is a web app that you need to create a user for.
This user manages your connections to Quickbooks Online (QBO).
QBOFeed is a JavaFX thick client that uses QBONode to manage its access keys to QBO.
QBOFeed then interacts with QBO directlly using those keys and is responsible for uploading Invoices and Payments to QBO.
QBOFeed represents the logic of how you want your accounting to behave.
The only way QBOFeed can connect to Quickbooks Online is by using QBONode. So QBONode should be set up first.
QBOFeed configuration. This is the heart of the matter. This is where you determine how your invoices and payments will be treated by quickbooks. This is also where you will set vendor cost percentages, sales tax rates to use
for which locations.
Frequently Asked Questions
What does QBONode do?
The QBONode web app maintains access tokens that allow direct connection to Quickbooks online. Quickbooks requires OAuth2 authentication which does not work with normal Thick Client applications like QBOFeed. So QBONode acts as an intermediary. QBONode is where you establish the needed connections to your Quickbooks Online Companies.
How do I Connect to QBONode/Quickbooks?
Visit the QBONode website. Create a user and profile. If you are a customer who intends to use the QBOFeed program then a user account will be set up for you during the
Next from the QBONode website's Connections page, press the [connect to quickbooks] button.
Use your QBO username and password to grant the QBONode web app access your QBO books of business.
If there are multiple companies that you need to connect to then repeat the process for each company.
As an example, you may have one book of business for your Framing Operation named 'Austin Framing Warehouse'.
You may also have a gallery and framing design operation book of business named 'Austin Downtown Gallery' where you sell art and design framing.
Each of these books of business would need a connection and each would have a Connection Category.
What are Connection Categories?
A connection category represents a set of program behaviors with regards to how quickbooks Invoices, Payments, and Bills are handled.
a "Gallery" connection category treats ArtCloud and FrameReady invoices in a special way.
For every invoice received from ArtCloud, if there is a Consignment cost associated with the sale of that piece of art, a Vendor Bill and Invoice are created in quickbooks.
For every invoice received from FrameReady a Vendor Bill (for the Frame Shop vendor) and an Invoice are created in quickbooks. The amount paid to the framing vendor can be set as a percentage of the invoice amount. If that percentage is 0 then no vendor bill is created.
a "Warehouse" connection category treats FrameReady invoices in a special way.
For every invoice received from FrameReady, an Invoice is created with an amount that is a percentage of the FrameReady invoice amount.
For instance, your gallery may keep 40% of the gross for a frame order and the Frame shop gets 60%.
In this case the "warehouse" book of business get a quickbooks invoice for 60% of the FrameReady invoice amount.
The gallery book of business will get a quickbooks invoice for 40% and a Vendor bill for 60%.
Customers, Vendors, Inventory, and Items Sold
For any ArtCloud or FrameReady invoice, if a Customer, Vendor, or InventoryItem do not exist in quickbooks, they are created.
The inventory items are just entered as Items that will show up in an item list (Not the add on quickbooks inventory). These programs do NOT integrate into quickbooks inventory. It is assumed that ArtCloud maintains your art inventory and FrameReady maintains your framing workorders, invoices, inventory, etc.
Generic Thick Client
Easily Integrate Your Own Generic Thick Client with Quickbooks Online
If you have an new or existing program and want to integrate it with Quickbooks Online you can use QBONode to manage your QBO connections without all the hassles of OAuth2.
Access token and Refresh token management can be a real hassle for QBO integrators. QBONode simplifies the experience.
Simple, Secure Restful API for managing QBO connections (Access, Refresh Tokens, QBO Company association)
No need to define your own developer QBO app.
Not forced to manage a 'Valid Certificate' SSL only website with a registered domain. Thats all done for you with QBONode.
Source for QBONode and QBOFeed
Source for these programs is maintained on GitHub.