Skip to main content
All CollectionsAccounting and Finance TabMerchant Account
Reconcile your Monthly Bank Statements with your Online Payments
Reconcile your Monthly Bank Statements with your Online Payments

Learn how to match your bank statements with online client payments using the Netbanx settlement report and your Payment summary.

Samantha Postlethwaite avatar
Written by Samantha Postlethwaite
Updated over 4 months ago

There's a processing period between the time an online payment takes place in SmartRec, to when a bank transfer (EFT) is sent from your merchant account to be deposited in your organization's bank account. As a result, you'll notice that payment dates in SmartRec's payment reports don't necessarily match up with the dates they were deposited in the bank.

๐Ÿ‘‰ AMEX payments are deposited separately from regular credit card payment deposits. AMEX payment details are still available in Amilia Payment reports, but they aren't in the Netbanx portal, any Netbanx reports or the Merchant account settlement & fee report. They must be calculated manually when going through the reconciliation steps.

Our 5 step process will help you identify which dates to use when pulling your reports to reconcile your monthly statements with your online payments.

โ— The reconciliation of credit card payments

and eCheck payments must be done separately!


How it Works

FAQ
โ€‹


What are the A, B & C Dates?

There are 3 sets of dates needed to reconcile your monthly statements:

  • Dates A1 & A2: When payments were made in SmartRec. These dates are used to pull your payment reports.

  • Dates B1 & B2: When the payment processor transfers money from the merchant account to your bank account. These dates are used to generate your Merchant settlement & fee report.

  • Dates C1 & C2: First and last days transfers were deposited in your bank account. These dates are found in your monthly bank statement.


Step 1: Find the C Dates on your Bank Statement

You need to identify the first (C1) and last (C2) days your payment processor deposited payments to your account during the month.

Ex: C1- April 2nd ย  ย  ย  C2- April 30th



Step 2: Use your C Dates to Find your B Dates

You'll need to know the first (B1) and last (B2) day the payment processor transferred payments to your bank account. To find out, go to the Accounting and finance > Merchant account subtab, click on the Filters button and select a payment method (credit card or eCheck). Next, click on the blue icon at the top right of the page to download the Merchant account settlement & fee report.

The Transfer date range will be FROM: C1 minus 5 business days ย  ย TO: C2

๐Ÿ‘‰ We deduct 5 business days from our C1 date because transfer dates happen a few days earlier than the actual deposit date to your bank. These delays are due to processing time, holidays and/or weekends.

  • In the example below, the C1 date is April 2nd. This means our report will start on March 26th. The end date will be the C2 date which is April 30th.

  • Locate the first and last transfer amounts under the EFT column. The B Dates will be the transfer date for your first (B1) and last (B2) deposit.



Step 3: Generate a New Report Using your B Dates

Once you have the B1 and B2 dates from the Merchant account settlement & fee report, generate it again using the correct date range (e.g. March 29th to April 27th).

The first transfer amount should be visible at the top of the list and your last transfer amount at the bottom.



Step 4: Click on the Transfer Amount to Find your A Dates

You'll also need to generate your payment reports. But which date range to use?

To find out, you need to identify the A Dates. These dates pertain to the first (A1) and last (A2) day that payments were made in SmartRec. This information is available by clicking on the first and last transfer amounts on your Merchant account settlement & fee report.


๐Ÿ“† Finding A1:

  • Under the column Transfer amount (EFT), click on the first transfer.

  • This jumps to a tab that gives details on each payment within that transfer.

  • Note the Date of Transaction of the first payment on the list. This is the A1 Date!

๐Ÿ“† Finding A2:

  • Return to the Summary Tab on the report.

  • Under the column Transfer amount (EFT), click on the last transfer.

  • Note the Date of Transaction of the last amount on the list. This is the A2 Date!

Use the A1 and A2 dates (e.g. March 27th to April 26th) to generate your payment reports.


Step 5: Compare the Payment Summary with your Merchant Settlement Report

In the Reports tab, download a Payment summary report using the A1 and A2 dates. You now have everything you need to reconcile.

To be assured you are using accurate dates for your reports, you can:

๐Ÿ“† Confirm your B Dates:

  • The Transfer amount (EFT) should match the total amount deposited on your bank statement (for either credit card OR eCheck).

๐Ÿ“† Confirm your A Dates:

  • On the Payment summary report, refer to the amount under the Payment column which applies to the mode of payment you are reconciling.

  • It should match with the Settlement amount on your Merchant account settlement & fee report.

๐Ÿ‘‰ Settlement and transfer amounts differ depending on whether you had to credit and/or refund any online payments.


Frequently Asked Questions

What if my reports don't match?

  • Begin by checking the list of payments in the last deposit on your Merchant account settlement & fee report and compare it to your Payment summary. It may be that a payment was batched in a bank transfer that took place outside the date range of your payment report. Adjust your date ranges accordingly.

  • A deposit differing by a few cents in your Merchant account settlement & fee report vs your bank statement is caused by rounded taxes as SmartRec and the processor may round them up differently.

Where is the Merchant account page? Why can't I see it?

The Merchant account page is visible in the Accounting and finance>Merchant account subtab. Your organization must have a Paysafe merchant account and administrators require an 'account owner' or 'Finance and reporting-Accounting reports' permission. Franchisees do not have access to the Merchant account page.

If you do not have the required permission, contact the account owner at your organization. If you still cannot see the tab, contact us at support@amilia.com.

What is Amilia Payment?

Amilia Payment is our deep integration into payment to help simplify your financial operations. Our partnership with Paysafe enables us to bring relevant data from Netbanx into Amilia, so you don't need to open multiple tabs to find the information you're looking for. Netbanx is Paysafe's gateway portal that allows you to track the funds inside your merchant account.

When should I reconcile my bank statements with payments from SmartRec?

We recommend doing the reconciliation at least once a month. This makes it easier to match your monthly bank statements with deposits made to your organization's bank account and allows you to address any inconsistencies in a timely manner (in the unlikely event they occur).

Which reports will help reconcile my bank statements with online payments?

In addition to your bank statement, you should download the:

  • Payment Summary: It provides the total amount of payments received by payment method (credit card, eCheck, cash, etc.) and a breakdown of each payment transaction made during the time period. This report is located in the Reports tab under the Payments section.

  • Merchant account settlement & fee: It allows you to check the transfers from Paysafe so you can compare them with the deposits to your bank account. It includes a breakdown of each payment, refund and/or credit that took place in your merchant account. You can export this report from the Accounting and finance > Merchant account subtab. Specify a date range, a payment method, and then click on the blue export icon to the top right of the screen.

Which reports show who paid and what service they paid for?

To find out for which client a payment was made, use the Payment summary.

To find out what was paid for, use the Breakdown of payments by ledger code.

You can also find out which client and invoice is linked to a payment in the Merchant account subtab. Click here to learn more!

Where can I find the ledger codes to link to my payments?

In the Reports tab, you can download the:

  • Breakdown of payments by ledger code: It provides a list of client payments associated to the ledger code of the item that was sold. It includes credit memos and invoice information linked to the reconciled payments. Download the report using the same dates as your Payment summary.

To quickly view the ledger code(s) linked to a specific online payment, go to the Accounting and finance > Merchant account subtab. Click on a transfer amount to view all the client payments within the transfer. Under the Reconciliations column, click on View to jump to a client's billing to see which invoice was reconciled to the payment. Click on the Invoice ID to load the invoice on the screen. Click on the invoice to see the ledger code(s). Click here for more information.

Can ledger codes be included in the Settlement amounts?

Settlements are managed by the merchant account provider, Paysafe. They cannot access invoice and/or ledger code details from Amilia. However, you can easily find out what was paid for by using the Breakdown of payments by ledger code report and/or going to the Accounting and finance > Merchant account subtab and viewing the reconciliations there.

When does the merchant provider (Paysafe) batch payments?

Paysafe batches payments based on the transaction date. Keep in mind a transfer to your bank account can include more than one batch of payments.

For credit cards and eChecks: the batch times are midnight to midnight Eastern Time for all processing regardless of region. Transactions that occur up to 11:59pm that same day will be included in the settlement record the following day in the Account Statement.

How long does it take for payments to be deposited into my bank account?

In total, it can take up to 5 business days from the time a client makes an online payment to the time it is deposited in your organization's bank account.

When a client makes an online payment, it is held in your merchant account for 2 business days. If you have been using your merchant account for more than 6 months, the holding period may be reduced by contacting us at support@amilia.com.

After the holding period, Paysafe transfers the funds to your bank account. It can take up to 72 hours before the money is deposited in your bank account. This time frame depends on your banking institution (regardless of where you are located).

Where can I find information about chargebacks?

A chargeback is a reversal of funds made at the request of the client. This cannot be tracked in Amilia's client billing. However, you can view chargeback amounts in the:

  • Accounting and finance > Merchant account subtab: Chargebacks are listed in the Other column on the merchant account page as well as when exporting your Merchant account settlement & fee report.

  • Netbanx portal: Log into the Netbanx portal to view and pull reports for more details about a chargeback. Be sure to configure your notifications so that you are made aware when a chargeback takes place.

Please note there is a Network Assessment fee associated with chargebacks, which appears on the upcoming Amilia invoice.

Where can I view refunds made to clients?

Refunds are visible in the:

  • Payment Summary: It provides the total amount of payments received by payment method (credit card, eCheck, cash, etc.) and provides a breakdown of each payment transaction (including refunds) made during the time period. This report is located in the Reports tab under the Payments section.

  • Accounting and finance > Merchant account subtab: To view payments that were reimbursed from your merchant account, refer to the Refunds & returns column on the Merchant account page. Click on a transfer amount to view which amounts were credited back to the client.

Why can't I find a record of a refund on the Merchant account page?

The Accounting and finance > Merchant account subtab displays and breaks down the payment transfers from your merchant account to your organization's bank account. If you can't find the record of a refund, consider the following:

  • It takes two days for a bank transfer (EFT) to show in the Merchant account page. If you refunded a client within the last 48 hours, check back in a few days to allow for processing, batching and settlement transfers to take place. Otherwise, you can log in to Netbanx and view up-to-date transactions in your merchant account.

  • The Merchant account page displays the date and details of payment transfers. If your organization has not received any payments, no payment transfer can take place. If your organization has issued refunds but hasn't received any payments, the information cannot be displayed in the Merchant account page. In this case, log in to Netbanx to view your refunds.

  • Only successful refunds within a bank transfer are displayed in the Merchant account page. If the refund was unsuccessful, it will not appear.

What happens if I cancel a payment on the same day?

If you cancel a payment on the day it was made, the payment is halted before the money lands in your merchant account. Clients will still see a pending payment on their credit card but the charges will disappear shortly afterwards. There will be no record of this payment on the Merchant account page.

When will a pending payment disappear from my transaction report?

It can take 2-3 business days.

Are client accounts automatically reconciled?

Payments are automatically reconciled to an invoice when purchased via your Amilia store. If you add a payment directly in the client's billing account, Amilia will prompt you to reconcile the payment with the appropriate invoice item(s). You can always check in the Accounting and finance > Unreconciled items subtab to verify if any payments or credits remain unreconciled.

Do I still have to log in to Netbanx?

The Merchant account page displays when a bank transfer took place (i.e. funds were sent to your bank account) and more importantly, allows you to break down those transfers to see which client payments were included, as well as which invoice(s) was reconciled to the payment. Paired with the Merchant account settlement & fee report, this is a great tool when doing your banking reconciliation for online payments. In most cases, you do not need to log into the payment processor's portal.

However, if you require more details on your current balance in your merchant account, on chargebacks, pending transactions, failed payments, and/or error codes, you can download additional reports in Netbanx.

Make sure you login to your Netbanx account at least once every 90 days to avoid your login becoming inactive. If this happens, contact Paysafe support.

What is an eCheck?

An eCheck is an online version of a paper check. Both contain the account holder's bank details and an instruction to the bank to authorize a transfer of funds. Unlike a credit card that taps into the credit card network, an eCheck payment is a transfer between banks only. Since fewer institutions are involved, the payment processing cost is considerably less.

A separate merchant account is required to process eChecks so that clients have the option of paying online with their banking information. Contact us at support@amilia.com for more information!


*Last updated in May 2024



You might also be interested in:

Did this answer your question?