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 Inventory Control > Reports > Items-on-Hand Valuation.

  • 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 General Ledger > Reports > Trial Balance.

  • 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.