imported bank file messing my account balance up. how to get rid of?

[joulian]

Derek Atkins-3 wrote
> 
> Hi,
> 
> On Thu, December 15, 2011 12:14 pm, joulian wrote:
> 
>> Ok I have downloaded an OFX file for import purposes for the entire year
>> to
>> get GNU cash going.
> 
> From where did you get this OFX file?  From your Bank?
> 
> I downloaded from banks' site.
> 
>> Whats happening is I have all my categories completed. For example Fuel
>> in
>> the Expense:auto fuel etc..etc..etc..
> 
> So during your import you took the time to assign each transaction to the
> appropriate income/expense account?
> 
> After importing I had two tabs up: Accounts ( first ),  Bank statement for
> 2011 ( second ) 
> The 2nd looks like a general double entry ledger book ( green and white
> columns ). In the transfer row, I would change each from imbalance-USD (
> this is i guess how GNU Cash labeled it ) to say Auto gas, or food, or
> what ever it needed to be. If that change fell under say expenses ( i am
> looking for example at Expense utilities internet ) it would be under
> Expense/ NOT rebate.  BTW Rebate is a debit correct ?,  Then the Balance
> row would be summing up the months as I go.
> 
> As I am looking at this shouldn't all expenses be in red with parenthesis?
> 
>> now that I have all things put in their place. When I generate a Balance
>> statement the bank file and its totals are doubling the amount for my
>> current assets. FOR EXAMPLE: if current assets is 50k then the account
>> category BANK FILE FOR 2011 is also 50k under current assets which makes
>> it
>> a total of 100k. Which is false.
> 
> There is no report "Balance Statement".  There is a Balance Sheet, or
> Income Statement.  Which exact report are you using?  And how are you
> configuring the report?
> 
> I am going to Reports/A&L/ BS ( You are correct, its sheet, sorry for
> confusion ) 
> 
> Your doubling could be due to an incorrect import, backwards accounts,
> backwards transactions, or just not understanding what the report is
> telling you.  We need more information to determine which.  For example, I
> have no idea what you mean by "Current Assets is 50k then the account
> category BANK FILE FOR 2011 is also 50k ... total of 100k"?
> 
> Maybe you used your "Current Assets" placeholder account instead of
> Equity?  Or maybe you're summing up a placeholder and a child manually
> when it's already being summed internally?
> 
> Yes the Bank statement is a placeholder, its getting summed along with
> expenses for example, i don't know where to put. Thats the problem. OR if
> I have everything cataloged accordingly do i just delete it. Will that
> delete everything else?
> 
> Thanks for the help its been some yrs since i took ACC. in college and
> clearly i don't remember as much as I thought.
> 
> Maybe some screen shots of what you are seeing will help us?
> 
>> How do i get the bank statement account not to be included?
> 
> What is a "Bank Statement Account"?  Do you mean your regular Bank
> Account?  How did you set up your Chart of Accounts on the Assets branch
> of the account tree?
> 
>> I hope thats clear?
> 
> See above for clarifying questions
> 
>> Please remember to CC this list on all your replies.
>> You can do this by using Reply-To-List or Reply-All.
> 
> -derek
> 
> -- 
>        Derek Atkins                 617-623-3745
>        derek@             www.ihtfp.com
>        Computer and Internet Security Consultant
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user@
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 


-----
Wealth is a responsibility, not a privilege- Carlos Slim
--
View this message in context: http://gnucash.1415818.n4.nabble.com/imported-bank-file-messing-my-account-balance-up-how-to-get-rid-of-tp4200826p4202966.html
Sent from the GnuCash - User mailing list archive at Nabble.com.