Bank Imports

This module is still a work in progress (both in BOS and in documentation).

A bank import is performed to capture all the bank entries automatically, so they do not have to captured manually.

Before a bank import can be performed for the first time the following steps must be taken:

1. Add the Bank module to a menu.
2. Set User Access for the bank module: … Bank > Menu (button) > Edit User Access.
3. Create statuses for the bank entries:
   1. … Bank > Menu (button) > Edit Statuses (Bank Header) > Add Default (button).
   2. … Bank > Menu (button) > Edit Statuses (Bank Item) > Add Default (button).

In the context of bank imports, the import is treated as a bank transaction with the header status referring to the import header, and the transactions that are added to the import are treated as the items.

---

Bank Import List View

Buttons Explained

Button	Description
View	Displays a list of bank recons or import entries.
Arrow on View button > Reset Data Filter	Resets the selected filters.
New	Creates a new Bank Import or Bank Reconciliation as selected from the dropdown list.
Menu	Views – Default – Items Settings – Edit User Access – Edit Accounting (Accounts, VAT Types, Currencies, Credit Terms, Bank Profiles)  – Edit Statuses (Bank Header) – Edit Statuses (Bank Item) Layout

---

Filters Explained

Filter	Description
Set	A selection of date options including No Date to display all the entries.
Date (radio button)	Works in conjunction with the date. Displays entries that were created on that date (i.e. the date on which the recon or import was created.)
Updated (radio button)	Works in conjunction with the date. Displays entries that were updated on that date (i.e. the date on which the recon or import was updated.)
Account	A dropdown list of bank accounts to select one or all.
Status Groups	Checkboxes to filter the entries based on the status groups. If none of the boxes are checked, all the entries are displayed.

---

Fields Explained

Field	Description
Status	The status of the recon or import.
Bank No.	The system-generated number allocated to the entry.
Type	Whether the entry is an Import or Recon.
Account	The name of the bank account.
Date Start	The start date of the recon or import. After the first import is created, this date is automatically set as the day after the previous import ended.
Date End	The end date of the recon or import.
Bank Balance	The bank balance at the end of the period.
Ledger Balance	The ledger balance at the end of the period.
Variance	The difference between the bank and ledger balances.
Widget	A submenu with the following actions: – Edit – Delete

---

Bank Import Edit View

Buttons Explained

Button	Description
Arrows	Navigates between bank reconciliations / imports.
New	Creates a new Bank Import or Bank Reconciliation as selected from the dropdown list.
Save	Saves any changes
Actions	Upload File: Allows a file to be uploaded to QuickEasy BOS. Download File: Allows a file to be downloaded to a local computer. Delete Bank: Deletes the bank import.
Menu	Open Ledger: Opens the transaction in the ledger. Settings – Edit Accounting (Accounts, VAT Types, Currencies, Credit Terms, Bank Profiles)  – Edit User Access – Edit Statuses (Bank Header) – Edit Statuses (Bank Item) Layout

---

Fields Explained: Header

Field	Description
Status	A dropdown list of statuses to select a header status.
Bank No.	The system-generated number allocated to the entry.
Type	Whether the entry is an Import or Reconciliation.
Account	A dropdown list of bank accounts to select one. Only bank accounts with correctly completed Bank Profiles appear on the list.
Date Start	The start date of the recon or import.
Date End	The end date of the recon or import.
Note Field	A field to type a note.
Bank Balance	A field to enter the bank balance as per the bank statement.
Ledger Balance	The ledger balance at the end of the period.
Variance	The difference between the bank and ledger balances.

---

Fields Explained: Transactions

Button and Checkbox	Description
Synchronise Ledger	Used to create ledger transactions from the imported entries.
Refresh (button)	Refreshes the display after transactions were created.

---

Field	Description
ID	The system-generated number for the entry.
Status	The item’s status where item refers to the transaction (which is an item on a bank import).
Bank ID	The system-generated number for the bank import.
Date	The date of the transaction.
Description	The transaction’s description.
Amount	The transaction amount.
Ledger	The ledger amount.
Variance	The difference between the ledger and transaction amounts.
Trans No.	The Transaction Type code and number.
Created	The date on which the entry was created.
Updated	The date on which the entry was last updated.
Updated By	The user who last updated the entry.
Trans No.	The original Transaction Type code and number.
Widget	A submenu with the following action: Open Ledger: Opens the transaction on the right panel.

---

Tutorials

How to Create a Bank Import

1. Navigate to Bank.
   • Note: The module is named Bank, however, it might be renamed on the menu (e.g. to Bank Recon or Bank Import). It can be added to any menu group (e.g. Accounting).
2. Click New (button) > Bank Import.
3. Click Actions (button) > Upload File.
4. Navigate to the file and click Select (button).
5. Create entries for all the transactions (instructions to follow).

---

Learn More

---