There are places in the management system where the all of the general ledger accounts including the inventory asset account are available as a posting option. This makes it accessible for posting when necessary. For example, in Accounts Receivable when an adjustment is being is being created, the inventory account can be seen in the drop down list as an available ledger account (see figure 1.1). If you were to write off an Accounts Receivable invoice and if you chose the Inventory Asset Account, it would credit A/R and would debit Inventory. The Balance sheet would remain in balance but you would have increased the financial inventory value directly at the General Ledger and would not have impacted the detailed inventory record, which would result in a variance.
When running the financial inventory report and the balance sheet, make sure to run these for the same date range. This is important because as of this writing, the financial inventory report can only be run “As of Today” So running the financial inventory report today and the balance sheet as of a different ending date could report a variance. In order to get an accurate picture before you start adjusting inventory manually, run the financial inventory report and then the balance sheet both as of today immediately back to back. This means that you will need to run these reports when there is no other activity happening in the system which effect inventory values. The period can be frozen momentarily to get these reports and unfrozen once they have been completed. Begin the balancing procedures with comparing these two reports back to back on the same day for today. Usually it is year-end when the inventory financials are reviewed. As common as this is, is will be much easier to self-audit inventory errors if these reports are compared on a monthly basis. Here’s what typically happens; fiscal year end arrives at December 31st. The financial inventory report is run on December 31st. On January 10th, the financial statements are run. The balance sheet is run on January 10th with a range date of “as of December 31st”. The problem with this type of comparison is that the inventory has changed over those 10 or so days. Payables for December have continued to post, inventory has continued to be delivered in a rev rec environment (what if something was un-delivered?) and inventory adjustments have continued to be made. The balance sheet is no longer a true representation of what the system looked like on the true date of December 31st. The only way to compare inventory financials is to look at the numbers on the same day. If these numbers balance then any variance after the fact would be due to data entry in the time after the initial comparison and therefore no inventory adjustments need to be made.
Journal entries that are made to the inventory asset account will impact the General Ledger but will not impact the Financial Inventory Records or report. The financial inventory report is a reflection of the automatic processes in the system and do not reflect manual journal entries. You must take into account the total value of journal entries from the beginning of time when comparing the balance sheet inventory value to the financial inventory report. These entries will not appear in the financial inventory report values.
During the transitional period when old jobs are completing in the previous system and new jobs are begun in the new system, there could be postings to the inventory asset account that have no corresponding postings in the automated processes of the management system. This would be in the form of a manual journal entry. We recommend maintaining a separate inventory asset account for any materials not imported into the management system during the implementation process.
During the implementation process, carry over inventory is imported into the management systems via a spreadsheet. This spreadsheet dollar value MUST match the value of inventory asset being posted to the system’s inventory asset account during the beginning balances journal entry. Any inventory asset value that exceeds the import spreadsheet value must be posted into an alternative inventory asset ledger account. If the import spreadsheet does not match the beginning balance to the inventory asset system account, you could see variances in your financial inventory and balance sheet until an adjusting journal entry is created to correct the variance.
There is an option at the A/P GL Spread tab to change the posting ledger account number. If this number is changed to the inventory asset account number, then you could have inventory financial variances between the balance sheet and the financial inventory report.
Perform the inventory maintenance routines before comparing any reports pertaining to inventory. This would include (but are not limited to):
All of these routines are directly related to inventory. This will ensure the data is the most accurate at the time you run the financial reports.
Make all inventory adjustments AFTER the maintenance routines have been performed. Making adjustments prior to completing this process could cause financial inventory variances in the management systems.