Bank enquiries

Use the bank enquiries to investigate and find information about your Sage 200 bank accounts and transactions. You can find monies paid and received, as well as see the overall balance on the account. This helps you to determine the status of a bank account.

All values are displayed in the operating currency for the bank account.

Bank Account Enquiry

Open: Cash Book > Bank Account Enquiries > Bank Account Enquiry.

1. Select the account you want to view.

   Note: If you see a message This account will not display in lists, this means the bank account has been hidden. To change an account status, see Hide or show a bank account.

2. Choose the information that you want to view, by selecting the appropriate tab: Details, Contacts, Statement Balances, E-Banking, Memo, Attachments.

3. An * (asterisk) is displayed on the Memo tab if there are active memos.

   • To add memos, select the Memo tab and click Add.

     Enter the memo text and click OK.

     The memo details are added, along with the date and time that it was added as well as the user who created the memo. You can Edit and Delete memos as required.

   • By default, memos that you add will be marked as Active. This can be changed by selecting the active memo and clicking Set as Inactive. This means you can keep a copy of old memos

   • Select Show memo text to view the full text of the memo.

Bank Account Transaction Enquiry

The transaction enquiry provides a detailed breakdown of each transaction held on the bank account.

Open: Cash Book > Bank Account Enquiries > Transactions.

You can:

• Select a bank transaction and see the customer or supplier entry associated with it: Select Trader Transaction from the Select drilldown drop-down list.
• Select a grouped bank transaction and view all the sales and purchase transactions associated with it.
• View nominal and VAT details associated with each transaction: Select Nominal or VAT from the Select drilldown drop-down list.
• Sort the transactions.
• Print the details of transactions you are interested in.

Standing Orders and Direct Debits Enquiry

Open: Cash Book > Bank Account Enquiries > Standing Orders and Direct Debit Enquiries.

You can view summary details of standing orders and direct debits associated with your bank accounts; this covers the references, first entry date, number of required entries and its description.

Select a transaction to see further details: the nominal accounts affected by the postings, the frequency and day of the month transactions are made and the actual transactions made to date.

You can print a report, showing all active standing orders and direct debits for a bank account.

Short term Cash Projection Enquiry

The Short Term Cash Projection helps you to forecast the amount of cash you will have in your bank accounts on a particular day after your outstanding transactions have been paid.

Do this on the Short Term Cash Projection screen.

Open: Cash Book > Bank Account Enquiries > Short Term Cash Projection

1. Chose the date range to be covered by the projection.
   1. Select a date range from the list.
   2. Select custom from the list and then specify a date range using the calendars.
2. Choose the bank accounts you want to include. Click Include? next to those accounts in the Accounts section.

3. Choose the transactions to include. Click Include next to those transactions in the Transactions section.

   Use Select All and Deselect All to do this quickly.

4. Click Refresh to recalculate with your amendments.
5. The forecast totals for the selected bank accounts is shown in the Summary section.

Note: Each time you make an amendment to the projection (for example, include or exclude a bank account or transaction) click Refresh.