Welcome, Guest. Please Login.
06/06/25 at 16:07:38
News:
Home Help Search Login


Pages: 1
Send Topic Print
BOOK TO PHYSICAL DIFF (Read 566 times)
lynnkissinger
Member
**


I love YaBB 1G -
SP1!

Posts: 75
Gender: female
BOOK TO PHYSICAL DIFF
11/08/07 at 15:22:03
 
When I compare my inventory gl acct #'s to my inventory value report, the numbers do not equal.  The net effect is equal, but the sub categories are not.  How do I correct?
Back to top
 
 
  IP Logged
David Waldmann
Active Member
*****


Live to work, or
work to live?

Posts: 1919
Gender: male
Re: BOOK TO PHYSICAL DIFF
Reply #1 - 11/09/07 at 05:10:57
 
Quote from lynnkissinger on 11/08/07 at 15:22:03:
The net effect is equal.

 
Wow. I have NEVER had the GL balance to the book value. Sometimes it's close (within $100), sometimes it's waaaay off.
 
I enter a GL-B transaction, debiting or crediting the Inventory accounts as required to make them balance, and the rest to a "Inventory Adjustments" account I created.
Back to top
 
 

David N Waldmann
President
Vermont Hardwoods
Chester, VT

Evo-ERP, 5 user
IST Build: 3/4/19, patched 04/30/19
Pervasive v11.31
Server 2012 / Win10 x64
Crystal Reports v11
Email WWW   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: BOOK TO PHYSICAL DIFF
Reply #2 - 11/09/07 at 08:53:05
 
We balance our GL accounts for inventory with the value reports every month.  We are seldom off by more than $30  total for our 5 accounts.
Do you print your Value report by GL account? This is the only way to get a total that will match the GL account you are looking at.
As far as the accounts not matching the value report if you are printing by GL account, you may have some non counted (type N) parts that use a counted part class code.  The transactions hit the GL in but the part will not show up on your value report because there is no on hand quantity maintained for N types. Another reason I have found that the accounts don't match is if for some reason you issue or make adjustments or receive a PO at $0 cost otherwise incorrect cost ( for instance if you go negative  the average cost can be  off for the issue process).  
I am sure there are other reasons why the accounts would not match, I just can't think of them.
Hope this helps.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
lmk223a
Senior Member
****


Accountant

Posts: 377
Re: BOOK TO PHYSICAL DIFF
Reply #3 - 11/13/07 at 06:57:49
 
Quote from lynnkissinger on 11/08/07 at 15:22:03:
When I compare my inventory gl acct #'s to my inventory value report, the numbers do not equal.  The net effect is equal, but the sub categories are not.  How do I correct?

 
I set up an expense account called Inventory Variation and create a journal entry that will charge the GL account for inventory and offset the transaction to Inventory Variation.  If the net effect is equal, this will accomplish correcting the inventory GL balances, and the net effect will be shown in Inventory Variation Account.
 
Also, yes, David, I also reconcile IN-F to GL type for inventory every month.  Finished goods is usually within cents; raw material is minimal, the only sizeable differences reside in WIP material.  WIP material variation is almost always offsest by WIP Labor variation, because I separate WIP between its components: labor, load and material, via EXCEL spreadsheet using EVO monthly labor (JC-C), and entries to finished goods, JC-Q, to evaluate remaining WIP Labor $.  
 
AFTERNOTE: we also have a few educated EVO users which helps reduce variation, so that inventory transactions are entered properly.
Back to top
 
 

EVO/ERP 2007.2 3/2708 update, 15 users
Linda Kucan
Email   IP Logged
Pages: 1
Send Topic Print