1 / 8

Sub-ledger Reconciliation Utilities

Sub-ledger Reconciliation Utilities. Product Demonstration GRN Suspense. Press ESC to exit. Variance between the sub-ledger balance and the Ledger control account balance at the beginning of the period you selected to view.

jody
Download Presentation

Sub-ledger Reconciliation Utilities

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Sub-ledger Reconciliation Utilities Product Demonstration GRN Suspense Press ESC to exit

  2. Variance between the sub-ledger balance and the Ledger control account balance at the beginning of the period you selected to view. Variance between the sub-ledger movement and the Ledger control account movement for the period you selected to view. Variance between the sub-ledger balance and the Ledger control account balance at the end of the period you selected to view. GRN sub-ledger balance at the beginning of the period you selected to view. GRN sub-ledger balance at the end of the period you selected to view. GRN sub-ledger movement for the period you selected to view. Ledger control account balance at the beginning of the period you selected to view. Ledger control account balance at the end of the period you selected to view. Ledger control account movement for the period you selected to view. If you have more than one control account, you can expand the view to display detailed values. Use the Show details function to display values for a single control account. The detailed variance analysis is based on this value. Press ESC to exit

  3. The total value of differences between A/P expense journal values and G/L group entry values. The total value of differences between GRN journal values and G/L group entry values. The total value of differences between G/L Group Entry values and values posted to the control account(s). The total value of differences between Inventory journal values and G/L group entry values. The total value of differences between GRN matching values and A/P expense journal values. The total value of differences between GRN adjustment values and GRN journal values. The total value of differences between GRN receipt values and Inventory journal values. The total value of transactions posted to the control account(s) that were not generated in the GRN, Inventory or Accounts Payable modules. Press ESC to exit

  4. Details of the transactions making up these variances are displayed in the tabs below. Details of GRN receipts where: The Inventory audit trail reports have not been printed. The Inventory journal value differs from the G/L group entry value. The G/L group entry has not been posted. Details of GRN matching transactions where: The A/P audit trail reports have not been printed. The A/P journal value differs from the G/L group entry value. The G/L group entry has not been posted. Details of GRN adjustments where: The GRN audit trail reports have not been printed. The GRN journal value differs from the G/L group entry value. The G/L group entry has not been posted. Details of transactions posted to the control account(s) that were not generated in the GRN, Inventory or Accounts Payable modules. Details of entries where the G/L group entries value differs from the value posted to the General Ledger control account. Details of transactions where the GRN receipt value differs from the Inventory journal value. Details of transactions where the GRN matching value differs from the A/P expense journal value. Details of transactions where the GRN adjustment value differs from the GRN journal value. Press ESC to exit

  5. Use the What Next function to view the possible cause of the variance and suggested corrective measures. Use the Notes function to view and edit notes held against the line item. Indicates that notes have been created against the line item. What Next? Notes… Contra Entry… Expense Journal Summary… Expense Journal… What Next? By highlighting a detail line and using your right mouse button, you can access the following functions…. Includes hyperlinks to the SYSPRO program required to correct the selected variance. Notes… Press ESC to exit

  6. Opens a new Contra Entries group window. You can continue to add variances to the group from any tab. Simply highlight the relevant variance and select the Contra Entry function. You can save the group once the Contra group variance amount is zero. What Next? Notes… Contra Entry… Expense Journal Summary… Expense Journal… Contra Entry… What Next? Notes… Contra Entry… GRN Journal Summary… Contra Entry… Press ESC to exit

  7. The Variance Details values are displayed net of the contra entries. The variances saved in the contra group appear in the reconciliation with a strikethrough line. Alternatively, you can select to exclude contra variances from the reconciliation. Press ESC to exit

  8. Zoom on the journal created to record the detail transaction. What Next? Notes… Contra Entry… Expense Journal Summary… Expense Journal… Expense Journal Summary… Expense Journal… Press ESC to exit

More Related