Next Generation - The BACS Export screen | Access Financials Help Centre

The BACS Export feature allows you to export your BACS file for all payments that are listed on the screen. You can narrow down your search by opening the Advanced Filters panel.

You can delete a single or multiple transactions from the BACS run if they are not fully ready to be processed.

To create the BACS export file, please refer to the process the BACS export and create the BACS file article.

All of our enquiry type screens have the same look and feel and functionality for consistency purposes.

You can run enquiries against all records or just a specific record.
You can apply filters to ensure that only the transactions you're interested in are displayed in the enquiry window.
Access to enquiry windows is controlled by your Security Profile.

The BACS Export is made up of the following sections:

Sections	Description
Record Count	Shows the number of transactions listed in the grid for the provided filter criteria. Updates depending on the filter criteria. Updates when you select transactions when you don't have payment approval set up.
Search field	Search on Account Name or Header Ref which is the same as the Invoice and Credit Note Number, or Payment, Debit and Credit Adjustment Reference field. Tip: You have to know the first few characters or numbers to be able to search as these searches are what we refer to as Begins With searches. You can search for the beginning of each word in the available quick search fields, no matter where they are. Example: If you wish to search for an Account Name of "The Access Group", you can now enter the words "The", "Access", or "Group" and Financials will intelligently find this result. Note: The above logic is only available for the search on the Supplier Name and not for the Header Ref.
Saved Filters List	A list of any saved filters that are available. Filters are saved using the advanced filter panel, for more information please refer to how to use the advanced filter.
Advanced Filter	Opens the advanced filter panel for advanced filtering. Number indicator displays the number of applied filter criteria to the enquiry list. For more information, please refer to the advance filter article.
Cog	Contains a list of actions which can be carried out on the enquiry. Configure Columns - Customise the displayed columns in the best order to suit your needs. For more information please refer to Configure Columns. Clear Criteria - Clears all the filter criteria that you have added directly for a column displayed. Doesn't clear the filter you have added to the Advanced Filter panel. Reset Sorting - Removes any sorting that you've set on all displayed columns. Reset Default Column Width - Resets all column widths to their default size. Export to Excel - All - Exports all the transactions for the columns displayed on the screen. If you wish to see all columns available on your export, you have to add all columns in the configure column option. The current limit is set at 500,000 rows to protect the performance. You can run several exports at the same time, even from the same screen and you'll be notified individually as each one is completed. Export to Excel Current View - Exports the currently displayed or loaded transactions and columns, the default is to load 100 transactions. If you wish to see all columns available on your export, you have to add all columns in the configure column option. Once you scroll past the 100th transaction, this loads another 100 transactions. This is done to make sure that you don't come across any performance issues when you have hundreds of thousands of records.
Hide Grouping	You can select to group by any column when this option is on by dragging a column into the drag and drop columns header for grouping field. You can group multiple columns. You can turn this option off to allow for more space for your transactions by clicking on Hide Grouping. You can turn grouping back on by clicking on Show Grouping.
Hyperlinks - Account Code and Supplier Name	You can click on the hyperlinks on the account code or supplier name to view the supplier record. The record opens in View mode and if your security permissions has edit permissions, you can edit the supplier. If you don't have access to edit supplier records, instead of an Edit button, you will see a Close button on the supplier record.
The Grid	Default columns are displayed when the Remittance BACS screen opens. You can change by manually dragging and dropping the columns to where you want them or alternatively you can customise your columns using the Configure Columns. Each column is sortable, and you can sort on multiple columns at the same time. To sort on multiple columns, hold down the Shift key on your keyboard and click on the column you want to sort. You can filter on all the columns by pointing to the column label and clicking on the icon to open the filter window. You can increase and decrease the column width and the settings are saved for you so you to only have to do this action once. The GBP Totals at the bottom right-hand side of the screen show the sum of all values for the displayed transactions. For currency transactions, change the Currency Code to be the required currency. You have to change the Bank Analysis to match the analysis for the selected currency and you need to select a BACS export format. The default Value at the bottom of the screen will be displayed in the same currency as your database is, and you can change the currency by clicking on the drop-down arrow above the Totals at the bottom right-hand side of the screen. Once you have changed the currency, you will be able to see the total value for the currency.

More information on the default displayed columns

Column label	Description
Account Code and Supplier Name	You can click on the hyperlinks on the Code and Supplier Name to view the supplier record which depending on your security permissions opens in edit or view mode. If you don't have access to the Financials module Suppliers option, the hyperlinks aren't visible on the enquiry screen.
Header Ref.	The header reference field is the same as the Invoice and Credit Note Number, or Payment, Debit and Credit Adjustment Reference field.
Reference	The BACS Reference that you have entered on the supplier's bank details.
Audit No.	A system generated number assigned to all transactions posted.
Date	The original date that you have posted the transaction to.
Year	The year that you have posted the transactions with.
Value	The total value of the transaction.
Currency Code	The currency code of the transactions that you have posted.
Description	Automatic description of Remittance is added to all transactions.
Period	The period that you have posted the transaction to.
Currency Rate	The exchange rate used when the transaction was posted.
Bank Analysis	The bank analysis used on the transaction.
BACS Export Format	The export format used on the Remittance BACS processing screen.

Next Generation - Process the BACS Export and create the BACS file

Next Generation - The Remittance BACS screen

Next Generation - The Remittance Cheques screen

Processing Remittance BACS

Next Generation - Processing Remittance BACS