This report shows all settlements NETBANX has processed in a given month for payments made by CREDIT CARD via Amilia. Only works for organizations that use NETBANX as a CREDIT CARD processor.
We are currently working with NETBANX to gather E-check information to eventually include in this report.
HOW TO GENERATE THIS REPORT
- FINANCE tab
- Section FOR ENTIRE ORGANIZATION
- Sub-section REPORTS BY DATE INTERVAL
- Choose the date range; START and END
- Report ; NETBANX SETTLEMENT
This report is NOT IN REAL TIME; the current month’s data will be uploaded up to 2 weeks after the end of the month.
This report contains 3 tabs to browse.
ALL: In this tab you will find all the settlements from credit card payments, reconciled or not.
CC RECONCILED: All settlements from payments by CREDIT CARD that are reconciled.
CC NOT-RECONCILED: All settlements from payments by CREDIT CARD that are not reconciled.
This report will continue to evolve as we work to support RECONCILIATION BY INVOICE ITEM. Thus the number of unreconciled payments will decrease significantly.
INFORMATION IN THE REPORT
Date on which transfer was initiated by NETBANX to the organization’s bank account. That said, it is not the date on which the deposit was made in the bank account since this date we do not have access to it.
This represents the amount to be deposited into the organization’s bank account. It is a sum of transactions for one or more days minus your Netbanx processing fees.
The sum of transactions for one or more days before Netbanx deducts processing fees.
The transaction number generated during the client’s online payment. This number is also shown on the receipt of customer payments and several financial reports, such as BREAKDOWN OF REVENUE.
The number generated by Amilia as number of payment receipt. This number appears in various reports in Amilia, such as BREAKDOWN OF REVENUE, and also in the BILLING tab of the client’s account.
PAYMENT DONE BY
Client: The customer made himself the payment.
Admin: An administrator of the organization made the payment for the customer.
Installment: An installment payment configured under ACOUNT>INSTALLEMENTS and chosen by the customer or the admin when purchasing.
Custom Installment: An installment payment created manually by an administrator in Client Billing. This configuration is unique and used only for this client.
The invoice number that is associated with the payment.
Invoices are not necessarily generated on the same date as payments, especially with installment payments. The invoice number column will show which invoice is associated with this payment, but the invoice may have been generated in a previous month.
The first name of the Amilia account owner.
The last name of the Amilia account owner.
If you use ledger codes and a ledger code is associated with the invoiced item(s), then the payment will by default have the same ledger code as the invoice.
We strongly recommend using ledgers codes to keep track of revenue. If you want to know which invoices are reconciled with a certain payment, ledger codes are the best way to do so.
Amount on the invoice associated to the payment, before tax and before the promotions are applied.
Promotion amount before tax that was configured in the PROMOTIONS tab to be applied automatically by the system.
Net invoice amount before tax.
Amount of the GST taxes which have been billed on the invoice when buying.
Amount of the QST taxes which have been billed on the invoice when buying.
TAX will varies depending on region.
Net invoice amount including tax.
Payment Amount received for this bill.
Reconciled: The payment was reconciled with the invoice that is associated with payment.
Not Reconciled: Payment has not been reconciled with any invoice.
REASONS A PAYMENT MAY NOT BE RECONCILED
PAYMENT OF ACCOUNT BALANCE BY CUSTOMER; When a client logs in to pay off their outstanding balance, this payment may cover several unpaid bills. It is therefore not possible for the system to reconcile payment automatically.
INITIAL INSTALLMENT PAYMENT; A client’s initial installment payment will not be reconciled by the system, as the payment may be linked to several items if multiple purchases were made by the customer.
CUSTOM INSTALLMENT; Because custom installments have been configured for a particular client by an administrator, they currently cannot be reconciled.