EDI Integration Options for QuickBooks

Infocon Systems
2 min readApr 27, 2020

--

QuickBooks is the #1 rated accounting software solution for small and medium-sized businesses developed and marketed by Intuit. It manages all finances with either a licensed or online version. QuickBooks application helps in streamlining all the payment related operations involved in a business. It is a centralized accounting software that also supports cloud storage. Of late EDI systems are becoming an integral part of every business. QuickBooks EDI Integration allows formatting transactions with partner organizations as per their requests. EDI transactions easily transformed into a human-readable format. Most enterprises nowadays are incorporating EDI translators across trading platforms for smooth and quick transactions.

Electronic Data Interchange or (EDI) is the process of exchanging of business documents between trading partners. It is a secure, reliable, fast, and accurate system for exchanging information with external entities that do business together. Each company uses specific formats based on accepted standards in their EDI documents. These standards i.e. X12, EDIFACT, RosettaNet allow flexibility so companies can tailor them to suit their particular business needs. In North America the US standard ANSI ASC X12 or the EDI x12 is predominantly used.

Some example EDI documents types are:

· EDI 810 — Invoice

· EDI 850 — Purchase Order

· EDI 855 — Purchase Order Acknowledgment

· EDI 846 — Inventory Inquiry/Advice

· EDI 856 — ASN (Advance Ship Notice)

· EDI Integration with QuickBooks

QuickBooks manages business’ sales and expenses from one place and automates manual data entries such as creating invoices, export/ import purchase orders, or business reports. Every supplier required a solution that would decrease manual data entry and time to export or import business documents from their EDI portal to QuickBooks and vice versa.

How automation improves the productivity of a business:

· A buyer places an order with the supplier. The buyer sends EDI 850 Purchase Order electronically to the EDI provider company.

· The EDI provider company translates the edi document using tools and sends to the supplier.

· The Supplier got the purchase order electronically and inserted it into QuickBooks using one of the methods provided by the EDI providers.

· Supplier sends EDI 856 Advance Shipping Notice (ASN) to the buyer by way of the EDI provider company to update the buyer of the shipping information.

· Supplier sends EDI 810 invoice to the buyer by way of the EDI provider company for payment.

Web EDI QuickBooks business users realize significant gains through accounting system integration:

· Reducing time consuming, manual data entry

· Complete elimination of and charge-backs

· Increasing productivity with fewer resources, freeing employees’ time for other work

· Staying within EDI updates while integrating Web EDI transactions with QuickBooks

--

--

No responses yet