Skip to content

Reconcile a bank account

Reconciling matches the transactions you imported from the bank to the transactions in the Nexsyis check register. Most items match automatically; you match the rest on the Reconcile Items tab.

Nexsyis keeps the bank statement and the check register separately and matches them one transaction at a time. You can reconcile at any time, not only at month-end, so differences show up at the transaction level as they happen. Credit card accounts are reconciled the same way.

The steps are:

  1. Download the statement from the bank and import it.
  2. Accept the auto-matched items.
  3. Reconcile the remaining items: cash and check deposits, EFT and credit card deposits, fees, returned checks, transfers and small differences.

Import the bank file. See Import bank and credit card transactions.

  1. On the Accounting tab, select Account Reconciliation, then Reconcile Bank Accounts.

    The Account Reconciliation menu with Reconcile Bank Accounts

  2. Select the bank account in Account.

The Auto-Match tab matches items on the bank statement (left) with entries in Nexsyis (right). Clear any item you don’t want reconciled yet, then select Save to reconcile the rest.

The Auto-Match tab with matched bank and check register lines and the Save button

Maximum days to allow between Bank Transaction and System Transaction sets how far apart the dates can be for an automatic match.

The Reconcile Items tab lists items that couldn’t be matched automatically: the bank statement on the left and the check register on the right.

To clear a selected item, hold down Ctrl and select it.

Many payments have the same amount, such as $250 or $500 deductibles, so Nexsyis can’t match them all automatically.

  1. Select Smart Match.
  2. Select a transaction on the left. If the check register has a transaction with the same amount, it’s highlighted and moved to the top of the list on the right.
  3. Select the matching items, then select Reconcile.

Smart Match selected and a bank line matched to a check register line, with the Reconcile button

  1. Select the EFT line and select Deposit Item.

    An EFT line selected and the Deposit Item button

  2. If no payer is assigned, select it under EFT Paid By. Select a location to narrow the results.

  3. Find the payments that make up the EFT. Move any that don’t belong to the left with the green arrow above the grid.

  4. When the deposit total matches the bank amount, select Save.

    The matching deposit screen with EFT Paid By and the payment under Deposit These Items

  1. Select the credit card line (its Group shows CCRD) and select Deposit EFT/CC.

    A CCRD line selected and the Deposit EFT/CC button

  2. In the bottom-left grid, the date range is set to within a week of the selected transaction.

    The batch list with the Code, From and Thru fields

  3. Select the checkbox of the batch that matches the bank statement.

  4. If your card processor takes its fees out of the deposit, enter the fee amount in Card Fees.

  5. When the amounts are equal, select Save.

    A batch selected, with its payments under Deposit These Items

For how batches are created, see Complete a credit card batch.

For card or bank fees charged separately, create a reconciling transaction:

  1. Make sure the line’s Group is FEES. Select the line, then select Fees.

    A FEES line selected and the Fees button

  2. In Bank Fees Reason, select the fee type, for example BANK FEES or CREDIT CARD FEES.

  3. If you want, select a location in Allocate To, then confirm.

    The Bank Fees Reason window with the fee types and Allocate To

When a check bounces and you get a return notice, find the original payment by its amount.

  1. Select the returned item line and select Return Check/CC.

    A returned check line on the Reconcile Items tab

  2. On the Return Item screen, check the date range and select refresh. Payments matching the amount in that range are listed.

  3. Select the right payment and select the select button.

    The Return Item screen with a matching payment and the select button

  4. Select Yes to continue.

    The message asking whether to insert a Return record

The returned check shows in gray on the folder’s A/R tab.

The folder A/R tab with the returned check payment

For more, see Record a returned check.

If a line is off by a few cents and you can’t find why, write off the difference. The difference should be less than a dollar.

  1. Select the line on the left and the line that should match it on the right.
  2. Select Adjust Difference.
  3. When asked whether to write off the difference, select Yes if it’s correct.

The Adjust Difference button

To move an old item that never cleared from the check register to a balance sheet account, select it and select Remove Expired at the bottom right. To find older items, sort by the date column. The screen refreshes when the item is removed.

The Remove Expired button

Transfers between your bank and credit card accounts post to the general ledger through bank reconciliation, but only when Nexsyis reconciles both accounts. If Nexsyis reconciles only one side, record the transfer with an AP payment or a non-AR payment instead.

  • Both sides must have the TRF trans group, in both accounts. Set up trans group mapping so most transfers are marked TRF on import. If a transfer isn’t, select its group box and choose Transfer Between Cash Ac.
  • When both sides are classified, their dates and amounts match, and there’s only one transfer of that amount that day, Nexsyis records the transfer automatically when you select next after the Auto-Match tab.
  • Otherwise, select the transfer, pick the other side in the box that shows, and select the transfer button at the bottom.

The GL entry debits the financial category of the account transferred to and credits the financial category of the account transferred from. If the accounts belong to different legal entities, entries also post to the inter-legal-entity accounts.