GoldFinch and Accounting Seed Inventory Reconciliation
At month’s end, you will want to reconcile your inventory value with the value in your General Ledger. Reconciling your inventory values can be a time-consuming process. To help with that, some reports and functions in GoldFinch can streamline the process.
To reconcile the GoldFinch (GF) Inventory Sub Ledger with the GF GL Inventory Balance, follow these steps:
Run the GF1003 Inventory to GL Recon As Of Date report as of the month-end date to view the inventory value.
Run the GF4010 Inventory GL by Month report to view the month-end amount posted to the GL.
The Invoiced Cost on the GF1003 Inventory to GL Recon As Of Date report must match the accumulated GF Inventory Balance on the GF4010 Inventory GL by Month report for that date.
If you see differences, run the Inventory Analysis function to look for differences by Document No.
Enter the Start Date and End Date to minimize the scope of analysis.
The routine takes a few minutes to run. Refresh the page until you see the last line, which is named “Total.”
Search for the Document No. in GF to research transactions to look for the root cause.
To reconcile the data between GoldFinch (GF) and Accounting Seed (AS), compare the GF GL Inventory Balance and AS Transaction Balance.
Run GF4010 Inventory GL by Month
Run AS110 Inventory Transactions by Month
The monthly changes must be the same for the Inventory Account
If not, check the following potential reasons:
Are there any GL Entries posted in GF but not copied to an AS Journal Entry?
Create a view in the GL Entries list to see the entries with these filters:
Is AR/AP = false
Journal Entry = blank
Are all of the Journal Entries created in the Accounting Seed from GFERP posted?
Are there any manual entries posted to the Inventory GL Account in AS?
If you see differences, run the Inventory Analysis function to look for differences by Document No.
Enter the Start Date and End Date to minimize the scope of analysis.
The routine takes a few minutes to run. Refresh the page until you see the last line, which is named “Total.”
Search for the Document No. in GF to research transactions to look for root causes.
Finally, post a manual entry in AS so that the Accrued Inventory Account equals the Expected Cost in the GF1003 Inventory to GL Recon As Of Date report.
The total Inventory values must be the total of the Inventory Account + the total of the Accrued Inventory Account.For reference:
GoldFinch Month-End Closing Best Practices Month-End Routines
Accounting Seed Month End Closing Best Practices https://support.accountingseed.com/hc/en-us/articles/217520877-Best-Practices-for-Month-End