Bank reconciliatoin

[CoxSherlock]

Hi,

I have an issue with bank reconciliation screen showing as the bank as reconciled. However, the bank reconciliation report showing outstanding withdrawals & deposits that are NOT outstanding. Could someone please shed some light on this issue please.

Thanks,

Robyn

[LRBooks61]

Hi Robyn

The only thing I can think of is that these transactions may be doubled up.

Is this the case?

Are the dates and bank amounts correct?

A screenshot or a copy of the report would be helpful too

Lisa

[CoxSherlock]

Hi Lisa,

Thanks for your reply. I have attached a copy of the bank reconciliation.

The balance sheet shows a figure of $5,731.49.

In the banking reconciliation screen, both the closing statement balance & calculated closing balance show a figure of $2,506.16. Given the reconciliatoin report is showing $5,731.49, I would expect the bank reconciliation screen to also show this (which is doesn't).

I do not have a copy of the bank statemtent, however the transactions appear to be some sort of bank feed (there are no transactions to reconcile in the bank reconciliation screen).

Thanks, Robyn

[LRBooks61]

Hi Robyn

From the look of the report it would appear that the tranastions have not been reconciled at all.

A reconcilation report should show 

deposits cleared 

cheques cleared

uncleared deposits and uncleared  cheques

this report shows nothing cleared 

Go into the banking tab and select reconcile accounts

select your cheque account and the date for reconciling 31/12/2021 enter the closing balance amount

These transactions should appear 

Make sure you tick them all as reconciled then reconcile the account with the bottom right hand corner button if it all agrees

Hope that solces it for you

Lisa

[CoxSherlock]

Hi Lisa

That is the problem - all of the transactions listed in the reconciliation report are NOT appearing on the bank reconciliation screen. Hence my issue.

I've not come across this issue/gremlin before.

Thanks for your feedback.

I'm not sure where to go from here.

Kind regards,

Robyn

[LRBooks61]

Hi Robyn

What date is the cheque account reconciled to?

Do you know what the current balance of the cheque account is?

Do you use bank feeds or do you manually reconcile?

 Can you send me a screenshot of the reconcile accounts screen?

We can figure this out but need some bank balance info

Lisa

[CoxSherlock]

Hi Lisa,

I have attached a screen shot saved as a pdf of the reconcile account screen.

The bank statement balance should be $2,506.16. I believe but I do not have a copy of the bank statement. It was last reconciled 31 December 2021 - I believe this was the last reconciliation, but no 100% sure. In any case, the bank reconciliation report at 31 December 2021 should not list any transactions if there aren't any showing as outstanding at 31 December 2021.

The client uses bank feeds & undertakes the bank reconciliations (we merely extract info to prepare the BAS).

Thanks

[LRBooks61]

Well I am at a loss

Would you rerun your reconciliation report and just select the cheque account rather than all

The most telling thing from this report is that nothing has been reconciled but there are no records in the reconcile screen.

The only thing I can think of is that the reconciliation was done on a different day to the 31st.  probably after the 31st you could run your recon report on different dates to see but.........

I think that you might have to check with your client on this one

Sorry not really much help

Lisa

[CoxSherlock]

Hi Lisa

Thanks for trying.

I will go back to the client & see if the client can shed any light on actions taken in regards to the bank reconciliation - I just don't understand why the bank reconciliation screen is inconsistent with the bank reconciliation report.

Kind regards,

Robyn

[SupportNoteGuy]

Hi @CoxSherlock - sorry for the late reply - did you find out anything that might shed some light on this?