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
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.
5. You can now set the sync date/time or press "Sync now" and Franpos will automatically start syncing on this date/time
What information is being synced?
- Your POS will sync the following once per day:
- All sales will be synced within single sales receipt and mapped to one customer (POS Customer)
- Sales receipt will be deposited to Undeposited Funds account (Other Current Asset/Undeposited Funds)
- Categories will be synced to QB side as Non-inventory item with name, sku (category code) and Sales account (Income/Sales Of Product Income)
- 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)
- 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)
- All drawer operations will be synced to QB as Journal Entries
- Received Purchase Orders will be synced to QB as Bills
- Inventory (COGS, Waste, Spoilage) will be synced to QB as Journal Entries
POS will sync following:
- Payments: there are 5 different payment methods we support right now
- Cash
- Check
- Credit Card
- Gift Card
- Other
We are trying to find these methods by name on QBO side first if not exists – create them - We do not create every product on QBO side, we just create two types of products:
- Product (Income Account - Sales of Product Income, Inventory Asset Account - Inventory Asset, Expense Account - Cost of Goods Sold)
- 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:- Tips
- Reward points
- Customer balance
- 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 - Customers - We do not sync customers to QBO side, we just create Guest Customer which will be attached to every order
- 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.
- Tickets - Tickets will be synced as Invoice in case of sales (positive total) and Refund Receipt in case of refund (negative total).
- Payments - Payments will be synced as Payment for sale transactions only (Invoice). Refund Receipt on QBO side does not support payment detalization.
- All data syncs at Mid-night Mountain Time