When the Void Check function is executed in the system, the Close at Date field shall be automatically assigned a value based on the Last Statement Date.
Functional Logic
Close at Date = Last Statement Date + 1 day
You note that the “Closed at Date” occurs before the “Posting Date” of the Bank Account Ledger Entries.
This functionality enables users to close and reopen Bank Reconciliation entries directly from Bank Account Ledger Entries, based on user permissions and system setup configuration.
The system provides the ability to:
In the Acumens User Setup Card, the user must have Can Update Reconciliation Entries enabled.
This permission controls whether the user can manually modify reconciliation status on bank ledger entries.
In Acumens StarterPack Setup, the following Bank Reconciliation configurations control the feature:
Available options:
The "Close All Bank Ledger Entries" report enables authorized users to bulk close bank ledger entries for reconciliation instead of manually selecting entries one by one from the Bank Account Ledger Entries page.
This functionality is controlled through the Acumens User Setup Card permission to ensure only authorized users can execute multiple reconciliation updates.
The user must have the Can Close All Bank Ledger Entries permission enabled in the Acumens User Setup Card as highlighted below.
When above setup is FALSE then user will get below warning.
This retains the deprecated version of Bank Reconciliation module designed for the North America version which was deprecated by Microsoft
On General Ledger setup page, setup “Bank Rec. Adj. Doc. Nos.” field. This specifies the bank reconciliation adjustment document number.
On the Bank Account card, setup the "Last Statement No." field. This specifies the number of the last bank account statement that was reconciled with this bank account. When a new Bank Reconciliations card is created, the Statement No. will be incremented from this setup.
Search or Find the ASP Bank Reconciliations list.
Opens ASP Bank Reconciliations List.
Select Existing or click on "New" action to create a new Bank Reconciliation.
Opens a bank reconciliations card. Select the Bank account to reconcile.
Select the Statement Date. The amounts on the card will automatically populate when the date is updated.
Suggest Lines.
Bank Reconciliation Lines are updated.
Header amounts are also recalculated.
Update the "Balance on Statement" field. This specifies the blance on the bank statement.
On the statement lines, Compare the suggested lines against the Bank Statement Lines. Checkmark the verified lines. This specifies that the check/deposit/transfer on the line has been cleared, as indicated on the bank statement.
Cleared amounts is automatically populated and can be modified. Difference amount is also calculated.
Verify and repeat the same for all lines.
You can use the "Find and Reconcile" feature to locate specific check/deposit entries then specify the amount to clear. Click to open the search page.
Type the document number or amount then hit Enter to search.
If an entry is found and the desire is to clear the entire amount, click Yes.
If intending to clear less amount, click No then specify the amount in the subsequent page, then hit Enter as well.
The header totals are recalculated as you clear the lines.(You may need to refresh page).
The "Difference" field show the difference between the bank statement and the ledger entries on Business Central. This might be due to bank transactional charges, interests or other charges and deposits not posted in Business Central.
On Adjustment fastTab, enter any entries to be adjusted. This will will inculde any entries on the bank statement that have not yet been posted on business central.
Refresh and review Header Totals. If the difference is Zero(0) then the Bank Reconciliation can be Posted. Adjustments are posted togheter with the Bank Reconciliation entries.
Click on “Post” or “Post and Print” action to post the bank reconciliation card.
Search or Find the ASP Posted Bank Reconciliations list.
Opens ASP Posted Bank Reconciliations list.
Open card to view Posted Bank Reconciliations.
Adjustment entries are posted to the ledgers.
Reconciled Bank account entries are closed.
