Resources for Ability Financial Exchange for QuickBooks Online
Find answers, how to’s, videos, best practices to questions and workflows along with resources for Ability Financial Exchange, a sync tool and connector, for QuickBooks Online and QuickBooks POS.
What you need to know about Ability Financial Exchange (AFE) for QuickBooks Online
-
Ability Financial Exchange technically does work with QuickBooks Point of Sale but certain sync features will not and there may be limitations in the following areas:
- Advanced inventory tracking and management like vendor attaching
- Work Order and Sales Order tracking + Layaways, Deposits
- Pre-set inventory levels/re-order points
- Purchase Orders
-
At this time, Ability Financial Exchange for QuickBooks Online does not support multiple store locations. Due to limitations of the QuickBooks Online features, there is no way to control inventory for each site.
- You can connect multiple locations to your QBO file and we can set a “location” so you can run reports in QBO but inventory will be in one big bucket for all locations.
- This means that the QTY in QBO will feed to each location that you have tied with AFE.
In some cases this may be ok. Be sure to discuss with out consulting team.
-
Since QuickBooks Online and QuickBooks Point of Sale do not share the same feature sets or back-end platform architecture, at this time we are unable to map QuickBooks Online Price Rules with QuickBooks Point of Sale Price Levels. Our dev team has developed four global options to help meet the needs of pricing. You can select only one option.
- Sync QBO Price to QBPOS Regular Price Only
- Sync QBO Price to ALL QBPOS Price Levels
- DO NOT Sync QBO Price to QBPOS
- Sync QBO Price to ALL QBPOS Price Levels with Fixed Markdowns
-
QuickBooks POS Style Matrix feature aka styles are not supported.
Since each item name in QuickBooks POS, QuickBooks Online, and QBES, we suggest combining the name with the size & color. Additionally, when onboarding and you have data, our team will combine item cells on a spreadsheet to create a unique name.
We always suggest that you take time to review the data, this is a great time to clean up your item lists and purge outdated items.
For example:
- Ruffled Blouse Black Small
- Ruffled Blouse Black Medium
- Ruffled Blouse Black Large
- Ruffled Blouse Black x-Large
-
Since QuickBooks Online is your “inventory control” software, best practice is to utilize the QuickBooks Online App for sales at pop-up’s, tradeshows, etc.
-
Currently due to API limitations and the automatic sales tax feature for QuickBooks Online, AFE only supports one (1) tax lacoation. The sales tax is selected in the AFE settings and pulled from QuickBooks Online.
AFE supports the the following tax codes in QuickBooks Point of Sale:
- tax
- non
- exempt
Certain businesses that have layered or special taxes or are located in CA, IL, LA, WA are encouraged to discuss your sales tax needs prior to purchasing the solution.
-
Requirements
- QBO Plus or QBO Advanced (QBO Simple Start or Essentials is not compatible)
- Individual QBO Subscriptions needed to track inventory in multiple locations
- New Company File created in QuickBooks Point of Sale
- Note: when creating a new QuickBooks POS company file, the existing company’s file of historic data is not included and cannot be migrated – this historic data includes permissions & settings, sales history, open purchase orders & history, receiving history, open sales orders & history, current reward status & history, current employee list, status & history. As with any new solution,
Limitations and/or exclusions:
– Only 1 tax code syncs
– POS Styles does not sync
– Only 1 Price Level syncs
– It is not recommended to use the QuickBooks POS Mobile Sync with GoPayments with AFE
Ability Financial Exchange for QuickBooks Online
-
Ability Financial Exchange is a real-time sync tool application that connects QuickBooks Online and QuickBooks Point of Sale Desktop. AFE (Ability Finanical Exchange) gives you the flexibility to access business financials anywhere with QuickBooks Online and run your day to day operations at the storefront with QuickBooks POS.
- Sync sales receipts & invoices (on account) from QuickBooks POS to QuickBooks Online.
- Sync QuickBooks POS sales orders, work orders, and layaways. Note these are Estimates in QuickBooks Online.
- Stay up to date on inventory – know what products are in stock, what needs reordered, and what is selling.
-
I just just ordered Ability Financial Exchange, what’s next? No worries, our team is here to assist during your project. Be sure to check your Inbox for the welcome letter that explains the next steps.
- Invite us as an Accountant User in QuickBooks Online.
- Schedule your first onboarding call.
- During this call, you can expect our team to ask you questions about your business, discuss inventory, determine your timeline, and chat about the next steps.
- Depending on your needs and how complex your setup is, onboarding can take 2 days to 4 weeks.
- Start thinking about your inventory – products and services. This is a great time to review inventory lists and do some cleanup. Remember, good data in means good reproting!
- Our team will review your lits and help guide you with best practices. We will discuss how QuickBooks Online item fields map to QuickBooks Point of Sale Desktop.
- Once inventory is ready, we will import the product info into QuickBooks Online.
-
Our onboarding team will walk you through the Ability Financial Exchange settings.
Ability Financial Exchange (AFE) Settings
AFE Settings
What & WhereNotesSales Tax & Add a tax location
Select from the dropdown list.
The Sales Tax list is from QuickBooks Online. In the AFE settings, we can update the shipping address for POS receipts.
Location
Select the Location from the dropdown list.
Create Locations in QuickBooks Online.
Sync Customer Types
Use customer types to categorize your customers that are meaningful to your business.
Create and assign customer types in QuickBooks Online.Send discounted items with net value
Enabled: Receipt-level discounts and redeemed customer rewards will be subtracted from the price of items.
Disabled: Receipt-level discounts and redeemed customer rewards will come over as separate line item on the receipt or invoice.Sync item reorder points
Enable or disable to sync inventory reorder points.
Only sync associated customer types
Sync a particular set of customers to QuickBooks POS by assigning a specific customer type.
Two-way customer sync
Add customers or update info in QuickBooks POS or QuickBooks Online.
Two-way vendor sync
Add vendors or update info in QuickBooks POS or QuickBooks Online.
Two-way item sync
Add inventory or update info in QuickBooks POS or QuickBooks Online.
Sync base UOMs
Store "Base UOM" labels in QuickBooks Online.
QBO Purchase Description
Example: BaseUOM = CanSync the customer's tax-exempt status.
Sync the QuickBooks Online Tax Info "checkbox" to QuickBooks POS.
Sync the customers fully qualified name to the QuickBooks POS Company customer field.
Used for Customer:Subcustomer relationships.
Names longer than 48 characters will be truncated.
Sync the QuickBooks Online customer Company field to the QuickBooks POS Last Name field.
Allows you to see the QBO company field text even if you are using the POS company box to display the fully qualified QBO name.
Price sync mode
There are 4 options. You can CHOOSE only 1 option. This is a Global Setting.
1. Sync QBO Price to QBPOS Regular Price Only
2. Sync QBO Price to ALL QBPOS Price Levels
3. DO NOT Sync QBO Price to QBPOS
4. Sync QBO Price to ALL QBPOS Price Levels with Fixed Markdowns
Enable IFE
Allows users to modify customer credit limits in QuickBooks POS while using AFE (Ability Financial Exchange).
Let POS modify item accounts
Let users modify QuickBooks POS inventory GL Accounts.
Sync Purchase Orders
Sync Purchase Orders between QuickBooks Online and QuickBooks POS
Sync Sales Orders
QuickBooks POS Sales Orders, Work Orders, and Layaways sync to QuickBooks Online Estimates.
-
Info coming soon!
-
Info coming soon!
-
Info coming soon!
-
Info coming soon!
-
Info coming soon!
-
Info coming soon!
-
Info coming soon!