What reconciliation does and why you need it
Bank 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 processed differently, a fee you missed — before they throw off your financial records.
Sage 50 does not automatically know what your bank did. You tell it what you recorded, the bank tells you what it processed, and reconciliation is where you line them up. If they do not match, you find out why and fix it. Most businesses reconcile monthly, when the bank statement arrives.
The reconciliation window in Sage 50 walks you through this step by step. You tell it which transactions cleared the bank, it marks them as cleared in your records, and at the end it tells you whether everything balances. If it does not, the software shows you which transactions are still unmatched so you can investigate.
Key Takeaways
- Reconciliation in Sage 50 matches your recorded transactions against your bank statement to catch errors and missing items.
- You access the reconciliation window from the Banking menu, select the account, and enter the ending balance from your bank statement.
- Sage 50 shows you each transaction in your account and lets you mark it as cleared when you find it on the bank statement.
- If your reconciliation does not balance, Sage 50 shows you the difference and which transactions remain unmatched so you can track down the problem.
- Common mismatches include outstanding checks that have not cleared yet, deposits in transit, and bank fees or interest you did not record.
Opening the reconciliation window and entering bank statement details
Start with your bank statement in front of you. Open Sage 50 and go to Banking in the menu bar, then select Reconcile Bank Accounts. The software will ask you which account you want to reconcile — choose the one that matches your bank statement.
Sage 50 will show you the last reconciliation date and the last reconciled balance. Below that, enter the ending balance from your bank statement — this is the total shown at the bottom of the statement, not the beginning balance. Also enter the statement date. Do not guess at these numbers; copy them directly from the statement.
The reconciliation window will now show every transaction in that account since the last reconciliation. Each one has a checkbox next to it. Your job is to go through the bank statement line by line and check off each transaction you find there.
Matching transactions and marking them as cleared
Read through your bank statement from top to bottom. For each transaction listed, find it in the Sage 50 reconciliation window and check the box next to it. The software calls this marking it as cleared. You are telling Sage 50: "Yes, the bank processed this one."
Transactions usually appear in the same order on both the statement and in Sage 50, but not always. If you recorded a check on the 15th but the bank did not clear it until the 22nd, it will be in a different place. Read the amount and the date carefully. A $500 check to a vendor should match a $500 debit on the statement to that same vendor.
As you check off transactions, Sage 50 keeps a running total at the bottom of the window. It shows you how much you have matched so far and what the difference is between that total and the bank statement ending balance. When you have checked off everything that appears on the statement, that difference should be zero.
What to do when the reconciliation does not balance
If the difference at the bottom of the reconciliation window is not zero, something is unmatched. Sage 50 will show you which transactions you have not checked off yet. These fall into a few categories: checks you wrote that have not cleared the bank yet, deposits you made that the bank has not processed yet, and transactions the bank processed that you have not recorded in Sage 50.
Outstanding checks and deposits in transit are normal. A check you mailed last week might not clear for several more days. A deposit you made on the 28th might not show up until the 1st of the next month. These are not errors — they will clear eventually. You do not check them off during reconciliation because they are not on the bank statement yet.
If you find a transaction on the bank statement that is not in Sage 50 at all — a fee, an interest payment, an automatic withdrawal — you need to record it in Sage 50 before you can reconcile. Go back to the Banking menu, select Write Checks or Deposit Slip depending on whether it was money out or money in, and add the transaction. Then return to reconciliation and check it off.
If the amounts do not match — you recorded a $100 check but the bank shows $110 — look at the bank statement carefully. The bank is right. Go back to the transaction in Sage 50, open it, and correct the amount. Then return to reconciliation.
Completing the reconciliation and saving your work
Once the difference shows zero and you have checked off everything that should be cleared, click the Reconcile button at the bottom of the window. Sage 50 will mark all the checked transactions as cleared in your account and save the reconciliation. The software will show you a summary of what was reconciled and the date.
Sage 50 keeps a record of each reconciliation you complete. The next time you reconcile this account, the software will start from the last reconciliation date and show you only the new transactions since then. This is why it matters to reconcile regularly — each month you are working with a smaller set of transactions, so errors are easier to spot.
If you close the reconciliation window without clicking Reconcile, Sage 50 will not save your work. You will have to start over next time. Make sure the difference is zero before you close.
Handling timing differences between your records and the bank
The most common reason reconciliation does not balance on the first try is timing. You record a transaction when you make it; the bank records it when it processes it. These dates are often different.
A check you write on the 10th might not clear until the 15th or later, depending on how the recipient deposits it and how fast the banking system moves. A deposit you make on Friday might not show up until Monday. These are not errors. Leave them unchecked in the reconciliation window — they will appear on next month's statement and you will check them off then.
Bank fees and interest work the same way. Your bank might charge a monthly fee on the last day of the month, but you do not know the exact amount until you see the statement. When you see it, record it in Sage 50 as a transaction, then check it off in reconciliation.
Frequently Asked Questions
What if I recorded a transaction in Sage 50 but it never appears on the bank statement?
If a check or transfer you recorded weeks ago still has not cleared, contact your bank. A check can take two weeks in normal circumstances, but longer than that suggests it may have been lost. A transfer should clear in one to three business days. If it has been longer, the bank can investigate. Once you confirm it will not clear, you may need to reverse the transaction in Sage 50 and record a new one.
Can I reconcile a partial month, or do I have to wait for the full statement?
You can reconcile whenever you want, but most people wait for the bank statement because that is the official record. If you reconcile before the statement arrives, you are comparing against your own records, which defeats the purpose. Wait for the statement, then reconcile against it.
What happens if I reconcile by mistake with the wrong ending balance?
Sage 50 lets you undo a reconciliation. Go to Banking, select Reconcile Bank Accounts, choose the account, and look for an option to reverse the last reconciliation. Once you reverse it, you can reconcile again with the correct balance. The transactions will be marked as uncleared and you can start over.
Do I have to reconcile every month?
You do not have to, but monthly reconciliation catches errors early and keeps your records accurate. If you wait three months and then reconcile, a mistake from month one will be much harder to find. Monthly is standard practice for most businesses.
What if the bank statement shows a transaction I did not authorize?
Do not check it off in Sage 50. Contact your bank when ready to report it. Once the bank investigates and reverses it, it will disappear from future statements. At that point your records will match again. Until then, leave it unchecked and your reconciliation will show a difference equal to that transaction.