Quickbooks Integration Rules and Notes

1. The Customer reconciliation between the two systems is done by the Contact and Company. Flex Catering will create both customer and its respective company in Quickbooks. The order will display the customer and and its company for the billing details.

Note: Customer/Company relationship will not be updated on subsequent imports. Other details will update as per order.

2. Quickbooks can’t have duplicated Customer and Company name. They MUST be unique. 

3. On each import you will be prompted with a mapping screen that allows you to match your contacts and products in Flex Catering to your respective ones in Quickbooks. If no contact or product is mapped, a new one will be created in Quickbooks. 

4. After the import is initiated, Orders can take a few minutes to show in Quickbooks. We recommend importing in batches of up to 10 orders per import.

5.  Status Matching:

Flex Catering                                  Quickbooks

  • Paid                                          = Paid
  • Unpaid or Partially Paid        = Open

6. Payment Integration:

  • Payments are imported to Quickbooks with their respective orders.
  • Payments created by Flex Catering are prefixed with reference id `PF` (i.e: PF394). If payment is adjusted directly in Quickbooks, it will be overwritten by payments in Flex on subsequent import of the order.
  • If Flex is unable to update payments from order in Quickbooks, the order will get updated except for the payments details. Flex will show the message ‘Order details updated except for its payments’ so you can manually adjust the payments in Quickbooks.

7. Ticks next to each orders in the order list:

  • No tick: Order hasn’t been imported.
  • Green tick: Successfully imported into Quickbooks.
  • Yellow tick: It was successfully imported but has been edited since. It can be re-imported.
  • Red tick: failed to import. It can be re-imported.

Note: If order is imported to Quickbooks, it will not allow to import this same order again (Green Tick in Flex Catering order list).

8. Delivery fee passes to Quickbooks as line item in order.

9. Discount passes to Quickbooks as line item in order.

10. Imported Voided Orders in Quickbooks: If an order is voided in Quickbooks and re-imported from Flex, the order will become active again and gets updated on import.

11. Same as item 10 above applies to Customer and Company.

How to Integrate and Import Orders into Quickbooks

Google Rating
5.0

Google Review

Peter Botros
Peter Botros
01:23 05 Aug 19
Flex Catering was the best business decision we made. It has built consistency within the business and provided transparency for our customers. Now customers can view and order from our online menu. Our staff can easily identify the confirmed orders and print specific production reports for the kitchen and drivers. Customer support is always online and very helpful. New versions are released every few weeks or so with nice additional features which are always very welcome and helpful. A big thumbs up to the Flex team :)
Email David
Email David
00:14 14 Apr 19
Very quick, very good and getting better all the time - great customer experience
John Mulligan
John Mulligan
20:27 11 Mar 19
Flex catering provide a great personalised service an excellent product that is constantly evolving based on feedback from their clients. Well done.
See All Reviews