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