You use bank accounts in Business Central to keep track of your banking transactions. Accounts can be denominated in your local currency or a foreign currency. After you have set up bank accounts, you can also use the check printing option. The bank accounts include extra functionality for payment reconciliation, bank reconciliation, and the import and export of bank files. The bank accounts can also be included in transactions in the general journals. Each bank account is linked to an account in the chart of accounts through the assigned bank account posting group. Using a bank account in a payment transaction will automatically create an entry in both the bank account and the connected general ledger (G/L) account.
Bank accounts work differently depending on whether a currency code is specified:
If the currency code is blank
All transactions in the bank account are in the local currency (LCY) for the current company. If a transaction is made to the account in another currency, the amounts are posted to the account in LCY based on the relevant currency exchange rate. Any checks issued from this account must be issued in LCY. If the bank account is used in a journal, the journal line will automatically inherit the blank currency code.
Currency code is specified
All transactions made to and checks issued from this account must be in the same currency as specified on the account.
You can save time on data entry by making a bank account the default account to use for the currency specified for the account. If you do, the account is assigned to sales and service documents that use the currency. To make the account the default for sales and service documents, on the Bank Account Card page, turn on the Use as Default for Currency toggle. If needed, you can choose a different account when you're working on a document.
A bank account is an integral part of Business Central and plays a role in many other capabilities. The following illustration shows the most important relations:
You can see that creating a bank account makes it available in all the places shown above, as well as being mirrored in the relevant G/L account and on the Company Information page.
A bank account is usually monitored daily to make sure any new payments from customers are registered as quickly as possible. This helps ensure a customer's actual status is reflected in Business Central. That gives sales people, accountants, and other employees access to the most relevant and up-to-date information so they avoid making unnecessary calls to the customer regarding overdue invoices or delays in shipments.
Another task is to import vendor currency payments with the realized currency rates to make sure that the actual status of the vendors is up-to-date. Using the payment reconciliation capability is the easiest way to do that. In the Payment Reconciliation Journal, you can import bank transactions directly from an online bank application and have them posted more or less automatically. The journal automatically identifies and posts the following:
Payment reconciliation provides significant time savings in posting incoming and outgoing payments. However, the transactions on the bank account in Business Central are not considered 100% correct until you run a bank reconciliation.
Bank reconciliation is how you make sure that the bank account in Business Central matches the external account at the bank.
In the illustration above, the leftmost side represents the bank account in Business Central, and the rightmost side represents transactions imported from the bank through the online bank application. The diagram in the middle shows the transactions from both sides, which is the bank reconciliation.
From the bank account in Business Central, most transactions should be known to the physical bank. The few exceptions include the following cases:
From the physical account at the bank, transactions not identified in the payment reconciliation journal arrive all the time, such as the following:
The better you are at mapping information in the payment reconciliation journal, the more transactions are posted automatically and the easier periodic bank reconciliation becomes.
See in the video below the basic steps to set up a bank account in Business Central.
Warning
Some fields may contain sensitive data, such as the Bank Branch No., Bank Account No., SWIFT Code, and IBAN Code fields. Learn more at Monitor Sensitive Fields.
Choose the icon, enter Bank Accounts, then choose the related link.
On the Bank Accounts page, choose the New action.
Fill in the fields as necessary. Hover over a field to read a short description.
An example would be the Bank Acc. Posting Group field which connects the bank account to the underlying G/L account in the balance sheet. Learn more at Set Up Posting Groups.
Tip
Some fields are hidden until you choose the Show more action, typically because they are rarely used. Others must be added through personalization. Learn more at Personalize Your Workspace.
You can create as many bank accounts as you need for your business. For each bank account, you must specify information that makes the bank account uniquely identifiable. This information includes the bank's geographical address; number series for different types of transactions, such as direct debit and credit transfers; the currency amounts are specified in; and information used for importing bank statements. Hover over a field to read a short description.
To fill the Balance field in with an opening balance, you must post a bank account ledger entry with the amount in question. You can do this by performing a bank account reconciliation. Learn more at Reconcile Bank Accounts.
Alternatively, you can implement the opening balance as part of general data creation in new companies using the Migrate Business Data assisted setup guide. Learn more at Getting Ready for Doing Business.
Important
Do not post the opening balance directly to the general ledger. Having entries in the G/L account that were posted directly to it typically results in you not being able to reconcile the bank account. With foreign currency bank accounts, such a practice results in differences accumulating as you post more bank reconciliations. Usually you post the opening bank balance directly to the bank account, and the amount ends up in the G/L account. Alternatively, later you can reverse it out of the G/L account you use to balance the opening general ledger balance. In either case, you must balance any direct posting to the G/L account before you start your first bank reconciliation—especially if the bank account is in a foreign currency.
The fields related to the import and export of bank feeds and files are on the Transfer FastTab on the Bank Account Card page. Learn more at Using the AMC Banking 365 Fundamentals Extension and Set Up the Envestnet Yodlee Bank Feeds Service.
Note
Different file export services and their formats require different setup values on the Bank Account Card page. You'll be informed of wrong or missing setup values when you export the file. Read the short descriptions of the fields carefully or refer to the related procedure topics. For example, exporting a payment file for North American electronic funds transfer (EFT) requires that both the Last Remittance Advice No. and the Transit No. fields be filled in. Learn more at Export Payments to a Bank File.
The fields on the Transit FastTab on the bank account serve different purposes, depending on whether the payment is inbound or outbound.
The illustration below shows the route of inbound payments (numbers in the description correspond with those in illustration):
Incoming payments are always imported through the Payment Reconciliation Journal or directly into the Bank Account Reconciliation page. In contrast, outgoing payments can originate from any payment journal. The only prerequisite is that the Allow Payment Export field in the relevant payment journal batch must be selected.
The illustration below shows the route of outbound payments (numbers in the description correspond with those in illustration):
Fields on the Transfer FastTab on the Vendor Bank Account Card page are related to the export of bank feeds and files. Learn more at Use the AMC Banking 365 Fundamentals extension and Export Payments to a Bank File.
Tip
Some fields are hidden until you choose the Show more action, typically because they are used rarely. Others must be added through personalization. For more information, see Personalize Your Workspace.
Warning
Some fields on the vendor bank account contain sensitive business data, such as the Bank Branch No., Bank Account No., SWIFT Code, and IBAN Code. For more information on how to monitor and be notified when someone changes a value in those fields, see Monitor Sensitive Fields.
To use a different bank account for your business, you must create the new bank account in Business Central. We recommend that you do not simply replace the information about the account you are currently using because that can cause incorrect data. For example, your opening balance might be incorrect or your bank feed might stop working correctly. It's important that you keep the current and new accounts separate.
After you create the new bank account, you should also create a new bank posting group and assign it to a new general ledger account. You can reuse an existing bank posting group, and bank transactions will be posted to the same general ledger accounts as other bank accounts sharing that bank posting group. However, we recommend that you create a new bank posting group and general ledger account so that reconciliations are easier to do.
Note
Remember that the bank account information on open sales invoices still shows the original bank account. Accordingly, payments are likely to still be posted to that account. We recommend that you keep both accounts active for a period of time after the change.
To get a more condensed view of your cash accounts in financial reporting, use the Begin-Total and End-Total accounts in your chart of accounts, the Totaling rows in financial reports, or G/L account categories. Learn more at Business Intelligence and Financial Reporting section.
Setting Up Banking
Setting Up Posting Groups
Reconciling Bank Accounts
Set Up the Envestnet Yodlee Bank Feeds Service
SEPA Direct Debit in Business Central
To set up your bank account for SEPA direct debit
To set up a bank account for SEPA Credit Transfer
Make Payments with the AMC Banking 365 Fundamentals Extension or SEPA Credit Transfer
Payment Reconciliation
Understanding the General Ledger and the COA