Collaborate on Open Invoice Example for Banking with Ease Using airSlate SignNow

Open invoice example for Banking

hi there Davey from invoice ninja today I'd like to take you through our latest feature which is banking Integrations we've integrated with yodley who's a leading data aggregation platform and they connect through to all of the major Banks across the world through the Americas Europe UK Australia through them you can log into your bank account and select accounts that you wish to then have transactions sent across into invoice ninja so that you can categorize and reconcile your accounts so how does this look in practice well on the hosted platform you'd go to settings and bank accounts and then connect and so this screen will then allow you to log into your bank account through Yardley here we go and you can search for your bank you can search for any of your Banks and you're not restricted to One bank or one account you can integrate with many banks and many bank accounts and have those transactions then pulled into invoice Ninja so how does it look once the data has been imported in well I've set up some test data here and this is what it will look like initially this is all raw data from yodley and you can see it starts with the status of unmatched lettuces can either be unmatched matched which is when we perform some matching for you based on some rules that you can create and then converted which means the transactions finally been linked to a payment or an expense let's go through and and see how this works we'll click on this first one here which is a deposit so it's going to be assigned to an invoice and you can assign it to multiple invoices and you can convert that to a payment so you can see here this transaction has been linked through to these three invoices if we click on the invoice we'll also be able to see the payment that was created as well for it great what about an expense well this is a withdrawal so that lines up with expenses so we'll click on this one here you can see you can assign the uh transaction to a vendor and a category and then we can convert this into an expense great you can see the expense has been created here okay what about if we took this to the next level and started creating some rules so if you have a lot of transactions with similar keywords in the descriptions you can intelligently match those and we can perform some actions for you so let's see through this list of Latin here whether we can find a common kind of word so a lot of Quee so we're going to create a a rule based on the word Queen foreign and let's go through back to settings bank accounts and we're going to manage some rules here so let's create a rule we're going to call it the query rule and this rule the description must contain the letters squeeze great you can see I can actually add multiple rules inside here too so let's take it one step further and so as well as Qui we want the amount to match and let's have it to be greater than two thousand dollars safe right we're going to assign it to a vendor the category and now what about these two options here match all rules what this means if it's turned on is that both of these rules have to hit so the description must have Quee in it and the amount must be greater than two thousand doesn't have those two rules we do not touch the transaction at all it passes through if we do get a hit we have a choice to make whether we just match it or whether we convert it into an expense so let's set this one off it's we're going to match on Qui for expenses over two thousand dollars let's hit save there and so in the background the system is going to perform some magic let's head back over the transaction lists and let's search for quick okay so we have a query it's an it's a withdrawal here which is over 2000 so that one should hit we have another query which is under 2 000. so this will be interesting so this one should convert this one should be left untouched so let us refresh the data here we go so you can see this one's correctly converted this one's been left excellent you can see the other ones which have also match on Queen but also correctly matched so let's just do a quick test and create another matching let's find a different word to match on this time non non's pretty popular in the Latin okay so we have three we've only got one withdrawal here that we can match on so we'll go for this one so let's create a new rule we'll call it non doesn't have to match on everything none and let's just set that we're going to give it a miscellaneous category metronome rules and we're going to convert it so this will match on our non and give it a category of misc and then if we go back to our transaction list and click not and refresh excellent It's converted so you can see you can quickly build very powerful a rule system which can go through match your transactions also convert them for you as well super powerful for payment transactions we automatically match for you based on invoice number and in the next version we're also going to be expanding this to be able to attach transactions to existing payments and existing expenses so you can link all of your transactions through that's a quick rundown on transactions we hope you enjoy it it works extremely well we're very pleased with the way it's turned out and we're sure it's going to be very useful for you and your business