merging data...

[reksrags]

I am using PT Complete 2004 (upgrading to Premium soon)

Over the years, I've used PT (various versions) and our chart of accounts has been evolving to suit our needs. I do maintain backups for all my previous years. Now the issue at hand!

We closed year 2003 in Dec 04 before starting 05 transactions. Now, for three months thru march we've added a lot of data (mostly time-tickets for 15employees and invoices and payroll linked directly to time-tickets). Mid March 05 - due to various reasons - we had to overhaul our chart of accounts going back to 2003.

Retrieved the backup file (before closing 2003 - Dec 04 file) and redid the chart of accounts and made sure everything is ok as of Dec 04. Closed Year 2003 again. Now, my questions are:

(We run bi-weekly pay - so there are approx. 15 x 7 x 2 = 210 weeks of data (over 1000 time tickets - @1 per day) and I hate to input them manually again. Then, I need to worry about running the payroll for 100 times (15 emps x 7 pay periods) and make sure the reimbursements etc. are ok)

1) Is it possible to somehow export the data (mainly time tickets and payroll) from Jan - Mar 05 and import into this newly designed company.

2) If I export the time tickets/payroll data, do I need to change any fields so there is no conflict with the existing data before I import it into new company.

3) Any other journals, etc. I need to export/import?

Thank you so much in advance.
RR

[M GO BLUE]

Honestly, I think you should hire someone to help with this. Yes you can export time tickets and import them into the new company. Because you changed the chart of accounts, I think thats all you want to do. Of course you'll have to rerun the payroll, and you'll have to mark the tickets not used in payroll. This can be done once you have exported using excel.

[reksrags]

Thank you for your reply M GO BLUE!

For those who might want to try in the future - here's what I did and it worked.

1) Time tickets: Export from 03-04 file (dec month only) and 05 file (dec 04 - mar 05). Compare the .csv output for dec (they should be same) - but, due to some changes we did the ticket numbers were different. So, I renumbered all the tickets in 05 file starting with the ending number of 03-04 file. Also, changed one of the fields to FALSE (which means they are not used in the payroll). Then, imported into 05 file - done! Not an error!

2) Payroll: I ran it manually!!!

3) Accounts Payable (POs, Purchase jrnl, Payments jrnl in that order) and Journal entries: Did similar file comparisons like Time Tickets, updated each individual G/L account number in the .csv file and imported into 05 file - done!

That accomplished about everything in a fraction of the time that I would've taken to re do the whole job!

Good luck to everyone who might want to give it a try! Thanks again...
RR.