Accounting Integration Settings is where you configure how you want Order Time to integrate with your accounting system.
There are five tabs each having there own configuration settings.
The biggest decision you will make with the integration is whether you want to Sync Inventory (parts and assemblies) with your accounting system. Most accounting systems support inventory items and Order Time can both manage these items and include them in transactions. However in certain circumstances you may not want to synchronize inventory for a variety of reasons the most common of which is as follows:
- The number of items you have exceeds your accounting system's limitation.
- The valuation method used by your accounting system is not suitable for you purposes.
- Inventory items causes bloat, speed or corruption issues in your accounting system.
- You want to manually establish your inventory valuation (and by extension your cost of of good sold - COGS).
There are two question that arise if inventory is NOT synced:
- What items are used to post transactions in your accounting system? Order Time will use a Proxy which is a non-inventory item used in place of the inventory item when posting transactions into your accounting system. For example this invoice uses a proxy item called Books in the accounting system. Notice the actual item number (sku) is in the description. This is generally not a issue as you can send to your customers an invoice from Order Time which will list the actual items. By default Order Time will create a proxy called OT Proxy.
- How is COGS calculated? Each accounting system has its own way of calculating COGS. For example QuickBooks Desktop generally uses average cost when recording inventory items. However when inventory is not synced, there would be no COGS entry. If you choose to Post valuation entries, Order Time will create a journal entry reflecting the appropriate inventory and COGS ledger entries.
When you check Do not sync inventory:
- Import existing inventory items: check if you want to import existing inventory items. Note: this will occur during the initial sync only.
- Post valuation entries: check if you want Order Time to post journal entries as described above.
When you check sync inventory:
- Create an initial inventory adjustment in Order Time after initial import: When this is checked, a Quantity Adjustment will be created in Order Time reflecting the positive QOH shown in QuickBooks.
- Import existing Sales Orders during the initial sync: When this is checked, Order Time will import open sales orders from QuickBooks.
- Import existing Purchase Orders during the initial sync. When this is checked, Order Time will import open purchase orders from QuickBooks.
- Order Time WILL NOT sync Lot / Serial numbers. To bring in Lot / Serial numbers you will need to do that with a Count Line Import. (Start video at 13:15 mark)
Order Time will attempt to use the same Doc No. for imported sales orders and purchases orders when they are numeric and have not already used.
If your accounting system supports Item custom fields, then you can map your accounting custom fields to Order Time fields.
With customers there are a few options to consider:
- Use billing contact as default shipping contact: Copies the Customer primary contact to the contact fields in the shipping address's contact fields.
- After initial import, do not continue to synchronize addresses: After the initial import, you can stop syncing the billing and shipping addresses. This was added to avoid certain versions of QuickBooks of changing non-US addresses when address verification is turned on. We recommend that you keep this unchecked.
- Synchronize credit card information: Check if you want Order Time to sync custom credit card information into your accounting system. This will be a one way sync as Order Time is unable to import Credit Card #'s due to compliance standards.
- Invoice Send Method: This is used by QuickBooks. When a invoice is synced, QuickBooks will add it to the to be printed list or to be emailed list.
If your accounting system supports Customer custom fields, then you can map your accounting custom fields to Order Time fields.
The Ship Doc is the source for the Invoice in your accounting system and the Customer Return is the source for the Credit Memo in your accounting question. The first two settings relate to the timing of when Order Time should queue up these transactions to be synced. This is done by selecting the appropriate document status as the trigger point.
Invoice Date in Accounting is by default set to the Posting Date which is the date, the ship doc's status was changed to Shipped. If you want to use the Ship Doc Date instead, check - Use Ship Doc's Date as Invoice Date (by default Ship Doc's Posting Date is used.)
By default, Order Time will sync payments collected in Order Time to your accounting system. To prevent this check Do not post payments in Accounting.
If your accounting system supports Invoice and/or Invoice Line Item custom fields, then you can map your accounting custom fields to Order Time fields.
The Receiver is the source for the Bill in your accounting system and the Vendor Return is the source for the Debit Memo in your accounting question. The first two settings relate to the timing of when Order Time should queue up these transactions to be synced. This is done by selecting the appropriate document status as the trigger point.
If your accounting system supports Vendor custom fields, then you can map your accounting custom fields to Order Time fields.
Scheduling will tell Order Time to sync with accounting at predetermined intervals. Check the box to enable Scheduling. The interval can be daily or hourly. We recommend a daily interval.
When scheduling is set for the first time a sync will occur immediately.
The Order Time accounting integration with QuickBooks Online only supports PLUS & ADVANCED plans at this time.
It DOES NOT support Simple Start or Essentials.