more clarification
I am actually in Canada and therefore not regulated by the SEC, we are also not a publicly traded company. I am not looking for information in regards to content, as I know what I want and need the end result to look like. What I am asking for is advice on how to get it there.
Specifically, I am curious if users have found, for example, it more effective to use database references such as the DGET formulas, or Pivot tables or some other way?
For those who may be able to help but do not understand how financial statement "work", here it is. I start with a database of trial balances for each month. A trial balance is a list of all accounts and the respective dollar amount (what I have found works best is one big database with account numbers/names in column A and then each month listed in subsequent columns with amounts listed below, then on a go ahead basis, each new month is just inserted) but this can be changed if something else works better. Then, in simple terms, an income statement and balance sheet are created by either retrieving amounts from trial balance, combining amounts, or recording the change in amounts from one period to the other.
Any suggestions?