Report - Netbanx Settlement

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.

NOTE 
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

NOTE
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. 

TABS

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.

NOTE
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

TRANSFER DATE

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.

TRANSFER AMOUNT

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.

SETTLEMENT AMOUNT

The sum of transactions for one or more days before Netbanx deducts processing fees.

TRANSACTION ID

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.

RECEIPT NUMBER

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.

INVOICE NUMBER

The invoice number that is associated with the payment.

NOTE
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.

FIRST NAME

The first name of the Amilia account owner.

LAST NAME

The last name of the Amilia account owner. 

LEDGER CODE

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.

NOTE
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.

GROSS

Amount on the invoice associated to the payment, before tax and before the promotions are applied.

PROMOTION

Promotion amount before tax that was configured in the PROMOTIONS tab to be applied automatically by the system.

SUBTOTAL

Net invoice amount before tax.

GST

Amount of the GST taxes which have been billed on the invoice when buying.

QST

Amount of the QST taxes which have been billed on the invoice when buying.

NOTE
TAX will varies depending on region.

TOTAL

Net invoice amount including tax.

PAID AMOUNT

Payment Amount received for this bill.

STATUS

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.

Have more questions? Submit a request

0 Comments

Article is closed for comments.