I am trying to understand how figures on the Trial Balance report are derived (and I apologise, I am not an accountant).
We have an account of type 'Equity' called 'Dividends' - according to my Finance Manager this is meant to be the accumulated Profit for the company. He was told that we don't have to 'close down' each year in NetSuite (as he has in previous systems) and so he doesn't manually transfer the accumulated Profit from the closed year to the next.
This account shows with a value of over £2m in the Trial Balance report (which I assume is 'correct' as this is the figure the Finance Manager is expecting to see):
However, when I click on the figure to see the Account Detail, and set the dates right back to the earliest period available in NetSuite, I can only see a single Journal entry for £170k?
There are other similar accounts (set up as Equity etc) that show the same value in the Trial Balance and the Account Detail screens. How do I determine how this particular balance is being calculated?
My problem is I need to calculate this figure in a Saved Search (to use in a script) - and the only way I know how to generate these nominal balances is to search on all posting transactions on that account number. However, if this account doesn't have transactions posted to it that match the balance, how can I generate this figure in a search?