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

Max Vitesse
Max Vitesse Member Posts: 1
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

Comments

  • Linda ABC
    Linda ABC Accredited Partner Posts: 1,131 Accredited Partner Accredited Partner
    edited June 2020
    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?