Index
Overview
The Invoice Payment Revenue Reconciliation page and Payments - Reconciled Revenue report offer a robust feature set to make cash-based accounting practices with Uplifter a breeze!
The Invoice Payment Revenue Reconciliation page is found by navigating to Accounting > Invoices > Reconcile Revenues. In order to access the Invoice Payment Revenue Reconciliation page you will need the following permissions: Admin, Can Perform Refunds/Delete Paid Payments. The Payments - Reconciled Revenue report is found by navigating to Reports > Payments - Reconciled Revenue. In order to access the Payments - Reconciled Revenue report you will need the following permissions: Admin, Manage Reports.
Further Resources
The article below speaks to basic features and functions of the invoice tool within Uplifter. For further information about each button/element on the invoice edit page you may wish to review our article Invoice Anatomy. For more information on more complex processes such as refunds, adjustments, etc. you will want to review our article Invoice Actions.
Invoice Payment Revenue Reconciliation
Upon the creation of an invoice, Uplifter will perform calculations to attribute the revenue of the purchased items to the various payments and owing balances. The algorithms used for this will follow the same logic as the various installment structures (if any) of the involved items. In so doing, we can generate a very accurate picture of the revenue separation among the payments.
The Invoice Payment Revenue Reconciliation Page
- Navigate to Accounting > Invoices
- Click Reconcile Revenues
Page Dissection
- Invoice information including the invoice number, date, member, and billing name. A warning icon may appear if your invoice was created before this feature was launched. This icon indicates the invoice was updated using our "back-filling" method, rather than organically during the time of invoice creation.
- The table legend offers insight into the various colours and icons used within the page.
- The Payments row separates the invoice's payments into cells. Therein, each cell will note the date of payment (or expected payment) and method. Paid payments will also have a Help
icon that you can hover over to see more information about the payment.
- The Items column notes each item purchased on the invoice. If any of the items have adjustments or discounts, the listing will be contracted. Click on the listing to expand it and view all details. The expansion of the listing will be required if you wish to make adjustments to the associated revenue.
- The Totals row and column represent the total value of the respective payments (row) and items (column).
- The Unallocated row and column represents any currently unallocated values associated with either their respective payments (row) and items (column).
- The Revenue cell is an intersecting cell where a payment column and an item row meet. The value in this cell represents the amount of the item's price that is paid for by the payment.
- The Save button will save your changes and updates to this page.
Reconciling Revenues
Reconciling your Uplifter invoices is quick an easy. By default, our system will have automatically determined the correct allocation of revenues to payments. However, in some unique cases, or where invoices have been adjusted in a manner that our systems cannot reconcile automatically, there may be some unallocated revenues listed. These will be listed in the yellow UNALLOCATED row and column, indicating which payment(s) and which item(s) have not been completely accounted for.
If the row is contracted, click the item listing to expand it. This will reveal the intersecting cells that you can now take action within. Double-click into the field and update the value as desired.
To complete this process, you will want to ensure that no Unallocated amounts are listed in the yellow Unallocated row and column. Once this is true, then all item revenues have been attributed to payments and you are ready to click Save.
Payments - Reconciled Revenue Report
The Payments - Reconciled Revenue Report works in tandem with the Invoice Payment Revenue Reconciliation Page and allows admins to pull a report on the revenues allocated to their payments.