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.

Link to post
  • 2 years later...

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
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.

  • General Statistics

    • Total Topics
      13,656
    • Total Posts
      68,264
    • Total Members
      57,144
    • Most Online
      5,137
      14/01/21 09:51

    Newest Member
    ichimaru8989
    Joined 17/01/21 22:50
  • Posts

    • I'll try to be concise: Dent was in 2010 calling for the mother of all stock market crashes - so were Elliott Wave International in fact EWI have been call for a massive collapse since 1986!  Some of what he says is accurate - deflation for example - the reason QE has not caused inflation is because it was issued in a deflationary cycle The crash he talks about won't happen - I listened to dent and EWI back in 2010 and I choose to do my own research as other things i was investigating suggested the opposite to what they were both spouting Read my Time Cycles page, it explains the deflationary/inflationary cycles - proven with 220+ years of stock market history behind the reasoning The deflationary cycle he refers to ended late 2016, its now inflationary according to my calcs and research and my prediction is stock market is going upwards until the mid 2030's when it will crash and top out - yet Dent still thinks its in play Up until then we might get a 1987 style crash event but overall the corrections will be modest not massive and they will all be quickly surpassed I don't listen to anyone out there - I trade independently according to my methods so I don't need to be buying and holding and if I'm wrong so be it - it won't affect my trading as the market dictates my positions, not my expectations - since 2010 this has work exceptionally well, where if I'd of followed EWI and Dents forecasts I'd of lost everything in 2010! I've no thoughts on Gold other than it is inflationary hedge - as mentioned on another thread when the stock market is inflationary (which I think started 2017) then price correlation backwards to last time it was inflationary (1982-2000) gold was subdued    
    • Thanks @Caseynotes. Do you think the time of the daily close bears any significance. When viewing the hourly charts, the volume and movements seem to be higher in GMT "working hours" and then slow down overnight. Therefore, are other countries trading on GMT I wonder?
    • Saw a snippet on Sky news complaining that the Lateral Flow test must be faulty because it wasn't picking up as many positives as the PCR. Quite an unbelievable misinterpretation of the data on the number of false positives made by the PCR. Not surprising really as the fake positive numbers generated by the PCR are the only thing driving project fear and lockdowns. Meanwhile, in order to stem the flow of staff needing to self isolate following a PCR false positive the NHS are switching to ...  er, the lateral flow test.         Dr Clare Craig  @ClareCraigPath Deaths are not climbing commensurate with cases. Either COVID got less deadly (despite inc hospital admissions) or we have two measure a) a community positive rate off the charts with false positives b) a hospital rate (likely to inc some real COVID) which is at a steady state     .
×
×
  • Create New...