What reconciliation does and why you need it

Reconciliation is the process of matching the transactions Sage 50 shows in your bank account against the actual transactions your bank shows. It catches errors—a deposit you recorded wrong, a check the bank hasn't cleared yet, a fee you missed—before they throw off your whole account balance. Sage 50 does not automatically know what your bank processed; you have to tell it by comparing the two lists and marking off what matches.

The goal is simple: your Sage 50 balance and your bank statement balance should be identical after reconciliation. If they are not, reconciliation forces you to find and fix the difference before you move forward. This matters because if your records are wrong, every financial report you run—profit and loss, cash flow, tax prep—will be wrong too.

Key Takeaways

  • Reconciliation in Sage 50 means matching your recorded transactions against your bank statement line by line until both balances match.
  • You start a reconciliation by opening the bank account, clicking the Reconcile button, and entering the ending balance from your bank statement.
  • Sage 50 shows you which transactions have cleared the bank and which have not; you mark each one as cleared by checking the box next to it.
  • Outstanding items—checks you wrote that have not cleared yet, deposits not yet posted—stay unchecked until the bank processes them.
  • If your Sage 50 balance does not match your bank balance after marking cleared items, you have an error to find and fix before you finish.

How to open the reconciliation window in Sage 50

From the Sage 50 home screen, click Banking in the left menu, then click the name of the bank account you want to reconcile. The account register opens and shows all transactions for that account.

At the top of the register window, click the Reconcile button. A new window titled "Reconcile Bank Account" opens. This is where you enter information from your bank statement and mark off transactions that have cleared.

In the reconciliation window, you will see a field for Statement Ending Balance. This is the balance shown at the bottom of your bank statement—the number you are trying to match. Enter that number exactly as it appears on your statement, including cents.

Marking transactions as cleared

Once you enter the statement ending balance, Sage 50 displays two lists: one showing transactions in your account that have not yet been marked as cleared, and another showing transactions already marked as cleared in previous reconciliations.

Go through your bank statement line by line. For each transaction the bank shows, find the matching transaction in Sage 50's list. When you find it, click the checkbox next to that transaction to mark it as cleared. The checkbox tells Sage 50 that the bank has processed this item.

Work through your entire bank statement this way. Deposits, checks, transfers, fees, and interest all get marked when you see them on the statement. Do not mark anything you do not see on the statement, even if it is in Sage 50—that means it has not cleared yet.

What to do with outstanding items

Outstanding items are transactions in Sage 50 that do not appear on your bank statement yet. Common examples are checks you wrote that have not been deposited, or deposits you recorded that have not posted. Leave these unchecked.

Sage 50 automatically calculates a difference between your statement ending balance and your Sage 50 balance. This difference should equal the total of all your outstanding items. For example, if you wrote a check for $500 that has not cleared, and everything else matches, Sage 50 should show a $500 difference.

If the difference matches your outstanding items exactly, your reconciliation is correct. Click Reconcile to finish. Sage 50 locks those cleared transactions so you cannot accidentally change them later.

Finding errors when balances do not match

If your Sage 50 balance and your bank statement balance do not match after you have marked all cleared items, you have an error somewhere. The most common mistakes are: a transaction recorded in Sage 50 with the wrong amount, a transaction recorded twice, a transaction in Sage 50 that is not on the bank statement, or a transaction on the bank statement that you forgot to record in Sage 50.

Start by checking the amounts. Look at each marked transaction in Sage 50 and compare it to the bank statement. A $150 check recorded as $105 will throw off your balance by $45. Fix the amount in Sage 50 and try reconciling again.

Next, scan for duplicates. If you see the same check number or deposit twice in Sage 50, delete one. Then look for transactions on the bank statement that do not appear in Sage 50 at all—bank fees, automatic transfers, interest deposits. Add these to Sage 50 before reconciling again.

If you still cannot find the error, print both your bank statement and your Sage 50 register for that account. Sit down with both documents and go line by line, checking off each item as you match it. This manual method catches errors that are easy to miss on screen.

Reconciling after you have already finished one

Once you reconcile an account, Sage 50 marks those transactions as cleared and locks them. The next time you reconcile, you only work with new transactions that have come in since the last reconciliation.

Open the account, click Reconcile, and enter the new statement ending balance from your latest bank statement. Sage 50 shows only the transactions that are not yet marked as cleared. Mark the ones that appear on your new statement, leave the outstanding ones unchecked, and reconcile again.

This rolling process means you reconcile once a month (or whenever you get a statement) and only deal with that month's transactions. You do not re-reconcile old months unless you find an error in a previous reconciliation.

Frequently Asked Questions

What if I reconcile and then find out I made a mistake?

You can undo a reconciliation in Sage 50. Open the account, click Reconcile, and look for an option to unreconcile or reverse the last reconciliation. This unlocks the cleared transactions so you can fix the error and reconcile again. The exact menu path depends on your Sage 50 version, so check your software's help menu if you cannot find it.

Can I reconcile a bank account that has a negative balance?

Yes. A negative balance means you have written more checks than you have deposited, or your account is overdrawn. Reconcile it the same way: enter the negative statement ending balance, mark cleared transactions, and match the totals. The process is identical.

What does it mean if Sage 50 shows a cleared transaction that is not on my bank statement?

It means the bank has not processed it yet, even though Sage 50 shows it as cleared from a previous reconciliation. Do not mark it as cleared again. Leave it unchecked and contact your bank to find out why it has not posted. It may be pending, rejected, or stuck in processing.

Do I have to reconcile every month?

You should reconcile at least as often as you receive bank statements—usually monthly. Reconciling frequently catches errors early, when they are easier to find and fix. If you wait three months to reconcile, finding a $50 error from month one becomes much harder.

What if a check I wrote never clears?

If a check has been outstanding for more than 60 days, contact the person or business you wrote it to and ask if they received it. If they say they never got it, you may need to stop payment on the check and issue a new one. Once you do, remove the old check from Sage 50 and add the new one. Then reconcile again.