How to download balance accounts and transactions using Power Query?

Questions
, ,
1

Missing balance accounts and transactions in Navigation – how to extract full account data to Excel with one sheet per account?

I am trying to extract all balance accounts and their transactions from Fortnox into Excel using Invantive Control for Excel. My goal is to place each balance account (e.g. 1910, 1930, 2010, etc.) in a separate Excel sheet containing all related transactions, so I can reconcile each account individually.

When I search for accounts via Navigation in Invantive, I cannot find all the balance accounts I need. Some accounts are missing, and others do appear but show no transactions, even though they definitely contain postings in Fortnox.

I suspect the issue may be that I’m not retrieving data from the correct table or that the sync with Fortnox does not fully update all accounting data:

  • Used the TransactionLinesAll table and others related to general ledger data
  • Tried filtering specific accounts (like where Account = '1930').
  • Verified in Fortnox that transactions exist on these accounts.
  • Explored Navigation and searched manually – no success.
2

Financial transactions are typically to be found in tables with Voucher as a part of the name.