LOVING IT! THANK YOU for saving me from the bloated horror of QuickBuck$…
On 25/7/2016 I used the (then) current version of Manager (can’t recall what it was, sorry…14.xx.xx, I think) to perform my first bank reconciliation.
As far as I am aware, all went OK. I have a printout of the “Bank Reconciliation Statement” from that time that tells me that I have no pending deposits or withdrawals.
I have updated to the now current Manager (16.10.34) and I have now tried to run a “Bank Reconciliation Statement” report but I can’t get past the screen shown in the attached screenshot.
You haven’t shown enough information to tell what your problem is. (Impossible to diagnose reconciliation glitches without being all the transaction amounts and running balances.) But I notice you have several transactions on 25 August, the end date of your reconciliation. I’ve had similar problems in that situation before. Try reconciling for the following day.
I tried reconciling for 26/8/2016. Same behaviour.
I suspected that diagnosis would require knowledge of everything…
I am happy to make the whole data file available out-of-band of this forum. Also happy to pay a small fee for the much appreciated assistance, should that be required.
I can get by without reconciling my bank but it is leaving me with an uneasy feeling.
That’s basically true. I definitely do not want to see your data file. I’m just a user like yourself. But I seriously doubt there is a bug, or hundreds would be complaining about that. And please don’t offer payment to anyone on the forum, as that goes against community rules. We help each other for free.
Having been through exactly what you’re describing several times, I can tell you this always turns out to be a trivial error as to dates of initial transaction or clearance. That’s something to check, by the way. Don’t just mark a transaction as cleared; enter the date as per the bank statement. Also, be sure you didn’t enter transactions manually and then import the bank statement, or you’ll have duplicates.
Another thought is to verify your starting balance. Did you really have an existing balance when you started using Manager? And were all those transactions already cleared? Or did you make a deposit in Manager, too?
Anyway, there really isn’t anything for it but to slog through the transactions Manager throws up at you. The good thing is that if those are the transactions it’s having trouble with, that’s where the error will be found. It’s not an infinite list.
My advice is adjust your cash register when you get your bank statements with bank charges etc . And then start BR entering balances as manager asks you.
I am trawling though the entries, as suggested. Sigh.
Question: If I have a sales invoice with an entry having tax = “GST 10%” do I also need to specify the tax column in the associated receipt? Currently I am assuming that I can leave it as “No tax”
You are correct. By specifying the tax as being applicable on the sales receipt, you added it to the account receivable for that customer. You also created a corresponding liability in Tax payable, which tells you how much you need to remit to the tax authority. Remember, you are collecting that tax as the government’s agent. When the customer pays you, they are settling the Accounts receivable amount. You settle the Tax payable amount when you make your periodic remission to the tax authority.
New cash account “Cash Account”, start balance at 1/10/2016 is $1000.00, maintained by bank
new Customer “Customer”
New tax code: “Australia - GST 10%”
New Sales Invoice to Customer on 5/10/2016 to account ‘Sales’ for 1 * $100 with tax “GST 10%”
Received cash in “Cash Account” 1 * $110 on 10/10/2016, cleared on 10/10/2016 from Payer “Customer” for account line “Accounts Receivable” for 'Customer" invoice #1; no tax assigned
invoice is marked “Paid in Full”
Run a bank reconciliation for 19/10/2016; account is not reconciled
process: to find discrepancy quicker closing balance for 10/10: $1100
process: to find discrepancy quicker closing balance for 1/10: $1000. shows me that my sole $110 receipt is at fault. The offending receipt is:
Can you post a shot of the Cash Accounts tab’s register? Then drill down on the cleared balance and show a shot of that.
Edited later:
I spent quite a bit of time reviewing the steps you described, to make sure I wasn’t reading something in that you hadn’t said. As far as I can tell, the invoicing and receipt parts were all done correctly. That takes me back to my initial reaction, that you must have some problem with the cash account entries. That’s why I asked for the Cash Accounts screen shots.
First, a question: under Preferences in the top menu bar, what date format do you have selected? All your posts suggest you are using DD/MM/YYYY. But if you have it set for MM/DD/YYYY, your reconciliation date would have been changed by Manager to a feasible, though probably nonsensical, date.
Second, a request: if the date format doesn’t solve the problem, the screen shot I asked for of the Cash Accounts tab register would be of the first screen that comes up after selecting the tab. It will look something like this, though some columns may be missing:
OK, speaking only of this test business X, if you Edit the Bank Reconciliation Statement and put in October 19, 2016 as the date and click Update, then click View, you should see:
Since you don’t actually have a statement for this fake account, enter 1,110.00. Click Update, because that is what a bank statement would show if you had an opening balance of $1,000 and received a single payment of $110. Post a screen shot of the result. By definition, you have no pending deposits or withdrawals, so if everything else you’ve shown remains as it was, you should be reconciled.
