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 comment
  • 2 years later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • General Statistics

    • Total Topics
      20,067
    • Total Posts
      88,118
    • Total Members
      69,064
    • Most Online
      7,522
      10/06/21 10:53

    Newest Member
    Cueball
    Joined 02/10/22 20:33
  • Posts

    • Commodity Futures Market Summary: Elliott Wave Trading Strategies; US Gov Bonds 10 Yr Yields, US Dollar Index DXY, US Spot Gold, GDX, Silver, Copper, XLE Energy ETF, Crude Oil and Natural Gas Market Summary: The USD is expected higher in the trading sessions ahead, which in turn places pressure on any of the commodities that have been rallying over the last few sessions. I also take a look at most of the US Sector ETFs which are under a lot of bearish pressure, basically in line with the SP500 TRIAL Buy 1 Month Get 3 Months Video Chapters 00:00 US Sector ETFs 09:40 US Gov Bonds 10 Yr Yields 12:16 US Dollar Index DXY  17:40 GDX ETF /  US Spot Gold 20:02 US Spot Silver 23:19 US Copper / Lithium / Uranium / Nickel 29:36 Crude Oil. Sector XLE / XOM 32:53 Natural Gas 35:35 Thanks for supporting! Analyst Peter Mathers TradingLounge™ Australian Financial Services Licence - AFSL 317817 Source: tradinglounge com    
    • SP500 US Stock Bear Market: AMZN, AAPL, NVDA, TSLA, GOOGL, BRK.B, SQ, META, NFLX, ENPH, MSFT, BAC, JPM, GS. Elliott Wave Technical Analysis  Stock Market News: OPEC to consider oil cut of over than 1 million barrels per day Stock Market Summary Elliott Wave Count: Elliott Wave Analysis - (iii) of v) of 3 of (1) Analysis US Stocks: Tesla TSLA, Amazon AMZN, Nvidia (NVDA), Apple AAPL, Microsoft MSFT, Berkshire Hathaway (BRK/B),Block, Inc (SQ), Meta Platforms, Netflix (NFLX), Enphase (ENPH), Alphabet GOOGL. XFL Finance Sector ETF, JPMorgan JPM & Bank of America BAC, Goldman Sachs Group Inc (GS) Stock Market Trading strategies: Monday should follow Friday lower in the bearish weekly cycle. Holding short until Wave 3 for most stocks Video Chapters 00:00 SP500 02:11 Apple (AAPL) 03:18 NVIDIA (NVDA) 03:34 Amazon (AMZN) 05:00 Meta Platforms (META) 05:58 Netflix (NFLX)  07:23 Enphase (ENPH) 09:17 Tesla (TSLA) 10:20 Alphabet (GOOGL)  12:08 Microsoft (MSFT) 13:07 Berkshire Hathaway (BRK.B) 14:48 Block Inc. (SQ)  15:55 Banks JPM, GS 20:19 End. Thanks for supporting! Analyst Peter Mathers TradingLounge™ Australian Financial Services Licence - AFSL 317817 Source: tradinglounge com    
    • Dow daily Nothing new on the eastern front But maybe a bounce?        
×
×
  • Create New...