V9 - Reconcile journal entries tool

The Reconcile journal entries report (Operations > Reports > Accounting > Reconcile journal entries) will provide the current calculated value of a transaction and compare it to the journal entry that was sent to QuickBooks for the transaction.

This report can highlight:

Journal entries that were changed in QuickBooks.
Journal entries that were posted to QuickBooks, but the value of the transaction has changed in SOS. This means that a prior transaction in that item's history was added, edited, or deleted, changing the value of the transaction in question.
Transactions that did not post a journal entry in QuickBooks.

To run the report:

Under the Filters section:
- Choose the From date and To date. The From date is the reconciliation date that you found in Summary of the reconciliation process. The To date is either Today or the closing date of the reconciliation period.
- Choose All for the Transaction type.
Under the Retrieve your report section, select Display report.

When making corrections, this report may be rerun again, if looking for a specific Transaction type.

Understanding the color coding in the Reconcile journal entries report

Blue highlights.
- A blue highlight may indicate that SOS Inventory did not post a journal entry to QuickBooks for the corresponding transaction, or the journal entry was deleted in QuickBooks after it was posted by SOS Inventory. This may have occurred if the value of the journal entry would have been 0.00.
  - If the current calculated value of the transaction is 0.00, this line can be ignored.
  - If the currently calculated value of the transaction is not 0.00, click the Add to queue link to add that transaction to the sync queue.
- A blue highlight may also be the result of a sync error on the transaction. You may see a resolved journal entry listed on the row, yet still have the blue highlight. Use the transaction Ref # to look at the appropriate list and determine whether a sync error exists. If so, correct the error and resave the transaction to add to the Sync queue.
Green highlights. Green highlights indicate that the line item on the transaction cannot be found on the journal entry posted to QuickBooks. This can occur:
- If the item name has been changed since SOS Inventory posted the journal entry to QuickBooks.
- If the current calculated value of the line item was 0.00 at the time the transaction was created, this line can be ignored.
- If the current calculated value of the transaction is not 0.00, click the Add to queue link to add that transaction to the Sync queue.
Red highlights. Red highlights indicate that the value of the line item on the transaction was changed after SOS Inventory posted the journal entry to QuickBooks. This can occur:
- If a transaction increased or decreased the inventory value of the item dated before the transaction in question.
- Anytime a historical transaction containing that item was added, edited, or deleted. When a red highlight is observed, click the Add to queue link to have SOS Inventory update the journal entry in QuickBooks with the newly corrected values.

edit_noteNOTE: As the algorithm to compare transactions looks for the item name within the line on the QuickBooks journal entry, it can sometimes indicate a false mismatch. This occurs when the item name of one item on the SOS Inventory transaction is contained within more than one line of the journal entry in QuickBooks. If you have added these to the queue, synced, and there still seems to be a mismatch, this is most probably the case.

edit_noteNOTE: On returns to vendors (RTVs), the item that is removed from inventory will affect the asset account and the accounts payable account, according to the valuation method you have chosen in SOS Inventory. This value may or may not be the same as the amount of credit the vendor provides. If this is the case, it is recommended that you add a second line to the vendor credit to account for the difference in the valuation-method-derived value of the RTV and the amount of actual credit given by the vendor. SOS Inventory has a procedure for you to use to correct the value difference within QuickBooks Online. For more information, see Vendor credit memo value difference correction.