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


Pages: 1 
Send Topic Print
Balance Sheet Imbalance (Read 2572 times)
ASIMedicalJR
Browser
*




Posts: 24
Balance Sheet Imbalance
06/25/08 at 08:34:55
 
I have a GL asset account, WIP Variance, that is showing up on the Trial Balance and Income Statement but not on the Balance Sheet.  This is causing the Assets=Liabilities+Owners Equity to not balance together.  How can I get the WIP Variance GL account to show up on the Balance Sheet so they balance??
 
Thanks,
Jamie
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #1 - 06/25/08 at 09:05:52
 
I think the way WIP Variance is used normally is as an expense account;  if this is the way your account is set up (as an "E" type)  it should be on your income statement and should not be on your balance sheet.  
 
If it is an asset account and it is showing up on the income statement,  you may have it included it in the range of accounts normally used as expense accounts, but you have made it an asset.  
On the default income statement, this would happen if you made and account in the normal expense range (500--'s) an asset account.  Conversely, it will not show up on the balance sheet because the normal range of assets in in the 100--'s.  
To use an account out of the normal range as a different type, you need to do a custom statement for both income and balance sheet.
 
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
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #2 - 06/25/08 at 12:29:29
 
Thanks for your help.  So the situation is the income on the balance sheet is not matching the income balance on the income statement.  The difference is the exact dollar amount of WIP Variance which is the account showing up on DTB and Income Statement but not the Balance Sheet.  The WIP Variance is under "Revenue" on the Income Statement.  Is this still something I need to take care of under "Custom Financials"?
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #3 - 06/25/08 at 13:56:31
 
What is your account number?  What type of account is it (AM-A)?
 
PS If it is an expense account is it "Cash" or "non-cash" ?
 
 
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
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #4 - 06/25/08 at 14:01:58
 
You mean GL-A?  Because AM-A is Reset Period Close Date....
 
And which account number do you need to know?  The income, or WIP?
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #5 - 06/25/08 at 14:20:17
 
Sorry, yes I meant GL-A-- the WIP Variance account.  What income account are you talking about?
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
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #6 - 06/25/08 at 14:33:55
 
We have two WIP Variance's for some reason.  The one throwing off the Balance Sheet, however, is 50125.  And the income account I am speaking of is on the Balance Sheet under Equity, it says 30020 Net Income.  Does this help?
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #7 - 06/25/08 at 15:18:12
 
Yes the income account is coming from the income statement-  it is the net income aka Retained Earnings.
What is the account type for your account 50125?  What is the other WIP variance account number and type?
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
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #8 - 06/25/08 at 15:26:21
 
Exactly.  And for some reason the Balance Sheet is not pulling the correct income from the Income Sheet.  Like I mentioned, it is off the WIP Variance amount.
 
Both WIP Variance's 50125 & 11310 are under Assets in the Chart of Accounts.  
 
Sorry, I am fairly new at this so I hope I am understanding your ?'s.....
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #9 - 06/25/08 at 15:54:00
 
Actually your balance sheet is probably right but your income statement is off because it is reporting the 50125 account in the COGS when you have it typed as an asset.  
 
WIP variance is really an expense.  It is either the difference between actual costs and standard cost if you finish production at standard cost, or it is (as in our case) costs added to the work order after finishing production at actual cost.  WIP as an asset on the other hand is costs of Work In Process that is not finished.  That must be what your other account 11310 is?
 
I am not sure why you have WIP variance as an asset , but in order for it not to report on the Income Statement you need to have it as a number outside all of your other expenses.  The standard  forms only allow two ranges for COGS and your WIP variance as an asset probably falls with in those ranges.  
 
   
 
Take a look at the Standard Income Statement Format in AM-E.  See if your 50125 is included in the account ranges for this report.
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
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #10 - 06/30/08 at 14:18:26
 
Yes the 50125 WIP falls under our expense accounts.  So you are saying it should be an asset?  How would I put it under the asset category?
 
Jamie
Back to top
 
 

Jamie
Email   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: Balance Sheet Imbalance
Reply #11 - 06/30/08 at 15:50:08
 
Sounds like you have it incorrectly designated.  Number 50125 (in your numbering convention) looks like it should be an Expense but you seem to have it set in AM-C as A (Asset).  You need to change the type in AM-C from A to E for Expense.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #12 - 07/01/08 at 08:44:41
 
Yes that's how I interpreted it also, your account 50125 is typed as an asset, but it falls in the range of Expenses so it shows up on your Income Statement.  You need to make it an E type.  
As I said before, normally WIP variance is an expense, but if for some reason you want it to be an asset it needs to be in the asset range -10000's.
 
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
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #13 - 07/02/08 at 13:39:40
 
So both WIP Variances, 11320 & 50125, are under the A for Asset in Chart of Accounts.  Except all of our asset GL codes fall in the 10000's and the 2nd WIP Variance is 50125 which is expense account numbers 50000; however the expense GL does not show the 50125, Asset does.  Does that mess with the reporting on the Balance Sheet?  If so than how do I change the 50125 to a 10000 style account?  
 
Am I making sense??
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #14 - 07/02/08 at 14:11:34
 
Are you sure the 11320 is a WIP variance and not your WIP asset account?  
 
In my opinion you need to have only one WIP asset, the one that collects costs on work orders that are in process.   It is the account that you are using for the WIP account when you set up your class codes for manufactured items.  That may be the 11320 account.  
 
The WIP variance is an expense (it is part of COGS), so you should change the 50125 account to be an expense.  Once you do this your reports should be right.
 
I am sure this is confusing but I hope it 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
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #15 - 07/02/08 at 14:53:41
 
They both say WIP Variance I sware!  Smiley
 
But you were right!  I changed 50125 to E since the range falls under COGS (Expense) and now the financials are right.  Woohoo!  Thank you so much for your help!  
 
But now I have another separate issue.  Sad  This morning our recieving guy received 25 parts and realized he was supposed to recieve 23 instead.  So he recieved -25 and than 23.  Now the GL-O (posting) is off the $ amount of the 25.  Shouldn't this of washed?
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #16 - 07/03/08 at 07:49:21
 
I'm glad your financials are finally balanced!  As for the 11320 account, check your item class codes and see if this is the account used for WIP.  If it is then you just need to change the account name.  If it isn't then I am curious about what is posting to this account.
AS for the PO receipt, are you looking at GL-O by a certain date or all dates? If by a certain date, did he use the same dates for all the receipts?
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
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #17 - 07/03/08 at 08:08:03
 
For the PO thing, I don't even type in a date yet when it tells me it is out of balance.  When you click on GL-O it processes all the batches before it brings you to the screen where you would type in the date you want to post for.  Well it tells me an out of balance error message.  I type Y or N to get into the GL-O screen.  Y allows me to access GL-O without seeing the out of balance and N allows me to see the out of balance.  So I am unable to post until I figure out why it got out of balance.  I know the transaction that caused it but I don't know why.  And, yes he processed all receivings and unreceivings as 07/01/08  
 
Even when I look in AP-C the way he received and unreceived looks correct.
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #18 - 07/03/08 at 11:17:07
 
It sounds like your transaction is correct in The Purchase Order record, have you checked inventory?
 
It is probably just the GL transactions that are wrong-- this happens to us too once in a while when there is some kind of record locking error.
 
You need to click on the "out of balance" report at the bottom of the GL-O screen to see which transactions are out of balance, and then use GL-P to edit the entries.  You can find them by doing a look-up for account and then the date to find the ones that need correcting.
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
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #19 - 07/07/08 at 08:21:58
 
I fixed the transaction through GL-P.  Thank you very much.  You are helping me learn EVO!  
 
Jamie
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #20 - 07/07/08 at 08:29:16
 
Glad to hear you got that fixed, Jamie.  
I get soooo much help from this forum-- it is a pleasure to give some back!    Cheesy
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
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #21 - 07/07/08 at 14:18:19
 
So, now I am trying to figure out why we have two WIP Variances.  We have an Asset WIP Variance and an Expense WIP Variance.  They are both tied to Work Orders via Sales Orders.  The Expense WIP Variance is strictly when we are closing the Work Orders.  Whereas, the Asset Variance, is closing Work Orders, Receipt from Work Orders, and Material Issues to WIP.  I researched this info through Detailed Trial Balance.  
 
What do you think?
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #22 - 07/07/08 at 15:52:35
 
I suspect your Asset WIP "Variance" is not a variance, but the actual materials and labor collected while the work is in process.  As you collect costs, they are debited to this WIP asset and when you finish production they go from the WIP asset to the Finished Goods Assets.  
 
If you close the work order when you finish it, all the costs for that work order are taken out of WIP (credited) and put in (debited) to whichever FG account you are using for that item.  
 
If you leave the work order open and collect more costs after you have finished it, those costs are expensed to the WIP variance  Expense account when you close it.  Or, if you finish production at standard cost instead of actual, the difference is posted here when you close the work order.
 
Double check your class codes for your manufactured parts and see if the account you are calling Asset WIP Variance is used as the WIP account.  If it is, I would rename that account to WIP or Work In Process, and take out the confusing "Variance".
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
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #23 - 07/08/08 at 08:40:03
 
And how would I check the class codes?
Back to top
 
 

Jamie
Email   IP Logged
cathyh
Active Member
*****


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

Posts: 1210
Gender: female
Re: Balance Sheet Imbalance
Reply #24 - 07/08/08 at 10:27:30
 
System Manager, SM-C, Enter Item Classes.  Click the <Item Class GL's> button at the bottom of the screen, highlight a class code that is used by a manufactured item, and click <enter>.  The class code GL accounts will be displayed (and can be edited here).  You want to look at WIP Inventory Asset.
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
ASIMedicalJR
Browser
*




Posts: 24
Re: Balance Sheet Imbalance
Reply #25 - 07/08/08 at 15:31:17
 
Okay, thanks.  Let me see what I can figure out through your instruction and I will get back to you with more questions I am sure.
Back to top
 
 

Jamie
Email   IP Logged
Pages: 1 
Send Topic Print