Hi,
I get a trial balance report each month that shows me the current account balances year to date. For the balance sheet accounts this is fine but for the profit and loss accounts I need to wort out the movement since last months report. For example the Rent cost account for February shows a balance year to date of £2000. In March it shows £2000. I want a table that shows me the value for March of £1000. As mentioned if the account is a balance sheet one then it would just take the year to date balance not the difference.
Thanks
Bax
Hi Bax,
I guess there are a few ways you can approach this depending on the information you have in the reports, but the simplest might be to separate the P&L accounts and balance sheet accounts data into separate queries. Then merge the current month P&L accounts with the prior month and add a column to calculate the difference.
Then append the P&L movement values back together with the balance sheet account data from the current month.
Hope that points you in the right direction.
Mynda
