Jump to content

Compatibility with Xero accounting software

Recommended Posts

Hi,

 

I'm trying to sync up my IG Markets activity with my books and there are two main challenges I'm facing:

  1. The GST on Commission is split from the Commission line item effectively making 2 line items for the one charge in the transactions history export (csv). So when importing the .csv I can't properly assign a tax type to the expense. The ideal solution will be to export the transaction history with the commission inclusive of tax. For other tax regions, you could probably add a column indicating what type of tax is calculated into the fee. It will then be up to the user to report on tax they incur in their expenses.
  2. The USD transactions are combined with the main currency (AUD) in the one file export. When importing to an accounting system, an account can only be one currency. A simple filter when going through the exporting function can deal with this issue and avoid manual manipulation of the exported csv file.

Those two items above I think are all that's needed to spruik "Xero" compatibility because when the exported file is prepared as such, Xero's Statement Importing function has easy-to-use column mapping features.

Share this post


Link to post

Join the conversation

You are posting as a guest. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
You are posting as a guest. If you have an account, please sign in.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×