{"id":269,"date":"2021-02-22T13:26:00","date_gmt":"2021-02-22T13:26:00","guid":{"rendered":"https:\/\/www.orama.ai\/academy-tesoreria\/automatic-transaction-reconciliation\/"},"modified":"2026-10-22T21:53:10","modified_gmt":"2026-10-22T21:53:10","slug":"automatic-transaction-reconciliation","status":"publish","type":"post","link":"https:\/\/www.orama.ai\/en\/academy-tesoreria\/automatic-transaction-reconciliation\/","title":{"rendered":"Automatic transaction reconciliation"},"content":{"rendered":"<p>Orama&#8217;s automatic transaction reconciliation will save you hours of work in your day-to-day!<\/p>\n<h2>What is transaction reconciliation?<\/h2>\n<p>To keep your cash flow forecast up to date, you should remove from your forecasts the collections and payments that you have already paid or collected. This process is done through the reconciliation of bank transactions with their corresponding forecast.<\/p>\n<p>For example, if you have a balance in your bank accounts of \u20ac5,000, and you expect to pay office rent of \u20ac1,000 at the end of this month, your forecast will indicate that you will end the month with a total bank balance of \u20ac4,000.<\/p>\n<p><img fetchpriority=\"high\" width=\"1600\" height=\"860\" src=\"https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ConciliacionMovimientos.webp\" class=\"wp-image-609 size-full\" alt=\"Orama transaction reconciliation screen: a bank transaction assigned to its line item\" decoding=\"async\" srcset=\"https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ConciliacionMovimientos.webp 1600w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ConciliacionMovimientos-300x161.webp 300w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ConciliacionMovimientos-1024x550.webp 1024w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ConciliacionMovimientos-768x413.webp 768w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ConciliacionMovimientos-1536x826.webp 1536w\" sizes=\"(max-width: 1600px) 100vw, 1600px\" \/><\/p>\n<p>By the time you pay for the office, your bank balance will have dropped to \u20ac4,000, so you must reconcile this item in your forecasts, otherwise your forecast bank balance at the end of the month would be \u20ac3,000 as you still have the forecast rent payment of \u20ac1,000.<\/p>\n<p><img width=\"1600\" height=\"720\" src=\"https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ConYSinConciliacion.webp\" class=\"wp-image-611 size-full\" alt=\"With and without reconciliation: without reconciling, the month-end forecast is \u20ac3,000; reconciling, it is \u20ac4,000\" decoding=\"async\" srcset=\"https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ConYSinConciliacion.webp 1600w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ConYSinConciliacion-300x135.webp 300w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ConYSinConciliacion-1024x461.webp 1024w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ConYSinConciliacion-768x346.webp 768w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ConYSinConciliacion-1536x691.webp 1536w\" sizes=\"(max-width: 1600px) 100vw, 1600px\" \/><\/p>\n<p>As you can see, by not doing a reconciliation, you expect to end the month with \u20ac3,000 in cash, which is wrong. However, when you reconcile you update your cash flow forecast by correctly forecasting to end the month with \u20ac4,000 of cash in banks.<\/p>\n<p>Orama brings in your bank transactions up to 4 times a day (every 6 hours) and suggests which forecast to reconcile each one with. And with automatic reconciliation rules, you do not even have to review them.<\/p>\n<h2>Automatic transaction reconciliation in Orama<\/h2>\n<p>The reconciliation of new payments and receipts from the bank with your forecast item&#8230; is <strong>completely automatic<\/strong>! You set the rules for automatic reconciliation, and if they are met, the transaction will be applied directly to the corresponding forecast.<\/p>\n<p>To edit the reconciliation rules, simply click on one of the line items, and in the slider on the right there will be a &#8220;Features&#8221; tab, where you will find the keywords assigned to that particular line item. Click on the small arrow and the reconciliation settings for that line item will open.<\/p>\n<figure id=\"attachment_603\" aria-describedby=\"caption-attachment-603\" style=\"width: 1600px\" class=\"wp-caption alignnone\"><img width=\"1600\" height=\"760\" src=\"https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ReglasConciliacion.webp\" class=\"wp-image-603 size-full\" alt=\"Reconciliation rules for a line item in Orama: mandatory, optional and rejected words, amounts and automatic reconciliation\" decoding=\"async\" srcset=\"https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ReglasConciliacion.webp 1600w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ReglasConciliacion-300x143.webp 300w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ReglasConciliacion-1024x486.webp 1024w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ReglasConciliacion-768x365.webp 768w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-ReglasConciliacion-1536x730.webp 1536w\" sizes=\"(max-width: 1600px) 100vw, 1600px\" \/><figcaption id=\"caption-attachment-603\" class=\"wp-caption-text\">Automatic transaction reconciliation<\/figcaption><\/figure>\n<p>Here you will find the reconciliation rules, where you will have different concepts. Remember that the fields you leave blank will be disabled.<\/p>\n<figure id=\"attachment_605\" aria-describedby=\"caption-attachment-605\" style=\"width: 1600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" width=\"1600\" height=\"560\" src=\"https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-PalabrasClave.webp\" class=\"wp-image-605 size-full\" alt=\"Reconciliation keywords in Orama: one mandatory word and one rejected word in a line item\" decoding=\"async\" srcset=\"https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-PalabrasClave.webp 1600w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-PalabrasClave-300x105.webp 300w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-PalabrasClave-1024x358.webp 1024w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-PalabrasClave-768x269.webp 768w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-PalabrasClave-1536x538.webp 1536w\" sizes=\"(max-width: 1600px) 100vw, 1600px\" \/><figcaption id=\"caption-attachment-605\" class=\"wp-caption-text\">Automatic reconciliation of transactions by keywords<\/figcaption><\/figure>\n<ul>\n<li><strong>Mandatory words: <\/strong>words that must appear in the bank transaction in order to be reconciled. If you enter more than one word, all of them must appear in the transaction description.<\/li>\n<li><strong>Optional words:<\/strong> simply one of the words you indicate as optional will have to appear. If, for example, you enter the optional words &#8220;Google&#8221; and &#8220;LinkedIn&#8221;, the payments for both items will be reconciled to this line item.<\/li>\n<li><strong>Rejected words: <\/strong>are excluding words, if the bank transaction contains any of the rejected words, it will not be reconciled with this item or forecast.<\/li>\n<li><strong>Minimum or maximum amounts: <\/strong>in case you want to define maximum amount ranges in the transactions for that item or forecast.<\/li>\n<li><strong>Bank category:<\/strong> quite useful for items such as payroll, taxes, or bank charges.<\/li>\n<\/ul>\n<p>And finally&#8230;<\/p>\n<ul>\n<li><strong>Automatic Reconciliation Check:<\/strong> if you activate automatic reconciliation, and a bank transaction meets the above parameters, it will be reconciled automatically, without asking! Remember that by default it is deactivated, but you can easily reconcile your new transactions in the Reconciliations section, where you will find reconciliation proposals so that you can quickly have your forecasts updated in just a few clicks.<\/li>\n<\/ul>\n<figure id=\"attachment_607\" aria-describedby=\"caption-attachment-607\" style=\"width: 1600px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" width=\"1600\" height=\"860\" src=\"https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-CheckAutomatica.webp\" class=\"wp-image-607 size-full\" alt=\"List of line items in Orama with the automatic reconciliation box ticked for each one\" decoding=\"async\" srcset=\"https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-CheckAutomatica.webp 1600w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-CheckAutomatica-300x161.webp 300w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-CheckAutomatica-1024x550.webp 1024w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-CheckAutomatica-768x413.webp 768w, https:\/\/www.orama.ai\/wp-content\/uploads\/2026\/10\/Blog-CheckAutomatica-1536x826.webp 1536w\" sizes=\"(max-width: 1600px) 100vw, 1600px\" \/><figcaption id=\"caption-attachment-607\" class=\"wp-caption-text\">Automatic Reconciliation Check<\/figcaption><\/figure>\n<p>Do you want to save hours and hours of time updating your cash budget?<br \/>\nFind out how in a <a href=\"https:\/\/www.orama.ai\/en\/demo\/\">30-minute chat with one of our experts<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are constantly innovating, that&#8217;s why Orama now offers automatic transaction reconciliation. Discover how to save time and errors with automation.<\/p>\n","protected":false},"author":3,"featured_media":1959,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_joinchat":[],"footnotes":""},"categories":[19],"tags":[],"class_list":["post-269","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-treasury"],"_links":{"self":[{"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/posts\/269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/comments?post=269"}],"version-history":[{"count":3,"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/posts\/269\/revisions"}],"predecessor-version":[{"id":1253,"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/posts\/269\/revisions\/1253"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/media\/1959"}],"wp:attachment":[{"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/media?parent=269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/categories?post=269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/tags?post=269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}