August 2022

These updates are our most recent rollouts for the month of August 2022!!e We pushed updates and new features including Creating and Updating an Accounting Rule, Adding an Accounting Rule to a Teller, Restructuring of the Journal Entry Bulk Import Template, and many more.


🎉🎉 New


Accounting Rule: Create and Update Accounting Rule

An accounting rule is a preconfigured accounting transaction in which the debit and credit accounts available for journal posting are defined.
For example, a user can configure an Accounting Rule for a journal posting such that only an organization's expense general ledger accounts are available for debits and only the asset general ledger accounts are available for credits.

This new feature enables users to swiftly perform a journal posting with preconfigured GL accounts instead of scrolling through numerous GL accounts when selecting the debits and credits for a transaction. Accounting Rules can be used on the main Woodcore Console and the Teller's Interface.

To create an accounting rule, navigate to the Accounting Rules tab in the Accounting module on the navigation panel and click on the Add a rule button as shown in the image below:


Create Accounting Rule

Create Accounting Rule


Fill in the required details and click on the Submit button to create the new accounting rule.



To edit an accounting rule, select the Edit button on the existing accounting rule.


Teller Manager UI: Add Accounting Rule to a Teller Group

As earlier stated the accounting rule feature can also be used on the Teller's Interface. This means that a teller can seamlessly send journal posting requests to their managers with the preconfigured accounts for debits and credits. To achieve this, we have made it possible for teller managers to be able to set up an accounting rule for each teller group being created from the Tellers Module on the main Woodcore Console.

Essentially, the Accounting Rule added to a particular Teller Group governs the journal postings requests made by the tellers in that group and also reduces manual errors.

To create a new Teller group, navigate to the Business section on the navigation panel and click on Tellers.


Select Tellers

Select Tellers


Next, click on the New Group button as shown below:


Create New Teller

Create New Teller


On clicking the Add teller group button, the teller manager would see an Accounting Rule dropdown selection field amongst the fields listed on the creation form.

The Accounting Rule dropdown selection field ideally contains a list of all the accounting rules configured via the Accounting Module on the CBA.


Select Accounting Rule

Select Accounting Rule


Finally, click on the Create Group button to create the teller group.


Send Journal Posting Requests on the Teller UI

Based on the accounting rule set up for a teller group, tellers are now able to send journal posting requests to their teller managers for approval or rejection. This simply means that transactions between a teller's GL accounts and other GL accounts of the organization can easily be recorded from the teller's interface.

To perform a journal posting on the Teller UI, log in with your details and click on the Requests tab in the navigation panel. Fill in the amount, and under the Personnel dropdown, select Journal Posting.


Send Journal Posting Request

Send Journal Posting Request


This would prompt for an Action Type, GL Account, Request Note, and Cashier Note. Depending on the Action type, either Credit posting , or Debit Posting, the GL account would be populated with the configured GL set in the accounting rule for the Teller group the teller belongs to.

Hit the Submit Button and you should get a successful prompt if all the details check out.


Transaction Details

Transaction Details


Now log on to the console and navigate to Search Entries in the Accounting tab of the navigation panel, input all the details in the required fields and click on search


Input required details including the GL and the Reference Number

Input required details including the GL and the Reference Number


The journal posting is returned and you can then click on it to view the details.


Transaction details

Transaction details


Teller UI: Download Teller Till Report

A teller is now able to download his/her teller till report so that he/she can present their financial balances for the previous day to their teller managers.

To download a teller till report, click on the Download Till Report button on the top-right corner of the teller dashboard.


Download teller till report

Download teller till report


The report would be automatically downloaded and you can select the downloaded file to view it. Note that the report is in a .pdf format.


Teller Till Report

Teller Till Report


Teller UI: Display A Teller's Running Balance

A teller's running balance, i.e., the amount available to a teller during working hours is now displayed on the Teller dashboard and Teller managers console .

This helps with providing information on the amount of money available for a particular teller during operating hours.


Teller's Running Balance

Teller's Dashboard Running Balance


For the teller manager's dashboard, select the teller group and then, select the particular teller to view his/her running balance.


Select Teller Group

Select Teller Group


View Teller

View Teller


Teller Manager's Dashboard

Teller Manager's Dashboard


🚀 Improvements


Teller Manager: Display the start time and end time fields when editing an existing teller's details

The start time and end time fields now display when editing a teller's details.

To edit a teller's details as a teller manager, navigate to Tellers and select a teller group >> select a teller >> click on edit details.


Select a Teller Group

Select a Teller Group


Click on Edit

Click on Edit


Add Start Date and End Date

Add Start Date and End Date


Restructuring of Journal Entry Bulk import template (Excel Template)

The excel template which is uploaded during the Journal Entry Bulk import has been improved!!

Users can now upload multiple debits and credit entries for a journal-to-journal account transaction (GL to GL) as long as the total debits are equal to the total credits and all credit and debit entries have the same reference number and date.


👍

The new excel template for Journal Entries bulk import can ONLY be used for multiple credits and multiple debits for GL accounts and vice versa.


The new excel template does NOT support multiple debits and credits for a set of GL accounts and also multiple debits and credits for another set of GL accounts.


To upload the debit and credit entries:

  • first, download the template and fill it out accordingly.

Select "Journal Entry" and download the template to be filled

Select "Journal Entry" and download the template to be filled


Fill the Journal entries excel sheet for a transaction with a single credit and debit entry as shown below:


Fill the template with a Debit and Credit Transaction for a Single Journal Transaction

Fill the template with a Debit and Credit Transaction for a Single Journal Transaction


Shown below is the Journal Entries excel sheet containing a transaction with multiple credit and debit entries and 2 other transactions with single debit and credit entries:


Template for multiple credit and debit entries

Template for multiple credit and debit entries


Next, you can then upload the file to the console.


Upload file

Upload file


The status of the document changes to Imported as indicated in the status column of the sheet.



By clicking on the Documents button in the mid-right corner of the page, all previously uploaded Journal Entries are displayed which can then be downloaded.


Display Previously uploaded Journal Entries

Display Previously uploaded Journal Entries


Restructuring of Account to Journal Entry Bulk import template

The excel template which is uploaded during the Account to Journal Entry Bulk import has been improved!!

Users can now upload multiple debit and credit entries for account-to-journal account transactions (Account to GL) as long as the total debits are equal to the total credits and all credit and debit entries have the same reference number and date.


👍

The new excel template for Account to Journal Entries bulk import can ONLY be used for multiple credits for clients' savings accounts and multiple debits for GL accounts and vice versa.


The new excel template does NOT support multiple debits and credits for clients' savings accounts and also multiple debits and credits for GL accounts.


To upload the debit and credit entries:

  • first, download the template and fill it out accordingly.

Select "Account to Journal Entries" & Download Account to Journal Entries Template

Select "Account to Journal Entries" & Download Account to Journal Entries Template


Account to Journal entries excel sheet containing a transaction with multiple credit and credit entries and another transaction with single debit and credit entries is shown below:



Next, you can then upload the file to the console.


Upload excel sheet

Upload excel sheet


After a successful upload, the file would now be shown in the Documents page.


Click on Documents to view upload Account to Journal Entry

Click on Documents to view upload Account to Journal Entry


By clicking on the Documents button in the mid-right corner of the page, all previously uploaded Account to Journal Entries are displayed which can then be downloaded.


Download Account to Journal Entries

Download Account to Journal Entries


Search Journal Entries: Add Search by reference number and search by User ID as search parameters

The search by reference number and search by UserID fields have been added as filter parameters for fetching Journal Entries.

This implies that when searching for a specific journal entry, you can do so by filtering with the Reference Number and the UserId respectively in addition to the other search parameters that are presently available.


Filter by UserId and Reference Number

Filter by UserId and Reference Number


The returned entries

The returned entries



⛏ Fixes


Teller UI: Pagination Fix on Request History Page

The request history page on the Teller UI now supports pagination. Previously, the results were restricted to 1000 transactions and you couldn't search beyond that.

Now, a total of 10 requests are displayed per page which makes navigation easier and the interface cleaner.


Request History

Request History


Search Journal Entries: All records are now returned for a JE search

All records are now returned for a retrieve all Journal Entries search.

To retrieve all journal entry records on your console, simply head to Search Entries in the Accounting tab of the navigation panel.


Search Entries

Search Entries


Ensure to select the all search filter to fetch all types of journal entries and also the from and to date filter parameters. Click on the Search button to fetch the Journal Entries.


Returned entries

Returned entries


Maker & Checker : View details of an action request under checker inbox

You can now view all the details of an action request under the checker inbox.

To do this, navigate to the Approvals page of the Business section in the navigation pane. Here, a list of all pending requests would be displayed.


List of pending requests

List of pending requests


You can finally select the action request you want to view its details.

Action Details

Action Details


In conclusion, it's been a busy month for us and we hope you continue to enjoy the quality experience that Woodcore gives.