Bank Feed

Overview

Surf Accounts team works with an aim to present to you new features which are easy to apply while accounting through the software. In Surf Accounts a new feature has been introduced which allows you to synchronize receipts and payments with your cloud based accounting software based on the bank statements received. You can set Import Rules for each note within the statement in Surf Accounts and add imported transactions directly within customer or supplier accounts. This will allow you to reconcile payments and receipts easily with your financial books with your bank.

The objective of the Bank Statement Import is to allow for the import of Statements directly into Surf Accounts from CSV files (or XLS files) provided by the businesses bank.

Import Bank Feed into Surf Accounts

Importing Bank Feed into Surf Accounts will be a two step process where the user will be able to preview the data before importing the live transaction.

To import the bank feed in Surf Accounts select Banking» Import Bank Feeds the following screen will appear. 

Bank_Feed_Image_I.jpg

By selecting the Import Bank Feeds a new browser will appear to import the *CSV files into Surf Accounts. The following screen will appear. 

Bank_Feed_Image_II.jpg

Go to top   uparrow.png

How to Import Bank Feeds

To import the *CSV or excel file select the “Add” option the new bank feed browser will appear. Select the bank account, bank name, file name, and type of transaction (receipts/ payments or all transactions). 

Bank_Feed_Image_III.jpg

Bank Account

Select the Bank Account from the drop down. For e.g. by default, the Bank Account will be the Bank Current Account with nominal code 771. To change the bank account, use the drop down button. The pre defined Bank Accounts are Bank Current Account with a nominal code 771, Cash Control account with a nominal code of 782, Bank Deposit Account with a nominal code of 777 and Petty Cash Account of 781.   

Bank_Feed_Image_IV.jpg

 

 

Bank Feed

Select the Bank Account from the drop down.

File Name

Select the correct *CSV file (Statement provided by your business bank) to upload into Surf Accounts. By selecting the “Select File” option system will prompt to select the “CSV file”. Select the CSV file to import the Bank Statement.

Import

The most significant part of Bank Feed is importing the statement into Surf Accounts. If you wish to import all transactions (Payment & Receipts) of the statement select “All Transaction” from the drop-down menu. If you wish to import payments or receipts only select the one as per business requirement. Please note system does not allow importing Payment or Receipts separately on a same date, you can select the “All Transactions” from the next browser. To import “Payment” or “Receipt” select “Payments Only” or “Receipt Only” respectively.

Load

Once the transaction type is selected, select the “Load” button to import the statement and you will be redirected to the next browser.

Bank Account

The type of the Bank Account with the nominal code is displayed under the Bank Account column. For e.g. if the transaction is imported under the Bank Current Account browser display of the bank account will be 771 bank current account.

Bank Feeds

The name of the business bank will appear in the Bank Feed column.

File Name

The file name which has been imported into Surf Accounts is displayed in the browser as “File Name”.

Statement Date

The Statement date is displayed under this column.

Import

This shows the transaction type. For e.g. if “Payments” are imported under the import column it displays as “Payments”. You can import Transactions into Surf Accounts into “Quick Batches” (Payments & Receipts) where import is checked.

Date

The transaction date of the Statement will appear under the Date column of the browser.

Ref No.

Reference number is an optional column. If there is any reference number in the statement it is displayed under the Reference number column of the browser.

Notes

The notes column will display the notes, if any.

Payment

Amount of the statement is displayed under the payment column of the browse.

Receipt

Receipt amount of the statement is displayed under the receipt column of the browse.

Total

The total of receipt and payment amount is displayed under the “Total” column.

Note

Please note Import Transaction in Surf Accounts into “Quick Batches” (Payments and Receipts) where import check box is checked. Once the bank feed is updated cannot be re-updated.

Select the “Import” check box from the “New Bank Feed” browse. Select the transactions you want to import and select the “Import” button from the browse. The selected transactions will be imported into the Surf Accounts. Select 'Import' to import the transactions into Surfaccoutns. A confirmation message will appear on the browse.

bankfeed1.jpg

By selecting "Yes' the transaction will be imported into Surf Accounts. Please note, the number of transaction you want to import into Surf Accounts depends upon the business plan.

Go to top   uparrow.png

Import Bank Feed Rule   

To activate the Bank Feed Rules into Surf Accounts user needs the permission from the user access under the settings tab. To import the bank statement user must have the access right. To activate the import bank feed rule select Settings» Business Details » Users »Open Bank Feed Rules. The following “Permission” pop up will appear on the browse.

 

Bank_Feed_Image_VI.png

Setting up Bank Feed Rule

Surf Accounts has introduced a feature to setup a rule for the Bank Feed for the payment and receipt transaction. To reduce the effort and to avoid duplicate transaction entry from the bank statement while importing the transactions into Surf Accounts user can set a rule for the Bank Feed for all receipts and payments.  
To set up the Bank Feed rule select the "Make Rule' button from the Bank Feed Browse. The following screen will appear.  

Image_16.png

Go to top   uparrow.png

Edit The Bank Feed

To edit the Bank Feed Rule select the Edit Button from the Bank Feed Browse. The following screen will appear.

Image_20.png

 

Ref No. 

Enter the reference number here. 

Payment Type

To edit the 'Payment Type' select the drop down menu. Different 'Payment Type' will appear. For e.g. cash, cheque. Select the appropriate payment type.

Customer Code

Select the customer code by using the look up button. 

VAT Code

To modify the VAT codes use   the drop down. For e.g. if the VAT rate is reduced as 13.5%, you can change   it into reduced from Standard VAT Rate. 

Nominal Code

To modify the nominal code use the look up button. 

 Go to top   uparrow.png

Generating Bank Feed Report

To generate the Bank Feed report select Accounts» General Ledger »Import Bank Feed and select the Print option the following screen will be generated.

Bank_Feed_Report_Image_I.jpg

The bank feed report displays the following infomation column wise.

Date

The statement date is displayed under this column.

Ref No.

The reference number is displayed here if any.

Payment Type

The payment type in the statement is displayed under this column.

Notes

The notes of the transaction is displayed under ‘Notes’ column if any.

Customer/ Supplier

As per the statement this column displays whether it is a customer or supplier.

Payment

The payment amount is displayed in the ‘Payment’ column.

Receipt

The receipt amount is displayed in the ‘Receipt’ column.

VAT Code

The VAT code of transaction displayed in the statement is displayed in the ‘VAT Code’ column.

VAT Amount

The VAT amount of the transaction in the statement is displayed in the ‘VAT Amount’ column.

Nominal Code

The nominal code of the transaction in the imported statedment is displayed in the nominal code column.

Import

If the statement is already imported into Surfaccount.

Total

The total receipt and the payment amount of the statement after successful import into Surf Accounts displays under the total column.

Go to top   uparrow.png

Toolbar functionality of the Reporting Browse (Print, Email & Save):

Print

To print the Bank Feed Reports select the print option from the toolbar of the reporting browse. A preview will be generated to print the report.

Excel

To download the reports in MS excel format select the “Excel” option. The report will be downloaded to the local machine in a spread sheet.

Save

To save the Import Bank Feed Report select the save option from the toolbar. The report will be downloaded to the local machine in PDF format.

Email

To send the Bank Feed Report through email, select the “Email” option of the toolbar. A pop up will be generated.

 

To: Enter the email address of the recipient.

 

CC/ BCC: Enter the email address if you wish to send a copy of the report.

 

Subject: Enter the subject line in the mail dialogue box.

 

Attachment: The recipient will receive the report as an attachment (PDF file).

Bank_Feed_Report_Image_II.jpg

Go to top   uparrow.png

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk