importing general journal

[richodie]

I am trying to import from a csv file the data from people soft. The general journal keeps giving me a out of balance when I try to import the data. Any ideas, this is a clean install on peachtree complete 2002.

[dringstrom]

Do all of the lines of your import file net out to zero? An easy way to check is to open the file in Excel, then click on the worksheet frame for the column that contains the amounts. Excel will display the total at the bottom of the screen. If it's not zero, then your entry doesn't balance.

Conversely, if your journal entry balances in Excel, then you may have data problems in Peachtree.

David
www.accountingadvisors.com

[richodie]

Balance were the first thing I checked. It's like you have to import past years and post begining balance manually. This is what I going to do next. create a new company and change the first year to enter data.