By using this website, you agree to our Terms of Use (click here)
Hello everyone,
I am trying to create a P&L report to include budgeted covers (stats 7,500) on the below report, however when I add the row on the Row Set, it pulls actual (7,437 covers) for both the budget column and the actual column. I tried to add a row to pull only budget (7,500) on the report (which seems to be working), however, I don’t understand why actuals are pulling across under budget column.
Does anyone have any suggestions to correct?
Thank you!
Hello Jennifer,
I ran into something similar several years back. This is because of the way the ARM Report writer functions and I personally think it makes the STAT accounts very challenging to use. Ultimately we ended up going back to using the Actual Ledger for Statistical postings and using an offset account to balance the entries.
The issue with this is that you are creating your budget using the Budget ledger, but recording your daily/monthly values to the STAT ledger, so when you are trying to compare your STAT postings against what you have budgeted for the month it doesn't work out very well. You can try hard coding in the GL code and Ledger reference in the Row set for the "Covers Stats", but I always ran into issues when attempting to create a clean and concise income statement for our clients.
Chip