Rules

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. Date Matching:

Flex Catering = Xero

• Delivery Date in Flex = Order Date in QuickBooks
• Due Date in Flex = Due Date in QuickBooks
• If there is no Due Date, Flex will pass the Delivery Date as Due Date

7. 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.

8. 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).

9. Delivery fee passes to QuickBooks as line item in order.

10. Discount passes to QuickBooks as line item in order.

11. 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.

12. Same as item 10 above applies to Customer and Company.
13. You can enable order notes in Flex Catering to pass to the accounting software order notes field.