QuickBooks

QuickBooks

You can sync financial data from FranPOS to your QuickBooks online account as Sales receipt. Follow the steps below to Integrate your Quickbook with Franpos:

 

1. In your Back Office, please go to Settings >> QuickBooks

2. Turn on the "Enable integrated QuickBooks" toggle

3. Press on the "Create new connection"-button

2019-01-21_1448.png

Optional Step: In case you have multiple locations and you want to sync them to QBO, you can select an existing connection on the right. This can only be done once QBO has been connected with Franpos. 

 

 

4. After you connected your QBO account with Franpos, you will see the following window. Please press the "Initialize"-Button. 

2019-01-21_1509.png

2019-01-21_1511.png

 

5. You can now set the sync date/time or press "Sync now" and Franpos will automatically start syncing on this date/time

2019-01-21_1511_001.png

 

 

 

What information is being synced? 

- Your POS will sync the following once per day: 

2018-07-13_0918.png

 

 

  1. All sales will be synced within single sales receipt and mapped to one customer (POS Customer)
  2. Sales receipt will be deposited to Undeposited Funds account (Other Current Asset/Undeposited Funds)
  3. Categories will be synced to QB side as Non-inventory item with name, sku (category code) and Sales account (Income/Sales Of Product Income)
  4. All payment methods (including custom) will be synced to QB side as service with name (PMT - name) and Undeposited Funds account (Other Current Asset/Undeposited Funds)
  5. Unique (by name) taxes will be synced to QB side as service with name and Sales Tax Payable account (Other Current Liability/Sales Tax Payable)
  6. All drawer operations will be synced to QB as Journal Entries
  7. Received Purchase Orders will be synced to QB as Bills
  8. Inventory (COGS, Waste, Spoilage) will be synced to QB as Journal Entries

2018-07-13_0922.png2018-07-13_0921.png2018-07-13_0920.png

 

POS will sync following:

  1. Payments: there are 5 different payment methods we support right now
    1. Cash
    2. Check
    3. Credit Card
    4. Gift Card
    5. Other
    We are trying to find these methods by name on QBO side first if not exists – create them
  2. We do not create every product on QBO side, we just create two types of products:
    1. Product (Income Account - Sales of Product Income, Inventory Asset Account - Inventory Asset, Expense Account - Cost of Goods Sold)
    2. Service (Income Account - Services)
    These 2 items will be used for all line items in order with details in the description for each. 
    Due to the limitation of QBO services, we need to create few items with the type of service on their side to support our logic such as:
    1. Tips
    2. Reward points
    3. Customer balance
    4. Tax (our tax system is more flexible than QBO has)
    All these items will be created (if not exist) on QBO side with an account of type Services
  3. Customers - We do not sync customers to QBO side, we just create Guest Customer which will be attached to every order
  4. Discounts - For discounts, we create a new account with Discounts given a name (Account Type – Income, Classification – Revenue, Account Sub Type – Discounts Refunds Given). Each discount will be synced to QBO as a separate item with the type of Discount, name from iConnect discount and Income Account as previously created.
  5. Tickets - Tickets will be synced as Invoice in case of sales (positive total) and Refund Receipt in case of refund (negative total).
  6. Payments - Payments will be synced as Payment for sale transactions only (Invoice). Refund Receipt on QBO side does not support payment detalization.
  7. All data syncs at Mid-night Mountain Time

 



    • Related Articles

    • Common QuickBooks Sync Issues and Resolutions

      In this article, we will describe common issues with QuickBooks sync and the actions needed to fix them. Error Message: Sales receipt. Date: XX/XX/XXXX . BadRequest. Validation Exception was thrown.Details:Invalid Reference Id : Product/Service ...
    • Third Party Integration POS System

      Payment provider: Franpos Pay Financial QuickBooksSync transaction data with QuickBooks Online on daily basis. Ecommerce Franpos eCommerce Gift Cards & Loyalty Valutec Sell, Redeem and Account for your gift cards using Valutec. Givex Sell, Redeem and ...
    • QBO Multi location

      Franpos allows users to sync their Franpos data to one QBO account. This is achieved with the Track location function from QBO. Pre-requisite: Multi-location sync will work only on Plus or higher tier of QuickBooks Online subscription. Purchase ...
    • QBO Error messages

      This article shows the most common error messages in or while using Franpos and QBO BadRequest. Validation Exception was thrown.Details:Subscription period has ended or canceled or there was a billing problem : You can't add data to QuickBooks Online ...
    • Franpos Features

      Features Retail Full service restaurant QSR Health & Beauty Employee (https://my.iconnectpos.com/Employee) Add Employee X X X X Edit/Update Employee X X X X Setup Pin Code X X X X Setup pay rate X X X X Set access permission X X X X Add/remove access ...