Error in Sage Reconciliation Function...

[jonespr1]

Hi

We have used Sage for many years, but not fully and have only started using the reconciliation function in 2014.

We're getting to grips with it and other than the odd transaction, on the whole everything is matching.

We noticed for March there was a spurious presentation of a couple of transactions in the bank reconciliation screen, but as they totalled the correct amount we ignored and put down to a glitch.

However, we have now seen this again in April and are concerned, we have a UPS connected so can't see any logical reason for it and a data check shows no errors.

---
Transaction 87689 is for £58.97 and is paid in supplier screens, but in banking reconciliation screen is not showing.
Transaction 87691 is for £348.28 and is paid in supplier screens, but in banking reconciliation screen is not showing.
Transaction 87692 is for £1519.03 and is paid in supplier screens, but in banking reconciliation screen is not showing.
The above are three separate suppliers, all paid by BAC's on the same day, all show correctly in the bank account activity screen, but not in reconciliation screen.

Transaction 87700 is for £109.65 and is paid in supplier screens, but in banking reconciliation screen is showing as £9260.75.
Transaction 87701 is for £2915.06 and is paid in supplier screens, but in banking reconciliation screen is not showing.
Transaction 87703 is for £6236.04 and is paid in supplier screens, but in banking reconciliation screen is not showing.
The three transactions above are again for seperate suppliers, but in thisn case (as in March) add up to the £9260.75 - all show correctly if you look at bank account activity.
---

We are using Sage Accounts Professional 2013 v19.01.11.285 on a Windows 7 PC - 64 bit.

Any suggestions?

Robert

[jonespr1]

For additional context...



and

[brucedenney]

I think they may be grouping, this could be because they are contiguous transactions all on the same date, same bank account.

If this is the issue then you can switch off "group items in bank rec" in company preferences.

P.S. Good clear posting, nice description.

[jonespr1]

Hi

Thanks for that, this has fixed the second batch of transactions, but still no luck on the set which are completely missing - any ideas?

Robert

I think they may be grouping, this could be because they are contiguous transactions all on the same date, same bank account.

If this is the issue then you can switch off "group items in bank rec" in company preferences.

P.S. Good clear posting, nice description.

[brucedenney]

The missing transactions could be missing for a number of reasons.

Go to Financials and find them (by transaction number)

Check they are posted to the right bank account.
Check they are not already marked as reconciled.

[jonespr1]

Hi

They are posted to correct account (1200) and the financials screen shows that they have not been reconciled in the financials screen.

Any other ideas?

Thanks

Robert

The missing transactions could be missing for a number of reasons.

Go to Financials and find them (by transaction number)

Check they are posted to the right bank account.
Check they are not already marked as reconciled.

[brucedenney]

Can you do a snap shot of

The financails screen showing the transactions and the bank rec screen not showing the transactions.

[jonespr1]

Hi

Here is the financials screen (difficult for full screen as doing remotely over TeamViewer)



The reconciliation screen is in first post, if I was to scroll up from the screenshot there is just a gap in the numbering, there were oher transaction son the 8th which appeared fine, so is limited to these.

Thanks

Robert

Can you do a snap shot of

The financails screen showing the transactions and the bank rec screen not showing the transactions.

[brucedenney]

The bank rec screen starts is sorted by date not by transaction number.

Can you resort it and do a screen shot showing at least a transaction before 87689 and after 87692.

[jonespr1]

Hi

Looking into it further to do the screenshot has made me realise that it's operator error now!

The two issues were linked in that the second lot of transactions were explained by the fact they are in the bottom screen of the reconciliation which is currently saved, but not fully reconciled until we had sorted this issue out - two of us had been working on it and didn't spot it as the first issue had grouped the transactions wo weren't recognisable.

Thanks for your help!

Robert

The bank rec screen starts is sorted by date not by transaction number.

Can you resort it and do a screen shot showing at least a transaction before 87689 and after 87692.