My Financial Chart Is Adding Incorrectly

Our financial reporting in Infusion seems to be producing the incorrect information.  When we drill in to each of the General Ledger Codes they are correct but the don't reflect in the Profit and Loss.

Solution

The Infusion Financials are calculated depending on how Financial Chart is set up.

The chart is customisable, as to where each ID adds to, and if it is not displaying in the P&L as you expect, then it is not set up correctly. 

The first point would be to check General Ledger integrity.  (Financials / Utilities / Check GL integrity). This will report on any transactions that don’t have a General Ledger account to go to, and also any GL's that are adding in the wrong place. See G/L Chart Check Exceptions Explained to correct as necessary.

Secondly, run the Profit and Loss report and ensure that the G/L's add to the subtotals, if not you may have a non-printing General Ledger code or a code out of order, or a code with an incorrect subtotal account, or a General Ledger account in the wrong place in the Financial Chart.  

Using the example below we can see the Utility Expenses total $300, but there is clearly total expenses of $517.39 in the Electricity and Gas Codes:

Then in Marketing Expenses, there are no codes providing a total of $217.39

When we look at the chart, we can see that the Gas GL ID is a Sub Account of Marketing Expenses instead of Utility Expenses so is adding to the wrong totalling account.