P&L Summary versus Columnar Reports don't match, Totals are different

Max Vitesse
Member Posts: 1 Novice Member

I'm using Reckon Accounts Premier Edition 2018, although I recall we've seen this bug in previous versions too.
The problem is that the totals on supposedly matching financial reports don't match. Obviously this is a real problem, as the whole point of an accounting system is to give reliable accounts :-(
Specifically, when I run a P&L and filter down to just Sales and COS accounts to show Gross Profit, I get a certain set of balances and report totals, for a given period.
If I them modify that same report, and add columns for Class (we use this to show Department), then I get columns for each Class/Department, plus a "No Dept" column, plus a Total Column.
The amount/s in the Total column on the detailed/columnar/departmental report is different than in the summary report, without the "Column per Class" added. This is just soooooooo wrong, it's a show-stopper.
Obviously there is some sort of extra transaction filtering going on when the Class columns are added, but logic suggests all transactions should be included and just sorted according to which Class they are in (or the "None" column).
Any ideas?
Thanks, Max
The problem is that the totals on supposedly matching financial reports don't match. Obviously this is a real problem, as the whole point of an accounting system is to give reliable accounts :-(
Specifically, when I run a P&L and filter down to just Sales and COS accounts to show Gross Profit, I get a certain set of balances and report totals, for a given period.
If I them modify that same report, and add columns for Class (we use this to show Department), then I get columns for each Class/Department, plus a "No Dept" column, plus a Total Column.
The amount/s in the Total column on the detailed/columnar/departmental report is different than in the summary report, without the "Column per Class" added. This is just soooooooo wrong, it's a show-stopper.
Obviously there is some sort of extra transaction filtering going on when the Class columns are added, but logic suggests all transactions should be included and just sorted according to which Class they are in (or the "None" column).
Any ideas?
Thanks, Max
0
Comments
-
Hi Max - can you describe how you filter for Sales & COGS? Are you selecting specific accounts - or are you using the filter option - All Ordinary Income/cogs?
0
This discussion has been closed.