I have multiple banks to reconcile and the GL and the Bank Balance is not the same.
Have you had any Sage 300 training? This is a question best answered by your Sage Consultant.
In short, the starting balance of both the GL Bank control account and the Bank Services bank need to be the same - at some point in time. Then work forward month by month.
If that is too hard because it hasn't been done for years, for instance, then for each bank:
-in the bank rec screen reconcile everything except any actual outstanding lines.
- add a new single bank entry (code to suspense) to match the bank services bank balance to the bank statements, then reconcile this entry.
Delete or reverse this entry when it hits the GL
- If it is needed, enter a GL Journal to the GL bank control account so it matches the bank services bank rec screen balance.
An accountant will need to advise the other side of the entry .
The previous months were reconciled but this the deposits were 9000 withdrawal 30000 and I have the ending bank balance how ever the GL and the book balance is not the same
Two areas to review:
*Community Hub is the new name for Sage City