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.

Sorry unresolved is: 42,914.05

November corrections just means you edited/deleted one or more entries dated in November after you reconciled your November bank statement.  There should be an entry on both the Deposit and Withdrawal side if they were adjustments.  If the Deposit and Withdrawal sides are not the same, then your opening balance may not be correct but you indicated it is so the corrections should be the same dollar amount for each pair.  Therefore unchecking all or checking all should not change the math.

The only thing that we are not sure of is if you have a discrepancy?  It should always be zero but due to internal calculations sometimes goes out of balance.  This sometimes happens in older versions if the bank rec module is open during data entry and the screen does not refresh properly when you go back to it after posting an entry that affects the account you are reconciling, then save the information without the proper refresh.  I haven't seen this in current versions but I have in older ones.

The Opening Balance on the bank statement being the same as the opening balance on your G/L means there were no outstanding transactions from a previous period.  eg. no entry to check off in this bank rec that has a date before Dec (other than correction entries).

The fact that your difference is a positive number means that your difference is mostly likely a Deposit entry.  However, this could be one or more entries and could also include some withdrawals.  However, the difference is more on the deposit side.  I don't know if that will help.

At this point, without seeing the details I can't suggest anything else.  My past experience tells me the answer is in the date fields, closing balance or something was checked that shouldn't have been.  The problem is that you have checked the dates themselves and checked to make sure the end date is in the end date not the reconciliation date field based on your descriptions above.  This of course assumes nothing is wrong with the module's internal calculations and storage of data and that there is no Discrepancy.  Maybe Alwyn has some more ideas.

Thanks Alwyn!

Thanks!

All the previous adjustments are correct with the withdrawals and deposits. No discrepancy exists. All the deposits/withdrawals are accounted for. Only thing I can do right now is close the software and restart 

Hello. So further revelations as we go:

I have on my GL $42,953.31 this went out of the bank in Nov. But shows in my Dec GL but on the bank! So, let's say if we take our unresolved and this amount's difference

$42,953.31 - $42,914.05 = $39.26

I am not sure if we are close to solving the mystery. Thought if I let you guys know.

If the $42,953.31 went out of the bank in November, but did not show up on the GL until December, how did you complete the reconciliation of the November Bank Statement? Frequently, there are items from the GL that do not clear but if a reconciliation is complete everything on the bank statement must be in the GL in the month being reconciled or earlier.

I am guessing, I hate making assumptions, that you are trying to clear everything in the GL each month. However, a reconciliation of the bank makes the information on the bank statement to be accurate and the GL is matched to it. At the end of the process there is always the chance that a late month deposit is not recorded until the beginning of the following month. By the same token there is always a chance that some cheques do not clear the bank before the end of the month. Using Sage 50 Bank module's reconciliation feature, these unmatched items will stay on the file until the next reconciliation period when most will be cleared because they finally made it to a Bank Statement.

In the case at hand the entry of the $42,953.31 should have been dated in the GL for November if it was in the bank in November. Leaving it in the GL as a December entry causes this kind of situation to arise as it can never by reconciled in December, it is not on the bank statement for December.

It is good that you found this and now it needs to be resolved. Then you have only $39.26 to solve. Is this a single item where the checkmark did not stick and it appears to not be on the bank statement? 

Hello! I asked the person who did it. We usually get 1 payroll figure to do bank adjustment. So in Nov we had to do 1 adjustment for Oct pay period exactly same scenario whereby went out in Oct but showed on GL for Nov. This figure of $42,953.31 is the payroll for Nov end went out of our bank in Nov but shows on our GL for Dec.

Now why we do GL/Bank rec every month and clear it I am not sure I get asked to have it done monthly due to reporting each month.

So I guess I am doing this figure's adjustment as well considering this is part of a payroll and it shows in Unresolved and move on if I can put 39.07 deduction in Jan Bank from organization  as a miscellaneous?

I however do see a deduction of 39.07 from my January bank which is never seen from the gov. May be they had adjusted an overpayment may be. I checked whole 2023 never received such deductions. So I gather this 39.26 was part of a funding we received and it's being adjusted in Jan I suppose? This is all I have for your technical review.

Cheers!

Hello! I asked the person who did it. We usually get 1 payroll figure to do bank adjustment. So in Nov we had to do 1 adjustment for Oct pay period exactly same scenario whereby went out in Oct but showed on GL for Nov. This figure of $42,953.31 is the payroll for Nov end went out of our bank in Nov but shows on our GL for Dec.

Now why we do GL/Bank rec every month and clear it I am not sure I get asked to have it done monthly due to reporting each month.

So I guess I am doing this figure's adjustment as well considering this is part of a payroll and it shows in Unresolved and move on if I can put 39.07 deduction in Jan Bank from organization  as a miscellaneous?

I however do see a deduction of 39.07 from my January bank which is never seen from the gov. May be they had adjusted an overpayment may be. I checked whole 2023 never received such deductions. So I gather this 39.26 was part of a funding we received and it's being adjusted in Jan I suppose? This is all I have for your technical review.

Cheers!