Scribd
Upload
496 views2 pages

Inventory Reconciliation

This document outlines the steps to reconcile inventory for a specified period including running various reports, comparing values between reports, investigating discrepancies, and correcting any errors. Key steps include running a trial balance and period close reconciliation report for the period, comparing ending balances between the reports, examining inventory-related journal entries for discrepancies, correcting any errors, running a WIP value report, comparing WIP balances between the reports, and reconciling beginning and ending inventory balances if they do not match.

Uploaded by

Max Shor
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
496 views2 pages

Inventory Reconciliation

This document outlines the steps to reconcile inventory for a specified period including running various reports, comparing values between reports, investigating discrepancies, and correcting any errors. Key steps include running a trial balance and period close reconciliation report for the period, comparing ending balances between the reports, examining inventory-related journal entries for discrepancies, correcting any errors, running a WIP value report, comparing WIP balances between the reports, and reconciling beginning and ending inventory balances if they do not match.

Uploaded by

Max Shor
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 2

Inventory Period End Reconciliation 1.

Run "Trial Balance Detail Report" for the reconciled period Responsibility: General Ledger Super User / User
Navigation: Request Submit > Trial Balance Detail Parameters:

Page break Segment: Company Page break Segment Low High: Currency: USD Period: Period for Reconciliation (e.g. AUG-07) Amount Type: PTD (Period to date) 2. Run "Period Close Reconciliation Report" for the reconciled period Responsibility: CST Super User / User
Navigation: Report > Value> Choose Organization>Single Request>"Period Close Reconciliation Report" Parameters: Sort option: Default Period: Period for Reconciliation (e.g. AUG-07)

Currency: USD Exchange rate: 1 3. Run Period Close Reconciliation Report for all Organizations. Summarize Report Total Accounted Value (in the last report row) for all organizations. In the Detail Trial Balance Report go to the account line XXXXXX Material and note the Ending Balance for the period in the last row of the report. The Ending Balance in Detail Trial Balance Report should match the Summary of Total Accounted Values for all organizations. If not matched, go to Inquiry account, perform the inquiry for account XXXXXX Material and search for journals that result in discrepancies. Responsibility: General Ledger Super User / User Navigation: Inquiry>Account Selection criteria: Accounting periods Accounts: Company (YY), Account: XXXXXX Show Journal Details Search for Journal Entries with Source that is not Inventory, e.g. with Source Manual, Spreadsheet, Payables, etc. You can also export the journal details to GL for easier data search. File> Export 7. Perform the needed corrections for journal entries with errors. 8. Run WIP Value Report for all Organizations Responsibility: CST Super User / User
Navigation: Report > Value> Choose Organization>Single Request>WIP Value Report

4. 5. 6.

Parameters:

Report type: Period to date Period: Period for Reconciliation (e.g. AUG-07) Currency: USD Exchange rate: 1 9. In the Detail Trial Balance Report go to the account line XXXXXX WIP Material and note the Ending Balance for the period in the last row of the report. 10. In WIP Value Report go to Work in Process Account Summary at the last page of the report and note the Work in Process Cost Totals Net Activity (Last row, last column of the report). Summarize the Work in Process Cost Totals Net Activity for all Organizations. 11. Summary for reconciliation. Summarize the Ending balance for account XXXXXX for the previous period (the period before the period for reconciliation) and the Summary of WIP Cost Totals Net Activity (for all Organizations) for the period for reconciliation (Summary) 12. This Summary for reconciliation should match the Ending balance for account XXXXXX for the reconciled period. 13. If not matched perform 6 and 7 for account XXXXXX.

You might also like