End of period account balances
Posted: Mon Mar 27, 2006 12:48 pm
Hi,
In GL Controller, is there a report or screen where I can look up the end of period closing balance for a particular GL account?
I have examined the raw data in the glaudXX and glmastXX tables which contain debit and credit figures for each month.
Is our accounts department skipping a particular end of month operation which calculates and records opening/closing balances for each account per period?
Our accounts manager explained that she keeps these balances in Excel format and then reconciles them against the figures in Capital.
I am looking for a way that I can automatically look up the balance (eg, stored in a table or calculated).
If there is a process that we have skipped, can we go back and run the process for all previous periods, or do we need to start a new company database with opening balances for all accounts, and then be sure to run the process from then on?
Thanks,
In GL Controller, is there a report or screen where I can look up the end of period closing balance for a particular GL account?
I have examined the raw data in the glaudXX and glmastXX tables which contain debit and credit figures for each month.
Is our accounts department skipping a particular end of month operation which calculates and records opening/closing balances for each account per period?
Our accounts manager explained that she keeps these balances in Excel format and then reconciles them against the figures in Capital.
I am looking for a way that I can automatically look up the balance (eg, stored in a table or calculated).
If there is a process that we have skipped, can we go back and run the process for all previous periods, or do we need to start a new company database with opening balances for all accounts, and then be sure to run the process from then on?
Thanks,