I checked off the 'Do not show corrections'

According to Bank:

Opening: 442079.11

Closing: 432904.37

The GL on Sage:

Opening: 442079.11

Closing: 390631.87

My Unresolved is exactly the difference of bank closing - GL closing: 42272.5

I had everything checked off on GL noting is missing! What could be the issue here?

Desk said:

I checked off the 'Do not show corrections'

My recommendation above was to uncheck it so you can see the corrections and see if there might be some not checked when they should be (assuming there might be corrections - if there are none, then it doesn't matter).

Assuming you have your dates correct I think there is definitely a problem.

Assuming you are doing the January 1-31/24 bank rec, then you ran a General Ledger report for those dates for your bank account to get the G/L opening and closing balances of $442,079.11 and $390,631.87.

You entered the closing statement date of Jan 31/24 and the starting date of Jan 1/24.  The reconciliation date is not a factor and is usually the date you start doing a bank rec.

If it completed properly, the difference in the Bank Statement closing balance of $432,904.37 and G/L closing balance of $390,631.87 is $42,272.50 as you said, but that should be the Outstanding amount (positive number means the G/L balance is greater, negative the bank closing balance is greater.

The difference between the bank statement opening and closing balances of -$9174.74 should be the Resolved Amount when the bank rec is done properly.

Because you have said the Unresolved amount is not zero, there are missing transactions and the Resolved amount is not as I indicated above.

So either you have something entered in the wrong field or you have missed posting some entries.

I would go back over the reconciliation, uncheck everything on the account reconciliation screen that is not a correction.  Then go line by line through the statement and when you check off an entry on the data entry screen, also check off the entry on the statement.

When you are done, if you have anything unchecked on the statement, you should have an unresolved amount.  If those entries are not on screen, and they were not posted with an incorrect date, then you should be able to post them and then go back into the account reconciliation and check them off.

Just to add to Richard's excellent way to complete a bank reconciliation in Sage 50, which he taught me more than 20 years ago, I have one more suggestion. Before starting the reconciliation and before I enter the statement end date check the Unresolved against the Statement Opening Balance. If they are the same you are good to move ahead with the reconciliation. However, if they are different then Sage has not checked off one side of a correction. You will never know this for certain if you check the box to not show corrections. 

Hope this helps

Thank you for your response. But this does not resolve my issue. I unchecked 'Do not show corrections' and some Nov adjustments show up. If I checked those off my unresolved are same and outstanding is zero. When I unchecked them, my unresolved goes up. Anyways, this is Dec I am working on. My opening/closing dates and balances are correct. All the GL figures exist on my bank. Banks figure exist on my reconciliation page; but, my GL still does not match. I however found 2 corrections to make and since then my Unresolved has changed to $42,914.05

Any suggestions will be helpful.

Before I start any reconciliation, my unresolved is same as statement opening balance. So before I begin,

my opening bank 442,079.11

closing bank: 432,904.37

Outstanding: 52,088.79

Unresolved: 442,079.11

As soon as I check everything off as I go: My unresolved becomes: 42,914.05 possibly which means this amount is not on GL! It is very strange. Never occurred this with me on any other software.

Before I start any reconciliation, my unresolved is same as statement opening balance. So before I begin,

my opening bank 442,079.11

closing bank: 432,904.37

Outstanding: 52,088.79

Unresolved: 442,079.11

As soon as I check everything off as I go: My unresolved becomes: 42,914.05 possibly which means this amount is not on GL! It is very strange. Never occurred this with me on any other software.

Sorry unresolved is: 42,914.05