×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Incredibly basic import question

Incredibly basic import question

Incredibly basic import question

(OP)
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.

RE: Incredibly basic import question

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

RE: Incredibly basic import question

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)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close