to select the date from the calendar.Note: This topic does not apply to customers that use Bank Account Reconciliation to reconcile bank statement transactions. Refer to Bank Account Reconciliation instead.
Use Bank Statement Reconciliation to reconcile Beyond Software transactions to bank statement transactions downloaded from your banking app or website and imported using Bank Statement Import.
Select Financials | Cash | Bank Statement Reconciliation.
Use the Company field on the main toolbar to select the internal company whose bank account you are reconciling.
In Bank Account, select the account to reconcile. The Account Group field is populated based on bank account setup.
In Status, Pending is specified by default. Change the status to Posted when the reconciliation is ready to be closed. See Completing the Imported Bank Statement Reconciliation.
In Date, specify the reconciliation processing date to assign to this batch. You can click Calendar to select the date from the calendar.
Last Statement displays the last statement date reconciled. (For the first reconciliation using this screen, the field is blank.)
Last Reconciliation displays the last reconciliation date. (For the first reconciliation using this screen, the field is blank.)
In Statement Date, specify the date of the bank statement. Only bank account transactions dated on or before this date will be listed in the Imported Transactions grid on the screen.
In Beginning Balance, the ending balance amount from the previous bank reconciliation is displayed. (For the first reconciliation using this screen, you must specify this amount.)
In Ending Balance, specify the ending balance amount from the current bank statement.
With header information now specified, you have these options:
To display the imported bank statement transactions, without an attempt to automatically match them with existing Beyond transactions, click Update List. The imported transactions dated on or before the specified statement date are displayed in the Imported Transactions grid.
The Cleared check box—which indicates that the transactions are matched (reconciled) and should be cleared from the system upon posting—is not selected for any imported transaction. In this case, you must manually match the imported transactions with unreconciled Beyond transactions. See Manually Matching Transactions for Reconciliation.
To display the imported bank statement transactions, with an attempt to automatically match them to existing Beyond transactions, click Automatic Match. The imported transactions dated on or before the specified statement date are displayed in the Imported Transactions grid.
The Cleared check box is selected for transactions that appear to have a match. Matching is based on these criteria:
The system looks for a Beyond transaction whose reference number and amount are the same as the reference number and amount of an imported bank statement transaction. If a match is found, the Cleared check box is selected for the imported transaction.
If a reference and amount match is not found, the system looks for a date and amount match. If a match is found, the Cleared check box is selected for the imported transaction.
The system must find only one matching Beyond transaction. If there is more than one, either as a reference and amount match or a date and amount match, the Cleared check box is not selected.
If the automatic matches are straightforward and look accurate, you can post the reconciliation now. See Completing the Imported Bank Statement Reconciliation. If not, you can verify the automatic matches and make changes as needed. See Verifying Automatically Matched Transactions for Reconciliation.
This information applies when you have clicked Update List on the Bank Statement Reconciliation screen. If you clicked Automatic Match, see Verifying Automatically Matched Transactions for Reconciliation.
To manually match an imported transaction with a Beyond transaction, follow these steps:
In the Imported Transactions grid, select a transaction to work with and then click the Match 
button. (You can also double-click the transaction, right-click the transaction and select Match, or select the transaction and press Enter.) This opens the Match pop-up window.
The pop-up shows a list of currently unreconciled Beyond transactions from on or before the statement date; an empty section for the matched transaction(s); and, at the bottom of the window, the imported transaction that you selected.
In the Unmatched list, select the Match check box next to the transaction that matches the imported transaction. This moves the transaction down to the Matched list.
It is possible that multiple Beyond transactions make up the match for an imported bank statement transaction. For example, a single bank deposit may include multiple customer payments in Beyond. In this case, you can select the Match check box next to all applicable transactions in the Unmatched list, or, for a partial clearing, you can select only some of the applicable transactions. See About Partial Clearing.
Note: If there is no match in the Unmatched list, you may need to add and post a transaction in Beyond Client and then start this process again. See Adding Missing Beyond Transactions for Reconciliation.
With the matching complete, click OK. You are returned to the Bank Statement Reconciliation screen. The imported transaction is set to Cleared.
Repeat this process for each imported transaction that you want to reconcile. Notice that at the bottom of the screen, these fields are updated as you match transactions:
Payments: The number of payments, and their total amount, that will be cleared when you post the reconciliation.
Deposits: The number of deposits, and their total amount, that will be cleared.
Other: The number of other transactions that were entered directly against the bank account (for example, adjustments entered in the Journal Entry screen), and their total amount, that will be cleared.
Difference: The specified Beginning Balance - cleared Payments + cleared Deposits ± cleared Other. To post the reconciliation, the difference must be zero (0).
When finished, you can save as Pending or Posted. See Completing the Imported Bank Statement Reconciliation.
This information applies when you have clicked Automatic Match on the Bank Statement Reconciliation screen. If you clicked Update List, see Manually Matching Transactions for Reconciliation.
To verify automatically matched transactions, follow these steps:
In the Imported Transactions grid, select a transaction to work with and then click the Match button. (You can also double-click the transaction, right-click the transaction and select Match, or select the transaction and press Enter.) This opens the Match pop-up window.
The pop-up shows a list of currently unreconciled Beyond transactions from on or before the statement date; a section with the automatically matched Beyond transaction; and, at the bottom of the window, the imported transaction that you selected. You have these options:
If the current match is correct, leave it as-is.
If the current match is wrong and the correct match is included in the Unmatched Beyond Transactions list, select the Unmatch check box on the current match. This moves the transaction up to the Unmatched list. In the Unmatched list, select the Match check box for the correct match. This moves the transaction down to the Matched list.
It is possible that multiple Beyond transactions make up the match for an imported bank statement transaction. For example, a single bank deposit may include multiple customer payments in Beyond. In this case, you can select the Match check box next to all applicable transactions in the Unmatched list, or, for a partial clearing, you can select only some of the applicable transactions. See About Partial Clearing.
If the current match is wrong but there is no correct match in the Unmatched list, select the Unmatch check box on the current match. This moves the transaction up to the Unmatched list and leaves the imported transaction unmatched. You may need to add and post a transaction in Beyond Client and then start this process again for the imported transaction that has no match. See Adding Missing Beyond Transactions for Reconciliation.
With verification complete, click OK. You are returned to the Bank Statement Reconciliation screen. The Cleared check box remains selected for verified matches. It is cleared if the match was removed.
Repeat this process for each imported transaction that you want to verify. Notice that at the bottom of the screen, these fields are updated as you verify transactions:
Payments: The number of payments, and their total amount, that will be cleared when you post the reconciliation.
Deposits: The number of deposits, and their total amount, that will be cleared.
Other: The number of other transactions that were entered directly against the bank account (for example, adjustments entered in the Journal Entry screen), and their total amount, that will be cleared.
Difference: The specified Beginning Balance - cleared Payments + cleared Deposits ± cleared Other. To post the reconciliation, the difference must be zero (0).
When finished, you can save as Pending or Posted. See Completing the Imported Bank Statement Reconciliation.
If you find that do not have a Beyond transaction that matches one or more of the imported transactions for reconciliation, you can click Enter Vendor Payment, Enter Deposit/Customer Payment, and/or Enter Journal Entry on the Bank Statement Reconciliation screen, to open the appropriate application screen for entering and posting the transaction(s).
For example, you may have deposited a customer payment at the bank, but the transaction has not yet been entered into Beyond. You can click Enter Deposit/Customer Payment to open Cash Processing and post the deposit, so it will be available for reconciliation.
Another example is a missing vendor payment in Beyond. You can click Enter Vendor Payment to open the Vendor Invoice and Adjustment screen, where you can enter vendor invoice information on the Main tab and payment information on the Payment tab. Other ways to handle a missing vendor payment are to select Financials | Payables | Manual Payments and enter the payment on the Manual Payment screen or select Financials | Payables | Payment Selection and step through the process of selecting an existing invoice for payment and then using Print Checks or ACH Payments to enter the payment. In each case, after the added payment is posted, the transaction will be available for reconciliation on the Bank Statement Reconciliation screen.
After posting the added Beyond transactions, you can return to the Bank Statement Reconciliation screen and continue the matching process, using either Update List or Automatic Match.
Note: Some imported bank statement transactions will not have a matching Beyond transaction, and no transaction should be added. For example, a bank error may have occurred, so the bank had to debit or credit your account. In this case, the imported transaction should be cleared without reconciliation. See Clearing Unmatchable Bank Statement Transactions.
If an imported bank statement includes one or more transactions that should not be reconciled to Beyond transactions, you can remove them using a setting on the Match pop-up window.
In the Imported Transactions grid, select the transaction to remove and then click the Match button. The Match pop-up window is displayed.
In the Match pop-up window, click Set to Cleared.
When prompted to confirm, click OK. You are returned to the Bank Statement Reconciliation screen.
In the Imported Transactions grid, the Cleared check box is selected for the transaction, so it will be permanently removed from the list after the reconciliation is posted. No amount is displayed in the Previously Cleared or Cleared Amount columns, because the amount of the transaction is not part of the reconciliation.
Note: If you have selected the wrong transaction to be removed, and you have not yet posted the reconciliation, you can undo this action. Open the imported transaction again in the Match pop-up window and click Set to Uncleared.
Occasionally, an imported bank statement transaction must be matched to multiple Beyond transactions, as in the case of the single bank deposit that includes multiple customer payments in Beyond. However, you may choose not to clear all of the Beyond transactions at the same time. For example, if one of the customer payment transactions in Beyond is dated one day after the bank statement date, then you may choose to wait until the next reconciliation to match/clear that one transaction.
After you reconcile some, but not all, Beyond transactions for an imported bank statement, then when you review that posted reconciliation on the Bank Statement Import screen, you will see a difference between the Amount and Cleared Amount values for the applicable bank statement transaction.
When you start the next bank statement reconciliation, the partially cleared bank statement transaction will be included in the Imported Transactions list, so you can clear the remaining Beyond transaction(s).
You can save your work in the Bank Statement Reconciliation screen at any time. If you save when the status is Pending, the reconciliation session remains active. You can open the screen later, click Find 
on the main toolbar, and open the session to continue working on its transactions.
To complete and close the session, you must change the status to Posted and then click Save. All imported transactions that were set to Cleared are removed from the system.
To post the reconciliation, the Difference field at the bottom of the Bank Statement Reconciliation screen must display zero (0). Difference = Beginning Balance - cleared Payments + cleared Deposits ± cleared Other.
To review the results after you post an imported bank statement reconciliation, follow these steps:
Select Financials | Cash | Bank Statement Import.
On the toolbar, click Find.
Double-click the reconciled bank statement batch to review. The list of transactions is displayed in the Imported Transactions grid.
Columns are described in Reviewing Imported Bank Statement Transactions. The difference now is that all transactions are cleared, and the cleared amount is displayed. If any of the transactions were partially cleared, you will see a difference between the Amount and Cleared Amount values for those transactions.
A: Yes. Your statement date for a reconciliation batch could be several weeks into the future. As long as you leave the reconciliation status set to Pending, you can import and match bank statement transactions daily for that batch, until the statement date is reached.
This is the general process:
Day 1, import bank statement transactions using the Bank Statement Import screen.
Start the reconciliation on the Bank Statement Reconciliation screen and use either Update List or Automatic Match to add imported transactions.
Match and/or verify the imported transactions with Beyond transactions.
Leave the status set to Pending and save your work.
Day 2, import bank statement transactions.
Open the Bank Statement Reconciliation screen and use the Find button to find and open your existing reconciliation batch. Do not change the Statement Date field.
Use either Update List or Automatic Match to add the new imported transactions.
Match and/or verify the added transactions.
Leave the status set to Pending and save your work.
Repeat this process each day until you are ready to close the session and post. At that time, set the status to Posted and save.