Sage 50 does have this functionality... sort of.  You can export a Transaction (General Journal) report as a CSV file, but the format is not exactly the same as the import format.

And it's possible to set other accounts, beside bank accounts, for reconciliation.   This may help if there's one entry in one company that is a summary charge for 10 items in the other, for instance.

The online help in Sage 50 Canadian has a section in the index under Importing 'files for Sage 50 Accounting'. and under 'General Journal Entries'.

This may also help, this is a sample of a few other types of import data:

Sample Import File
<Version>
"12001", "1"
</Version>
<customers>
"name", "0", "Contact", "street", "street2", "city", "prov", "postal", "country", "phone", "phone2", "fax", "[email protected]"
"name2", "0", "Contact", "street", "street2", "city", "prov", "postal", "country", "phone", "phone2", "fax", "[email protected]"
</customers>
<vendors>
"name", "0", "Contact", "street", "street2", "city", "prov", "postal", "country", "phone", "phone2", "fax", "[email protected]"
"name2", "0", "Contact", "street", "street2", "city", "prov", "postal", "country", "phone", "phone2", "fax", "[email protected]"
</vendors>
<PurQuote>
<! This is the vendor line "name"
"UNIVERSAL CONSTRUCTION"
<! This is an option line
<! "no. of details", "quote no.", "entry date", "ship date", "total amount", "disount rate",
<! "discount days", "net days", "freight amt", "tax information"
"1","203","3-15-2000", ,"69.98","2.00","30","60","10.00","GST","0","1","7.00","0.70"
<! This is a detail line
<! "item no.", "quantity", "price", "amt", "tax information"
"C1020","20.0000","2.6000","52.00","GST","0","1","7.00","3.64","PST Charged","0","0","7.00","3.64"
</PurQuote>
<SalInvoice>
"UNIVERSAL CONSTRUCTION", , ,"102-3701 East Hastings St.", ,"Vancouver","British Columbia","V5C2H6", , , , ,
"2", ,"","3-15-2001", "3", "VISA", "67.84","0.00"
"C1020","2.0000","4.7500","9.50","GST","0","1","7.00","0.67","PST","0","0","7.00","0.67"
"H1020","2.0000","25.0000","50.00","GST","0","1","7.00","3.50","PST","0","0","7.00","3.50"
</SalInvoice>
<Timeslip>
“Sianos, Janice”
“2”,”1242”,”3-15-2001”
“Customer5”,”C1020”,”02:00:00”
“Customer6”,”C1020”,”02:00:00”
</Timeslip>

Hi Randy,

Thank you for your answer. It would be really faster if I could organize the data in excel rather than in the text.file. Can the imported information be entered into excel spreadsheet? If not, then I think this method will not be faster than the method I did now. Now I entered the transaction by opening both company's file, and enter one transactions in one company first. Then I copy and paste all items from the one to another one. "Is there any faster way for me to enter the same transaction in both company (A) and (B)?"

I have done some research. It seems that Sage 50 US version could import the excel file as audit trail transactions. However, the Canada's version does not have these functions.

Thank you very much.

Yen

The US and Canadian versions of the program are completely different. Do not assume one has anything to do with the other.

Randy gave you the formats for most of the imports that can be done in Sage 50 Canadian. He had to give you that many because you did not indicate how you wished to import them (eg. purchase invoice vs. general journal entry). He gave you both, though Purchase invoice is the Purchase Quote format as well I believe (it's been a long time since I personally have looked at that one but I think you just change PurQuote to PurInvoice in both places).

Yes you can use a spreadsheet to format these entries but export as a text file to import into Sage 50. I generally use prn file format.

Hi Richard,

Could you please help me with how to use a spreadsheet to format these entries but export as a text file to import into sage 50? I have tried to save the file as (prn, txt, or csv), but all the text file are not like the format that Randy list above. I also tried to export the files from sage to see what the files looks like. All the words is quote by " ". When I export excel file to txt format, all the words are not quoted by " ". Could you please help me?

Basicly I would like to import the transactions to Purchase invoice and payment. Most of our transactions are entered in AP module. I only entered a few transaction through General Journal.

Thank you!

Yen

Two things to clarify:
Reworking entries to export from Excel is a fair bit of work, and sometimes not worth the trouble. But other times:

I recorded over 13,500 inventory adjustment / transfer lines on the weekend, using Excel and Access with Recurring Transactions, for instance. Most of the time was waiting for copy / paste, and playing Sage's special version of Space Invaders on a few hundred 'Line 389: Entry has no amount'. messages.  Excel is going to be the most efficient way if you have a LOT of entries.

It's often quicker to open two windows and use:

control-C, alt-tab, control-v, down, alt-tab, down a hundred times.

I use Excel to open and re-format the exported data, re-export it in a CSV, then use Notepad to add the 'Sage' stuff - the lines at the top with the version number, and the bracketed data type identifiers.

and the other thing:

The Canadian version does have some additional functionality that I didn't mention - it's possible to set up import / export items in a customer 's settings under 'Import / Export. You can then email an 'invoice' to the 'customer' (yourself) and rework the attached .IMP file in Notepad to be your purchase quote / invoice.

This is not something that I've done recently, so it might / might not be formatted correctly.  Again, the most efficient way, will depend on the sheer number of entries.

Excel can't be used to send data directly into the Sage 50 database, Microsoft has probably designed it that way so there could never be a question of Excel changing anyone's corporate data - it just can't do that.

One might be tempted to accuse Sage of making the data difficult to extract intentionally as a way of preventing moving to other products, but I believe that it's designed that way, to make fraud more difficult.   Imagine if an employee could quickly export a set of transactions from your system, fiddle with them, perhaps remove an entry or two, then pull the whole works back into another file?  

(we can import manually created entries from a special sub-set of the data, using the Accountants' Edition, but that's another story).

There's a free Sage 50 SDK available but it's more of a programmer's toolkit, and there is at least one vendor that I know of, selling a (not free) data import utility. (Swagman systems?)
 
btw, I'm no longer selling software and services, but still active on this forum, especially with the more 'interesting' problems.

I think at this point you should pursue the option Randy has suggested by recording the amount owing by the school to your employer's company as a sale, emailing it to yourself and importing it into the school's file as a purchase. There is no need to rework the file as far as I know. The original design is to allow a customer invoice to be emailed to a customer who can import it into their file as a vendor invoice.

I would try this first because it will not you any extra but your time for the testing. I would test on a copy of your data files so you get used to the setup before you try it on your live file.