Converting a bank statement in PDF/image to CSV for import
Go to Documents then click on the Bank Statement tab.
Click on upload to select one or multiple PDF/image files to upload,
The status of the file will be changed to Ready once the conversion is completed.
Download the CSV to review and make any changes if necessary.
Go to Banking from the top menu navigation
Click on import and select the reviewed CSV file.
In case there are errors, we'll generate an error report. You can download the report and fix the errors in your import CSV file. To fix the errors, please refer to this document.
Uploading a bank statement
Go to Bank Statements under the Banking tab.
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.
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
On this page, to the right, please click the Import CSV button
Download the template and then complete your own CSV.
Import the CSV using the same interface.
In case there are errors, we'll generate an error report. You can download the report and fix the errors in your import CSV file. To fix the errors, please refer to this document.
Reconciling a bank statement line
In Bank Statements, go to the reconcile mode by clicking Reconcile.
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.
Select related bank account transactions recorded in Eleven on the right by checking the checkbox.
Click Reconcile.
Viewing a reconciliation
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.
Click on the check mark of the line you want to check.
You should be able to view the reconciled pair in a modal.
Viewing a Journal Entry
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 (coming soon)
In Bank Statements, click on the Reconcile.
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.
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 (coming soon)
After creating and reconciling a receipt or payment, click on Match Transaction in the prompt message.
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.
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
Setting up bank feed
Go to Bank Statements under the Banking tab.
Under the actions menu, click on Setup Bank Feed.
Follow the instructions in the prompt and login into your bank account.
Select the bank account(s) you want to connect.
Connecting the bank account might take a while.
Importing bank feed
Go to Bank Statements under the Banking tab.
Under the actions menu, click on Import from Bank Feed.
Select the bank account from the charts of account you want the bank feed to be imported to.
Select the bank feed to import.
You can choose to import all available transactions or select a date range. Note: If you import all available transactions more than once, you might import duplicate transactions.
See what Eleven can do for you
Book a personal live demo to see how Eleven can streamline your accounting practice and tasks.