I'm trying to import general journal transactions but I'm not having too much luck.
Here's what is in the csv file:
date,reference,date cleared,number dist,g/l account,description,amount,job id,reimburseable,transaction period,transaction num,consolidated tran 2/24/2007,,,2,40000-AV,Sales - Aviary,-201.5,,,,, 2/24/2007,,,2,40000-BK,Sales - Books,-438,,,,, 2/24/2007,,,2,40000-CE,Sales - Ceramics,-529.33,,,,, 2/24/2007,,,2,40000-DS,Sales - Design Services,-3228.32,,,,, 2/24/2007,,,2,10000-00,Petty Cash,1575.65,,,,, 2/24/2007,,,2,10100-00,Cash on Hand,165.72,,,,, 2/24/2007,,,2,10200-00,Regular Checking Account,222.07,,,,, 2/24/2007,,,2,10300-00,Payroll Checking Account,2004.56,,,,, 2/24/2007,,,2,10400-00,Savings Account,429.15,,,,,
Everytime I import the above transactions it says it's out of balance (I'm trying to import this into the sample company and I checked the box saying there's a header row).
Can anybody please provide me with a sample file that has multiple rows of records? What is the field Number of distributions in this file? How does that field work? I don't have an accounting background. We are just trying to import data from our application into Peachtree.
Thanks in advance for any help!