Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

A record on the WIP Reconciliation window indicates an imbalance, with an extra $75.00 in the General Ledger.

Expand
titleClick here to view screenshot.

Image Modified



Double-click the line to view transaction details. You can drag and drop a column header to the grouping toolbar to group the transactions and view a summary by, for example, journal entry number.

Expand
titleClick here to view screenshot.

Image Modified



Viewing cost amounts by group allows you to focus on a group and makes it easier to narrow down the list of transactions that may be out of balance. 

In the example below, two of the three journal entries (4800 and 4802) have the same amounts in the subledger and General Ledger. The unreconciled transactions belong to journal entry 4477.

Expand
titleClick here to view screenshot.

Image Modified



You can expand a category to view the transactions in that group.

Once you have ruled out certain transactions - or a certain group - as the cause of the imbalance, you can mark those transactions as reconciled and use the Hide Reconciled button to hide them from view.

Expand
titleClick here to view screenshot.

Image Modified



Only the transactions for journal entry 4477 remain.

Expand
titleClick here to view screenshot.

Image Modified



If you expand those groups, you can identify that one of the $75.00 transactions from this journal entry hit the General Ledger but did not hit your WIP subledger.

Expand
titleClick here to view screenshot.

Image Modified



To save the custom view you have created before closing the WIP Reconciliation window and reconciling the unbalanced transactions, select Export.

Expand
titleClick here to view screenshot.

Subledger Export
Image Modified

General Ledger Export
Image Modified