Import Canadian Bank file

We are a Canadian company that just converted to peachtree 2006. I want to use the import bank transactions for bank account reconciliation purposes
but it will not import because the transactions are in canadian currency. It seems the import program goes through the entire file and check each entry but imports none of them.
Anyone know how to fix this?
Thanks
--
to send email simply remove the pants

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Hi Gord!
I think you could edit the import file in Excel or Word or both to make it work. Just export first a file in order to know how the import fields should look like. I always have to do this when I have to import GL data from one customer to another.
It is not really difficult and saves a lot of time.
Since you are Canadian, please can you tell me how you set up your tax fields for VAT? I'd like to know. Peachtree help etc. contains no word about VAT.
Love and thanks
Martin
Gord wrote:

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload
Ok - This is absolutely No thanks to peachtree support - once I changed my windows settings (control panel/regional settings) to English (United States) it worked like a charm. I of course switched right back afterward to English (Canada) because Americans have a screwy short date formula.

--
to send email simply remove the pants

Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

BeanSmart.com is a site by and for consumers of financial services and advice. We are not affiliated with any of the banks, financial services or software manufacturers discussed here. All logos and trade names are the property of their respective owners.

Tax and financial advice you come across on this site is freely given by your peers and professionals on their own time and out of the kindness of their hearts. We can guarantee neither accuracy of such advice nor its applicability for your situation. Simply put, you are fully responsible for the results of using information from this site in real life situations.