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!

*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

Importing trial balances

Importing trial balances

Importing trial balances

Before I begin I'm not an accountant but the IT guy for the company.

Now my question, we just started using peach tree and the accountant wants to import last years ending balance then import each of this years period ends and adjustments to the GL accounts. So what I take he wants to do is import all of the credits and debits per GL account for each period end so that we will be able to pull the finacial statements. Does any one know how to do this? I've tried to import the data into the General journal but with out any luck.


RE: Importing trial balances

Importing/exporting is supported by PT, but there is a lot to keep track of to do it right and not screw something up.  You can start with the help in PT for import/export.  There are several pages explaining it.  There is an order which things must be done in.  I wonder too if you might want to look at the help for "rebuilding a company."  In import/export, there are a lot of things you can export, and basically it makes a CSV file.  When you import, you need to know what was exported so you can import correctly.  If doing the journals, you have to have the COA and vendors and such set up properly to make sure it all matches on the way in.
There are people that consult on this issue.  

RE: Importing trial balances

I've got the format for the file down for importing the general journal, What he wants to do and what I'm looking helo for is start with the beginning balance of period one then import each period afterwards so that he can have a running balance in the chart of accounts. I can import the beginning Chart of accounts but PT support says that after that I have to do the General juronal. Any idea on how to import 10 periods into peach tree with out manually entering the Data. Also the current system we are using does not export data to a CSV file.

RE: Importing trial balances

Step 1) Get all this data into spreadsheets that the accountant can approve.  Then save them as CSV files.  NO HEADINGS.

Step 2) Make sure the chart or accounts is 100% right.

Step 3) Sounds like summary data may be ok.  Check with the accountant.  If all that is wanted is month end totals your job is much easier.

Step 4) Import the chart of accounts.

Step 5) Import the data.

One important point is that the field order has to be exactly right.  

Don't wory about vendor or customer lists. They'll be similar problems and handling, but later.

Nobody has ever been willing to pay to bring in detail so never tried that.

Bill Couture

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