. In the Save As dialog, specify a new file name and/or location and then click Save.Note: This topic does not apply to customers that use Bank Account Reconciliation to reconcile bank statement transactions. Refer to Bank Account Reconciliation instead.
Use Bank Statement Import to import bank statement transactions that you have downloaded from your online banking app or website. The imported transactions can then be added in Bank Statement Reconciliation to reconcile them to transaction records in the Beyond Software database.
These are the types of Beyond Client transaction records that can be reconciled using this process:
Direct deposits to the bank account
Customer payments that are made as deposits to the bank account (via Cash Processing)
Journal transactions or journal entries that have been made directly against the bank account
Payments to vendors that are made through Payables (via Payment Selection and Print Checks or ACH Payments)
Before using Bank Statement Import, you must have a bank account record for your bank in Bank Accounts.
You must download the bank statement transaction file(s) from your bank.
The file(s) that you import into Beyond Client must be in an Excel file format (.xls or .xlsx), and the data format must match the requirements of our template. If your banking site provides downloaded bank statements as only PDF or CSV files, you must convert the files to Excel first and then format the data before importing. See Creating a Bank Statement Import File.
This section explains how to create a bank statement import file using our template. We recommend that you copy/paste the required bank statement transaction data into our template; however, you could also use the template to view our data requirements and then format your own Excel file accordingly.
Select Financials | Cash | Bank Statement Import.
On the toolbar, click Import. The Import dialog is displayed.
In Action, select Template.
In File, the default location and name for the import template file is displayed. Optionally, you can change this by clicking Lookup . In the Save As dialog, specify a new file name and/or location and then click Save.
Click Begin Processing. After the template file is created, click OK.
Find the template file in the location specified and open it to see the required data and format. Columns are provided for this information:
Transaction Date: Required. Must be included for every bank statement transaction.
Transaction Description: Optional. The field can be blank if the bank statement transaction does not include a description.
Transaction Reference: Optional. The field can be blank if the bank statement transaction does not include a reference number.
Transaction Amount: Required. Must be included for every bank statement transaction. In the downloaded bank statement, payments from the bank account must be displayed as negative numbers (e.g., -235.00) and deposits to the bank account must be displayed as positive numbers (e.g., 750.00).
Perform one of these actions:
Copy the required information from your bank statement transaction file, paste it into the template file, and then save the file for import.
Update your bank statement Excel file to match the data requirements in our template and then save the file for import.
You can validate your bank statement Excel file without running the Import process. However, validation also occurs during the Import process, so if you are ready to import, you can skip to Importing a Bank Statement File.
Select Financials | Cash | Bank Statement Import.
On the toolbar, click Import. The Import dialog is displayed.
In Action, select Import.
In File, click Lookup to find and select your bank statement import file.
Select Validate Only.
If your Excel file has multiple tabs (also called sheets), then in Import Tab Name you can select the one to validate. If your file has only one tab, it is selected by default.
Click Begin Processing. These are the possible results:
If the file is valid, a success message is displayed. Click OK.
If the file does not meet requirements, an error message is displayed. You can click View next to the File field on the Import dialog to open the file in Excel. Update the file and try again.
When your bank statement Excel file is ready to be imported it into Beyond Client, follow these steps:
Select Financials | Cash | Bank Statement Import.
On the toolbar, click Import. The Import dialog is displayed.
In Action, select Import.
In File, click Lookup to find and open your bank statement import file.
If your Excel file has multiple tabs (also called sheets), then in Import Tab Name you can select the one to validate. If your file has only one tab, it is selected by default.
In Bank Account, select the bank account record in Beyond that corresponds to the bank statement file.
Import Date shows the current date by default. You can change it as needed.
Note: If you specify the same import date for more than one bank statement, then transactions from each statement will be added into the same batch file for that date. If you specify a different date each time you import a bank statement file, a separate batch file is created for each set of transactions.
Click Begin Processing. These are the possible results:
If the file is valid for importing, a success message is displayed. Click OK.
If the file does not meet requirements, an error message is displayed. You can click View next to the File field on the Import dialog to open the file in Excel. Update the file and try again.
To review imported bank statement transactions, follow these steps:
Select Financials | Cash | Bank Statement Import.
On the toolbar, click Find 
.
Double-click the imported bank statement batch to review. The list of transactions is displayed in the Imported Transactions grid. By default, the grid includes these columns:
Nbr – Displays the number assigned when the transaction was imported.
Cleared – Indicates whether the bank transaction has been matched to a Beyond Client transaction, to be cleared from the system. When first imported, this field is not selected for any transaction.
Date – Displays the date of the bank transaction.
Description – Displays the description of the bank transaction, when applicable.
Reference – Displays the reference number given to the bank transaction, when applicable. For example, in the case of printed checks, reference numbers are usually the check numbers.
Amount – Displays the amount of the bank transaction.
Possible Duplicate – If two or more transactions have the same date and amount, the system flags all but the first one as possible duplicates, so you can investigate and make changes if needed. See Verifying Automatically Matched Transactions for Reconciliation.
Cleared Amount – When first imported, there is no amount for any transaction. After reconciliation, this field shows the amount that was cleared for each transaction. See also About Partial Clearing.
In the event that you imported a bank statement by mistake or made some other mistake with an imported statement, you can delete the statement as long as none of its transactions have been cleared.
Select Financials | Cash | Bank Statement Import.
On the toolbar, click Find .
Double-click the imported bank statement to delete. If the system determines that the statement is eligible to be deleted (because no transactions have been cleared), the Delete button on the main toolbar is enabled for use.
Click Delete.
When prompted to confirm, click Yes. The statement is removed.