For enterprise users on our hosted platform, we have integrated with Yodlee a leading data aggregration platform.
Yodlee integration with most of the major global banks, allowing you to link your bank accounts with Invoice Ninja to import your bank transactions for reconciliation.
Settings > Bank Accounts > Connect
Clicking on the connect button with open a new browser window which connects to Yodlee, from this screen you are able to search for your bank and then log into your Bank Account
Once you have successfully authenticated with your bank, you'll be able to select the accounts you wish to link to Invoice Ninja, when this is completed, click save & finish.
Yodlee will give you the opportunity to add more bank accounts from different banks prior to exiting.
If you prefer to import your data using .csv files from your bank, you can upload these directly into Invoice Ninja
You can import these from
Settings > Import | Export > Bank Transactions
You'll need to have created a Bank Account prior to this, so the transactions are linked to the correct bank account.
Once data has been imported into Invoice Ninja, this can be viewed from the Transactions tab in the sidebar.
A transaction can appear in three states
A transaction that is unmatched is a transaction that has yet to be processed or categorized. When a transaction is created in the system, its first status is unmatched.
A transaction that is matched means that Invoice Ninja has calculated (based on a set of rules) the correct matching for this particular transaction. In the matched state, the transaction can be Converted (to either an expense or payment) or it can be recategorized manually.
A transaction that is converted means that either Invoice Ninja or a user has matched and converted the transaction into either an Expense or Payment. The details and linked objects can be viewed by clicking onto the transaction.
A transaction can be manually created or updated.
When you click on the transaction row, a side panel will appear as above.
From this panel you are able to assign a Vendor and/or an expense category to this transaction. When you are satisfied, just click on Convert to expense. The system will then process the transaction, convert it to an expense and finally link the expense and transaction together.
When you click on the transaction row, a side panel will appear as above.
From this panel you are able to click on a range of invoice which are to be associated with this transaction.
When this has been completed, click on the Create Payment Button. The system will then process the transaction, creating a payment for the full tranasction amount, apply the payment to the associated invoices, and then link the invoice / transaction and payments together.
To improve your efficiency, you can build a ruleset to match your incoming transactions.
Using a rule set will allow Invoice Ninja to performing the matching and/or conversion of transactions for you.
To create a bank rule navigate to
Settings > Back Accounts > Manage Rules
You can edit and create rules from this page, simply click on a rule, or the create button to create a new bank rule.
When creating a rule there are a number of options to consider:
When creating a rule there are a number of options available.
Operator - Description | when matching text there are several matching options available
Contains | The description must contain the value assigned
Is Empty | The description must be empty
Operator - Amount | when matching on the transaction amount there are several options available
< | The amount must be less than the value
>= | The amount must be greater than or equal to the value
Value | The user assigned value used to compare against.