Deriving cash positions


I have been trying to make a report in PBI showing the balance sheet. If i understand the ‘vouchers’ data, it is the transactions and not the balance on a given date, how do i succeed with creating the balance sheet given this structure?

It seems like it does not work to take all transactions from company inception to the date of interest in seeing the balance - this would otherwise makes since if it contains all historic bookings on the account. But when i do this a get negative cash balances, so it does not seem to be a correct approach.


Hey @Gustav!

I am happy to hear from you again. :grinning:

For your convenience, we have prepared a data model for balance sheet. You reach the outcome from that in table fortnox_report.balance_sheet.

Important! Make sure to always filter on a specific month for which you want the balance values from. You can read more below.

Fantastic, thanks a lot!

1 Like