Creating a balance sheet for ES that shows my cash is showing way different numbers than what ES reports.
The formula I am using is
=GL_BAL("1005:1020","0:9",,-1,2007,"1:6",0,,1,1)
1005 to 1020 are my cash accounts, 0-9 are my cost units, 2007 is the financial year and 1:6 are the periods.
I'm getting around $73k when I should be getting over $1 million.
What is weird is all my other accounts seem to match up when I do an income statement. Any idea what I am doing wrong?
The formula I am using is
=GL_BAL("1005:1020","0:9",,-1,2007,"1:6",0,,1,1)
1005 to 1020 are my cash accounts, 0-9 are my cost units, 2007 is the financial year and 1:6 are the periods.
I'm getting around $73k when I should be getting over $1 million.
What is weird is all my other accounts seem to match up when I do an income statement. Any idea what I am doing wrong?