Reconciling Inventory with the General Ledger
Follow this procedure regularly to reconcile your inventory with the General Ledger.
PART A
On the Site Map screen, click .
Complete the Selections section and select your G/L period end for "as of date."
In the Report type section, select the Summary report format.
In the Quantity selection section, select the All items option.
In the Discontinued status section, press Enter to accept the default of All items.
Select to Print the report.
PART B
On the Site Map screen, click .
Enter your Inventory Asset account(s) in the G/L Account # field.
In the Fiscal Year, enter the desired 4-digit fiscal year.
In the "from" fiscal period, enter 1.
In the "to" fiscal period, enter the period through which you are reconciling.
Direct cost entries are no relevant because you have selected asset account(s).
Select Summary or Detail.
Preview or Print the report.
Compare the report balances obtained in PART A with the report balances obtained in PART B to reconcile inventory on-hand.
Make any adjustments for the variance as a journal entry in G/L Data Entry.