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:
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.
Next, click on the New Group button as shown below:
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.
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.
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.
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
The journal posting is returned and you can then click on it to view the 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.
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 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.
For the teller manager's dashboard, select the teller group and then, select the particular teller to view his/her running balance.
🚀 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.
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.
Fill the Journal entries excel sheet for a transaction with a single credit and debit entry as shown below:
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:
Next, you can then upload the file to the console.
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.
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.
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.
After a successful upload, the file would now be shown in the Documents page.
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.
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.
⛏ 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.
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.
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.
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.
You can finally select the action request you want to view its details.
In conclusion, it's been a busy month for us and we hope you continue to enjoy the quality experience that Woodcore gives.