Reconcile Inventory Costs with the General Ledger

When you post inventory transactions, such as sales shipments, purchase invoices, or stock adjustments, the changed item costs are recorded in item value entries. To reflect this change of inventory value in your financial books, the inventory costs are automatically posted to the related inventory accounts in the general ledger. For each inventory transaction that you post, the appropriate values are posted to the inventory account, adjustment account, and COGS account in the general ledger.

Automatic cost posting is defined by the Automatic Cost Posting field on the Inventory Setup page.

Even though inventory costs are automatically posted to the general ledger, it is still necessary to ensure that the costs of goods are forwarded to the related outbound sales transaction, especially in situations where you sell goods before you invoice the purchase of those goods. This is referred to as cost adjustment. Item costs are automatically adjusted when you post item transactions, but you can also adjust item costs manually. For more information, see Adjust Item Costs.

To post inventory costs manually

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Post Inventory Cost to G/L, and then choose the related link.
  2. Post inventory costs to the general ledger manually by running the batch job. When you run this batch job, general ledger entries are created on the basis of value entries. You can post the entries so that they are summarised per posting group.

Note

When you run this batch job, you might encounter errors having to do with missing setup or incompatible dimension setup. If the batch job encounters errors in the dimension setup, it overrides these errors and uses the dimensions of the value entry. For any other errors, the batch job skips posting the value entries and lists them at the end of the report in a section titled “Skipped Entries.” To post these entries, you must fix the errors.

To see a list of errors before running the posting batch job, you can run the Post Invt. Cost to G/L - Test report. The test report lists all the errors encountered during a test posting. You can then fix the errors, and run the inventory cost posting batch job without skipping any entries.

If you would like to simply get an overview of what values could be posted to the general ledger without actually performing the posting, you can run the Post Inventory Cost to G/L batch job without actually posting the values to the general ledger. You do this by clearing the check mark from the Post field on the request page. This way, when you run the batch job, the report is produced showing the values that are ready to be posted to the general ledger, but they are not posted.

To audit the reconciliation between the inventory ledger and the general ledger

The Inventory - G/L Reconciliation page provides the following:

  • Exposes reconciliation differences by comparing what is recorded in G/L and what is recorded in the inventory ledger (value entries).
  • Displays unreconciled cost amounts in the value entries in the inventory ledger as if they were mapped to corresponding inventory-related accounts in G/L and compares those to the totals actually recorded in the same accounts in G/L.
  • Reflects the double entry structure of G/L by visually presenting data as such. For example, a COGS entry has a corresponding inventory entry.
  • Lets users drill down and see the entries that make up the cost amounts.
  • Includes filters to narrow the analysis by date, item, and location.
  • Explains reasons for reconciliation differences in informative messages.

The Name column on the far left in the grid lists the various G/L account types that are associated with inventory.

The Inventory, Inventory (Interim), and WIP Inventory columns show the invoiced, non-invoiced, and WIP totals of each G/L account type. These are calculated from value entries, that is, they are projected onto the G/L account types where they will end when they are eventually posted to G/L.

The Total column shows the sum (in bold font) of the value entry amounts in the three inventory columns.

The G/L Total column shows the amounts (in bold font) for each G/L account type that exists in G/L. These are calculated from G/L entries, that is, they represent inventory costs already posted to G/L.

The Difference column represents the difference between the value in the G/L Total and Total fields.

In the top of the Inventory - G/L Reconciliation page, you can enter filters to limit, for example, the period of time for which you want information.

If you select the Show Warning check box and if there are any discrepancies between the inventory totals and G/L totals, application shows messages in the Warning field of the grid that explain the discrepancy. If you choose the Warning field, application gives you more information on what the warning means.

When you have entered all relevant filters, choose the Show Matrix action. The data is calculated and the matrix page appears.

On the far left column in the grid, you see the various general ledger account types that are associated with inventory. The grid then shows the invoiced, non-invoiced (interim), and WIP inventory totals for each of these account types. These totals are calculated from the value entries.

The next columns show the totals for the same account types calculated from the general ledger entries.

Choose the amount in any of the total fields to see the inventory report entries that were used to calculate the totals. For inventory totals, the inventory report entries are the sums of the value entries for the items. For the G/L totals, the inventory report entries are the sums from the general ledger entries.

Reporting Costs and Reconciling with the General Ledger

Other reports, tracing functions, and a special reconciliation tool are available to the auditor or controller responsible for reporting a correct and balanced inventory value to the finance department.

The following table describes them.

To See
View the inventory value of selected items, including information about the quantities and values of increases and decreases in inventory over a selected period. Inventory Valuation report
View the inventory value of selected production orders in your WIP (work in progress) inventory, such as the quantities and values of consumption, capacity usage, and output in ongoing production orders. Inventory Valuation - WIP report
View the inventory value of selected items, including their actual and expected cost on the date specified. Invt. Valuation - Cost Spec. report
Use a report to analyse the reasons for cost variances or to gain insight into the cost shares of sold items (COGS). Cost Shares Breakdown report

See Also

Managing Inventory Costs
Purchasing
Sales
Work with Business Central
General Business Functionality

Find free e-learning modules for Business Central here