Incredibly basic import question

[blueprintblue]

I work with a volunteer organization and have to pull together eoy financial statements. We run on a cash basis, so throughout the year all I look at is cash transactions in the bank statements. For eoy, I need to generate some reports out of Peachtree (the accounting package that was handed off to me by the previous volunteer in this position).

I have downloaded all the bank transactions into a spreadsheet/csv file and added a column for the G/L account I'd like them to fall under. Would like to import the transactions into Peachtree.

I've read the help file, but can't seem to import the transactions. I have separated the cash receipts from the cash payments into two separate .csf files, each with 4 columns, and labled the columns with headings from Peachtree: Date Description Cash Amount G/L Account


When I go to import the cash receipts file, Peachtree says it can't open the file.

I know this is incredibly basic, but would be a tremendous help to me if I could import all the transactions.

Many thanks for any help.

 

[3gm]

When I've done this in the past, I've started by exporting an Excel file of the type of transactions I want so that I get a good layout for the column headings and know what to use for the necessary values for columns I don't care about. I believe that all columns must be present, but ... I'm not at my Peachtree computer to verify that.

Once you have a sample spreadsheet, you can delete the data rows and fill them in with your data. Save the spreadsheet and import it.

Glenn

 

[blueboyz]

You should be importing into the General Journal.
If you export the General Journal from the sample company you can open the file in Excel.
Columns you must have in order to import are:
Date
# of Distributions
G/L Account
Amount
Recur # (this would have 0 in each row)