{"id":1297,"date":"2026-10-23T00:10:49","date_gmt":"2026-10-23T00:10:49","guid":{"rendered":"https:\/\/www.orama.ai\/?p=1297"},"modified":"2026-10-23T00:10:50","modified_gmt":"2026-10-23T00:10:50","slug":"norma-43-cash-flow-forecasting","status":"publish","type":"post","link":"https:\/\/www.orama.ai\/en\/academy-tesoreria\/norma-43-cash-flow-forecasting\/","title":{"rendered":"Do you need Norma 43 files to forecast cash flow?"},"content":{"rendered":"

No: to forecast your cash flow you don’t need to download the Norma 43 file from each bank. If you connect your banks, Orama receives transactions and balances without files, up to 4 times a day, and uses them together with your invoices to build your cash flow forecast. Norma 43 is still useful to take a statement into another program, but it isn’t the basis of a forecast.<\/strong><\/p>\n

If every week you log in to three or four banks, download the statement in Norma 43, convert it to Excel and paste it into your cash flow spreadsheet, here is what that file gives you, why it falls short for forecasting, what to do with banks that can’t be connected and an example of how much time it saves.<\/p>\n

What Norma 43 is and what it’s used for<\/h2>\n

Norma 43, also known as Cuaderno 43 or CSB43, is the Spanish banks’ standard format for delivering an account’s transaction statement in a text file. Almost every bank offers it in online banking. Because all banks use the same structure, one program can read any bank’s statement without anyone typing in the transactions. The record-by-record detail is in Orama Academy (in Spanish): Norma 43<\/a>.<\/p>\n

Why a Norma 43 statement isn’t enough to forecast cash<\/h2>\n

A statement is a snapshot of the past: it tells you what came in and went out up to the day you downloaded it. A forecast also needs what is going to happen: invoices pending collection and payment, payroll, taxes, loan and credit line instalments. And it needs every bank’s data up to date, not from the day someone had time to download it.<\/p>\n\n\n\n\n\n\n\n\n
<\/th>\nNorma 43 file<\/th>\nOrama bank connection<\/th>\nExcel in Orama<\/th>\n<\/tr>\n<\/thead>\n
How transactions arrive<\/td>\nYou download it from online banking<\/td>\nAutomatically<\/td>\nYou upload it<\/td>\n<\/tr>\n
Frequency<\/td>\nWhenever you download it<\/td>\nUp to 4 times a day<\/td>\nWhenever you upload it<\/td>\n<\/tr>\n
What it’s for<\/td>\nTaking the statement into other programs<\/td>\nConnected banks<\/td>\nUnsupported bank, history or petty cash<\/td>\n<\/tr>\n
Manual work<\/td>\nDownload, convert and paste for each bank<\/td>\nNone; renew the authorisation every 90 or 180 days<\/td>\nDownload and upload<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

How to move from files to a forecast that updates itself<\/h2>\n
    \n
  1. Connect your banks.<\/strong> You authorise the connection once at each bank (PSD2, read-only). Orama connects to 100% of banks in Spain and 3,000+ across Europe and Latin America, and downloads the history each bank allows.<\/li>\n
  2. Connect your ERP.<\/strong> Customer and supplier invoices arrive automatically and become expected collections and payments on their due dates.<\/li>\n
  3. Let it reconcile.<\/strong> Each transaction is assigned to its item with keyword rules: between 80 and 95% of transactions reconcile on their own, and the rest go to the task inbox.<\/li>\n
  4. Review the forecast.<\/strong> With actuals and forecast together, you see your cash 13 weeks and 12, 18 or 24 months ahead, and test scenarios before deciding.<\/li>\n<\/ol>\n

    And if a bank can’t be connected<\/h2>\n

    It can happen with a foreign bank, an account where you want more history or petty cash. In those cases transactions are uploaded in Excel<\/strong> to a manual account: an .xlsx file of up to 1 MB with three required columns (transaction date, description and amount), with collections as positive and payments as negative. If your online banking offers the statement in Norma 43 and in Excel, download the Excel file. The step-by-step guide is in Orama Academy (in Spanish): Importing bank transactions<\/a>.<\/p>\n

    Those transactions are assigned to their items with the same rules as those from the bank and enter the forecast like any other account.<\/p>\n

    If your accountant works from the statement<\/h2>\n

    Many Spanish accounting firms ask for the Norma 43 file every month for the books. With your banks connected in Orama, your accountant can have access, with the permissions you decide, to your already reconciled transactions, or receive the data exported from Orama in Excel (or in Norma 43, on request). If your management software is SIS Grupo, Orama sends it the bank transactions. We explain it for firms in Orama for accounting firms<\/a>.<\/p>\n

    Example: from 3 hours a week to none<\/h2>\n

    Anonymised example.<\/em> Talleres Duero, in Burgos, has a turnover of \u20ac4M and works with four banks. Every Monday, the office manager downloaded the four statements in Norma 43, converted them to Excel and pasted them into her cash flow spreadsheet: about 3 hours a week, and the forecast was only up to date on Mondays.<\/p>\n

    After connecting the four banks and the ERP, transactions arrive on their own up to 4 times a day and 90% reconcile without being touched. One Wednesday, the forecast shows that in five weeks the balance will drop to \u20ac12,000 because of the extra pay month and a leasing instalment. With that margin, they bring forward the direct debit collection for two customers and reach that week with a cushion. With the files, they would have seen it the following Monday.<\/p>\n

    If you still keep your cash in a spreadsheet, the 13-week cash flow template<\/a> is a good starting point. And if you want to see the forecast with your banks connected, try Orama free for 7 days, no card required<\/a>, or book a 30-minute demo<\/a>. Plans are at orama.ai\/en\/plans<\/a>.<\/p>\n

    Frequently asked questions<\/h2>\n

    Can I import a Norma 43 file into Orama?<\/h3>\n

    To upload transactions manually, Orama uses Excel (.xlsx). If your online banking offers the statement in Norma 43 and in Excel, download the Excel file. With the bank connected you don’t need any file.<\/p>\n

    Do I need Norma 43 if I use Orama?<\/h3>\n

    No. If your bank is connected, Orama downloads transactions and balances without files. You only upload transactions manually for an unsupported bank, to extend the history or for petty cash.<\/p>\n

    How often are transactions updated?<\/h3>\n

    With the bank connection, up to 4 times a day. With files, whenever someone downloads and uploads them.<\/p>\n

    Is the bank connection secure?<\/h3>\n

    It’s a read-only PSD2 connection through aggregators regulated by the Bank of Spain and ISO 27001 certified: Orama sees transactions and balances, but can’t move money.<\/p>\n

    What if the statement’s closing balance doesn’t match the bank’s?<\/h3>\n

    Usually a transaction is missing or the downloaded period is wrong. With the bank connected, Orama takes the balance directly from the bank.<\/p>\n","protected":false},"excerpt":{"rendered":"

    No: to forecast your cash flow you don’t need to download the Norma 43 file from each bank. If you connect your banks, Orama receives transactions and balances without files, up to 4 times a day, and uses them together with your invoices to build your cash flow forecast. Norma 43 is still useful to […]<\/p>\n","protected":false},"author":1,"featured_media":1319,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_joinchat":[],"footnotes":""},"categories":[10,9],"tags":[],"class_list":["post-1297","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-prevision","category-tesoreria"],"_links":{"self":[{"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/posts\/1297","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/comments?post=1297"}],"version-history":[{"count":2,"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/posts\/1297\/revisions"}],"predecessor-version":[{"id":1322,"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/posts\/1297\/revisions\/1322"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/media\/1319"}],"wp:attachment":[{"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/media?parent=1297"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/categories?post=1297"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.orama.ai\/en\/wp-json\/wp\/v2\/tags?post=1297"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}