{"id":21396,"date":"2021-08-19T17:35:17","date_gmt":"2021-08-19T16:35:17","guid":{"rendered":"https:\/\/bigredcloud.com\/?post_type=docs&#038;p=21396"},"modified":"2022-11-10T17:34:46","modified_gmt":"2022-11-10T17:34:46","password":"","slug":"big-red-cloud-open-banking","status":"publish","type":"docs","link":"https:\/\/bigredcloud.com\/en\/documents\/big-red-cloud-open-banking\/","title":{"rendered":"Big Red Cloud Open Banking"},"content":{"rendered":"<p>This guide has been written to instruct users in importing Bank transactions and create lodgements and bank payments.<\/p>\n<p><iframe loading=\"lazy\" class=\"lazy-loaded\" title=\"vimeo447126972\" src=\"https:\/\/player.vimeo.com\/video\/447126972?autoplay=0&amp;autopause=0\" width=\"600\" height=\"360\" allowfullscreen=\"allowfullscreen\" data-lazy-type=\"iframe\" data-src=\"https:\/\/player.vimeo.com\/video\/447126972?autoplay=0&amp;autopause=0\"><\/iframe><\/p>\n<h2>Locating the Bank Feed Button<\/h2>\n<p>Open Banking is a new system that will greatly improve the ability and reliability to import banking statements from your bank into the Big Red Cloud accounts. Big Red Cloud users should no longer need to download CSV files which can be awkward to use when using Open Banking. To bring this exciting new development to the Big Red Cloud we have teamed up with <a href=\"https:\/\/plaid.com\">Plaid<\/a> who have vast experiences in financial services software development<\/p>\n<p>1. Step one go to <u>Lookup<\/u> and <u>Bank Accounts<\/u>.<\/p>\n<p>And click on <u>Bank Feed<\/u><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21397\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/1-6.png\" alt=\"\" width=\"820\" height=\"606\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/1-6.png 820w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/1-6-300x222.png 300w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/1-6-768x568.png 768w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><\/p>\n<p>2. When the <u>Manage Bank Feed<\/u> window opens in the <u>Open Banking Import<\/u> section click on the <u>Manage Connections<\/u><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21398\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/2-4.png\" alt=\"\" width=\"822\" height=\"605\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/2-4.png 822w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/2-4-300x221.png 300w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/2-4-768x565.png 768w\" sizes=\"auto, (max-width: 822px) 100vw, 822px\" \/><\/p>\n<p>3. On the Manage Connections window click on Add<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21399\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/3-5.png\" alt=\"\" width=\"823\" height=\"606\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/3-5.png 823w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/3-5-300x221.png 300w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/3-5-768x566.png 768w\" sizes=\"auto, (max-width: 823px) 100vw, 823px\" \/><\/p>\n<p>4. The next window is a T&amp;C for Plaid to retrieve your data to offer these services you will need to click <u>Continue<\/u>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21400\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/4-4.png\" alt=\"\" width=\"364\" height=\"539\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/4-4.png 364w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/4-4-203x300.png 203w\" sizes=\"auto, (max-width: 364px) 100vw, 364px\" \/><\/p>\n<p>5. The next step you select your bank. To do so you simply look for your bank in the list and click on it or you can type the name of your bank in the search bar at the top of the window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21401\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/5-4.png\" alt=\"\" width=\"363\" height=\"536\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/5-4.png 363w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/5-4-203x300.png 203w\" sizes=\"auto, (max-width: 363px) 100vw, 363px\" \/><\/p>\n<p>6. From this point the steps are based on Revolut Banking method of authorization other banks methods will differ. When you select your bank it will give you an Authentication window read on screen instructions and click Continue<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21402\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/6-4.png\" alt=\"\" width=\"365\" height=\"539\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/6-4.png 365w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/6-4-203x300.png 203w\" sizes=\"auto, (max-width: 365px) 100vw, 365px\" \/><\/p>\n<p>7. Once you click Continue on the previous step it will open a new smaller window.<\/p>\n<p>On this window you will need to enter your Phone number to authorize Plaid then click\u00a0<u>Continue<\/u><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21403\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/7-2.png\" alt=\"\" width=\"673\" height=\"461\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/7-2.png 673w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/7-2-300x205.png 300w\" sizes=\"auto, (max-width: 673px) 100vw, 673px\" \/><\/p>\n<p>8. On the Next window you will need to enter your Revolut App Pin<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21404\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/8-3.png\" alt=\"\" width=\"741\" height=\"646\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/8-3.png 741w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/8-3-300x262.png 300w\" sizes=\"auto, (max-width: 741px) 100vw, 741px\" \/><\/p>\n<p>9. You will receive a 6 digit code to your phone that will need to be entered into the next window, and click\u00a0<u>Continue<\/u>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21405\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/9-3.png\" alt=\"\" width=\"653\" height=\"573\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/9-3.png 653w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/9-3-300x263.png 300w\" sizes=\"auto, (max-width: 653px) 100vw, 653px\" \/><\/p>\n<p>10. The authorization window will display, and you will need to click on\u00a0<u>Authorize<\/u>. It will then take a moment to return a\u00a0<u>Granted<\/u><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21406\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/10-3.png\" alt=\"\" width=\"610\" height=\"572\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/10-3.png 610w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/10-3-300x281.png 300w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/p>\n<p>11. The next window will be a confirmation window and to confirm which bank account if you have more than one.<\/p>\n<p>Click\u00a0<u>Continue<\/u><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21407\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/11-3.png\" alt=\"\" width=\"363\" height=\"539\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/11-3.png 363w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/11-3-202x300.png 202w\" sizes=\"auto, (max-width: 363px) 100vw, 363px\" \/><\/p>\n<p>12. That is the end of the authorization process final step is to map the bank.<\/p>\n<p>In the drop down select the Big Red Cloud Bank Account you wish to be mapped to the bank to and click on\u00a0<u>Save<\/u>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21408\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/12-2.png\" alt=\"\" width=\"686\" height=\"507\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/12-2.png 686w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/12-2-300x222.png 300w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/p>\n<p>13. To import transaction from your Bank you will now need to go to Lookup and Bank Accounts and highlight the bank setup for Open Banking then click on\u00a0<u>Bank Feed<\/u><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21409\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/13-2.png\" alt=\"\" width=\"823\" height=\"606\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/13-2.png 823w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/13-2-300x221.png 300w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/13-2-768x566.png 768w\" sizes=\"auto, (max-width: 823px) 100vw, 823px\" \/><\/p>\n<p>14. Then click on the button\u00a0<u>Import from Open Banking<\/u><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21410\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/14-2.png\" alt=\"\" width=\"821\" height=\"608\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/14-2.png 821w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/14-2-300x222.png 300w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/14-2-768x569.png 768w\" sizes=\"auto, (max-width: 821px) 100vw, 821px\" \/><\/p>\n<p>15. On the next window it will prompt you to input the period you wish to import banking transaction for.<\/p>\n<p>Select the dates and click on OK<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21411\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/15-2.png\" alt=\"\" width=\"820\" height=\"609\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/15-2.png 820w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/15-2-300x223.png 300w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/15-2-768x570.png 768w\" sizes=\"auto, (max-width: 820px) 100vw, 820px\" \/><\/p>\n<p>If you now click \u2018Ok\u2019 you will be brought to the Review and Import Transactions Screen where you will see a list of the transactions within your file and the options available for them.<\/p>\n<p>Any Credit transactions with a date inside your current financial year will be automatically ticked to create both a Cash Receipt and a Lodgement.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21412\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628074612770.png\" alt=\"\" width=\"782\" height=\"334\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628074612770.png 782w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628074612770-300x128.png 300w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628074612770-768x328.png 768w\" sizes=\"auto, (max-width: 782px) 100vw, 782px\" \/><\/p>\n<p>The screen above is split into 4 sections (the first 3 of which are visible above).<\/p>\n<p>On the left hand section you have the transaction details;<br \/>\n\u2022 Date<br \/>\n\u2022 Debit and Credit amounts<br \/>\n\u2022 The Description.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21413\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628074854122.png\" alt=\"\" width=\"289\" height=\"309\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628074854122.png 289w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628074854122-281x300.png 281w\" sizes=\"auto, (max-width: 289px) 100vw, 289px\" \/><\/p>\n<p>In the second column you have the Cash Receipts details;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21414\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628075119623.png\" alt=\"\" width=\"352\" height=\"307\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628075119623.png 352w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628075119623-300x262.png 300w\" sizes=\"auto, (max-width: 352px) 100vw, 352px\" \/><\/p>\n<p>\u2022 A check box to pick whether or not the Cash Receipt is created<br \/>\n\u2022 A drop down list to choose the period it is added to if it is created<br \/>\n\u2022 A radio button to say if it is a Cash Receipt from a customer (Ledger) or not (Non-Ledger)<br \/>\n\u2022 In each of those cases a drop down list to choose the Customer Account or the Analysis Category the entry will be added to.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21415\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628075259215.png\" alt=\"\" width=\"236\" height=\"74\" \/><\/p>\n<p>On the right are the lodgements, here you have;<br \/>\n\u2022 A check box to pick whether or not the lodgement is created<br \/>\n\u2022 A dropdown list to choose the period it will be added to.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21416\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628075410137.png\" alt=\"\" width=\"185\" height=\"324\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628075410137.png 185w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628075410137-171x300.png 171w\" sizes=\"auto, (max-width: 185px) 100vw, 185px\" \/><\/p>\n<p>Currently only the Cash Receipts and Lodgements (the Credit transactions) can be imported so the Debit options (Bank Payments) cannot be ticked at this time.<\/p>\n<p>If you use Vat on Cash Receipts you will have two extra columns, Vat Type and VAT Rate.<br \/>\nThese columns will allow you to set the VAT Type for your entry (Shown Below) as well as the VAT Rate that will apply for it.<br \/>\nThe Vat Rates available will be your usual VAT rates as set in \u2018Setup\u2019 -&gt; \u2018Vat Rates\u2019.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21417\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180822115025504.png\" alt=\"\" width=\"610\" height=\"366\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180822115025504.png 610w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180822115025504-300x180.png 300w\" sizes=\"auto, (max-width: 610px) 100vw, 610px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21418\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180822115051973.png\" alt=\"\" width=\"242\" height=\"303\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180822115051973.png 242w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180822115051973-240x300.png 240w\" sizes=\"auto, (max-width: 242px) 100vw, 242px\" \/><\/p>\n<p>to the right are the lodgements, here you have;<br \/>\n\u2022 A check box to pick whether or not the lodgement is created<br \/>\n\u2022 A dropdown list to choose the period it will be added to.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21419\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926113815532.png\" alt=\"\" width=\"278\" height=\"492\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926113815532.png 278w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926113815532-170x300.png 170w\" sizes=\"auto, (max-width: 278px) 100vw, 278px\" \/><\/p>\n<p>On the far right is the Bank Payment details;<br \/>\n\u2022 A check box to pick whether or not the Bank Payment is created<br \/>\n\u2022 A dropdown list to choose the period it is added to if it is created<br \/>\n\u2022 A radio button to say if it is a Payment to a Supplier (Ledger) or not (Non-Ledger)<br \/>\n\u2022 In each of those cases a dropdown list to choose the Supplier Account or the Analysis Category the entry will be added to.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21420\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180822115305954.png\" alt=\"\" width=\"599\" height=\"501\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180822115305954.png 599w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180822115305954-300x251.png 300w\" sizes=\"auto, (max-width: 599px) 100vw, 599px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21421\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180822115338557.png\" alt=\"\" width=\"443\" height=\"125\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180822115338557.png 443w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180822115338557-300x85.png 300w\" sizes=\"auto, (max-width: 443px) 100vw, 443px\" \/><\/p>\n<p>Once you click the Create Transactions option Big Red Cloud will process the ticked transactions and create a lodgement (as a Cash Payment) or a receipt (as a Cash Receipt) for each of them within the Cash Book.<br \/>\nOnce done it will return a message telling you how many transactions have been created and the total value of all created transactions.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21422\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180628075525876.png\" alt=\"\" width=\"301\" height=\"135\" \/><\/p>\n<p>If the transaction validation fails when \u2018Create Transactions\u2019 is clicked you will need to correct those errors before the\u00a0import can succeed.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Creating Bank Feed Rules<\/strong><\/p>\n<p>It is possible to create rules which can be applied to your bank files in order to make the import easier.<br \/>\nThe rule manager is opened by selecting \u2018Manage Rules\u2019 at the bottom left of the screen once you have loaded a Bank Feeds file and opens the following screen<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21423\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114125366.png\" alt=\"\" width=\"988\" height=\"611\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114125366.png 988w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114125366-300x186.png 300w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114125366-768x475.png 768w\" sizes=\"auto, (max-width: 988px) 100vw, 988px\" \/><br \/>\nOnce the screen has been opened select \u2018Add\u2019 to create a new rule and the \u2018Add a Matching Rule\u2019 option will appear.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21424\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114205271.png\" alt=\"\" width=\"1212\" height=\"528\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114205271.png 1212w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114205271-300x131.png 300w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114205271-1024x446.png 1024w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114205271-768x335.png 768w\" sizes=\"auto, (max-width: 1212px) 100vw, 1212px\" \/><\/p>\n<p>Rules can be based on the Description line and\/or the Amount of the entry in the Bank Feeds file and can have conditions set on them to assist in matching the contents of your file.<\/p>\n<p><strong>Rules Conditions:\u00a0<\/strong><br \/>\nConditions are set on the added rules.<br \/>\nThese conditions are used to decide what rules are applied to what transactions in the Bank Feed File.<br \/>\nRules are applied from top to bottom and only the first matching rule is applied.<br \/>\nIE. The first rule entered to the list will be the first rule applied to an entry from the Bank Feed file. If that rule does not match the entry the second rule that was added will be applied to see if it matches.<br \/>\nThis will continue until a matching rule has been applied to the entry at which point it will move on to the next entry from your file and no further rules will be matched against that entry.<br \/>\nYou can match a rule to an entry in your Bank Feeds file using the Description line from the file, the Amount of the entry (which checks against both Debit and Credit) or both.<br \/>\nFor each of Description and Amount you select your condition (explained below) and then enter the details that you wish to use to match your entry to the field on the right.<\/p>\n<p>For Description you have;<br \/>\n\u2013 Contains: The text you enter on the right appears somewhere in the description<br \/>\n\u2013 Begins With: The text you enter on the right appears at the start of the description<br \/>\n\u2013 Ends With: The text on the right will appear at the end of the description<br \/>\n\u2013 Equals: The text you enter will be exactly the same as the text in the description<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21425\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114358007.png\" alt=\"\" width=\"435\" height=\"329\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114358007.png 435w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114358007-300x227.png 300w\" sizes=\"auto, (max-width: 435px) 100vw, 435px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21426\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114448807.png\" alt=\"\" width=\"419\" height=\"415\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114448807.png 419w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114448807-300x297.png 300w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114448807-150x150.png 150w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114448807-100x100.png 100w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114448807-140x140.png 140w\" sizes=\"auto, (max-width: 419px) 100vw, 419px\" \/><\/p>\n<p>For Amount you have;<br \/>\n\u2013 =: The Amount of the entry from the file will be equal to the number entered on the right<br \/>\n\u2013 &gt;: The Amount of the entry from the file will be less than the number entered on the right<br \/>\n\u2013 &lt;: The Amount of the entry from the file will be greater than the number entered on the right<br \/>\n\u2013 &gt;=: The Amount of the entry from the file will be less than or equal to the number entered on the right<br \/>\n\u2013 &lt;=: The Amount of the entry from the file will be greater than or equal to the number entered on the right<br \/>\n\u2013 &lt;&gt;: The Amount of the entry from the file will not be equal to the number entered on the right<br \/>\n\u2013 Between: The Amount of the entry from the file will be between the 2 values entered on the right<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21427\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114549251.png\" alt=\"\" width=\"1126\" height=\"193\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114549251.png 1126w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114549251-300x51.png 300w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114549251-1024x176.png 1024w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114549251-768x132.png 768w\" sizes=\"auto, (max-width: 1126px) 100vw, 1126px\" \/><\/p>\n<p><strong>Transaction(s) to Update<br \/>\n<\/strong>Once a rule has been matched to an entry the \u2018Transaction(s) to Update\u2019 section is checked and the choices made in it are applied to the entry.<br \/>\nYour rules can be applied to a Cash Receipt, Bank Payment or both in the case of general rules that may match each side.<br \/>\nYou have the option to make the entry a Ledger entry and select a Customer or Supplier account for it to apply to or a Non-Ledger entry and select an Analysis Category for it to apply to.<br \/>\nThis is done by clicking the radio button and then choosing the account or category from the field beside it.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21428\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114731530.png\" alt=\"\" width=\"1240\" height=\"167\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114731530.png 1240w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114731530-300x40.png 300w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114731530-1024x138.png 1024w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114731530-768x103.png 768w\" sizes=\"auto, (max-width: 1240px) 100vw, 1240px\" \/><\/p>\n<p><strong>Applying The Rules<\/strong><br \/>\nOnce you have created some rules for you Bank files they can be applied from the Manage Rules screen.<br \/>\nOnce it opens you will see all of your existing rules (which will be ticked) and will have the option to Add any new rules, Delete any rules that you will no longer be using or to Apply the rules to your Bank Feeds file.<br \/>\nPlease note that any unticked rules will be bypassed so it is possible to skip rules that you do not wish to apply at this time by unchecking them.<br \/>\nThis does mean that later rules that also match that transaction will be applied to it instead if they are still ticked however.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21429\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114826927.png\" alt=\"\" width=\"1227\" height=\"282\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114826927.png 1227w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114826927-300x69.png 300w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114826927-1024x235.png 1024w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114826927-768x177.png 768w\" sizes=\"auto, (max-width: 1227px) 100vw, 1227px\" \/><\/p>\n<p>After choosing the \u2018Apply Rules\u2019 button any selected (ticked) rules will be processed against your Bank Feeds file and applied.<br \/>\nBig Red Cloud will then return a message to you telling you how many entries were matched by the chosen rules for each of the Bank Payments and Cash Receipts.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-21430\" src=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114909643.png\" alt=\"\" width=\"401\" height=\"236\" srcset=\"https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114909643.png 401w, https:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/capture20180926114909643-300x177.png 300w\" sizes=\"auto, (max-width: 401px) 100vw, 401px\" \/><\/p>\n<p>Once you click \u2018OK\u2019 you will be returned to the Transaction Review screen and can check to see if there are any entries that were not matched by your rules. You can then attempt to apply more rules if required (or if you had any unticked previously) or categorise those entries manually.<br \/>\nOnce done, or if there were no transactions left uncategorised by your rules, you can click \u2018Create Transactions\u2019 to add the transactions to Big Red Cloud as normal.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This guide has been written to instruct users in importing Bank transactions and create lodgements and bank payments. Locating the&#8230;<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"footnotes":""},"doc_category":[210,213],"doc_tag":[],"class_list":{"0":"post-21396","1":"docs","2":"type-docs","3":"status-publish","5":"doc_category-payments-book","6":"doc_category-utilities"},"year_month":"2026-04","word_count":1810,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"apathak","author_nicename":"apathak","author_url":"https:\/\/bigredcloud.com\/en\/author\/apathak\/"},"doc_category_info":[{"term_name":"Payments Book","term_url":"https:\/\/bigredcloud.com\/en\/docs-category\/payments-book\/"},{"term_name":"Utilities","term_url":"https:\/\/bigredcloud.com\/en\/docs-category\/utilities\/"}],"doc_tag_info":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.3) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Big Red Cloud Open Banking - Big Red Cloud<\/title>\n<meta name=\"description\" content=\"This guide has been written to instruct users in importing Bank transactions and create lodgements and bank payments. Locating the Bank Feed Button Open\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bigredcloud.com\/documents\/big-red-cloud-open-banking\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Big Red Cloud Open Banking\" \/>\n<meta property=\"og:description\" content=\"This guide has been written to instruct users in importing Bank transactions and create lodgements and bank payments. Locating the Bank Feed Button Open\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bigredcloud.com\/documents\/big-red-cloud-open-banking\/\" \/>\n<meta property=\"og:site_name\" content=\"Big Red Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SimpleOnlineAccounts\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-10T17:34:46+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/1-6.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@BigRedCloud\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"15 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Big Red Cloud Open Banking - Big Red Cloud","description":"This guide has been written to instruct users in importing Bank transactions and create lodgements and bank payments. Locating the Bank Feed Button Open","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bigredcloud.com\/documents\/big-red-cloud-open-banking\/","og_locale":"en_US","og_type":"article","og_title":"Big Red Cloud Open Banking","og_description":"This guide has been written to instruct users in importing Bank transactions and create lodgements and bank payments. Locating the Bank Feed Button Open","og_url":"https:\/\/bigredcloud.com\/documents\/big-red-cloud-open-banking\/","og_site_name":"Big Red Cloud","article_publisher":"https:\/\/www.facebook.com\/SimpleOnlineAccounts","article_modified_time":"2022-11-10T17:34:46+00:00","og_image":[{"url":"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/1-6.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@BigRedCloud","twitter_misc":{"Est. reading time":"15 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bigredcloud.com\/documents\/big-red-cloud-open-banking\/","url":"https:\/\/bigredcloud.com\/documents\/big-red-cloud-open-banking\/","name":"Big Red Cloud Open Banking - Big Red Cloud","isPartOf":{"@id":"https:\/\/bigredcloud.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bigredcloud.com\/documents\/big-red-cloud-open-banking\/#primaryimage"},"image":{"@id":"https:\/\/bigredcloud.com\/documents\/big-red-cloud-open-banking\/#primaryimage"},"thumbnailUrl":"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/1-6.png","datePublished":"2021-08-19T16:35:17+00:00","dateModified":"2022-11-10T17:34:46+00:00","description":"This guide has been written to instruct users in importing Bank transactions and create lodgements and bank payments. Locating the Bank Feed Button Open","breadcrumb":{"@id":"https:\/\/bigredcloud.com\/documents\/big-red-cloud-open-banking\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bigredcloud.com\/documents\/big-red-cloud-open-banking\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/bigredcloud.com\/documents\/big-red-cloud-open-banking\/#primaryimage","url":"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/1-6.png","contentUrl":"http:\/\/bigredcloud.com\/wp-content\/uploads\/2021\/08\/1-6.png"},{"@type":"BreadcrumbList","@id":"https:\/\/bigredcloud.com\/documents\/big-red-cloud-open-banking\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bigredcloud.com\/en\/"},{"@type":"ListItem","position":2,"name":"Docs","item":"https:\/\/bigredcloud.com\/en\/documents\/"},{"@type":"ListItem","position":3,"name":"Big Red Cloud Open Banking"}]},{"@type":"WebSite","@id":"https:\/\/bigredcloud.com\/#website","url":"https:\/\/bigredcloud.com\/","name":"Big Red Cloud","description":"Online Accounting Software","publisher":{"@id":"https:\/\/bigredcloud.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bigredcloud.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/bigredcloud.com\/#organization","name":"Big Red Cloud","url":"https:\/\/bigredcloud.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/bigredcloud.com\/#\/schema\/logo\/image\/","url":"https:\/\/bigredcloud.com\/wp-content\/uploads\/2025\/07\/unnamed-1.png","contentUrl":"https:\/\/bigredcloud.com\/wp-content\/uploads\/2025\/07\/unnamed-1.png","width":512,"height":512,"caption":"Big Red Cloud"},"image":{"@id":"https:\/\/bigredcloud.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SimpleOnlineAccounts","https:\/\/x.com\/BigRedCloud","https:\/\/www.linkedin.com\/company\/big-red-cloud\/?originalSubdomain=ie"]}]}},"_links":{"self":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/docs\/21396","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/comments?post=21396"}],"version-history":[{"count":0,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/docs\/21396\/revisions"}],"wp:attachment":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/media?parent=21396"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/doc_category?post=21396"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/doc_tag?post=21396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}