Link to home
Start Free TrialLog in
Avatar of ralphsauto
ralphsauto

asked on

Simply Accounting import Transactions

Does anyone know the format of the import function for Simply accounting 2004 basic.  It seems to be a XML format.

Please help asap
Avatar of Member_2_933725
Member_2_933725

The file you need to create is an .imp file, and the format varies according to the transaction type.

For example, this is a sales order file (which I found at
http://www.accountingsoftware411.com/AS411Msgbrds.nsf/msgBoards_vw/00619BC9CBFFA56D85256CB7005FE79F?OpenDocument ):

<Version>
"9001","1"
</Version>
<SalOrder>
"Lawn Maintenance Company", , , ,"Ontario", , , , ,
"1","2","1-1-2003", ,"3789.25","0.00"
"1000","1.0000","3295.0000","3295.00","GST","0","1","7.00","230.65","PST","0","0","8.00","263.60"
</SalOrder>

If you have access to the program, and can create the required transaction, *and* email it to yourself, then you can see the format from the file, and work out what the fields represent.

Regards
Mike
Hi: are you making any progress?
Mike
Avatar of ralphsauto

ASKER

I have already looked at this format at the site you mentioned before I posted this message.  There is something wrong with this as the person using it couldn't get it to work either.  The problem is what goes where, can you supply me with this information?

Thanks

John
Avatar of turn123
John,

Ugh this is one of the most unfrendly systems I've seen for importing info too.

Not much help but mabey gives an idea?
http://www.simplyaccounting.com/techsupport/kb/d_kbeditor.asp?xkbid=10252

Choose simply accounting (bottom Solution Set  choice) and type in import and you can see all 8 suggestions there.
http://www.simplyaccounting.com/techsupport/kb/kbsrch.asp 

If your withing the first 30 days of *any* purchase you might have a shot at their toll free phone support http://www.simplyaccounting.com/ce/support/default.asp

Their forum might have someone that has tried to do this before but it appears you need to sign up :-(.
http://www.simplyaccounting.com/_mem_bin/default.aspx?page=http://www.simplyaccounting.com/_mem_bin/CheckIfAuthenticated.aspx

According to this review the sales order import funcanality is limited.
http://www.accountingsoftwareanswers.com/asa/simply_full.htm

Doesn't look like fun at all.

What are you trying to do?  Did you check that all the information required by the import already exists in the database?

Turn123
Hello Turn123,

Thanks for your answers, They are a little late.  I have already found these pages and the one that helped teh most is the first one.  There are a couple of things that people need to know in order to import into Simply Accounting.

1.  You can only import directly into the General Journal, unless you have the email system setup (described above)
2.  The file imported must be CSV format
3.  The totals must balance exactly any discrepancy and you are toast.
4.  The format for the xml import is hidden in secrecy so you can't import into sales or expenses, just the General Journal which doesn't apply the information to any other module.

ACCPAC's Simply Accounting is a good tool if you are not using any external programs to create data.

If you can find/decifer the format for the xml import I am extremely interested.

ralphsauto,

I'm sorry I can't help more :-(.

It is usually a good idea to request that your question be PAQd and your points refunded as soon as you find your answer to prevent someone looking for the answer for you when you already have it as it is discouraging to look for an answer only to find that the asker has already found the answer and you wasted your time.  :-)

If you want to PAQ this question, post a zero-point question in https://www.experts-exchange.com/Community_Support/

Subject: Moderator Please PAQ
Body: Please PAQ this question:
https://www.experts-exchange.com/questions/21365139/Simply-Accounting-import-Transactions.html

~~~Turn123
Sorry Turn123,

This question was online for about 2 months and was hoping for a quicker answer than that.  I was also unaware I could do what you said, regarding the PAQ.  I am still looking for the format of the XML import though and that is what the original questions is about.

Ralphsauto
The main problem with this import is I was looking for a way to import directly into two modules Sales and Payables.  Simply Accounting simply does not do it unless you are using Simply to send an email and receive an email and it needs to have specific header information with a check digit.

The answer to an import using XML is that you can't.  It has to be a Text file with the following format and follows the CSV (comma separated values) format

for expenses:
Date, "short des (9 char)", "Long Decription (39 Characters)"
Account number, Amount
Bank Number, neg Amount

for Sales:
Date, "short des (9 char)", "Long Decription (39 Characters)"
Account number, neg Amount
Bank Number, Amount

The last thing that you need to know is that the file being imported can only be imported into the General Journal

I wish to apologize to the two people who tried to answer the question I posted.  I needed to have the answers right away, I didn't expect Simply Accounting to have such limitations for importing.  The program is almost useless if you want to create a web-interface for it.
Sorry one last point the Totals for the amounts need to balance, no exceptions.
ASKER CERTIFIED SOLUTION
Avatar of Netminder
Netminder

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial