Unreconciled bank transaction doesn't appear on the bank rec

Question

I'm having an issue with a bank rec where an unreconciled supplier payment on account isn't coming up for me to reconcile. I've checked the transaction type, the date, the value, and it's definitely not reconciled. 
 Has anyone else come across this and managed to fix it?

Ian C · Answer

Hi Lindsey, 
 Thanks for using Sage City. 
 Three things i would check would be the Bank Account on the transaction (1200?) and make sure it's the same Bank as the one you're trying to reconcile. 
 
 I would also check the "End Date" within the Bank Rec screen (Top right hand corner) and make sure the date is on or after that of the transaction that is missing. 
 
 You could also make sure it's not already in the matched section of the current Bank Rec. 
 If this has answered your question please click More > Verify Answer. 
 Regards, 
 Ian 
 Sage UKI

Ian C · Answer

Hi Lindsey, 
 A couple of other things you could check would be grouped transactions option. Go to Settings > Bank Defaults and untick "Group items in Bank Rec" > OK and try and search again. (You can turn this setting back on later) 
 You may also find enabling the following column useful to help locate the transaction. Right click a heading in Bank Rec and click "Tran no". You can also sort by this column to put them in order. 
 
 Putting another transaction on will fix the problem but as you say probably not the right thing to do, it will be there we just need to find it. I don't think it's corruption issue however if you "Save" your bank rec it may be worth pressing discard and starting the Bank Rec again, maybe backup before you do this and if it doesn't fix the problem just restore your backup. 
 If this has answered your question please click More > Verify Answer. 
 Regards, 
 Ian 
 Sage UKI

Sage 50 Accounts

Unreconciled bank transaction doesn't appear on the bank rec

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING