Using Many to Many for Financial Reporting

1) For multiple Reports and Report Variations As discussed in a previous blog article, simple Profit and Loss may assume a single reportinghierarchy rolling up account numbers into a reporting line and heading.As this starts to break down we may have a Many to Many mapping between Account Codes and Reporting Lines. Like below, and … Continue reading Using Many to Many for Financial Reporting

Why Chart of Accounts doesn’t work for Financial Reporting

For financial reporting, can we use the Chart of Accounts as a hierarchy for all our reporting needs ? The short answer is: In the ideal world - Yes. In the not ideal world – No. The Chart of Accounts provides us with a way to categorise Account Codes (aka GL Codes) into an account name and … Continue reading Why Chart of Accounts doesn’t work for Financial Reporting