Bank Accounts
The accounts themselves, with the live balance the feed reports and the GL account each one posts to.
Where to find it
- Module: Accounting
- Group: Working Capital
- Section: Banking
- Screen: Bank Accounts
Address in the console: /accounting/bank-accounts
List · 12 columns · 19 fields on its form · 3 of them required · 4 actions
What the list shows
These are the columns of the list, in the order they are drawn. Any of them can be sorted on, filtered on, hidden, or exported.
| Column | Kind | Field name |
|---|---|---|
| Account | Text | name |
| Bank | Text | bank_name |
| Number | Code | account_masked |
| Type | Status | account_type |
| Ccy | Code | currency |
| Balance | Amount | ledger_balance |
| Available | Amount | available_balance |
| As of | Date and time | balance_as_of |
| GL | Code | gl_account_no |
| Unmatched | Number | unmatched |
| Syncing | Yes or no | sync_enabled |
| Primary | Yes or no | is_primary |
The form
What is asked for when a record is created here. Required fields are marked; a choice drawn from a configuration list is one an administrator can extend without a release.
| Field | Type | Choices | Notes |
|---|---|---|---|
| Account name required | Text | ||
| Bank name required | Text | ||
| Masked number required | Text | Set the real number through "Store account number" — it is encrypted and this is derived from it. | |
| Currency | Text | ||
| Type | Choice | Configuration list | |
| What it is for | Text | ||
| Bank | Choice | Looked up from existing records | |
| Connection | Choice | Looked up from existing records | |
| Routing number | Text | ||
| IBAN | Text | ||
| SWIFT BIC | Text | ||
| Account id at the bank | Text | How the bank names this account on its feed. | |
| Cash GL account | Choice | Looked up from existing records | |
| Cost center | Choice | Looked up from existing records | |
| Overdraft limit | Number | ||
| Minimum balance | Number | ||
| Collect from the bank | Yes or no | ||
| Primary account for this currency | Yes or no | ||
| Active | Yes or no |
What you can do here
Import statement primary
Import a statement
Asks for: Format Statement date File name Statement*
Reconcile
Reconcile a period
Asks for: From* To* Closing balance at the bank
Post recognized
Post everything the rules recognized
Store account number
Store the account number
Asks for: Account number*
* required
The rules that apply here
Everything on this screen obeys the platform rules rather than rules of its own. The ones worth knowing before you use it:
- Narrowing a list — search, conditions, sort, totals, export and saved views.
- What may be changed — the five grounds a record may not be edited on.
- Companies and business units — what the switcher above this list is doing to it.
- Creating a record — required fields, where choices come from, and how the number is allocated.
- Importing a spreadsheet — this screen accepts one, and it runs through the same rules as typing.