(008) QuickBooks Online - Imperfections In the Integration with 1place.cloud

Summary

This KBA is intended to explain the scenarios where the Integration between QuickBooks Online and 1place.cloud are not 100% perfect (due to restrictions in and/or lack of features in the QuickBooks Online API).  In other words, the following scenarios outline where our hands are tied, or where we cannot perfect the integration. 

QuickBooks Online (QBO) Integration Imperfections  

Receiving a Payment in QBO that includes SOME money received AND uses SOME credit

• EXAMPLE SCENARIO:
• Suppose Customer X these 3 open, unpaid Invoices:
• Invoice 101, Open Balance: $100
• Invoice 102, Open Balance: $200
• Invoice 103, Open Balance: $300
• Suppose ALSO that Customer X has these 2 open, unapplied Credit Memo's on file:
• Credit Memo 200, Unapplied Balance: $50
• Credit Memo 210, Unapplied Balance: $350
• Now suppose Customer X sends in a payment of $200 (and makes a note to apply the $400 of unused Credit towards the remaining $400 Balance Due).
• In this case QBO will apply the money received and the open/unapplied Credit Memo's towards the $600 balance and make the balance due $0.
• HOWEVER, QBO DOES NOT provide a way for 1place to determine exactly which Invoice(s) the $200 was actually applied to.
• WORK AROUND:
• Apply money received on a Payment.
• Then create ANOTHER Payment to apply the unused Credits

The COST OF GOODS SOLD on 1place Invoices and Credit Memo's cannot be Synced to QBO

• The API Problem:
• The QuickBooks Online API (used to create Integrations into QuickBooks Online) does NOT allow an exterior app (like 1place) to pass in a Cost of Goods Sold on Invoices or Credit Memo's created OUTSIDE of QBO.
• When Inventory is received AND PAID FOR in QBO, QBO will then increase the Value of the Inventory on its Balance Sheet.  Then when Invoices are synced into QBO, with Items that QBO recognizes, it determines its own COST OF GOODS SOLD - which CAN be a value different than the COST OF GOODS SOLD stored in the 1place Invoice or CM line item.  In this case the Total Cost of Goods Sold can be different--which can cause the Profit and Loss Statement (Income Statement) in QBO to be out of sync with 1place.
• The 1place Work Around:
• 1place has a new 'Month End' screen which can be used to auto compare the Cost of Goods Sold amounts between 1place and QBO for every Invoice and Credit Memo.  This tool can also auto create a QBO Journal Entries to enable the 2 systems to be in exact sync.