Linking Products to Accounting.

Created by Judy Macharia, Modified on Sun, 24 Sep, 2023 at 9:45 AM by Judy Macharia

Financial Actions

These are the accounts you can add to your Chart of Accounts.

After linking them to GL Accounts, Kwara will automatically post the journal entries on the correspondent GL Account whenever a transaction occurs.

For Loans :

Portfolio Control – the current asset account that is controlling the product portfolio.
Transaction Source – the current asset account that is managing your money source.
Write-off Expense – the expense account that you use when cancelling or writing off an account.
Interest / Fee / Penalty Income – the income accounts you recognize when cash is received
Interest / Fee / Penalty Receivable – are the current asset accounts used for managing the interest, fees or penalties you expect to earn in the Accruals Methodology

For Savings :

Transaction Source – the current asset account that is managing your money source.
Savings Control – the current liability account that is controlling the product portfolio.
Interest Expense – the expense account that you use when have to pay interest for the deposits.
Interest / Fee Income – the income accounts you recognize when cash is received
Overdraft Portfolio Control – the current asset account that is controlling the product portfolio.
Overdraft Write-Off Expense – the expense account that you use when cancelling or writing off an account.
Overdraft Interest Income – the income account you recognize when cash is received

Loans - Product Rules under Cash basis Accounting

In the following table shows Kwara's behavior after the accounting rules per product have been set:

Please Note - In parentheses above you can see some examples of accounts that could be used to link the loan products to accounting.

After enabling the Cash basis Accounting method, Kwara will display dropdown menus where you can choose the accounts depending on the type (asset, expense or income) in each one of them

After saving the changes the transactions will start being logged automatically in Accounting following those rules.

Loans - Product Rules under Accruals Accounting

In the following table you can see Kwara's internal behaviour when you define the accounting rules in a Loan Product under Accruals Accounting:

Please Note - In parentheses above there are some examples of accounts that could be used to link the loan products to accounting.

Like in the previous method, after enabling the Accruals Accounting method, Kwara will display dropdown menus where you can choose the accounts depending on the type (asset, expense or income) in each one of them.

For loan product types with accrual accounting you can select for the Interest Accrued Method to be Daily. Every day, when the End of Day Process runs, Kwara will log journal entries in accounting for the total amount of interest that is accrued (and not yet applied) on your active accounts. On the next process execution, Kwara will reverse the previous day's entries and log new ones with the updated accrued amounts.

Click on save and from this point onwards Kwara will log all of your transactions according to these rules.

Deposits - Product Rules

For deposits Kwara will manage the accounting following these rules:

Please Note: In parentheses above you can see some examples of accounts that could be used to link the deposit products to accounting.

Just like for Loans, after enabling the accounting in the product, select the account depending on the type (asset, liability, expense or income) in the dropdown menus > save it and from that moment on, the transactions will be automatically logged in Accounting.

Deposit Products with Cash Methodology

Deposit Products with Accrual Methodology

For deposit product types with accrual accounting, the Interest Accrued Method is Daily. The process is the same as for loan product types. If you allow overdrafts and want to use this option, define the Interest payable and Interest Receivable and journal entries will be posted.

When overdraft interest or fees are applied on the account, accounting entries will be posted. Kwara will credit the Overdraft Interest or Fees Income rule and debit the Overdraft Portfolio Control.