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


Pages: 1 2 
Send Topic Print
Balance Sheet Imbalance (Read 2573 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
Pages: 1 2 
Send Topic Print