Transactions - Contract Module
The Transactions page displays all transactions that have been posted for a contract. You can also create one-time transactions from the Transactions page. Transactions that are manually created will not have a batch ID. Manual transactions can be created outside of the payment Begin and End Date of the contract.
Recurring expenses will automatically generate transactions. Ensure that you do not create duplicate payments using the Transactions page. Transactions generated by the system will always have a Batch ID.
To navigate to the Transactions page:
-
Navigate to Contract > Payment Info > Transactions.
Use the links in the Navigation Pane on the leftmost side of the page.
-
Follow a procedure below.
Add Transaction
-
Click Add Item.
This displays in the Actions menu on the right side of the page.
-
Select the payment group from the Group field.
Create a new group or category.
Groups are the first level of organization in Lucernex. Groups are the parents of types, and grandparents of categories. Groups, types, and categories are used to simplify reporting.
-
Select the expense type from the Type field.
To add an expense type, follow the Add an Expense Type procedures.
Important!For transactions, the Type is associated with account numbers in your integrated accounting system. The Type is also associated with your lease accounting schedule. Ensure that you select the correct type for your transaction.
-
Select the payment category from the Category field.
Create a new group or category.
Categories are the third level of organization in Lucernex. Categories are the children of types, and grandchildren of groups. Groups, types, and categories are used to simplify reporting.
-
Enter the following dates:
You can also click Calendar
to open the Date Picker and select the appropriate date.
-
Effective Date / Effective End Date: Enter the date the transaction is effective.
This can also be thought of as your billing period.
-
Posting Date: Enter the date to send the transaction to the accounting system.
-
Due Date: Enter the the payment due date.
-
Coverage Begin / End Date
-
-
Enter the amount of the payment in the Base Amount field.
-
Enter the date of the invoice in the Invoice Date field.
You can also click Calendar
to open the Date Picker and select the appropriate date.
-
Enter the invoice reference number in the Invoice Ref# field.
-
Enter the tax amounts in currency values for these fields:
-
Primary Tax
-
Secondary Tax
-
Tax Amount #3
-
-
Enter any shipping costs in the Freight Amount field.
-
Enter any other amounts in the Other Amount field.
-
Select the Taxes Included In Amount? check box if taxes are included in the value you entered in the Base Amount field.
The Total Amount becomes editable. If you need to make changes to the value in the Total Amount field, you may now do so.
The value in the Currency defaults to the default currency on your contract. If you want to change the currency, select the appropriate currency from the field.
-
Enter a description of the payment in the Description field.
-
If this transaction is an accounts receivable item, select the A / R Flag check box.
These items are also known as income items.
As part of their lease, lessees (typically sub-lessees) may sometimes receive a discount if payments are made within a certain period before the payment due date. If your System Administrator is leveraging Lucernex's Early Payment Discount Option for A/R Leases, this may impact the Transaction Payment Due Date.
-
If this transaction is a credit item, select the Credit Flag check box.
-
Enter a remittance message in the Remit Message field.
This is the message that will appear on the memo line of a check.
-
Enter the internal reference number, if you have one, in the Internal Ref# field.
-
Select the payment method from the Payment Method field.
-
Enter the bank routing number in the Bank Routing# field.
-
Enter the bank account number in the Bank Account# field.
-
Enter the payment date in the Payment Date field.
You can also click Calendar
to open the Date Picker and select the appropriate date.
-
Enter the amount paid in the Amount Paid field.
-
Enter the payment / check reference number in the Payment/Check Ref# field.
-
Select the organization from which this payment should be debited from the Organization field.
To add an organization, follow the Add an Organization procedures.
You can view an organization’s information by selecting an organization from the field and then clicking the View
.
-
Select the vendor that this payment should be paid to from the Vendor field.
To add an employer, vendor, or legal party, follow the Add a Vendor procedures.
You can view an vendor’s information by selecting a vendor from the field and then clicking the View
.
Note:Since you are creating a transaction manually, the One-Time Expense check box will be automatically selected.
-
Enter the account reference number in the Acct/Ref# field.
-
Enter any comments in the large field in the Approval / Additional Comments section.
-
To add supporting documentation to your transaction:
-
Click Add Documents.
-
-
This displays in the Actions menu on the right side of the page.
The page refreshes. If there are allocations or taxes associated with the expense setup, the Allocate Transaction? window opens. The window will populate with multiple allocation options, depending on how your expense setup is configured:
-
If you have multiple vendor or expense allocations, you will be prompted to choose which allocation you want to use for the transaction.
-
If the effective date and the due date of the transaction fall in different allocation terms, the window will ask if you want to allocate based on the effective date or the due date of the transaction. For example, review the data in the table below.
Example One-Time Transaction Allocations Item
Date OR Date Range
Vendor Allocation A
01/01/2020 – 12/31/2020
Vendor Allocation B
01/01/2021 – 12/31/2021
Effective Date of One-Time Transaction
12/20/2020
Due Date of One-Time Transaction
01/31/2021
Since the Effective Date of the transaction falls during the term of Vendor Allocation A and the Due Date of the transaction falls during the term of Vendor Allocation B, Lucernex would ask if you want to allocate using the effective date or the due date.
-
If taxes are configured for your expense setup, you will be asked if you want to apply taxes to the transaction.
-
-
Do one of the following:
-
If you want to apply one or more of the options in the window:
-
Choose the appropriate Expense or Vendor Allocation options from the ones provided.
The options will vary depending on how your expense setup is configured.
-
If you want to apply tax rates, select the appropriate check boxes.
The tax rate options will only appear if they are applicable to the expense setup.
-
Click Yes.
The transaction appears in the Contract Payments List.
-
-
If you do not want to apply any of the options, click No.
The transaction appears in the Contract Payments List.
-
-
To approve the transaction, see the Approve Payments procedures.
Edit a Transaction
Once a transaction has been marked as processed, you cannot make any further changes. Do not select the Processed Flag check box unless you are certain you do not want to make any further changes. To learn more about the Processed flag, see our article Hold and Processed Flags.
If you have a tax rate at the location-level, the system will ask if you want to recalculate your taxes prior to saving your transaction.
To edit a transaction:
-
Select the transaction you want to edit from the Contract Payments List.
The transaction data populates on the page.
-
Make your changes.
-
Click Save Changes.
This displays in the Actions menu on the right side of the page.
The page refreshes. Your changes are saved.
Delete a Transaction
A transaction cannot be deleted if it has been processed.
To delete a transaction:
-
Select the transaction you want to delete from the Contract Payments List.
The transaction data populates on the page.
-
Click Delete Item.
This displays in the Actions menu on the right side of the page.
A dialog opens, asking you to confirm your choice.
-
Click Yes.
The page refreshes, and the transaction no longer appears in the Contract Payments List.
Take Action on a Transaction
To take action on a transaction:
-
Select the transaction you want to take action on from the Contract Payments List.
The transaction data populates on the page.
-
Scroll down to the Approvals / Additional Comments section.
-
If this transaction should be marked with a hold flag, select the Hold Flag check box.
-
Once the transaction has been processed, select the Processed Flag check box.
Once processed, a transaction is assigned a transaction number which can be used to identify the transaction.
Important!Once a transaction has been marked as processed, you cannot make any further changes. Do not select the Processed Flag check box unless you are certain you do not want to make any further changes. To learn more about the Processed flag, see our article Hold and Processed Flags.
-
Click Save Changes.
This displays in the Actions menu on the right side of the page.
The page refreshes. Your changes are saved.
Copy Transaction
A duplicate transaction will be marked as a “one-time expense" even if the original is not.
The following values will be copied in a duplicate transaction:
-
Group
-
Type
-
Category
-
Base Amount
-
Currency
-
A / R Flag
-
Credit Flag
To duplicate a transaction:
-
Select the transaction you want to duplicate from the Contract Payments List.
The transaction data populates on the page.
-
Click Copy Transaction.
This displays in the Actions menu on the right side of the page.
The Payment Transaction Copy window opens.
-
Select or clear the check boxes in the Copy section to indicate the aspects of the original transaction you want to copy.
-
Click OK.
The transaction is duplicated. A success dialog box appears.
The transaction will still need to be approved. See the Approvals Process procedures to learn how.
Pass-Through Payments
The pass-through payments functionality is used to pass responsibility for a payment from a master contract to a sublease. Pass-through payments can only be created at the master contract-level. Make sure that you are viewing your master contract.
In order to create pass-through payments, you must complete the following criteria:
-
The Master Contract must have an expense setup complete with an expense schedule.
-
Each sublease must have their master contract set on the Contract > Details > Summary page.
-
Each sublease must have their Pro Rata Share defined at the expense setup-level.
Pro Rata Share refers to a proportionate share of an expense. For example, many contracts for tenants of indoor malls stipulate that each tenant pay a pre-determined percentage of common area maintenance (CAM) expenses.
-
You must generate rent for the master contract.
To create pass-through payments:
-
Click Pass-Through Payments.
This displays in the Actions menu on the right side of the page.
The Create Pass-Through Payments window opens.
-
Select the check boxes next to the sublease contracts for which you want to create pass-through payments.
-
Click Create Pass-through payments.
A success message appears at the top of the window.
-
To view the pass-through payments, click the name of the sublease you want to view.
The contract name in the success message is a link to the transactions page of the sublease.
The pass-through transaction appears in the Transactions List.
View Transaction Source
Transactions generated by Lucernex have a Batch ID in the Internal Account Coding section of the Transactions page. Each Batch ID is unique and has a prefix that tells you how the transaction was created.
To view the type of record which generated a transaction:
-
Click the value in the Batch ID field.
A View [Record Type] window opens. This window displays data relevant to the record type that was used to generate the transaction.