If my assumption about what you are doing is correct, then the short answer is that you don't. There is no way to move transactions from one company file to another without a massive investment in data repair services. You have to re-enter them individually or post monthly changes and keep your old file for backup (I would do this anyway).

There is a method to export JE then manipulate the JE in excel then import them into the new company

GwG,

The OP didn't specify a lot of information, so my answer made the basic assumption she wished to import the entries into the actual modules because she mentioned payroll specifically. I could be wrong.

Are you saying there is a method to import payroll to the payroll module for each employee or are you only referring to the G/J entry import?

My intention was to export JE,Payroll transactions etc. to excel from company A and then import them to Company B. It's the same company just different fiscal year. I managed to export and import Account, Vendors, Customers and Employees just fine. I tried to use the same format for transactions but it didn't work. Do you have a step by step way of doing this. Thanks

GraceV: it sounds to me that all you are trying to do is create a new data file for each fiscal year. If this is correct, i would not go through the process you are doing as it is a lot of work and you will not be able to copy all transactions into each module. I would just do a "save As" and save a copy of the data under a new name in a new location. You will then have a complete copy of the data in two places. However, you are also indicating that you wish to move the data from Company A to Company B. If you are creating a new company but using the same chart of accounts, employees, vendors and customers then export and import is all that is required. The transactions should not be copied into a new copy as they belong specifically in the old company. A little more detail of what you are trying to accomplish would make the responses more specific.

Thanks for your reply. I was not specific in the original post of my intent. I started with the wrong fiscal year and began posting transactions. Yes...I made a error. As you cannot change the fiscal year in Sage 50, I thought I could start over and just export/import through excel all the work I've done. The program implies that this is possible but it has come to my understanding that it is impossible. Go to File, then Import/Export, then Import Transactions. At this point it gives you 2 options...1) Import general journal entries and 2) Import purchase invoices, sales invoices etc... Is this function operational?

Just the journal entries. Payroll YTD enter is the usual way. Although you are right if she wanted to move the payroll transactions could be possible but expensive

GraceV said:

2) Import purchase invoices, sales invoices etc... Is this function operational?

Yes, importing other transactions does work, but it's intended for allowing Sage 50 to be the Accounts Receivable / Accounts Payable system behind an invoicing or Point of Sale program. 

With only the Journal Entry part of the transactions exported with full detail, you could still:

 - set up just the Chart of Accounts and opening G/L ledger balances, then

 - import all the G/L transactions, then

 - add opening A/R, A/P, Inventory, and Payroll balances when setting up the other Ledgers.

Your books would be complete, but none of the payroll, A/P, or A/R transaction detail from before would be in those books, if you needed to look it up you would have to open the 'old' company file.

*********************************************************************

Another way that I've handled wrong year end setup is to get the ending period correctly set, and carry on from there.   i.e. if the year end should have been July 31 and it was set as April 30, then when you open the new May-April year, set the fiscal year to be May 1 to July 31.   It'll be a bit messy and some extra work for a while, but it will be sorted out by the end of the following year. 

You can be fairly sure that your Accountant or Sage Partner will be able to work with the actual fiscal year set up as parts of two different years, but you should ask them if that will add cost to your company's year end Review or Audit. 

*************************************************************************

And yet another way, is to start out with importing the ledgers, then run a Journal Entry report, and record each entry in the new file in the same order.  This is a LOT of work, about as much as starting with all the paper in your inbox.   The advantage is that you can run reports on each system and compare, to make sure you have all the entries.  

This method is easier to keep track of if using two monitors, one for each Company File (or two computers, for that matter), but it is definitely NOT easy.

GraceV said:

2) Import purchase invoices, sales invoices etc... Is this function operational?

Yes, importing other transactions does work, but it's intended for allowing Sage 50 to be the Accounts Receivable / Accounts Payable system behind an invoicing or Point of Sale program. 

With only the Journal Entry part of the transactions exported with full detail, you could still:

 - set up just the Chart of Accounts and opening G/L ledger balances, then

 - import all the G/L transactions, then

 - add opening A/R, A/P, Inventory, and Payroll balances when setting up the other Ledgers.

Your books would be complete, but none of the payroll, A/P, or A/R transaction detail from before would be in those books, if you needed to look it up you would have to open the 'old' company file.

*********************************************************************

Another way that I've handled wrong year end setup is to get the ending period correctly set, and carry on from there.   i.e. if the year end should have been July 31 and it was set as April 30, then when you open the new May-April year, set the fiscal year to be May 1 to July 31.   It'll be a bit messy and some extra work for a while, but it will be sorted out by the end of the following year. 

You can be fairly sure that your Accountant or Sage Partner will be able to work with the actual fiscal year set up as parts of two different years, but you should ask them if that will add cost to your company's year end Review or Audit. 

*************************************************************************

And yet another way, is to start out with importing the ledgers, then run a Journal Entry report, and record each entry in the new file in the same order.  This is a LOT of work, about as much as starting with all the paper in your inbox.   The advantage is that you can run reports on each system and compare, to make sure you have all the entries.  

This method is easier to keep track of if using two monitors, one for each Company File (or two computers, for that matter), but it is definitely NOT easy.

This is very helpful. Thank You Randy