Skip to main content

SAS Finance & Accounting Module — Software Requirements Specification (SRS)

Table of Contents

1 Document Information

FieldValue
Project NameSAS Finance & Accounting Module
Version1.0
Date2025-10-17
Project ManagerTBD
Tech LeadTBD
Qa LeadTBD
Platforms['Web']
Document StatusComprehensive Draft
Module CodeFINANCE
Parent ProjectSAS - Smart Assemble System

2 Project Overview

2.1 What Are We Building

2.1.1 System Function

Comprehensive financial management system with Sage ERP integration, handling premium billing, payment collection, receipting, refunds, accounts receivable/payable, commission payments, provider payments, reinsurance accounting, financial reconciliation, and financial reporting

2.1.2 Users

  • Finance Officers (transaction processing)
  • Accountants (reconciliation and reporting)
  • Finance Managers (approval workflows)
  • Cashiers (payment collection)
  • Accounts Receivable clerks
  • Accounts Payable clerks
  • Chief Financial Officer (financial oversight)
  • Auditors (audit and compliance)

2.1.3 Problem Solved

Manual financial processes, no integration with Sage ERP, manual receipting, delayed reconciliation, no automated payment tracking, manual commission calculations, lack of financial controls, limited financial reporting, no multi-currency support

2.1.4 Key Success Metric

100% Sage ERP integration for AR/AP, automated receipting within 1 hour of payment, daily reconciliation completion, 99.9% payment accuracy, automated commission disbursement, real-time financial dashboards, zero financial audit findings

2.2 Scope

2.2.1 In Scope

  • Sage ERP integration (bi-directional sync)
  • Premium billing and invoicing
  • Multi-channel payment collection (bank, mobile money, credit card, cash)
  • Automated receipt generation and distribution
  • Refund processing and approvals
  • Accounts Receivable management
  • Accounts Payable management
  • Commission payment processing
  • Provider payment processing (claims reimbursement)
  • Reinsurance premium accounting
  • Bank reconciliation
  • Multi-currency support (TZS, KES, USD)
  • Exchange rate management
  • Financial reporting and dashboards
  • Maker-checker workflows for payments
  • Audit trail for all financial transactions
  • Payment gateway integration
  • Debit/Credit note management

2.2.2 Out Of Scope

  • Full general ledger (handled by Sage ERP)
  • Fixed asset management (Sage ERP)
  • Payroll processing (separate system)
  • Budgeting and forecasting (future phase)
  • Advanced financial analytics (future phase)

3 User Requirements

3.1 Billing Invoicing

Feature CodeI Want ToSo That I CanPriorityNotes
FT-FIN-INVOICE-GENERATIONAuto-generate invoices upon policy issuanceEnsure timely billing of premiumsMustInvoice includes: policy number, member details, premium breakdown, due date, payment instructions. Integration with Sage ERP AR.
FT-FIN-INVOICE-SAGE-SYNCSync invoices to Sage ERP automaticallyMaintain single source of truth in SageMustBi-directional sync. Invoice created in SAS pushed to Sage AR. Status updates synced back.
FT-FIN-RENEWAL-INVOICEGenerate renewal invoices 60 days before expiryCollect renewal premiums timelyMustAutomated renewal invoice generation. Updated premium rates applied. Sent via email/SMS.
FT-FIN-DEBIT-NOTEGenerate debit notes for mid-term adjustmentsBill additional premium for endorsementsMustDebit note for member additions, benefit upgrades. Pro-rated calculation. Sage ERP sync.
FT-FIN-CREDIT-NOTEGenerate credit notes for refunds and cancellationsProcess premium refunds accuratelyMustCredit note for policy cancellations, member deletions. Refund calculation. Approval workflow. Sage sync.

3.2 Payment Collection

Feature CodeI Want ToSo That I CanPriorityNotes
FT-FIN-PAYMENT-CHANNELSAccept payments through multiple channelsProvide flexible payment options to clientsMustChannels: bank transfer, mobile money (M-Pesa, Tigo Pesa, Airtel Money), credit card, cash. Payment gateway integration.
FT-FIN-PAYMENT-ALLOCATIONAutomatically allocate payments to invoicesUpdate accounts receivable accuratelyMustPayment matching by reference number. Auto-allocation. Manual allocation for unmatched payments. Sage sync.
FT-FIN-RECEIPT-GENERATIONAuto-generate official receipts upon payment confirmationProvide immediate proof of paymentMustReceipt includes: receipt number, payer details, amount, payment method, date. Sent via SMS/email. Sage sync.
FT-FIN-PARTIAL-PAYMENTAccept and track partial paymentsAllow clients to pay in installmentsMustPartial payment tracking. Outstanding balance calculation. Multiple receipts for installments.
FT-FIN-OVERPAYMENTHandle overpayments with credit balance or refundManage excess payments appropriatelyMustOverpayment detection. Option to apply to credit balance or refund. Client notification.
FT-FIN-PAYMENT-GATEWAYIntegrate with payment gateways for online paymentsEnable secure online payment collectionMustPayment gateway: DPO, Flutterwave, or local gateway. Callback handling. Payment status tracking.

3.3 Accounts Receivable

Feature CodeI Want ToSo That I CanPriorityNotes
FT-FIN-AR-DASHBOARDView accounts receivable dashboardMonitor outstanding paymentsMustDashboard: total AR, aging analysis (0-30, 31-60, 61-90, 90+ days), payment trends, overdue invoices.
FT-FIN-AR-AGINGGenerate AR aging reportIdentify overdue accounts for follow-upMustAging buckets: current, 1-30 days, 31-60 days, 61-90 days, 90+ days. By client, by product, by agent.
FT-FIN-PAYMENT-REMINDERSend automated payment remindersImprove collection ratesMustReminders: 7 days before due, on due date, 7 days after due. SMS/email. Configurable schedule.
FT-FIN-BAD-DEBTWrite off bad debts with approvalClear uncollectible receivablesShouldBad debt write-off workflow. Manager approval required. Sage sync. Audit trail.

3.4 Refunds

Feature CodeI Want ToSo That I CanPriorityNotes
FT-FIN-REFUND-REQUESTProcess refund requests with approval workflowHandle refunds systematicallyMustRefund reasons: policy cancellation, overpayment, member deletion. Refund calculation. Approval workflow.
FT-FIN-REFUND-CALCULATIONCalculate refunds based on policy termsEnsure accurate refund amountsMustRefund calculation: pro-rata for mid-term cancellation. Less admin fees if applicable. Sage sync.
FT-FIN-REFUND-PAYMENTProcess refund payments via multiple methodsReturn funds to clients efficientlyMustRefund methods: bank transfer, mobile money, cheque. Refund voucher generation. Sage AP integration.

3.5 Accounts Payable

Feature CodeI Want ToSo That I CanPriorityNotes
FT-FIN-COMMISSION-PAYMENTProcess commission payments to agentsDisburse earned commissionsMustCommission voucher from sales module. Approval workflow. Batch payment processing. Sage AP sync.
FT-FIN-PROVIDER-PAYMENTProcess provider payments for claimsReimburse healthcare providersMustProvider invoice from claims module. Payment schedule (monthly, bi-weekly). Batch processing. Sage AP.
FT-FIN-REINSURANCE-PREMIUMProcess reinsurance premium paymentsPay reinsurance premiums to reinsurersMustReinsurance premium calculation from reinsurance module. Payment to multiple reinsurers. Sage AP.
FT-FIN-AP-APPROVALImplement maker-checker for AP paymentsEnsure payment accuracy and prevent fraudMustMaker creates payment voucher. Checker approves. Approval limits by amount. Audit trail.
FT-FIN-PAYMENT-BATCHProcess payments in batchesEfficiently handle multiple paymentsMustBatch payment file generation. Bank file format support. Batch approval. Sage sync.

3.6 Reconciliation

Feature CodeI Want ToSo That I CanPriorityNotes
FT-FIN-BANK-RECONCILIATIONReconcile bank statements with system recordsEnsure accuracy of financial recordsMustBank statement upload (CSV, Excel). Auto-matching by amount and date. Manual matching for exceptions.
FT-FIN-PAYMENT-GATEWAY-RECONReconcile payment gateway transactionsVerify all online payments capturedMustGateway report download. Matching with system payments. Discrepancy resolution.
FT-FIN-SAGE-RECONCILIATIONReconcile SAS transactions with Sage ERPEnsure data consistency between systemsMustDaily reconciliation. Compare AR, AP, receipts, payments. Discrepancy reporting.
FT-FIN-SUSPENSE-ACCOUNTManage suspense account for unallocated paymentsTrack payments pending allocationMustUnmatched payments to suspense. Manual allocation. Aging of suspense items.

3.7 Multi Currency

Feature CodeI Want ToSo That I CanPriorityNotes
FT-FIN-MULTI-CURRENCYSupport multiple currencies (TZS, KES, USD)Handle transactions in different currenciesMustCurrency selection at policy level. Currency conversion for reporting. Exchange gain/loss tracking.
FT-FIN-EXCHANGE-RATEManage exchange ratesConvert between currencies accuratelyMustExchange rate configuration. Daily rate updates. Historical rates maintained. Rate source (BOT, CBK).
FT-FIN-CURRENCY-CONVERSIONConvert transactions to base currency for reportingConsolidate financial reportsMustBase currency: TZS. Automatic conversion using exchange rates. Conversion tracking for audit.

3.8 Financial Reporting

Feature CodeI Want ToSo That I CanPriorityNotes
FT-FIN-REVENUE-REPORTGenerate premium revenue reportTrack premium incomeMustRevenue by period, product, channel, agent. Earned vs written premium. Trend analysis.
FT-FIN-COLLECTION-REPORTGenerate collection reportMonitor cash flowMustCollections by payment method, by period. Collection efficiency ratio. Outstanding AR.
FT-FIN-PAYMENT-REPORTGenerate payment report (AP)Track outgoing paymentsMustPayments by type (commission, provider, reinsurance), by period. Payment trends.
FT-FIN-CASHFLOW-REPORTGenerate cash flow reportMonitor liquidityMustCash inflows vs outflows. By period. Cash position. Forecast vs actual.
FT-FIN-FINANCIAL-DASHBOARDView real-time financial dashboardMonitor key financial metricsMustDashboard: revenue, collections, payments, AR, AP, cash balance. Trend charts. KPIs.

3.9 Financial Controls

Feature CodeI Want ToSo That I CanPriorityNotes
FT-FIN-MAKER-CHECKERImplement maker-checker for financial transactionsPrevent unauthorized transactionsMustMaker-checker for: payments above threshold, refunds, credit notes, write-offs. Approval limits.
FT-FIN-APPROVAL-LIMITSSet approval limits by user levelControl transaction authorizationMustApproval limits by amount. Escalation workflow. Override with senior approval.
FT-FIN-AUDIT-LOGMaintain comprehensive audit log of financial transactionsSupport audit and complianceMustAudit log: user, action, timestamp, old/new values. Immutable. Searchable and exportable.
FT-FIN-SEGREGATION-DUTIESEnforce segregation of dutiesPrevent fraudMustRole-based access. Maker cannot be checker. Payment creator cannot approve.

4 Detailed Feature Requirements

4.1 Ft Fin Invoice Generation

4.1.1 Priority

Must Have

4.1.2 User Story

As a finance system, I want to auto-generate invoices upon policy issuance so that I can ensure timely billing of premiums

4.1.3 Preconditions

Policy issued, premium calculated

4.1.4 Postconditions

Invoice generated, sent to client, synced to Sage ERP

4.1.5 Test Cases

IdDescriptionWeight
INVOICE-GENERATION-TC-001Verify invoice auto-generated upon policy issuanceHigh
INVOICE-GENERATION-TC-002Verify invoice includes policy numberHigh
INVOICE-GENERATION-TC-003Verify invoice includes member detailsHigh
INVOICE-GENERATION-TC-004Verify invoice includes premium breakdownHigh
INVOICE-GENERATION-TC-005Verify invoice includes due dateHigh
INVOICE-GENERATION-TC-006Verify invoice includes payment instructionsHigh
INVOICE-GENERATION-TC-007Verify invoice sent via email/SMSHigh

4.2 Ft Fin Invoice Sage Sync

4.2.1 Priority

Must Have

4.2.2 User Story

As a finance officer, I want to sync invoices to Sage ERP automatically so that I can maintain single source of truth in Sage

4.2.3 Preconditions

Sage ERP integration configured, invoice generated

4.2.4 Postconditions

Invoice pushed to Sage AR, status updates synced back

4.2.5 Test Cases

IdDescriptionWeight
INVOICE-SAGE-SYNC-TC-001Verify invoice pushed to Sage AR immediatelyHigh
INVOICE-SAGE-SYNC-TC-002Verify bi-directional sync operationalHigh
INVOICE-SAGE-SYNC-TC-003Verify invoice status updates synced from SageHigh
INVOICE-SAGE-SYNC-TC-004Verify sync errors logged and alertedHigh
INVOICE-SAGE-SYNC-TC-005Verify retry mechanism for failed syncsHigh
INVOICE-SAGE-SYNC-TC-006Verify sync audit trail maintainedMedium

4.3 Ft Fin Renewal Invoice

4.3.1 Priority

Must Have

4.3.2 User Story

As a finance officer, I want to generate renewal invoices 60 days before expiry so that I can collect renewal premiums timely

4.3.3 Preconditions

Policy approaching expiry (60 days), renewal rates calculated

4.3.4 Postconditions

Renewal invoice generated and sent, Sage sync completed

4.3.5 Test Cases

IdDescriptionWeight
RENEWAL-INVOICE-TC-001Verify renewal invoice generated 60 days before expiryHigh
RENEWAL-INVOICE-TC-002Verify updated premium rates appliedHigh
RENEWAL-INVOICE-TC-003Verify renewal invoice sent via email/SMSHigh
RENEWAL-INVOICE-TC-004Verify renewal notice includes new premium amountHigh
RENEWAL-INVOICE-TC-005Verify renewal invoice synced to SageHigh
RENEWAL-INVOICE-TC-006Verify follow-up reminders sentMedium

4.4 Ft Fin Debit Note

4.4.1 Priority

Must Have

4.4.2 User Story

As a finance officer, I want to generate debit notes for mid-term adjustments so that I can bill additional premium for endorsements

4.4.3 Preconditions

Endorsement processed requiring additional premium

4.4.4 Postconditions

Debit note generated, sent to client, Sage synced

4.4.5 Test Cases

IdDescriptionWeight
DEBIT-NOTE-TC-001Verify debit note generated for member additionHigh
DEBIT-NOTE-TC-002Verify debit note generated for benefit upgradeHigh
DEBIT-NOTE-TC-003Verify pro-rated premium calculated correctlyHigh
DEBIT-NOTE-TC-004Verify debit note synced to Sage ARHigh
DEBIT-NOTE-TC-005Verify debit note sent to clientHigh
DEBIT-NOTE-TC-006Verify original invoice updated with debit noteMedium

4.5 Ft Fin Credit Note

4.5.1 Priority

Must Have

4.5.2 User Story

As a finance officer, I want to generate credit notes for refunds and cancellations so that I can process premium refunds accurately

4.5.3 Preconditions

Refund approved or policy canceled

4.5.4 Postconditions

Credit note generated, Sage synced, refund processed

4.5.5 Test Cases

IdDescriptionWeight
CREDIT-NOTE-TC-001Verify credit note generated for policy cancellationHigh
CREDIT-NOTE-TC-002Verify credit note generated for member deletionHigh
CREDIT-NOTE-TC-003Verify refund amount calculated correctlyHigh
CREDIT-NOTE-TC-004Verify credit note requires approvalHigh
CREDIT-NOTE-TC-005Verify credit note synced to SageHigh
CREDIT-NOTE-TC-006Verify credit note sent to clientHigh

4.6 Ft Fin Payment Channels

4.6.1 Priority

Must Have

4.6.2 User Story

As a client, I want to pay through multiple channels so that I can choose convenient payment method

4.6.3 Preconditions

Invoice generated, payment channels configured

4.6.4 Postconditions

Payment collected via chosen channel, recorded in system

4.6.5 Test Cases

IdDescriptionWeight
PAYMENT-CHANNELS-TC-001Verify bank transfer payment acceptedHigh
PAYMENT-CHANNELS-TC-002Verify M-Pesa payment acceptedHigh
PAYMENT-CHANNELS-TC-003Verify Tigo Pesa payment acceptedHigh
PAYMENT-CHANNELS-TC-004Verify Airtel Money payment acceptedHigh
PAYMENT-CHANNELS-TC-005Verify credit card payment acceptedHigh
PAYMENT-CHANNELS-TC-006Verify cash payment recordedHigh
PAYMENT-CHANNELS-TC-007Verify payment gateway integration functionalHigh

4.7 Ft Fin Payment Allocation

4.7.1 Priority

Must Have

4.7.2 User Story

As a finance officer, I want to automatically allocate payments to invoices so that I can update accounts receivable accurately

4.7.3 Preconditions

Payment received, invoices outstanding

4.7.4 Postconditions

Payment allocated to invoice, AR updated, Sage synced

4.7.5 Test Cases

IdDescriptionWeight
PAYMENT-ALLOCATION-TC-001Verify payment matched by reference numberHigh
PAYMENT-ALLOCATION-TC-002Verify auto-allocation to invoiceHigh
PAYMENT-ALLOCATION-TC-003Verify manual allocation for unmatched paymentsHigh
PAYMENT-ALLOCATION-TC-004Verify partial payment allocationHigh
PAYMENT-ALLOCATION-TC-005Verify allocation synced to SageHigh
PAYMENT-ALLOCATION-TC-006Verify invoice status updated after full paymentHigh

4.8 Ft Fin Receipt Generation

4.8.1 Priority

Must Have

4.8.2 User Story

As a client, I want to receive official receipt immediately upon payment so that I have proof of payment

4.8.3 Preconditions

Payment confirmed

4.8.4 Postconditions

Receipt generated, sent to client, Sage synced

4.8.5 Test Cases

IdDescriptionWeight
RECEIPT-GENERATION-TC-001Verify receipt auto-generated upon payment confirmationHigh
RECEIPT-GENERATION-TC-002Verify receipt includes receipt numberHigh
RECEIPT-GENERATION-TC-003Verify receipt includes payer detailsHigh
RECEIPT-GENERATION-TC-004Verify receipt includes amount and payment methodHigh
RECEIPT-GENERATION-TC-005Verify receipt sent via SMSHigh
RECEIPT-GENERATION-TC-006Verify receipt sent via emailHigh
RECEIPT-GENERATION-TC-007Verify receipt synced to SageHigh

4.9 Ft Fin Partial Payment

4.9.1 Priority

Must Have

4.9.2 User Story

As a finance officer, I want to accept and track partial payments so that I can allow clients to pay in installments

4.9.3 Preconditions

Invoice outstanding, partial payment received

4.9.4 Postconditions

Partial payment recorded, outstanding balance updated, receipt issued

4.9.5 Test Cases

IdDescriptionWeight
PARTIAL-PAYMENT-TC-001Verify partial payment acceptedHigh
PARTIAL-PAYMENT-TC-002Verify outstanding balance calculatedHigh
PARTIAL-PAYMENT-TC-003Verify multiple receipts for installmentsHigh
PARTIAL-PAYMENT-TC-004Verify payment plan trackingMedium
PARTIAL-PAYMENT-TC-005Verify invoice status shows partial paymentHigh
PARTIAL-PAYMENT-TC-006Verify final payment clears invoiceHigh

4.10 Ft Fin Overpayment

4.10.1 Priority

Must Have

4.10.2 User Story

As a finance officer, I want to handle overpayments with credit balance or refund so that I can manage excess payments appropriately

4.10.3 Preconditions

Payment exceeds invoice amount

4.10.4 Postconditions

Overpayment detected, applied to credit balance or refunded

4.10.5 Test Cases

IdDescriptionWeight
OVERPAYMENT-TC-001Verify overpayment detectionHigh
OVERPAYMENT-TC-002Verify option to apply to credit balanceHigh
OVERPAYMENT-TC-003Verify option to refund excessHigh
OVERPAYMENT-TC-004Verify client notified of overpaymentHigh
OVERPAYMENT-TC-005Verify credit balance applied to future invoicesHigh
OVERPAYMENT-TC-006Verify refund processing if client requestsHigh

4.11 Ft Fin Payment Gateway

4.11.1 Priority

Must Have

4.11.2 User Story

As a client, I want to pay online securely so that I can make payments conveniently

4.11.3 Preconditions

Payment gateway integrated, online payment initiated

4.11.4 Postconditions

Payment processed securely, confirmation received, system updated

4.11.5 Test Cases

IdDescriptionWeight
PAYMENT-GATEWAY-TC-001Verify payment gateway integration (DPO/Flutterwave)High
PAYMENT-GATEWAY-TC-002Verify secure payment processingHigh
PAYMENT-GATEWAY-TC-003Verify callback handlingHigh
PAYMENT-GATEWAY-TC-004Verify payment status trackingHigh
PAYMENT-GATEWAY-TC-005Verify failed payment handlingHigh
PAYMENT-GATEWAY-TC-006Verify payment confirmation to clientHigh

4.12 Ft Fin Ar Dashboard

4.12.1 Priority

Must Have

4.12.2 User Story

As a finance manager, I want to view accounts receivable dashboard so that I can monitor outstanding payments

4.12.3 Preconditions

AR data available

4.12.4 Postconditions

Dashboard displays AR metrics and trends

4.12.5 Test Cases

IdDescriptionWeight
AR-DASHBOARD-TC-001Verify total AR displayedHigh
AR-DASHBOARD-TC-002Verify aging analysis shown (0-30, 31-60, 61-90, 90+)High
AR-DASHBOARD-TC-003Verify payment trends chartHigh
AR-DASHBOARD-TC-004Verify overdue invoices listHigh
AR-DASHBOARD-TC-005Verify collection efficiency ratioMedium
AR-DASHBOARD-TC-006Verify dashboard refreshed in real-timeMedium

4.13 Ft Fin Ar Aging

4.13.1 Priority

Must Have

4.13.2 User Story

As a finance officer, I want to generate AR aging report so that I can identify overdue accounts for follow-up

4.13.3 Preconditions

Outstanding invoices exist

4.13.4 Postconditions

Aging report generated showing buckets

4.13.5 Test Cases

IdDescriptionWeight
AR-AGING-TC-001Verify aging buckets (current, 1-30, 31-60, 61-90, 90+)High
AR-AGING-TC-002Verify aging by clientHigh
AR-AGING-TC-003Verify aging by productHigh
AR-AGING-TC-004Verify aging by agentMedium
AR-AGING-TC-005Verify overdue amounts highlightedHigh
AR-AGING-TC-006Verify report exportable to ExcelMedium

4.14 Ft Fin Payment Reminder

4.14.1 Priority

Must Have

4.14.2 User Story

As a finance officer, I want to send automated payment reminders so that I can improve collection rates

4.14.3 Preconditions

Outstanding invoices, reminder schedule configured

4.14.4 Postconditions

Reminders sent per schedule, delivery tracked

4.14.5 Test Cases

IdDescriptionWeight
PAYMENT-REMINDER-TC-001Verify reminder sent 7 days before due dateHigh
PAYMENT-REMINDER-TC-002Verify reminder sent on due dateHigh
PAYMENT-REMINDER-TC-003Verify reminder sent 7 days after due dateHigh
PAYMENT-REMINDER-TC-004Verify reminders sent via SMSHigh
PAYMENT-REMINDER-TC-005Verify reminders sent via emailHigh
PAYMENT-REMINDER-TC-006Verify reminder schedule configurableMedium
PAYMENT-REMINDER-TC-007Verify reminders stop after paymentHigh

4.15 Ft Fin Bad Debt

4.15.1 Priority

Should Have

4.15.2 User Story

As a finance manager, I want to write off bad debts with approval so that I can clear uncollectible receivables

4.15.3 Preconditions

Uncollectible debt identified

4.15.4 Postconditions

Bad debt written off, Sage synced, audit trail maintained

4.15.5 Test Cases

IdDescriptionWeight
BAD-DEBT-TC-001Verify bad debt write-off workflowHigh
BAD-DEBT-TC-002Verify manager approval requiredHigh
BAD-DEBT-TC-003Verify write-off reason documentedHigh
BAD-DEBT-TC-004Verify write-off synced to SageHigh
BAD-DEBT-TC-005Verify audit trail maintainedHigh
BAD-DEBT-TC-006Verify bad debt report availableMedium

4.16 Ft Fin Refund Request

4.16.1 Priority

Must Have

4.16.2 User Story

As a finance officer, I want to process refund requests with approval workflow so that I can handle refunds systematically

4.16.3 Preconditions

Refund request received

4.16.4 Postconditions

Refund approved or rejected, processed if approved

4.16.5 Test Cases

IdDescriptionWeight
REFUND-REQUEST-TC-001Verify refund request captured with reasonHigh
REFUND-REQUEST-TC-002Verify refund reasons (cancellation, overpayment, member deletion)High
REFUND-REQUEST-TC-003Verify refund approval workflowHigh
REFUND-REQUEST-TC-004Verify manager approval requiredHigh
REFUND-REQUEST-TC-005Verify refund calculation initiatedHigh
REFUND-REQUEST-TC-006Verify client notified of approval/rejectionHigh

4.17 Ft Fin Refund Calculation

4.17.1 Priority

Must Have

4.17.2 User Story

As a finance officer, I want to calculate refunds based on policy terms so that I can ensure accurate refund amounts

4.17.3 Preconditions

Refund approved, policy terms defined

4.17.4 Postconditions

Refund amount calculated, credit note generated

4.17.5 Test Cases

IdDescriptionWeight
REFUND-CALCULATION-TC-001Verify pro-rata calculation for mid-term cancellationHigh
REFUND-CALCULATION-TC-002Verify admin fees deducted if applicableHigh
REFUND-CALCULATION-TC-003Verify full refund for cancellation within cooling periodHigh
REFUND-CALCULATION-TC-004Verify refund calculation synced to SageHigh
REFUND-CALCULATION-TC-005Verify refund amount displayed to approverHigh

4.18 Ft Fin Refund Payment

4.18.1 Priority

Must Have

4.18.2 User Story

As a finance officer, I want to process refund payments via multiple methods so that I can return funds to clients efficiently

4.18.3 Preconditions

Refund approved and calculated

4.18.4 Postconditions

Refund payment processed, client notified, Sage AP updated

4.18.5 Test Cases

IdDescriptionWeight
REFUND-PAYMENT-TC-001Verify refund via bank transferHigh
REFUND-PAYMENT-TC-002Verify refund via mobile moneyHigh
REFUND-PAYMENT-TC-003Verify refund via chequeMedium
REFUND-PAYMENT-TC-004Verify refund voucher generatedHigh
REFUND-PAYMENT-TC-005Verify refund synced to Sage APHigh
REFUND-PAYMENT-TC-006Verify client notified of refundHigh

4.19 Ft Fin Commission Payment

4.19.1 Priority

Must Have

4.19.2 User Story

As a finance officer, I want to process commission payments to agents so that I can disburse earned commissions

4.19.3 Preconditions

Commission voucher from sales module, approval obtained

4.19.4 Postconditions

Commission paid, agent notified, Sage AP updated

4.19.5 Test Cases

IdDescriptionWeight
COMMISSION-PAYMENT-TC-001Verify commission voucher received from sales moduleHigh
COMMISSION-PAYMENT-TC-002Verify commission approval workflowHigh
COMMISSION-PAYMENT-TC-003Verify batch payment processingHigh
COMMISSION-PAYMENT-TC-004Verify commission synced to Sage APHigh
COMMISSION-PAYMENT-TC-005Verify agent notified of paymentHigh
COMMISSION-PAYMENT-TC-006Verify payment tracking and historyMedium

4.20 Ft Fin Provider Payment

4.20.1 Priority

Must Have

4.20.2 User Story

As a finance officer, I want to process provider payments for claims so that I can reimburse healthcare providers

4.20.3 Preconditions

Provider invoice from claims module, approved for payment

4.20.4 Postconditions

Provider paid, payment tracked, Sage AP updated

4.20.5 Test Cases

IdDescriptionWeight
PROVIDER-PAYMENT-TC-001Verify provider invoice received from claims moduleHigh
PROVIDER-PAYMENT-TC-002Verify payment schedule (monthly, bi-weekly)High
PROVIDER-PAYMENT-TC-003Verify batch processing for multiple providersHigh
PROVIDER-PAYMENT-TC-004Verify payment synced to Sage APHigh
PROVIDER-PAYMENT-TC-005Verify provider notified of paymentHigh
PROVIDER-PAYMENT-TC-006Verify remittance advice sent to providerHigh

4.21 Ft Fin Reinsurance Premium

4.21.1 Priority

Must Have

4.21.2 User Story

As a finance officer, I want to process reinsurance premium payments so that I can pay reinsurance premiums to reinsurers

4.21.3 Preconditions

Reinsurance premium calculated from reinsurance module

4.21.4 Postconditions

Reinsurance premium paid, payment tracked, Sage AP updated

4.21.5 Test Cases

IdDescriptionWeight
REINSURANCE-PREMIUM-TC-001Verify reinsurance premium calculation receivedHigh
REINSURANCE-PREMIUM-TC-002Verify payment to multiple reinsurersHigh
REINSURANCE-PREMIUM-TC-003Verify payment schedule per treaty termsHigh
REINSURANCE-PREMIUM-TC-004Verify payment synced to Sage APHigh
REINSURANCE-PREMIUM-TC-005Verify payment confirmation to reinsurerHigh

4.22 Ft Fin Ap Approval

4.22.1 Priority

Must Have

4.22.2 User Story

As a finance manager, I want to implement maker-checker for AP payments so that I can ensure payment accuracy and prevent fraud

4.22.3 Preconditions

Payment voucher created

4.22.4 Postconditions

Payment approved by checker, processed for disbursement

4.22.5 Test Cases

IdDescriptionWeight
AP-APPROVAL-TC-001Verify maker creates payment voucherHigh
AP-APPROVAL-TC-002Verify checker approval requiredHigh
AP-APPROVAL-TC-003Verify approval limits by amountHigh
AP-APPROVAL-TC-004Verify maker cannot approve own voucherHigh
AP-APPROVAL-TC-005Verify rejection requires reasonHigh
AP-APPROVAL-TC-006Verify audit trail for approvalsHigh

4.23 Ft Fin Payment Batch

4.23.1 Priority

Must Have

4.23.2 User Story

As a finance officer, I want to process payments in batches so that I can efficiently handle multiple payments

4.23.3 Preconditions

Multiple payments approved

4.23.4 Postconditions

Batch payment file generated, approved, sent to bank

4.23.5 Test Cases

IdDescriptionWeight
PAYMENT-BATCH-TC-001Verify batch payment file generationHigh
PAYMENT-BATCH-TC-002Verify bank file format supportHigh
PAYMENT-BATCH-TC-003Verify batch approval workflowHigh
PAYMENT-BATCH-TC-004Verify batch synced to SageHigh
PAYMENT-BATCH-TC-005Verify batch status trackingHigh
PAYMENT-BATCH-TC-006Verify individual payment status within batchHigh

4.24 Ft Fin Bank Reconciliation

4.24.1 Priority

Must Have

4.24.2 User Story

As a finance officer, I want to reconcile bank statements with system records so that I can ensure accuracy of financial records

4.24.3 Preconditions

Bank statement available, system transactions recorded

4.24.4 Postconditions

Reconciliation completed, discrepancies identified

4.24.5 Test Cases

IdDescriptionWeight
BANK-RECONCILIATION-TC-001Verify bank statement upload (CSV, Excel)High
BANK-RECONCILIATION-TC-002Verify auto-matching by amount and dateHigh
BANK-RECONCILIATION-TC-003Verify manual matching for exceptionsHigh
BANK-RECONCILIATION-TC-004Verify reconciliation report generationHigh
BANK-RECONCILIATION-TC-005Verify discrepancy flaggingHigh
BANK-RECONCILIATION-TC-006Verify reconciliation history maintainedMedium

4.25 Ft Fin Payment Gateway Recon

4.25.1 Priority

Must Have

4.25.2 User Story

As a finance officer, I want to reconcile payment gateway transactions so that I can verify all online payments captured

4.25.3 Preconditions

Payment gateway report available

4.25.4 Postconditions

Gateway transactions reconciled with system payments

4.25.5 Test Cases

IdDescriptionWeight
PAYMENT-GATEWAY-RECON-TC-001Verify gateway report downloadHigh
PAYMENT-GATEWAY-RECON-TC-002Verify matching with system paymentsHigh
PAYMENT-GATEWAY-RECON-TC-003Verify discrepancy identificationHigh
PAYMENT-GATEWAY-RECON-TC-004Verify discrepancy resolution workflowHigh
PAYMENT-GATEWAY-RECON-TC-005Verify reconciliation reportMedium

4.26 Ft Fin Sage Reconciliation

4.26.1 Priority

Must Have

4.26.2 User Story

As a finance officer, I want to reconcile SAS transactions with Sage ERP so that I can ensure data consistency between systems

4.26.3 Preconditions

SAS and Sage transactions recorded

4.26.4 Postconditions

Daily reconciliation completed, discrepancies identified

4.26.5 Test Cases

IdDescriptionWeight
SAGE-RECONCILIATION-TC-001Verify daily reconciliation scheduledHigh
SAGE-RECONCILIATION-TC-002Verify AR reconciliationHigh
SAGE-RECONCILIATION-TC-003Verify AP reconciliationHigh
SAGE-RECONCILIATION-TC-004Verify receipts reconciliationHigh
SAGE-RECONCILIATION-TC-005Verify payments reconciliationHigh
SAGE-RECONCILIATION-TC-006Verify discrepancy reportingHigh
SAGE-RECONCILIATION-TC-007Verify reconciliation dashboardMedium

4.27 Ft Fin Suspense Account

4.27.1 Priority

Must Have

4.27.2 User Story

As a finance officer, I want to manage suspense account for unallocated payments so that I can track payments pending allocation

4.27.3 Preconditions

Unmatched payments received

4.27.4 Postconditions

Payments in suspense tracked, allocated or resolved

4.27.5 Test Cases

IdDescriptionWeight
SUSPENSE-ACCOUNT-TC-001Verify unmatched payments to suspenseHigh
SUSPENSE-ACCOUNT-TC-002Verify manual allocation from suspenseHigh
SUSPENSE-ACCOUNT-TC-003Verify aging of suspense itemsHigh
SUSPENSE-ACCOUNT-TC-004Verify suspense account dashboardMedium
SUSPENSE-ACCOUNT-TC-005Verify alerts for old suspense itemsMedium

4.28 Ft Fin Multi Currency

4.28.1 Priority

Must Have

4.28.2 User Story

As a finance officer, I want to support multiple currencies so that I can handle transactions in different currencies

4.28.3 Preconditions

Multi-currency configured

4.28.4 Postconditions

Transactions processed in chosen currency, reporting accurate

4.28.5 Test Cases

IdDescriptionWeight
MULTI-CURRENCY-TC-001Verify TZS currency supportedHigh
MULTI-CURRENCY-TC-002Verify KES currency supportedHigh
MULTI-CURRENCY-TC-003Verify USD currency supportedHigh
MULTI-CURRENCY-TC-004Verify currency selection at policy levelHigh
MULTI-CURRENCY-TC-005Verify currency conversion for reportingHigh
MULTI-CURRENCY-TC-006Verify exchange gain/loss trackingMedium

4.29 Ft Fin Exchange Rate

4.29.1 Priority

Must Have

4.29.2 User Story

As a finance officer, I want to manage exchange rates so that I can convert between currencies accurately

4.29.3 Preconditions

Multiple currencies in use

4.29.4 Postconditions

Exchange rates configured and applied correctly

4.29.5 Test Cases

IdDescriptionWeight
EXCHANGE-RATE-TC-001Verify exchange rate configurationHigh
EXCHANGE-RATE-TC-002Verify daily rate updatesHigh
EXCHANGE-RATE-TC-003Verify historical rates maintainedHigh
EXCHANGE-RATE-TC-004Verify rate source (BOT, CBK)Medium
EXCHANGE-RATE-TC-005Verify rate effective datesHigh
EXCHANGE-RATE-TC-006Verify rate changes tracked in audit logMedium

4.30 Ft Fin Currency Conversion

4.30.1 Priority

Must Have

4.30.2 User Story

As a finance officer, I want to convert transactions to base currency for reporting so that I can consolidate financial reports

4.30.3 Preconditions

Transactions in multiple currencies, base currency defined

4.30.4 Postconditions

All transactions converted to base currency for reporting

4.30.5 Test Cases

IdDescriptionWeight
CURRENCY-CONVERSION-TC-001Verify base currency set to TZSHigh
CURRENCY-CONVERSION-TC-002Verify automatic conversion using exchange ratesHigh
CURRENCY-CONVERSION-TC-003Verify conversion at transaction date rateHigh
CURRENCY-CONVERSION-TC-004Verify conversion tracking for auditMedium
CURRENCY-CONVERSION-TC-005Verify converted amounts in reportsHigh

4.31 Ft Fin Revenue Report

4.31.1 Priority

Must Have

4.31.2 User Story

As a finance manager, I want to generate premium revenue report so that I can track premium income

4.31.3 Preconditions

Revenue data available

4.31.4 Postconditions

Revenue report generated with breakdown and trends

4.31.5 Test Cases

IdDescriptionWeight
REVENUE-REPORT-TC-001Verify revenue by periodHigh
REVENUE-REPORT-TC-002Verify revenue by productHigh
REVENUE-REPORT-TC-003Verify revenue by channelHigh
REVENUE-REPORT-TC-004Verify revenue by agentMedium
REVENUE-REPORT-TC-005Verify earned vs written premiumHigh
REVENUE-REPORT-TC-006Verify trend analysisMedium

4.32 Ft Fin Collection Report

4.32.1 Priority

Must Have

4.32.2 User Story

As a finance manager, I want to generate collection report so that I can monitor cash flow

4.32.3 Preconditions

Collection data available

4.32.4 Postconditions

Collection report showing collections by method and period

4.32.5 Test Cases

IdDescriptionWeight
COLLECTION-REPORT-TC-001Verify collections by payment methodHigh
COLLECTION-REPORT-TC-002Verify collections by periodHigh
COLLECTION-REPORT-TC-003Verify collection efficiency ratioHigh
COLLECTION-REPORT-TC-004Verify outstanding AR shownHigh
COLLECTION-REPORT-TC-005Verify collection trendsMedium

4.33 Ft Fin Payment Report

4.33.1 Priority

Must Have

4.33.2 User Story

As a finance manager, I want to generate payment report (AP) so that I can track outgoing payments

4.33.3 Preconditions

Payment data available

4.33.4 Postconditions

Payment report showing payments by type and period

4.33.5 Test Cases

IdDescriptionWeight
PAYMENT-REPORT-TC-001Verify payments by type (commission, provider, reinsurance)High
PAYMENT-REPORT-TC-002Verify payments by periodHigh
PAYMENT-REPORT-TC-003Verify payment trendsMedium
PAYMENT-REPORT-TC-004Verify outstanding AP shownHigh
PAYMENT-REPORT-TC-005Verify payment method breakdownMedium

4.34 Ft Fin Cashflow Report

4.34.1 Priority

Must Have

4.34.2 User Story

As a CFO, I want to generate cash flow report so that I can monitor liquidity

4.34.3 Preconditions

Cash flow data available

4.34.4 Postconditions

Cash flow report showing inflows vs outflows

4.34.5 Test Cases

IdDescriptionWeight
CASHFLOW-REPORT-TC-001Verify cash inflows shownHigh
CASHFLOW-REPORT-TC-002Verify cash outflows shownHigh
CASHFLOW-REPORT-TC-003Verify net cash flow calculatedHigh
CASHFLOW-REPORT-TC-004Verify cash position by periodHigh
CASHFLOW-REPORT-TC-005Verify forecast vs actualMedium

4.35 Ft Fin Financial Dashboard

4.35.1 Priority

Must Have

4.35.2 User Story

As a CFO, I want to view real-time financial dashboard so that I can monitor key financial metrics

4.35.3 Preconditions

Financial data available

4.35.4 Postconditions

Dashboard displays real-time metrics and trends

4.35.5 Test Cases

IdDescriptionWeight
FINANCIAL-DASHBOARD-TC-001Verify revenue metrics displayedHigh
FINANCIAL-DASHBOARD-TC-002Verify collections metrics displayedHigh
FINANCIAL-DASHBOARD-TC-003Verify payments metrics displayedHigh
FINANCIAL-DASHBOARD-TC-004Verify AR and AP balances shownHigh
FINANCIAL-DASHBOARD-TC-005Verify cash balance displayedHigh
FINANCIAL-DASHBOARD-TC-006Verify trend chartsMedium
FINANCIAL-DASHBOARD-TC-007Verify KPIs calculatedHigh

4.36 Ft Fin Maker Checker

4.36.1 Priority

Must Have

4.36.2 User Story

As a finance manager, I want to implement maker-checker for financial transactions so that I can prevent unauthorized transactions

4.36.3 Preconditions

Maker-checker workflow configured

4.36.4 Postconditions

Financial transactions require checker approval

4.36.5 Test Cases

IdDescriptionWeight
MAKER-CHECKER-TC-001Verify maker-checker for payments above thresholdHigh
MAKER-CHECKER-TC-002Verify maker-checker for refundsHigh
MAKER-CHECKER-TC-003Verify maker-checker for credit notesHigh
MAKER-CHECKER-TC-004Verify maker-checker for write-offsHigh
MAKER-CHECKER-TC-005Verify approval limits enforcedHigh
MAKER-CHECKER-TC-006Verify maker cannot approve own transactionHigh

4.37 Ft Fin Approval Limits

4.37.1 Priority

Must Have

4.37.2 User Story

As a finance manager, I want to set approval limits by user level so that I can control transaction authorization

4.37.3 Preconditions

Approval limits configured

4.37.4 Postconditions

Limits enforced, escalation workflow operational

4.37.5 Test Cases

IdDescriptionWeight
APPROVAL-LIMITS-TC-001Verify approval limits by amountHigh
APPROVAL-LIMITS-TC-002Verify limits per user levelHigh
APPROVAL-LIMITS-TC-003Verify escalation workflow when limits exceededHigh
APPROVAL-LIMITS-TC-004Verify override with senior approvalHigh
APPROVAL-LIMITS-TC-005Verify limit changes tracked in audit logMedium

4.38 Ft Fin Audit Log

4.38.1 Priority

Must Have

4.38.2 User Story

As an auditor, I want to maintain comprehensive audit log of financial transactions so that I can support audit and compliance

4.38.3 Preconditions

Audit logging enabled

4.38.4 Postconditions

Comprehensive audit logs maintained, searchable and exportable

4.38.5 Test Cases

IdDescriptionWeight
AUDIT-LOG-TC-001Verify audit log captures user for each actionHigh
AUDIT-LOG-TC-002Verify audit log captures action performedHigh
AUDIT-LOG-TC-003Verify audit log captures timestampHigh
AUDIT-LOG-TC-004Verify audit log captures old and new valuesHigh
AUDIT-LOG-TC-005Verify audit logs immutableHigh
AUDIT-LOG-TC-006Verify audit logs searchableHigh
AUDIT-LOG-TC-007Verify audit logs exportableHigh

4.39 Ft Fin Segregation Duties

4.39.1 Priority

Must Have

4.39.2 User Story

As a compliance officer, I want to enforce segregation of duties so that I can prevent fraud

4.39.3 Preconditions

Role-based access configured

4.39.4 Postconditions

Segregation of duties enforced, violations blocked

4.39.5 Test Cases

IdDescriptionWeight
SEGREGATION-DUTIES-TC-001Verify role-based access controlHigh
SEGREGATION-DUTIES-TC-002Verify maker cannot be checkerHigh
SEGREGATION-DUTIES-TC-003Verify payment creator cannot approveHigh
SEGREGATION-DUTIES-TC-004Verify violations blocked by systemHigh
SEGREGATION-DUTIES-TC-005Verify segregation violations loggedMedium