Uploading a Bank Statement

  1. Go to Bank Statements under the Banking tab.
     

  2. Select a bank account from the drop down under the title.
    *Note: Make sure that at least 1 bank account is created for your company, if not, you can create that under chart of account.
     

  3. Upload a bank statement from your bank by clicking the Upload Bank Statement button.
    *Note: Currently, Eleven supports only a specific format of bank statement. Please find the csv template here: https://drive.google.com/open?id=1CJ2secczzC9zsRm2pdBPYyq-Q2d0CUXm
     

  4. On this page, to the right, please click the Import CSV button
     

  5. Download the template and then complete your own CSV.
     

  6. Import the CSV using the same interface.
     

  7. Refer to the template if you receive error message.

 

Connect to a Bank Account

  1. Go to Settings in the Invoicing app.
     

  2. Click on Connect to a Bank Account
     

  3. Search for the bank institution of your bank account.
     

  4. Key in your credentials accordingly.
     

  5. Follow instructions to verify your login. Type 'Yes' when authentication is done and click on submit.
     

  6. By default, all accounts will be added. Click on the delete icon to remove the account you do not want to keep.
     

  7. Click on Save and Finish when done.

Import Bank Feed

 

*Note: To import a bank feed, you will have to Connect to a Bank Account.
 

  1. At the Banking screen, under the Actions menu, click on Import from bank feed.
     

  2. Select the account of bank type you want to import your bank feed to.
     

  3. Select a connected bank account.
     

  4. Select to import all available transactions, or select a date range.
     

  5. Click import Save and Import.

Reconciling a Bank Statement Line

 
  1. In Bank Statements, go to the reconcile mode by clicking Reconcile.
     

  2. Select a bank statement line to be reconciled by checking the checkbox of the corresponding line on the left.
    *Note: You can select multiple bank account transactions to reconcile to multiple transaction lines.
     

  3. Select related bank account transactions recorded in Eleven on the right by checking the checkbox.
     

  4. Click Reconcile.

Viewing a Reconciliation

 
  1. In Bank Statements, identify a bank statement line you want to view.
    Note: The bank statement line should be reconciled. Reconciled lines are the ones with a check mark under the reconciled column.

     

  2. Click on the check mark of the line you want to check.
     

  3. You should be able to view the reconciled pair in a modal.

Viewing a Journal Entry

 
  1. To view a transaction journal entry, click on the icon at the top right corner of the transaction line.

Creating Payment or Receipt Base on Bank Transaction

 
  1. In Bank Statements, click on the Reconcile.
     

  2. Select a bank statement line. If the selected line does not have an available transaction to reconcile with, you can click on the Create Deposit/Withdrawal tab to create a transaction.
     

  3. Fill in the necessary information. Once you are done, click on the Create & Reconcile.

*Note: You can also create a payment or receipt in the General Ledger.
Click here to learn how: Creating Payments & Receipts

Matching Transactions After Creating and Reconciling a Payment or Receipt

 
  1. After creating and reconciling a receipt or payment, click on Match Transaction in the prompt message.
     

  2. Select a transaction in the list to match with. If there is no available transaction, click on the Resolve check box to add a transaction. Amount has to match the payment or receipt amount.
     

  3. Fill in the necessary information. Once you are done, click on the Match.

 

*Note: You can also match transactions in the General Ledger.
Click here to learn how: Matching Journal Entries Manually

USA

Phone: (713) 975-7453

6100 Corporate Drive Suite 470

Houston, TX 77036

Europe

Phone: +33 (0)1 85 65 17 77

116 Rue Saint Denis

Paris 75002, France

Asia

Phone: +65 3158 4760

562B Serangoon Road

Singapore 218178

Advanced  Accounting Software

© 2020 Eleven Pte Ltd