Reconciling and Unreconciling a Bank in Sage 200

Reconciling and unreconciling a bank in Sage 200 is a key business process, which we’ll take you through step-by-step.

Reconciling a Bank

There are three ways in which you can reconcile bank transactions in Sage 200:

• Manually, using a printed statement
• Bank feeds, connecting directly to your bank
• Downloading transactions, which can then automatically be matched in Sage 200
• Some e-banking providers allow for files to be imported into Sage and then matched

This tutorial goes through the manual method of reconciling.

Topics covered:

1. How to reconcile multiple transactions
2. How to part-reconcile transactions
3. How to save a draft reconciliation
4. How to add a transaction of type

How to reconcile transactions (multiple and individual)

1. Find the bank reconciliation screen on the main menu (Cash Book > Period End Routines > Bank Reconciliation > Bank Reconciliation.
   
2. Enter your bank statement details. First, select the bank account that you want to reconcile. Specify the statement date if you want the show transactions up to a certain date. Enter a page number if you want to reconcile per page. You can also enter a projected end balance – typically the closing balance of the statement, or the carry forward balance of the page you’re reconciling.
   
3. To begin to reconcile transactions, select them from the list by ticking them off. To make this process quicker, you can also select a single transaction and hold down the Shift key, clicking to select multiple transactions at once.
   
4. Once you’re happy with the items you’ve selected, click “Match Checked Items”. In the bottom right hand corner of your screen, you’re able to compare your matched and projected end balances.
   
5. If you’ve matched a transaction in error, simply select it and click “Unmatch Selected Items”.
   
6. Once the transactions have been matched and you’re happy the balances are correct, click the “Reconcile” button.
   
   Note: If there’s a difference between the Matched Balance and End Balance, you’ll get a warning message. If you ignore this and choose to continue saving, the reconciliation would be saved with the matched balance.
   
   7. Reconciliation will give you two reports – one listing remaining unreconciled transactions, and the other listing all the reconciled transactions.

How to part-reconcile transactions

1. To reconcile part of a transaction, most of the steps above remain the same – just change the figure in the “Amount to Reconcile” column on the Bank Reconciliation screen.

How to save a draft reconciliation

1. To save a draft reconciliation, simply click the “Save button” in the bottom half of your Bank Reconciliation screen.
   
2. When you want to re-open the draft, go back to the Bank Reconciliation screen and go to add another bank account. Your previously drafted reconciliation should appear.
   
3. If a transaction is already part of a saved reconciliation, you won’t be able to use it as part of another reconciliation and will get a status notifying you of this.

How to add a transaction of type

This is useful if you’ve found a transaction that hasn’t yet been added into Sage 200 – like bank charges, or interest.

1. In the Bank Reconciliation screen, select “Add Transaction of Type” on the bottom half of your screen. You’ll then be able to select the type of payment or receipt, which will bring up the relevant screen where you can fill in the appropriate information.
   
2. Click “Save” – this will save the transaction, and add it as a matched transaction as part of your reconciliation.

Querying Transactions

This is a good way to flag up transactions you may be unsure about.

1. Select the relevant transaction.
2. Click “Add/Remove Query”
3. Type in the query you want to make.
4. Click “OK”
5. Your query is now highlighted in yellow in the Query column.

Note: Querying a transaction will stop it being selected in this transaction or any others.

You can remove a query using the same

Unreconciling a Bank

Alongside reconciling a bank in Sage 200, you may need to unreconcile a bank.

It is possible to see a summary of previous reconciliations via the cash book accounting enquiry screen. There are two ways to access this screen and Craig will show you both in this video.

Just be aware that the transactions are ordered by their transaction date not the date that we were reconciled.

Topics covered:

• How to change the page number to represent the page that needs correcting
• How to filter reconciled transaction by date range
• How to export this data to excel

For more helpful Sage software tips and advice please take a look at our Tip of the Week. Tip of the Week is an online resource where we share various tips every week to help you get the most out of your Sage.

If you need any help with your Sage system then contact our support team on [email protected], or if you would like some more information about which products are best for your business then contact [email protected].