A weird error popped up today - or this is at least the first I noticed it.
The Cash at bank figure on the Summary page is out by $350. When drilling down from the Summary screen, into Cash at bank, it displays the same incorrect figure. I am running the desktop version of Manager updated to version 20.7.54 but it made on difference.
This is the correct figure. Bank accounts are reconciled to last statement and figure in the Bank Accounts section agrees with the current balance as of the date of entry.
Does anyone have any idea what caused this discrepancy and how can it be fixed?
My bad wording. The account where the discrepancy appears from drilling down from the “Cash at bank” value in the Summary screen was the second bank account created for the business. The first account has been closed and has zero value.
This isn’t the cause of the problem because I deleted that transaction and the difference between the bank figure remained accessed through the Summary/Cash at bank link and the Cash Accounts menu item remains.
Entering a date, e.g. for the period 1 June 2020 to 30 June 2020 does not resolve the issue.
The Start Date in the Starting Balances is earlier than any of the transactions. All of the starting balances are 0.00. Deleting the Start Date makes no difference.
Are you saying that deleting this transaction reduces both balances by 350 so that the difference remains?
In that case you will have to try an see where the difference come from.
I see that you have 1,728 receipts and payments but it if you examine the balance for the period half way from the first transaction and the last you will be able to say that the difference arises either before or after the mid-point.
Continue like this with whichever period has the difference until you have isolated the transaction which is missing. Even with 1,728 transactions it should be easy enough to narrow it down to a range of transactions
I am a bit intrigued by the description on the transaction - it is a receipt but the description says “Bank transfer to main acct” and yet it is a receipt from outside the business so not a transfer of funds within the business
@scpantry, when did you close the old bank account? And was there an inter account transfer of $350 at some point? Did you have trouble with the final reconciliation of the old bank account?
No. The discrepancy remains with or without that transaction.
Excellent tip.
It seems to have been from payments for two really old sales invoices made about 2 weeks apart where the payments were not marked as “Accounts are tax inclusive”. I adjusted the figures to be GST inclusive and checked the box and all was fixed. Issue resolved.
Gold star award to Joe91 even though I am still puzzled how this happened and find it hard to believe that I could not have noticed this since September 2018 which is when those payments were received.
Making the changes does not seem to have altered anything other than correct the “Cash at bank” figure.
The amount of the transaction was just a coincidence. The problem was caused by two payments of $2000 plus GST and $1500 plus GST not having their GST inclusive amounts included. I don’t know how this happened but altering the amounts to be GST inclusive and checking the tax included box fixed the issue.
As for the “Bank transfer to main acct” notation - I transferred money between two current accounts and these transactions are imported when I export the transactions from my bank account to Manager. It is not an internal transfer but an actual transfer that occurs outside Manager.
