- Local time
- Today, 19:08
- Joined
- Sep 12, 2006
- Messages
- 15,980
i am not able to post this.
its just that you dont build reports by thinking about them as a line at a time - you have to think about selecting all the rows that make up your profit statement together
(ie a NL consists of P&L accounts, and BS accounts) so for a P&L account ignore the balance sheet accounts.
now to get the accounts sorted in a particular order for presentation, you need to be able to sort and group them in some way - this can be done either be examining the NL account number code, or by using some subgroup settings
eg
all accounts starting with a 1 may be sales
all accounts starting with a 2 may be cost of sales
all accounts starting with a 3 may be expenses
etc
so the total of all the accounts beginning with 3 is your total expenses
within the code, the third and forth characters perhaps may determine the production department
and the fifth and sixth characters may determin a cost category, etc
So you can summarise each department by grouping on characters 3-4. And obviously for each department you can get an expenses summary by subtotalling the expenses usings characters 5-6. But, if you have several departments, then instead you can get the total expenses, analysed by department, if you sort your accounts first by characters 5,6 and THEN by characters 3.4
instead of this (or as well as this!) you may have different or further lookups, not forming part of the account number, that identify certain accounts as sales, other accounts as expenses, which can then be further divided into rent/salaries/statinoery/motor expenses etc etc
-----
all substantial businesses would most likely have a highly structured account code of up to 12 or more characters perhaps that contains appropriate grouping information of this sort
so with such a structure you can get access to automatically give you subtotals on each grouping of characters at whatever level(s) you need - which is what you need to get a summarised P&L account.
if your PL accounts have no structure then its far far harder - and you are probably better exporting the list of balances to excel and rearranging it in excel
its just that you dont build reports by thinking about them as a line at a time - you have to think about selecting all the rows that make up your profit statement together
(ie a NL consists of P&L accounts, and BS accounts) so for a P&L account ignore the balance sheet accounts.
now to get the accounts sorted in a particular order for presentation, you need to be able to sort and group them in some way - this can be done either be examining the NL account number code, or by using some subgroup settings
eg
all accounts starting with a 1 may be sales
all accounts starting with a 2 may be cost of sales
all accounts starting with a 3 may be expenses
etc
so the total of all the accounts beginning with 3 is your total expenses
within the code, the third and forth characters perhaps may determine the production department
and the fifth and sixth characters may determin a cost category, etc
So you can summarise each department by grouping on characters 3-4. And obviously for each department you can get an expenses summary by subtotalling the expenses usings characters 5-6. But, if you have several departments, then instead you can get the total expenses, analysed by department, if you sort your accounts first by characters 5,6 and THEN by characters 3.4
instead of this (or as well as this!) you may have different or further lookups, not forming part of the account number, that identify certain accounts as sales, other accounts as expenses, which can then be further divided into rent/salaries/statinoery/motor expenses etc etc
-----
all substantial businesses would most likely have a highly structured account code of up to 12 or more characters perhaps that contains appropriate grouping information of this sort
so with such a structure you can get access to automatically give you subtotals on each grouping of characters at whatever level(s) you need - which is what you need to get a summarised P&L account.
if your PL accounts have no structure then its far far harder - and you are probably better exporting the list of balances to excel and rearranging it in excel
Last edited:
