Common searched topics: Manufacturing, Label printing, Sales order
Browse features guide
Managing products
Imports, exports & integrations
Sales
Stock level reports
Purchasing
inFlow settings
Imports, exports & integrations
  • Integrations
Connect QuickBooks Online

Connecting QuickBooks Online to inFlow

If you’re using inFlow and QuickBooks Online to manage your inventory and accounting, you’ll love the seamless integration between inFlow and QuickBooks Online to streamline your processes and enhance efficiency.

Setup

Two-way payment sync video

Take a look at this video to learn how you can seamlessly pay for sales and purchase orders from either inFlow or QuickBooks Online.

inFlow & QuickBooks Online: Payment Sync | Get to Know inFlow

This video doesn’t cover setup. Take a look at the Connecting inFlow to QuickBooks Online section below for complete setup instructions.

How does this work?

With inFlow, you can easily create new sales and purchase orders that can be seamlessly sent to QuickBooks Online. Plus, you have the flexibility to make payments within inFlow or QuickBooks Online using the handy two-way sync payments option.

If there are missing records in QuickBooks Online, inFlow can create new products, customers, and vendors for you. Currently, records made in QuickBooks Online can’t be pushed to inFlow.

As soon as the purchase order push is enabled, inFlow will push your inventory value to QuickBooks Online. Your inventory value must be accurate in inFlow and QuickBooks Online before enabling the integration.

Before setup checklist

We currently support QuickBooks US, Canada, UK and AUS.

  • ✅ Are your product quantities and costs accurate in inFlow? If you intend to push purchase orders, ensure your stock levels and product costs are accurate! The integration adjusts Quickbook’s total inventory value to match inFlow’s, so you’ll want to ensure they match before you begin. See the “Push purchase orders and inventory” tab for details!
  • ✅ Does your home currency in inFlow and QuickBooks Online match? Make sure that your main currency in both systems is the same. If you use more than one currency in your inFlow orders, turn on the Multicurrency setting in QuickBooks Online.
  • ✅ Are your taxes in both systems? Ensure that your inFlow taxes are also in QuickBooks Online.
  • ✅ Is your QuickBooks Online account using non-inventory product types? inFlow can only use QuickBooks Online’s non-inventory products.
  • ✅ Is your QuickBooks Online account using non-inventory product types? inFlow can only use QuickBooks Online’s non-inventory products.

    If you’re using inventory-type products in QuickBooks Online, you must make them inactive and re-create them as non-inventory products

    If your QuickBooks account uses inventory type, it will conflict with the integration and may cause double entries as both systems try to update the stock value.

    Make sure products are non-inventory types before connecting inFlow to QuickBooks Online to avoid making several corrections after the fact. If you have inventory-type products in stock, check the Adjust Inventory Items section of this QuickBooks Online guide to remove the product quantities.

QuickBooks Online doesn’t have an option to convert inventory products to non-inventory products.

  • ✅ Does your inventory include serialized products? At the moment, QuickBooks Online doesn’t support tracking serialized products, so serial numbers won’t be pushed to your QuickBooks Online invoices or bills.

    When inFlow pushes a sales or purchase order with a serialized product, the product is sent to QuickBooks Online without the serial number information. There won’t be any errors in inFlow or QuickBooks mentioning the missing serial details.
  • ✅ Creating an inFlow Adjustments account – inFlow must connect to a Cost of Goods Sold account (COGS) and a different COGS-based account to track adjustments. During the QuickBooks Online setup, select Create inFlow Adjustments account in QuickBooks.
Alt: QuickBooks Online, integration setup screen, highlighting the "create inFlow adjustments account in QuickBooks" setting.
  • Do your inFlow customers have the correct currency settings? You can’t change the customer currency settings in QuickBooks after a sales order has been pushed. Verify that the currency set up in the inFlow customer profile matches one of the currencies set up in QuickBooks.

    To check, open inFlow and go to the Main Menu > Sales > Customer list. Open the customer profile and select the correct currency from the Pricing/currency drop-down menu.

QuickBooks Online explainer & setup webinar

Webinar: Connecting inFlow to QuickBooks Online

Please note: the above webinar was recorded before the payment sync feature was added to this integration.

Connecting inFlow to QuickBooks Online

  1. With an Admin account, log into inFlow’s integration settings. (Main Menu > Options > Integrations. )
  2. Under Core integrations, click on QuickBooks Online.
  3. In the pop-up, select Connect to QuickBooks.
  4. Your browser will direct you to your QuickBooks Online account for authorization. If you have multiple QuickBooks accounts, select the account with which inFlow should connect. 
  5. Click Connect to allow inFlow to view and update your QuickBooks data.

Sales orders push integration settings

  1. Your browser will redirect to inFlow’s QuickBooks Online integration setup with the Sales order push setting toggled on. This means sales orders from inFlow will be pushed to QuickBooks Online as an invoice. 
QuickBooks Online integration setup screen, where the Sales order push setting is toggled on.
  1. In the General section, select the Product Income Account that inFlow should connect to.

    Typically, this is the account in QuickBooks Online you use to receive money for products sold. This account will be set as the Product income account for products created via inFlow in QuickBooks Online. Select the appropriate QuickBooks Online account from the drop-down. The Product Income account for existing products in QuickBooks Online will not change.
  2. Select the customer name setting you prefer. When a sales order is pushed to QuickBooks, you can choose whether to include or exclude the customer name as part of the address in the resulting invoice in QuickBooks.
QuickBooks Online integration setup screen shows the "Product Income account" and "Customer name settings."

Sales order payment settings

  1. Next are the Payment settings. When the Sync payments setting is toggled on, you can choose how you would like to manage and process payments. Select your preferred option. See the table below to learn about each payment option.
QuickBooks Online integration sales order push payment setting options.
Payment settingExplanation
Push and pull payments
This is a two-way payment sync option, where you can enter payments in either inFlow or QuickBooks Online. 

Please note: The two-way sync feature is strictly for payment information. This integration does not support two-way order sync. Orders must be created in inFlow first.

This setting is recommended if your team would like to process payments in either software, and the information will be sent automatically to the other one.

If a payment is added to a QuickBooks Online invoice, the payment will be sent to the matching inFlow sales order. 

If a payment has been added to the inFlow sales order, that payment will be sent to the matching QuickBooks Online invoice. 
Push paymentsWith this payment option, payments can only be made on inFlow sales orders, and the payment information will be sent to the matching QuickBooks Online invoice.

If a payment is added to the QuickBooks Online invoice, inFlow will not receive the payment information on the matching sales order.
Pull paymentsWith this setting, payments are only added to the QuickBooks Online invoice, and the payment information will be sent to the matching inFlow sales order. 

If a payment is added to an inFlow sales order, QuickBooks Online will not receive the payment information on the matching invoice.
inFlow & QuickBooks Online: Payment Sync | Get to Know inFlow
  1. The Refund setting is toggled on by default. This allows you to process refunds in inFlow, and the refund information will be sent to the matching QuickBooks Online invoice. Toggle this setting off if you don’t want refunds sent to QuickBooks Online. Any refunds will need to be processed in inFlow and QuickBooks Online separately.
  2. Next, select the Payments account from the drop-down menu. This is the account that updates when payments have been made on inFlow sales orders and QuickBooks invoices.
QuickBooks Online integration sales order push refund and payments account settings.

Sales order tax setup

  1. At the bottom of the setup are the tax settings. Similar to mapping your accounts, you’ll need to map the taxes that are in inFlow to the tax rates that are in QuickBooks.

    Match the inFlow taxes to the QuickBooks Online taxes in the drop-down menu. If you see No matches found. Please create one in QuickBooks and check again it means QuickBooks doesn’t have a matching tax. Create the tax in QuickBooks Online, then click on Check again before you proceed.
QuickBooks Online integration sales order push tax settings. The image to the left shows the integration settings without taxes created in QuickBooks Online, and to the right are the integration settings where taxes have been created in QuickBooks Online and are available to choose from.
  1. Click Next to continue the Payment order and inventory value push integration settings.

QuickBooks has released an Automated Sales Tax feature that can calculate the taxes on your invoices for you based on shipping addresses and other order information on your invoices. If your account has this feature enabled, you won’t have to map any taxes, and the window will say, “Tax setup is complete”. Click Next to complete the setup.

Sales order push account setup breakdown

AccountExplanation
Product income accountTypically, this is the account in QuickBooks Online you use to receive money for products sold. This account will be set as the Product income account for products created via inFlow in QuickBooks Online. Select the appropriate QuickBooks Online account from the dropdown. The Product Income account for existing products in QuickBooks Online will not change.
Customer nameWhen a sales order is pushed to QuickBooks, you can choose whether to include or exclude the customer name as part of the address in the resulting invoice in QuickBooks.
Payments accountIf payment push is enabled, you’ll need to tell inFlow which QuickBooks account to update when the order is pushed. This is the bank account you use in QuickBooks Online to receive/send payments (Checking, etc.).

Purchase order and inventory value push settings

  1. At the top of the screen, you’ll see that Purchase order and inventory value push settings are toggled on.

    This setting will push purchase orders from inFlow to QuickBooks Online as bills. In addition to creating a bill, inFlow will update the Inventory Assets and Cost of Goods Sold accounts in QuickBooks.
QuickBooks Online integration setup screen, where the Purchase order and inventory value push setting is toggled on.
  1. In the General settings, select the appropriate accounts inFlow should connect to. For the Adjustments/Other Costs account, we recommend that you select Create inFlow Adjustments account in QuickBooks to create a dedicated account for inFlow to make adjustments where needed. Don’t select the same QuickBooks Online account for more than one setting.
QuickBooks Online integration screen shows the purchase order and inventory value push account setup.

Purchase order payment settings

  1. Next in the setup is Payment settings. The Sync payments setting gives you the option of how you would like to manage payments. Select your preferred option. See the table below for a breakdown of each option.
Payment settingExplanation
Push and pull paymentsThis is a two-way payment sync option, where you can enter payments in either inFlow or QuickBooks Online. 

Please note: The two-way sync feature is strictly for payment information. This integration does not support two-way order sync. Orders must be created in inFlow first.

This setting is recommended if your team would like to process payments using either software, and the information will be sent automatically to the other one.

If a payment is added to a QuickBooks Online bill/expense, the payment will be sent to the matching inFlow purchase order. 

If a payment has been added to the inFlow purchase order, that payment will be sent to the matching QuickBooks Online invoice.
Push paymentsWith this setting, payments are only added to inFlow purchase orders, and the payment information will be sent to the matching QuickBooks Online bill. 

If a payment is added to the QuickBooks Online bill, inFlow will not receive the payment information on the matching purchase order.
Pull paymentsWith this setting, payments are only added to the QuickBooks Online bill, and the payment information will be sent to the matching inFlow purchase order. 

If a payment is added to an inFlow purchase order, QuickBooks Online will not receive the payment information on the matching bill.
inFlow & QuickBooks Online: Payment Sync | Get to Know inFlow
  1. The Refund setting is toggled on by default. This allows you to process refunds in inFlow, and the refund information will be sent to the matching QuickBooks Online bill. Toggle this setting off if you don’t want refunds sent to QuickBooks Online. When this setting is inactive, refunds will need to be processed in inFlow and QuickBooks Online separately.
  2. Next, select the Payments (Check) account and the Payments (Credit Card) account from the drop-down menus. These are the accounts that will be used for paying bills to your vendors in QuickBooks Online.
QuickBooks Online integration screen shows the purchase order push payments checking and credit card account setup.
  1. When done, click Complete, then click Done. And now inFlow is connected to QuickBooks Online.
QuickBooks Online integration setup completed screen.

Purchase order push account setup breakdown

AccountExplanation
Cost of Goods SoldYou’ll need to tell inFlow which QuickBooks account to update when it pushes the total Cost of Goods Sold value from inFlow to QuickBooks Online.
Inventory Assets accountYou’ll need to tell inFlow which QuickBooks account to update when it pushes the inventory cost value from inFlow to QuickBooks.
Adjustments/Other Costs accountYou’ll need to tell inFlow which QuickBooks account to use to balance out the Inventory Assets account. For example, if the integration needs to update QuickBooks’s inventory asset value by $500 to match inFlow’s inventory value, then $500 will be moved from this account to the inventory assets account. The account type is a “Cost of Goods Sold” type account only.

If you don’t have a QuickBooks account to map to,  you can click  ‘+ create this account for me‘ to automatically create a QuickBooks account called “inFlow Adjustments” (the name can be changed in QuickBooks.)
Taxes on Purchases (QuickBooks US only)QuickBooks US doesn’t support taxes on purchases. To make the integration work, you’ll need to select a QuickBooks account for inFlow to update (it should be a liability or expense account) so that any taxes on purchase orders in inFlow will still be pushed to QuickBooks, but in this case, as a separate line/category on the order.
Payments (Check)If payment push is enabled, you’ll need to tell inFlow which QuickBooks account to take payment from when the payment method is set to “Check” on the purchase order in inFlow.
Payments (Credit Card/no payment method selected)If payment push is enabled, you’ll need to tell inFlow which QuickBooks account to take payment from when the payment method is set to “Credit” on the purchase order in inFlow.

If no payment method is selected on the purchase order in inFlow, then that payment will be deducted from the selected QuickBooks payment account.

Push sales orders

Now that inFlow and QuickBooks Online are connected, you can start processing sales orders and pushing them to QuickBooks Online. 

How to push a sales order to QuickBooks Online

In inFlow, when a sales order is marked as invoiced (meaning you’ve notified your customer that they owe you for the order), inFlow will push the order to QuickBooks Online as an invoice.

You can change the sales order status to invoiced when a sales order is partially paid or paid in full or when you select the Mark invoiced button. 

You can mark a sales order as invoiced in the following ways:

  1. Printing a sales invoice. 
  2. Emailing a sales invoice. 
  3. Selecting the Mark invoiced button.  

Printing and emailing

Printing and emailing invoices are actions used to inform your customers that they owe money for this order. When clicking on these buttons, inFlow will automatically mark the sales order as invoiced. 

The inFlow sales order screen highlights the Print and Email button for sending invoices.

Mark invoiced button

If you want to mark the order as invoiced but don’t need to print or email it, you can click on the down arrow next to Mark paid to select Mark Invoiced

The inFlow sales order total area is where you can select the "Marked Invoiced" button to push orders to QuickBooks Online.

Which transactions will inFlow sales orders be in QuickBooks Online?

Sales orders pushed from inFlow will be created in QuickBooks Online as invoices, credit memos, journal entries, and payment transactions.

Order/transaction in inFlowOrder/transaction in QuickBooks Online
Invoiced unpaid sales orders will be listed as an invoice in QuickBooks Online.  Invoice
Payments made on invoiced sales orders that have been pushed to QuickBooks Online.Payment transactions
Refunds on paid sales orders that have been pushed to QuickBooks Online. Journal entry
Unpaid blank sales orders with negative totals that are pushed to QuickBooks Onlinecredit memo

New to accounting? Take a look at QuickBooks Online’s common accounting terms to learn more. 

Where can I find invoices and other transactions in QuickBooks Online?

When your sales orders are invoiced, partially paid, or paid in inFlow, they can be found in the Sales section of QuickBooks Online (qbo.intuit.com/app/sales.)

You can click on any of the headings in the table to sort the view of your orders. Select Edit or View to look at the invoice. 

QuickBooks Online Invoices area where inFlow sales orders are pushed.

inFlow’s sales order number will show up as the Invoice number in QuickBooks, making information tracking simple. Payments, refunds, and adjustments will create different line items in your sales transactions list.

Sales/purchase quotes and existing orders won’t be pushed to QuickBooks.

QuickBooks Online’s Audit log is a handy way to see many transactions at once. 

Which sales order fields push to QuickBooks Online?

  • Customer name
  • Customer billing address
  • Shipping address
  • Invoice/Order date
  • Invoice/Order number
  • Products/SKUs sold
  • Quantity of products purchased
  • Payment details
  • Payment terms
  • Due date
  • The subtotal on the sales order
  • Freight
  • Taxes on the sales order
  • Balance left on on sales order
  • Sales order remarks

Which fields won’t push to QuickBooks Online?

  • P.O #
  • Sales rep
  • Location of items
  • Non-customer costs
  • Payments made by credit
  • Custom fields
  • Requested ship date
  • Credits 

What customer fields push to QuickBooks Online?

Currently, inFlow only pushes your sales order with QuickBooks, not your customer records. When you save an order in inFlow with a customer that isn’t in QuickBooks, the push will create a new customer profile in QuickBooks, and inFlow will set the following fields:

  • Name
  • Billing Address
  • Shipping Address
  • Phone Number
  • Email
  • Currency

Other customer fields will need to be inputted in QuickBooks manually.

After a customer has been initially created, inFlow will not update the customer profile in QuickBooks Online, so if there are any changes, please enter them directly into QuickBooks and inFlow.

How will the products sync to QuickBooks Online?

The way products are pushed to QuickBooks Online will depend on the information available for the product in inFlow and QuickBooks Online. The matching priority happens automatically, but it goes as follows:

  1. Matching by inFlow SKU to a QuickBooks Online SKU.
  2. Matching by inFlow Product Name to a QuickBooks Online Product (SKU must be empty in at least one system)
  3. If there is no match, inFlow will create a new non-inventory product in QuickBooks Online, matching your product name and SKU field (if a SKU exists in inFlow.)

Processing payments

When setting up the inFlow to QuickBooks integration settings, you can choose whether to process payments with the sales order push integration settings or not. 

If the Sync payments setting is active, there are three payment options to choose from: 

  1. Push and pull payments
  2. Push payments
  3. Pull payments. 

Take a look below to learn how you can apply payments for each payment setting.

Push and pull payments

This is a two-way payment sync option. You can process payments in inFlow or QuickBooks online, and the payment will be pushed to the other system for you.

This is an example image showing an inFlow sales order that has been pushed to QuickBooks Online. With the Push and pull payments setting, the payment can be made in one system and synced to the other system.

In this example, the payment was made in inFlow and the payment was pushed to QuickBooks Online. 

inFlow & QuickBooks Online: Payment Sync | Get to Know inFlow

Paying multiple orders/invoices

In inFlow, you can pay for multiple sales orders at once, and the payments will be pushed individually to QuickBooks Online.

When using QuickBooks Online, paying multiple invoices with a single payment isn’t supported. Each invoice must have its own payment.

Push payments

With this payment option, payments can only be made on inFlow sales orders, and the payment information will be sent to the matching QuickBooks Online invoice. 

If a payment is added to the QuickBooks Online invoice, inFlow will not receive the payment information on the matching sales order. 

Pull payments

With this setting, payments are only added to the QuickBooks Online invoice, and the payment information will be sent to the matching inFlow sales order. 

If a payment is added to an inFlow sales order, QuickBooks Online will not receive the payment information on the matching invoice.

How are refunds handled? 

With this integration, refunds need to be processed from the sales order in inFlow. How you process the refund changes the transactions that you’ll see in QuickBooks Online. 

Refund options:

  1. Returning/refunding products on an existing paid sales order. 
  2. Returning/refunding products on a blank unpaid sales order. 

Returning/refunding products on an existing paid sales order

When processing refunds on sales orders, inFlow will push that information, and QuickBooks will track this in the form of a journal entry. 

  1. To start, process the refund/return in inFlow
  2. In QuickBooks, the matching invoice will show the refunded product, and the order total will be updated. 
  3. When you look at your sales transactions you’ll see both the original full payment and a journal entry for the refunded amount. 
This image shows a refund processed in inFlow on a paid and fulfilled sales order. The refund information has been pushed to the matching invoice in QuickBooks Online.

Returning/refunding products on a blank unpaid sales order

If processing a refund on a blank unpaid sales order, inFlow will push that information, and QuickBooks will track the refund as a QuickBooks credit memo. 

  1. To start, process the refund/return in inFlow
  2. In QuickBooks, a (debit) journal entry will be made with an accompanying credit memo with the matching order number will be created with the refunded product and funds.
This image shows a refund processed in inFlow on a blank, unpaid sales order. The refund information has been pushed to the matching invoice in QuickBooks Online.

To learn more about debits and credits, take a look at this QuickBooks Online blog post.

Customer Credits

Credits used in inFlow sales orders cannot be pushed to QuickBooks Online. If you need to issue a credit on a sales order, you will need to manually adjust your invoice in QuickBooks.

This also applies when a customer pays for a sales order with a credit. This information won’t be pushed and needs to be adjusted manually.

If a customer uses credit as payment in either inFlow or QuickBooks Online, the other system will only register a payment without noting that the customer used credit as the payment method.

Because inFlow and QuickBooks Online have different credit systems, both solutions may have different customer and vendor credits that will have to be managed.

Push purchase orders

Now that inFlow and QuickBooks Online are connected, you can start processing purchase orders and pushing them to QuickBooks Online. 

How to push purchase orders and inventory value to QuickBooks Online

When a purchase order is fully or partially received, inFlow creates a bill in QuickBooks Online. In addition to sending this information, your inventory value will also be pushed.

  1. To push a purchase order, click the fulfill button, or select the go to the Receive tab to partially receive the order. 
  2. Once the purchase order is partially or fully received, it will be sent to QuickBooks Online as a bill. 

When a purchase order is unfulfilled and is partially or fully paid in inFlow creates an expense until the purchase order is fulfilled.

Partially received purchase orders

For partially received orders, when the order is pushed to QuickBooks, it will only include items that have been received. As the remaining items are marked as received in inFlow, the same QuickBooks Bill will be updated to include those items.  

If you’d like to create separate QuickBooks bills when partially receiving items in inFlow, you’ll need to split the order by received items to create two separate purchase orders in inFlow.

Pushing total inventory value 

inFlow calculates the inventory value by adding up all of the costs of the items you currently have in stock. When a purchase order is pushed from inFlow to QuickBooks, inFlow will update QuickBooks’s inventory asset account with the new inventory value.

As soon as purchase order sync is enabled, inFlow will sync inventory value. It’s important that your inventory value is accurate in inFlow before enabling the sync. Otherwise, the inventory value that is synced to QuickBooks Online will be inaccurate.

To check the current inventory value in inFlow, run the Inventory Details report with “Total Cost Value” selected as a column.

Your total inventory value in inFlow is affected by:

Purchasing/selling itemsIf you purchase or sell items, your inventory quantities change and your inventory value will increase or decrease accordingly. 
Stock adjustments/count sheetsAdjusting your inventory quantities will increase/decrease the inventory value accordingly. 
Manufacture ordersAs you build finished products and use up components, your total inventory quantities will change, which will affect your inventory value. 
Cost adjustmentsWhen the cost of your items changes, so does the total inventory value.

How does inFlow push the Cost of Goods Sold?

inFlow calculates the Cost of Goods Sold using a number of factors. When a sales order is marked Fulfilled, inFlow will update QuickBooks’s Cost of Goods Sold account with the Cost of Goods Sold value for that order. 

inFlow’s Cost of Goods Sold will update the QuickBooks Cost of Goods Sold account.

Note: if you disable sales order push, the invoice will not be created in QuickBooks, but the Cost of Goods Sold will still be pushed if you have enabled purchase order & inventory value push.

Which transactions will inFlow purchase orders be in QuickBooks Online?

Purchase orders pushed from inFlow will be created in QuickBooks Online as bills and bill payments, or expenses if the payment is made on an unreceived purchase order.

To make the inFlow integration available to most of our customers, inFlow creates a bill instead of a purchase order. Purchase orders are available on select QuickBooks Online plans.

Order/transaction in inFlowOrder/transaction in QuickBooks Online
Partially or fully received purchase ordersBills
Payments made on partially or fully received purchase orders that have been pushed to QuickBooks OnlineBill payments
Unreceived paid purchase ordersExpense
Refunds on partially or fully received purchase orders that have been pushed to QuickBooks Journal entry

Where can I find bills and other transactions in QuickBooks?

When purchase orders are partially or fully received, inFlow pushes them as a bill, which you can find in the Expenses section of QuickBooks Online (qbo.intuit.com/app/expenses.)

You can click on any of the headings in the table to sort the view of your orders. Select Edit or View to look at the invoice.

An image of where to find bills in QuickBooks Online where inFlow purchase orders will be pushed.

How will the products sync to QuickBooks Online?

The way products sync to QuickBooks Online will depend on the information available for the product in inFlow and QuickBooks Online. 

The product matching priority happens automatically, but it goes as follows:

  1. Matching by inFlow SKU to a QuickBooks Online SKU.
  2. Matching by inFlow Product Name to a QuickBooks Online Product (SKU must be empty in at least one system)
  3. If there is no match, inFlow will create a new non-inventory product in QuickBooks Online, matching your product name and SKU field (if a SKU exists in inFlow.)

Processing payments

When setting up the inFlow to QuickBooks integration settings, you can choose whether to process payments with the purchase order push integration settings.

If the Sync payments setting is active, there are three payment options to choose from: 

  1. Push and pull payments
  2. Push payments
  3. Pull payments. 

Take a look below to learn how you can apply payments for each payment setting.

Push and pull payments

This is a two-way payment sync option. You can process payments in inFlow or QuickBooks online, and the payment will be pushed to the other system for you.

inFlow & QuickBooks Online: Payment Sync | Get to Know inFlow

Paying multiple orders/invoices

In inFlow, you can pay for multiple purchase orders at once, and the payments will be pushed to QuickBooks Online.

When using QuickBooks Online, paying multiple bills with a single payment isn’t supported. Each bill must have its own payment.

Push payments

With this payment option, payments can only be made on inFlow purchase orders, and the payment information will be sent to the matching QuickBooks Online bill. 

If a payment is added to the QuickBooks Online bill, inFlow will not receive the payment information on the matching purchase order. 

Pull payments

With this setting, payments are only added to the QuickBooks Online bill, and the payment information will be sent to the matching inFlow purchase order. 

If a payment is added to an inFlow purchase order, QuickBooks Online will not receive the payment information on the matching bill.

Troubleshooting

If you are having trouble using QuickBooks Online with inFlow, go to inFlow’s Integration settings and look at the error messages that are preventing your orders from syncing. (Main Menu > Options > Integrations.)

We currently support QuickBooks Online US, Canada, UK and AUS.

What if the product exists in inFlow but not in QuickBooks Online?

If a product on an order doesn’t exist in QuickBooks Online, inFlow will create the product in QuickBooks Online as a non-inventory item when an invoice/bill is pushed. Depending on which setting you enable, it’ll also fill in either of these checkboxes in QuickBooks Online:

  • “I sell this item” and sets the income account for this product to the same one that is mapped in the inFlow setup. 
  • “I purchase this item” and sets the expense account for this product depending on the inFlow product type:
    • stocked products: Inventory Asset account
    • non-stocked products: Adjustments / Other Costs account
    • service products: Adjustments / Other Costs account

At the moment there isn’t an option for inFlow to push all product information to create new products in QuickBooks Online. New products can only be made when invoices/bills are pushed from inFlow.

Does this sync inventory quantities?

No – the integration only pushes purchase orders, sales orders, total Cost of Goods Sold, and total Inventory value from inFlow to QuickBooks Online. 

If I make changes to an order, product, vendor, or customer in QuickBooks Online, will it be updated in inFlow?

No – the integration is one-way. All data is pushed from inFlow to QuickBooks Online (no data gets pushed back from QuickBooks Online to inFlow with the exception of payments with the Push and pull payments option). 

Seeing duplicate payments?

Duplicate payments can happen if payments are made directly into inFlow and QuickBooks Online (or another software integration) when the payment settings are set to Push payments. See the steps below to correct this issue.

  1. Go to the inFlow’s integration settings and click on QuickBooks Online.
  2. Select Sales orders or Purchase orders and inventory values.
  3. Under Payment settings select Push and pull payments. This setting makes sure payments stay in sync between inFlow and QuickBooks Online to avoid discrepancies.
  4. Click Save.

Common alerts/errors

If you have saved orders in inFlow and you don’t see those orders in QuickBooks Online, check inFlow’s Integrations screen to see what is causing the errors not to sync. You can also look below for common errors and how you can fix them.

Once you have made the changes, click on the Retry all button to sync your orders.

Reason: inFlow and QuickBooks have the same product, but there are different SKUs. 

Solution: Correct the SKU in either inFlow or QuickBooks Online so that the product has the same SKU in both systems.

Reason: An extra space at the end of the customer name prevents the order from being pushed to QuickBooks Online.

Solution: Go to the customer profile, remove the extra space, and save the customer record. When you’re done, click the Retry button.

Reason: This can happen when multiple transactions make changes to the same accounts receivable/accounts payable account (saving an order multiple times or multiple edits).

Solution: Check if the inFlow order has created a matching invoice/bill in QuickBooks Online. If it has, and payments/changes also push to QuickBooks Online, then you can click the Dismiss button from inFlow’s Integration settings.

Reason: Multiple invoices/bills were paid at the same time in QuickBooks Online.

Solution: Remove the bulk payment in QuickBooks Online and process payments on the outstanding invoices/bills individually.

Product/Service assigned to this transaction has been deleted. Before you can modify this transaction, you must restore [Product name]

Reason: The product on this inFlow sales order has been deleted or marked inactive in QuickBooks Online.

Solution: Log into QuickBooks Online and make this product active/available in order to sync this sales order.

The “[Name]” Payment Term details in inFlow and QuickBooks don’t match

Reason: The Days Due in inFlow and QuickBooks are different.

Solution: in the inFlow Windows App check the Days Due by going to

  1. Main Menu>Options>Settings>References>Payment Terms (Windows.) Or go to the inFlow Order settings and click on Payment terms (Web.)
  2. Besides the terms that aren’t syncing, check the Days Due. Now in QuickBooks, go to Settings>All lists>Terms>Click edit beside the term you just checked for in inFlow that the Days Due match. If they don’t update them too.

The name supplied already exists. : Id=X

1. This is a generic QuickBooks Online error that may be caused by a vendor with the same name as a customer (QuickBooks Online doesn’t allow this).

Solution: Check if you have a customer or vendor in QuickBooks Online with the same name as the customer or vendor on the order you’re trying to sync. If you do, QuickBooks Online recommends adding an indication to the names so it can handle them as two different entries: E.g., DebraC (C for customer) and DebraV (V for vendor).

2. This error can also occur if the Product name, Customer name, Categories, or Payment Terms have extra spaces in between or after them.

Solution: Please check your Product List/Customer/Vendor in inFlow and see if you can find that extra space at the end of the name. Once found, remove it save the product/customer/vendor, and retry the error.

If there are several products in the same order, you can check it also through an export. If there are extra spaces, please remove them and import the products back again with the updated CSV file (of course, you could also do the same process manually in every product on your account). The system should recognize the changes, and you can then retry the error on the Integration page.

3. There are some characters that QuickBooks does not accept. For example, product names containing the colon “: ” will cause this error.

Solution: Go through the Product names, Customer names, and Categories to see if there are characters other than the accepted ones listed by QuickBooks Online.

The name supplied already exists. : Another product or service is already using this name. Please use a different name.

Reason: If a product on your inFlow order has a different name than the product in QuickBooks Online, e.g., there is an extra “space” at the end of the name like “Apple ” vs. “Apple,” QuickBooks Online reads it as a different product.

Solution: check the product in the affected sales order in inFlow to see if there is an extra “space” at the end of the product name.

The name supplied already exists. : Another customer, supplier, or employee is already using this name. Please use a different name.

Reason: If a customer name in inFlow is different from the name in QuickBooks Online. e.g., the customer name in inFlow has an extra “space” at the end of it, like “John” vs “John “, QuickBooks Online reads it as a different customer.

Solution: check the customer in the affected sales orders in inFlow to see if there is an extra space at the end of the customer name.

Business Validation Error: You must set a transaction amount.

Reason: This error appears whenever there is a payment entry for either a Sales Order or Purchase Order with the value of 0 as the payment amount/amount applied.

Solution: On the order page, click on Paid, and on the Payment Details page, then delete that row. After that, you can retry the error on the Integration page, and the error should disappear.

Element contains invalid characters.

Reason: This error means you have an invalid character either in your company name, Customers, Suppliers, Products and Services, or the Chart of Accounts.

Solution: Please check and remove any special characters. You can check for QuickBooks Online acceptable characters here.

String length specified does not match the supported length.

Reason: Some fields have limited character lengths in QuickBooks but no limit in inFlow. If there is a field on the inFlow order that has reached the character limit for the matching field in QuickBooks Online, the sync will fail.

Solution: The error will specify a field’s character limit in QuickBooks (there is a list of their fields and character limits here). Check the corresponding field in inFlow to see that it hasn’t exceeded this character limit.

Object Not Found: Something you’re trying to use has been made inactive. Check the fields with accounts, customers, items, vendors or employees.

Reason: There’s a customer, product, or vendor on the order that has been deactivated in QuickBooks Online.

Solution: check to see if the customer or product in the affected sales order in inFlow has been deactivated in QuickBooks Online and then reactivate them before retrying the sync.

 Business Validation Error: You are not allowed to modify the quantity of an inactive stock item.

Reason: A product or service on the inFlow order is inactive in QuickBooks.

Solution: Check that the products or services that are on the inFlow order are not deactivated in QuickBooks Online and activate them if necessary. You can find more details here.

Invalid account type: You can’t associate a product or service with accounts of certain types (such as Accounts Receivable and Accounts Payable). If the product or service is something you sell, use an income account. If the product or service is something you buy, use an expense account.

Reason: Products inside of QuickBooks have an account associated with them. An item on the affected order has an account associated with it that is not allowed.

Solution: Check the accounts that are set up for the items on the affected order in QuickBooks Online. The accounts should be set up as income and/or expense accounts (depending on if it’s a sales order or a purchase order). Here’s how you can change the account associated

This transaction has been deposited. If you want to change or delete it, you must edit the deposit it appears on and remove it first.

Reason: This error may be due to an inFlow sales order that had previously synced with QuickBooks Online, and the payment was marked as deposited, but the payment was updated in inFlow after the initial sync to QuickBooks Online.

Solution: remove the payment deposit in QuickBooks Online or click “dismiss” on the error in the Cloud integration page to clear it.

Email Address does not conform to the syntax rules of RFC822.

Reason: There are issues with the syntax/format of the email in question. (e.g., extra white spaces or rouge symbols like “,com” instead of “.com”)

Solution: check the specific sales order, and look at the email of that order to see if there are any obvious extra spaces or incorrect email symbols. (easier to see on the Windows application)

Product has a duplicate SKU in QuickBooks Online.

Reason: QuickBooks Online allows different products to have the same SKU, while inFlow does not. When a sales order is pushed to QuickBooks Online, inFlow will look at items on the order to see if they already exist in QuickBooks Online by matching the SKU in both programs first. If you have more than one product with the same SKU in QuickBooks Online, inFlow doesn’t know which product it should match. Instead, it will match the first product in QuickBooks Online that has the corresponding SKU, which may be incorrect.

Solution: Check QuickBooks Online to see what items have the same SKU as the one in the inFlow error. Make sure that you don’t have duplicate SKUs in QuickBooks Online. You will also need to correct any sales orders that were pushed to QuickBooks Online with the item listed in the error and swap out the incorrect product for the intended one.

Sales Shipping is disabled in QuickBooks but specified in the inFlow transaction.

Reason: QuickBooks Online needs to have Shipping enabled so shipping information can be synced from inFlow to QuickBooks Online.

Solution: In QuickBooks Online, find the cogwheel on the top right. Click Account and Settings. Click Sales on the left bar. Edit the Sales form content section so that the Shipping setting is on.

QuickBooks Online Account and Settings page, with arrow point to Shipping toggle inside the Sales tab

QuickBooks Online can’t connect

If too many sales orders are saved in inFlow at the same time (for example, while importing sales orders), you may get an error saying: “Cannot connect to “QuickBooks Online at the moment.” This error will also be accompanied by a red exclamation mark on the top right-hand corner of the QuickBooks Online image and a warning on the inFlow for Windows app.

Don’t panic! QuickBooks Online has a system that prevents too many orders from being synced at once, so your orders are still able to sync. You’ll just need to wait a little, then click the Retry all button to sync again.

 If the Retry all option doesn’t work, please contact the inFlow team so we can further assist you.

Was this guide helpful?
Yes, thanks!
Not really
Thank you for your input, your feedback is important to us!

5 Comments

  1. YUAN QIU

    is inflow premium working QBO?

    Reply
  2. Wes Zalewski

    Prepayment of unreceived items is a balance sheet transaction, not income statement.
    Even if it might be corrected at some point, (maybe), it is already creating a nightmare in financial statements.

    Reply
  3. Jonah C Spilsbury

    Invalid bundle id 535 passed to SalesItemLineDetail.ItemRef. Please use GroupLineDetail with bundles.

    Error stopping an invoice from being passed to QBO, I can’t understand this error

    Reply
    • Jared Plumb

      Hey Jonah,

      Thanks for reading. Unfortunately, I can’t help you with that error. Your best bet is to contact Intuit directly. They should be able to give you some insights. Good luck!

      Cheers,
      Jared

      Reply
  4. Thomas Woolsey

    I have more questions regarding exactly what data is being pushed to quickbooks from inflow with total Cost of Goods Sold, and total Inventory value from inFlow to QuickBooks Online. I need to know how Inflow comes up with these numbers.

    Reply

Submit a Comment

Your email address will not be published. Required fields are marked *

In this tab
  • Two-way payment sync video
  • How does this work?
  • Before setup checklist
  • QuickBooks Online explainer & setup webinar
  • Connecting inFlow to QuickBooks Online
  • Sales orders push integration settings
  • Sales order payment settings
  • Sales order tax setup
  • Sales order push account setup breakdown
  • Purchase order and inventory value push settings
  • Purchase order payment settings
  • Purchase order push account setup breakdown
  • How to push a sales order to QuickBooks Online
  • Which transactions will inFlow sales orders be in QuickBooks Online?
  • Where can I find invoices and other transactions in QuickBooks Online?
  • Which sales order fields push to QuickBooks Online?
  • Which fields won't push to QuickBooks Online?
  • What customer fields push to QuickBooks Online?
  • How will the products sync to QuickBooks Online?
  • Processing payments
  • How are refunds handled?
  • How to push purchase orders and inventory value to QuickBooks Online
  • Pushing total inventory value
  • How does inFlow push the Cost of Goods Sold?
  • Which transactions will inFlow purchase orders be in QuickBooks Online?
  • Where can I find bills and other transactions in QuickBooks?
  • How will the products sync to QuickBooks Online?
  • Processing payments
  • What if the product exists in inFlow but not in QuickBooks Online?
  • Does this sync inventory quantities?
  • If I make changes to an order, product, vendor, or customer in QuickBooks Online, will it be updated in inFlow?
  • Seeing duplicate payments?
  • Common alerts/errors
Similar articles

A complete guide on how to set up inFlow.

Get advice and answers from the inFlow Support team