Note: 
1. A new In Progress status has been added to Bank Feeds, disabling deletion. Deletion remains possible for 
 Queued, Partially Imported, and Imported statuses.
2. 'Refresh Rule' has been introduced under Banking>Bank Feeds. If the user opens a new import to make a rule for one
 of the import entries. This new rule applies to several more instances in other entries for the same import.
3. A new column has been added to display the 'Queue Position' beside the Bank Feed Status. It shows the Queue Position of
the Feed if the same is in progress. 
4. While importing a bank feed, the limit is now set at 1000. You can enter up to a thousandth line of entry. 

You can import bank feeds or statements from a list of banks that keeps updating. The process of loading goes through certain stages – loading, updating feeds, if necessary and importing. After importing, depending on the settings, you can auto-allocate or manually allocate the feeds to customer or supplier invoices.

BrightBooks allows you to perform certain actions on bank feeds. To view the steps, click the steps below.

BrightBooks supports bank feeds from Co-op Bank and Lloyds Bank and a new feed type from Allied Irish Banks.

• Loading Feeds
• Viewing Feed
• Updating Statements
• Splitting Statement Records
• Allocating a Transaction
• Ignoring a Transaction
• Importing Feeds
• Auto-allocating Bank Feeds to Invoices

NOTE: In this release, two new options have been added under the Bank Feeds Template dropdown. This can be found 
under the New Import Bank Feed option. The new dropdowns added are AutoEntry AP(xls), and AutoEntry AP(csv).

Loading Feeds

Steps to load/import a Bank Feed CSV File

1. Log in and click the required business.

2. The Customers page appears. Click Banking > Bank Feeds.

3. The Import Bank Feeds page appears. To start loading, click [New].

4. The New Bank Feed page appears. The page contents vary depending on the following: Enter the following statement import details.

5. To load the statement into the system, click [Load].

6. The View/Edit Bank Feed page shows that the feed has been loaded.

Post a bank feed load, the current status of the payments and receipt records in a bank feed is indicated with distinct colours. The meaning of the colours is explained in the table below.

COLOUR	MEANING
	Incomplete information in the loaded feed record. You are not allowed to import until you provide all necessary information.
	All data in the transaction record are correct.
	There can be either of the two meanings: The transaction in the bank feed is not allocated or it is already allocated and the allocation details are shown when you move the cursor over the colour.
	Potential duplicate transaction identified.

Use the following hotkeys to perform your operations:

Error while importing a CSV Bank Feed

If you are receiving generic errors when importing your CSV bank feed and receiving messages relating to "invalid file types" or "extra commas" on the file, there are some checks that can be completed to help resolve these.

• Ensure there are no additional spaces before or after your headings in each cell (on row 1).
• Ensure the values on the file are formatted as "general," which should be the default format for most templates.
• Ensure there are no commas in the values in the file.
• Ensure the template you are importing has not been modified, i.e., you have not edited row 1, as the headings here are all mandatory, even if some of the information below them is not used.
• Ensure you have selected the correct bankfeed template type that matches the CSV file you are importing.

Please note, if the bank feed template type is greyed out on the 'New' screen and you need to change this, you can do so by going to:

• General Ledger, Chart of Accounts.
• Clicking on the dropdown on the right side of the bank account nominal code.
• Select edit, change the template, save,and  click save.

Viewing Bank Feeds

To view specific bank feed records, on the Import Bank Feeds page, click anywhere on the row.

Updating Statements

You can update one or more records or even update the same transaction types in a batch.

1. Load the bank feed.

2. On the View/Edit Bank Feed page, select the transactions and update the Ref. No., Payment Type, Cust./Supp., and Code columns.

3. To batch update the same transaction types, select multiple receipts or payments and click Edit.

To select all transactions, tick the tick box beside the Date column.

4. The Edit Bank Feeds window appears. Do the following:

•  
  •  
    • Update the required fields so that the updates apply to all records.
    • To update the last selected transaction only, keep the Update selected transaction option selected, else, to apply the updates to all selections, select Update all.

5. To save the updates, click Save.

Splitting Records

You can split a record and divide the transaction amount into as many parts as required and ensure that the total of the split parts is equal to the original transaction amount. You can also assign the split amounts to different customers or suppliers. To split, complete the following steps.

1. Load the statement.

2. On the View/Edit Bank Feed page, select the required record and click [Split].

3. The Split window appears. Divide the transaction amount into as many parts as required

4. To save the split amount, click Save.

The value in the Unallocated Amount column must be zero.

Allocating a Transaction

You can allocate a transaction, based on whether it is a receipt or a payment to a customer or supplier invoice. To allocate, complete the following steps.

1. On the View/Edit Bank Feed page, click the required transaction record and click Allocation.

2. The Allocations window appears. Tick the invoices you want to be allocated based on the amount available for allocation.

Optional: To have BrightBooks auto-allocate, click Auto. To reverse allocation, click Reverse.

3. To save the allocation, click Save.

Ignoring a Transaction

As per the new update, users can now Ignore a specific transaction and even Ignore the transaction. If you select a transaction and click on Ignore, the specific transaction will not be considered while Importing the Feed. 

To ignore a transaction, complete the following steps:

1. On the View/Edit Bank Feed page, click the required transaction record and click Ignore.

2. The Ignored Transaction tab changes colour. You can Undo the same by clicking Undo Ignore.

3. To save the changes, click Save.

4. The Ignored Transaction would not be considered while importing a feed. It will show Imported if all transactions except one are ignored. 

Refunds on a Bank Feed

BrightBooks does not support refunds on bank feeds. If you receive a refund on a bank feed for a customer/supplier, please ignore the transaction on the bank feed and manually post a minus payment/receipt for the supplier/customer.

Assigning a Division to Transactions

To assign divisions to your bank feed transactions, complete the below:

1. On the View/Edit Bank Feed page, click the required transaction record and click edit.
2. Select DIV, assign a division.
3. 3. To batch update the same transaction types, select multiple receipts or payments and click Edit.
4. Update the required fields so that the updates apply to all records.
5. To update the last selected transaction only, keep the Update selected transaction option selected, else, to apply the updates to all selections, select Update all.

6.  

   •  
     •  

   5. To save the updates, click Save.

Importing Feeds

To import feeds, complete the following steps.

1. Load the statements.

2. On the View/Edit Bank Feed page, do the following:

•  
  •  
    • Select the transactions you require to import. You may also select all.
    • Update the Ref. No., Payment Type, Cust./Supp., and Code columns.

To select all transactions, tick the tick box beside the Date column.

3. To import, click Import.

4. The Confirmation Message window appears. Review the message carefully and click Yes, if you are happy with the outcome.

5. A new feature has been implemented where the importing is queued and the progress of the same can be checked from the top left balloon notification.

6. The Import Bank Feeds page appears. It shows the bank feed is fully imported/partly imported/Queued as is the case.

BrightBooks can identify duplicate transactions in imported statements assuming that an imported statement has not already been manually updated. 
When you import a statement, BrightBooks checks the Date, Amount and the Ref. No. fields for duplicates. If matches are found, then a warning is provided. 
However, the decision to accept or decline the duplicates, if any, is with the user.

Auto-allocating Bank Feeds to Invoices

You can have bank feeds automatically allocated to all or selected customer or supplier invoices. Click the 'add' icon to view the steps.

Step 1: Settings

1. Log in and click the required business.

2. The Customers page appears. On the left panel, click Settings.

3. The Settings page appears. Under the ACCOUNTS heading, click Setup.

4. The Accounts Setup page appears. Now, complete the following actions:

•  
  •  
    • To fully auto-allocate all receipts to customer invoices, under the AUTO ALLOCATE RECEIPTS ON BANK FEED FOR CUSTOMERS list, select All.
    • To fully auto-allocate all payments to supplier invoices, under the AUTO ALLOCATE PAYMENTS ON BANK FEED FOR SUPPLIERS list, select All.

5. To save the settings, click Save.

Step 2: Auto-allocating Feeds

1. On the left panel, click Sales > Invoices & Credit Notes.

2. The Sales Invoices page appears. Note the unallocated invoices.

3. On the left panel, click Banking > Bank Feeds.

4. The Import Bank Feeds page appears. Click New.

5. The New Bank Feed page appears. Enter the required details, select the required bank feed file and click Load.

6. The View/Edit Bank Feed shows the various customer invoice receipts and supplier invoice payment records.

Post a bank feed load, the current status of the payments and receipt records in a bank feed is indicated with distinct colours. The meaning of the colours is explained in the table below.

COLOUR	MEANING
	Incomplete information in the loaded feed record. You are not allowed to import until you provide all necessary information.
	All data in the transaction record are correct.
	There can be either of the two meanings: The transaction in the bank feed is not allocated or it is already allocated and the allocation details are shown when you move the cursor over the colour.
	Potential duplicate transaction identified.

7. Select one or more receipt records, specify the customer from the lookup and the nominal codes and click Import.

8. The Confirmation Message appears. Review and click Yes, if you are happy with the outcome.

9. The Import Bank Feeds page shows the bank feed is fully or partly imported.

10. To verify the invoice allocation status, on the left panel, click Sales > Invoices & Credit Notes.

11. The Sales Invoices page appears. Note that the invoices are both fully and partly allocated already.

 

Allocating to Selected Invoices

Follow the same steps to auto-allocate to supplier invoices.