I am producing Accounting Transactions Reports for a particular bank account. The account has an opening balance of £515.94. Sometimes the Report for each category includes the opening balance - for example, if the first entry in the category report is a credit of £10.00, the balance after that first line will be shown as £525.94 and the final Report total is inevitably £515.94 too high. Frustratingly, sometimes the Report comes out correctly, ignoring the opening balance on the bank account. I cannot see what I am doing right and wrong, to produce the correct and incorrect reports. Can you help, please?
David.
Reports - balance figure
-
- Site Admin
- Posts:78
- Joined:Sat Jun 18, 2005 12:18 am
If the opeing balance is 515.94 the final balance will be the sum of all credits and debits + 515.94 (This is correct)
If you do not see the opeing balance in the running balance figure it may be because you are viewing transactions for a given date range, you would then see the transactions within the date + the opeing balance.
If you do not see the opeing balance in the running balance figure it may be because you are viewing transactions for a given date range, you would then see the transactions within the date + the opeing balance.
Thank you for the response, although it doesn't really help me. To explain further, I have accounts set for each financial year: Accounts 2206-07, Accounts 2007-08, etc. I carry the bank balance forward from year to year and it is this balance that gets added to my report totals.
I have worked round the problem by temporarily changing the opening balance to zero before running the reports for a given year and then putting it back to the correct figure afterwards, but it is only a workaround. Could the program perhaps be changed in some way, to force a zero starting balance in accounting transaction reports?
David
I have worked round the problem by temporarily changing the opening balance to zero before running the reports for a given year and then putting it back to the correct figure afterwards, but it is only a workaround. Could the program perhaps be changed in some way, to force a zero starting balance in accounting transaction reports?
David
-
- Site Admin
- Posts:78
- Joined:Sat Jun 18, 2005 12:18 am