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.
