Wiki source code of Managing Invoices
Last modified by David Stadnyk on 2026/04/06 15:23
Hide last authors
| author | version | line-number | content |
|---|---|---|---|
| |
1.1 | 1 | {{include reference="KBArticleHeader.WebHome"/}} |
| 2 | |||
| |
21.2 | 3 | = Billing = |
| |
1.1 | 4 | |
| |
23.2 | 5 | [[image:1775488762250-822.png]] |
| 6 | |||
| |
21.2 | 7 | The **Billing** section is a core module of the application, accessible from the left-hand navigation sidebar. It provides tools for managing financial transactions related to members, including invoice creation, tracking, and payment management. |
| |
1.1 | 8 | |
| |
21.2 | 9 | ---- |
| |
1.1 | 10 | |
| |
21.2 | 11 | == Overview == |
| |
19.2 | 12 | |
| |
21.2 | 13 | The Billing module is divided into two main tabs: |
| |
19.2 | 14 | |
| |
21.2 | 15 | * **Manage Invoices** – Search, view, and manage member invoices. |
| 16 | * **Manage Payments** – View and process scheduled payments for member contracts. | ||
| |
23.2 | 17 | * [[image:1775488779193-956.png]] |
| |
19.2 | 18 | |
| |
21.2 | 19 | ---- |
| |
1.1 | 20 | |
| |
21.2 | 21 | == Manage Invoices == |
| |
1.1 | 22 | |
| |
21.2 | 23 | The **Manage Invoices** tab allows staff to search for invoices using a variety of filters and perform bulk or individual actions on the results. |
| |
1.1 | 24 | |
| |
21.2 | 25 | === Search and Filter Panel === |
| |
1.1 | 26 | |
| |
21.2 | 27 | Users can narrow invoice results using the following filter fields: |
| |
1.1 | 28 | |
| |
21.2 | 29 | * **Invoice ID** – Filter by a specific invoice number. |
| 30 | * **From / To** – Define a date range for the invoice search. Dates can be entered manually or selected using the calendar picker. | ||
| 31 | * **Member ID** – Filter by a specific member's ID. | ||
| 32 | * **Group** – Filter by member group. Defaults to //All//. | ||
| 33 | * **First Name / Last Name** – Filter by the member's name. | ||
| 34 | * **Approved** – Filter by approval status. Defaults to //Approved//. | ||
| 35 | * **Payment** – Filter by payment status. Defaults to //All//. | ||
| |
1.1 | 36 | |
| |
21.2 | 37 | Once filters are set, users can click the **Search** button to retrieve matching invoices. |
| |
1.1 | 38 | |
| |
21.2 | 39 | ==== Create Invoices Due ==== |
| |
1.1 | 40 | |
| |
21.2 | 41 | The **Create Invoices Due** button, located next to the Search button, allows staff to automatically generate invoices for members with outstanding balances due. Clicking the button opens a confirmation dialog asking //"Are you sure you would like to create invoices due today?"// Staff must click **Yes** to proceed or **No** to cancel the action. |
| |
1.1 | 42 | |
| |
21.2 | 43 | ---- |
| |
1.1 | 44 | |
| |
21.2 | 45 | === Invoices Table === |
| |
1.1 | 46 | |
| |
21.2 | 47 | Search results are displayed in the **Invoices** table. The table supports row selection via checkboxes and includes the following columns: |
| |
1.1 | 48 | |
| |
21.2 | 49 | |=Column|=Description |
| 50 | |**Invoice ID**|A unique numeric identifier for each invoice. | ||
| 51 | |**Date of Invoice**|The date the invoice was generated. | ||
| 52 | |**First Name**|The first name of the member associated with the invoice. | ||
| 53 | |**Last Name**|The last name of the member associated with the invoice. | ||
| 54 | |**Amount**|The total amount of the invoice. | ||
| 55 | |**Paid**|The amount that has been paid toward the invoice. | ||
| 56 | |**Balance Due**|The remaining unpaid balance on the invoice. | ||
| 57 | |**Sales Person**|The staff member associated with the invoice, if applicable. | ||
| 58 | |**Invoice Status**|The current status of the invoice (e.g., //Approved//). | ||
| |
1.1 | 59 | |
| |
24.2 | 60 | ==== [[image:1775488857341-436.png]] ==== |
| 61 | |||
| |
21.2 | 62 | ==== Table Actions ==== |
| |
1.1 | 63 | |
| |
21.2 | 64 | The toolbar at the top of the Invoices table provides the following actions (applied to selected rows): |
| |
1.1 | 65 | |
| |
21.2 | 66 | * **Approve** – Approve the selected invoice(s). |
| 67 | * **Edit** – Edit the selected invoice(s). | ||
| 68 | * **Delete** – Delete the selected invoice(s). | ||
| 69 | * **Cancel** – Cancel the selected invoice(s). | ||
| 70 | * **Email** – Email the selected invoice(s) to the member. | ||
| 71 | * **Print** – Print the selected invoice(s). | ||
| 72 | * **More options** – Additional actions via dropdown. | ||
| |
1.1 | 73 | |
| |
21.2 | 74 | ---- |
| 75 | |||
| 76 | === Invoice Detail View === | ||
| 77 | |||
| 78 | Clicking on an **Invoice ID** in the Invoices table opens the full detail view for that invoice. A selected invoice row is highlighted in blue. | ||
| 79 | |||
| |
25.2 | 80 | [[image:1775488937441-931.png]] |
| 81 | |||
| |
21.2 | 82 | ==== Header ==== |
| 83 | |||
| 84 | The top of the detail view displays key reference information: | ||
| 85 | |||
| 86 | * **Invoice Number** – The unique invoice identifier. | ||
| 87 | * **Contract ID** – The contract associated with this invoice. | ||
| 88 | * **MSI #** – The MSI (Member Service Item) reference number. | ||
| 89 | * **Sold By** – The staff member who made the sale, if applicable. | ||
| 90 | * **Invoice For** – The full name of the member the invoice belongs to. | ||
| 91 | * **Date** – The date of the invoice. | ||
| 92 | |||
| 93 | ==== Line Items Table ==== | ||
| 94 | |||
| 95 | A table lists the products or services included on the invoice, with the following columns: | ||
| 96 | |||
| 97 | |=Column|=Description | ||
| 98 | |**Product ID**|The unique identifier for the product or service. | ||
| 99 | |**Purchased For**|The member the item was purchased for. | ||
| 100 | |**Name**|The name of the product or service. | ||
| 101 | |**Quantity**|The number of units purchased. | ||
| 102 | |**Price/Item**|The per-unit price. | ||
| 103 | |**Discount**|Any discount applied to the item. | ||
| 104 | |**Tax**|The tax rate or amount applied. | ||
| 105 | |**Amount Due**|The total amount due for that line item. | ||
| 106 | |||
| 107 | ==== MSI Fees ==== | ||
| 108 | |||
| 109 | The **MSI Fees** panel on the left side of the invoice displays any additional fees associated with the invoice: | ||
| 110 | |||
| 111 | * **Late Fee** – A fee applied for late payment. | ||
| 112 | * **Processing Fee** – A fee for payment processing. | ||
| 113 | * **Return Fee** – A fee applied for returned payments. | ||
| 114 | * **Total Fees Paid** – The sum of fees that have been paid. | ||
| 115 | * **Total Fees Due** – The sum of fees still outstanding. | ||
| 116 | |||
| 117 | ==== Invoice Totals ==== | ||
| 118 | |||
| 119 | The totals panel on the right provides a full financial breakdown: | ||
| 120 | |||
| 121 | |=Field|=Description | ||
| 122 | |**Item(s) Total**|The sum of all line item amounts. | ||
| 123 | |**Discounts**|Total discounts applied. | ||
| 124 | |**Taxes**|Total tax applied. | ||
| 125 | |**Refunds**|Any refunds issued against the invoice. | ||
| 126 | |**Adjustments**|Any manual adjustments made to the invoice. For invoices linked to MSI, adjustments cannot be made directly and must be submitted via a formal Adjustment Request. | ||
| 127 | |**Total Fees**|Sum of all MSI fees. | ||
| 128 | |**Subtotal**|The invoice total after discounts, taxes, and fees. | ||
| 129 | |**Amount Paid**|The total amount already paid. | ||
| 130 | |**Payment Amount**|An editable field for entering a payment amount. | ||
| 131 | |**Balance Due**|The remaining unpaid balance. | ||
| 132 | |**Due Now**|The amount currently due for immediate payment. | ||
| 133 | |||
| 134 | ==== Notes ==== | ||
| 135 | |||
| 136 | A free-text **Notes** field allows staff to add comments or internal notes to the invoice. A **Hide Note** toggle can be used to show or hide this section. | ||
| 137 | |||
| 138 | ==== Pay Contract ==== | ||
| 139 | |||
| 140 | Clicking the **Pay Contract** button navigates to the full contract payment page within the member's account. This page is part of the broader member account view and is accessible via the **Account** tab, under the **Contracts** sub-tab. | ||
| 141 | |||
| 142 | ===== Page Navigation ===== | ||
| 143 | |||
| 144 | The member account page contains the following top-level tabs: | ||
| 145 | |||
| 146 | * Profile, Interests, Activities, Contact Log, Questionnaires, Programs, **Account** //(active)//, Admin | ||
| 147 | |||
| 148 | Within the **Account** tab, the following sub-tabs are available: | ||
| 149 | |||
| 150 | * On Account, Remaining, Auto Renewals, **Contracts** //(active)//, Open Invoices, Invoice History, MSI History | ||
| 151 | |||
| 152 | ===== Contract Summary ===== | ||
| 153 | |||
| 154 | The top of the page displays the contract's key details: | ||
| 155 | |||
| 156 | * **Contract Name** – The name of the contract (e.g., //Bob FSB//). | ||
| 157 | * **ID** – The unique contract ID. | ||
| 158 | * **MSI #** – The associated MSI reference number. | ||
| 159 | |||
| 160 | A table lists the scheduled payment installments for the contract, with the following columns: | ||
| 161 | |||
| 162 | |=Column|=Description | ||
| 163 | |**Invoice #**|The invoice number, linked to the invoice detail view. Only generated invoices display a number; future scheduled payments show the date only. | ||
| 164 | |**Payment Date**|The scheduled or actual payment date. | ||
| 165 | |**Invoice Amount**|The amount of each installment. | ||
| 166 | |**Total Fees**|Any fees associated with the installment. | ||
| 167 | |**Amount Paid**|The amount paid toward the installment. | ||
| 168 | |**Status**|The current status of the installment. | ||
| 169 | |**Balance Due**|The remaining balance for the installment. | ||
| 170 | |||
| 171 | Below the table, two summary fields are shown: | ||
| 172 | |||
| 173 | * **Outstanding Payments** – The total amount currently overdue (displayed in red if greater than $0.00). | ||
| 174 | * **Contract Payoff** – The total amount required to fully pay off the contract. | ||
| 175 | |||
| 176 | ===== Payment Method ===== | ||
| 177 | |||
| 178 | Staff can select from the following payment methods using radio buttons: | ||
| 179 | |||
| 180 | |=Method|=Details | ||
| 181 | |**Credit Card on File**|Select from saved credit cards on the member's account. An **Add** link allows a new card to be added. | ||
| 182 | |**ACH Information on File**|Select from saved ACH (bank account) details. An **Add** link allows new ACH details to be added. | ||
| 183 | |**Member Solutions**|Select a payment method managed through Member Solutions. | ||
| 184 | |**Cash**|Record a cash payment. | ||
| 185 | |**Cheque**|Record a cheque payment, with a reference number field. | ||
| 186 | |**Gift Certificate #**|Apply a gift certificate by entering its number. | ||
| 187 | |**Offline Credit Card**|Record a credit card payment processed offline, with card type selector. | ||
| 188 | |**Credit Card**|Enter new credit card details manually, including card number, name on card, CVV, and expiry date. | ||
| 189 | |||
| 190 | ===== Actions ===== | ||
| 191 | |||
| 192 | * **Payment** – A field for entering the payment amount. | ||
| 193 | * **Pay Now** – Submits the payment using the selected method and amount. | ||
| 194 | * **Back** – Returns to the previous invoice detail view without processing a payment. | ||
| 195 | |||
| 196 | ==== Sales Receipt ==== | ||
| 197 | |||
| 198 | A **Sales Receipt** section at the bottom of the invoice detail displays a log of all payment transactions associated with the invoice. It includes the following columns: | ||
| 199 | |||
| 200 | |=Column|=Description | ||
| 201 | |**Date**|The date of the payment transaction. | ||
| 202 | |**Amount**|The payment amount. | ||
| 203 | |**Complete**|Indicates whether the transaction was completed. | ||
| 204 | |**Type**|The type of transaction. | ||
| 205 | |**Method**|The payment method used. | ||
| 206 | |**Code**|A transaction reference code. | ||
| 207 | |**Fields**|Additional transaction data fields. | ||
| 208 | |||
| 209 | Below the transaction log, summary lines show the **Total Paid To Date** and the current **Balance Due**. | ||
| 210 | |||
| 211 | A **Refund Item** button at the bottom right allows staff to initiate a refund for a specific item on the invoice. The Sales Receipt toolbar also includes icons for reversing a payment, emailing, and printing the receipt. | ||
| 212 | |||
| 213 | ---- | ||
| 214 | |||
| 215 | == Manage Payments == | ||
| 216 | |||
| 217 | The **Manage Payments** tab displays a list of **Scheduled Payments** — invoices that are queued for payment processing. This view is primarily used to review outstanding balances and trigger payment runs. | ||
| 218 | |||
| 219 | === Scheduled Payments Table === | ||
| 220 | |||
| 221 | The table includes a **Select All** checkbox in the top-right corner of the header, allowing staff to select all records at once. It contains the following columns: | ||
| 222 | |||
| 223 | |=Column|=Description | ||
| 224 | |**Invoice ID**|A unique numeric identifier for the invoice. | ||
| 225 | |**Date of Invoice**|The date and time the invoice was created. | ||
| 226 | |**Name**|The full name of the member associated with the invoice. | ||
| 227 | |**Amount**|The total invoice amount. | ||
| 228 | |**Paid**|The amount paid toward the invoice. | ||
| 229 | |**Balance Due**|The remaining unpaid balance. | ||
| 230 | |**Last Payment**|The result of the most recent payment attempt (e.g., //Failed//). If blank, no payment attempt has been made. | ||
| 231 | |**Sales Person**|The staff member associated with the invoice, if applicable. | ||
| 232 | |||
| 233 | ==== Last Payment Status ==== | ||
| 234 | |||
| 235 | The **Last Payment** column indicates the outcome of the most recent payment attempt. A status of **Failed** means the last automated payment attempt was unsuccessful, and the balance remains outstanding. | ||
| 236 | |||
| 237 | ==== Process Scheduled Payments ==== | ||
| 238 | |||
| 239 | The **Process Scheduled Payments** button, located at the bottom right of the page, triggers the payment processing run for all scheduled invoices. This will attempt to collect payment for outstanding balances using the payment methods on file for each member. | ||
| 240 | |||
| 241 | |||
| |
1.1 | 242 | {{include reference="KBSupportCTA.WebHome"/}} |