Purpose of this document
When you maintain the information about Bank accounts in Ceres, you must reconcile them on a regular basis. The process defined here assist with checking the entries and the balances on your accounts against the statements from the bank.
Ceres Object release 5.00.00 is required for the functionality described in this document.
Table of Contents
Creating and Posting a Bank Account Reconciliation
1. The Bank Account Reconciliation can be accessed from Departments à Financial Management à Cash
Management à Lists à Bank Account Reconciliations.
2. To create a new Bank Account Reconciliation, click on the Home Tab of the Ribbon and then New. Update
the fields as necessary.
Bank Account No.: Select the Bank Account Code for the account you are reconciling.
Statement No.: Ceres automatically fills in the Statement No. field based on the information on the bank account card.
Statement Date: Enter the date of the statement from the bank. This field is also used to filter the G/L Entries that display in the G/L Balance $ field.
Cleared With./Chks. Per Stmt.: Input from the bank statement, the checks and other withdrawals that cleared.
Cleared Inc./Dpsts. Per Stmt.: Input form the bank statement, the deposits and other incoming transactions that cleared.
Balance on Statement: Input the ending bank balance per the bank statement.
3. The Bank Account Lines in the Checks Lines and Deposits/Transfer FastTabs is where the actual reconciliation is performed by indicating which lines have cleared.
4. To bring the lines in, click on the Actions Tab in the Ribbon and select Suggest Lines.
5. From the Bank Rec. Process Lines Page, select the Record Type to process (Checks, Deposits, or Both) and
whether you want to replace the existing lines.
6. In the Posting Date field, enter the starting posting date for the Ledger Entries to be reconciled. In the
Ending Date field, enter the ending date for these Ledger Entries.
7. Click OK. Ceres then fills in the lines on the Checks FastTab and the Deposit/Transfers FastTab. and. The
outstanding checks are updated on the Checks FastTab and the outstanding deposits and transfers are
updated on the Deposit/Transfers FastTab.
8. Open the Checks FastTab and place a checkmark in the Cleared field for each check that cleared the bank
This process can be automated by running the Mark Lines Function from the Home Tab of the Ribbon and
then selecting Mark Lines.
9. Open the Deposit/Transfers FastTab repeat the process by placing a checkmark in the Cleared field for each
deposit or transfer that cleared the bank. This process can be automated by running the Mark Lines
Function from the Home Tab of the Ribbon and then selecting Mark Lines.
10. Click OK. Ceres will mark the lines as cleared based on the filters that were set.
11. Correct the lines, if necessary, by un-checking the checks or deposits that have not cleared.
12. If a check or deposit cleared for a different amount update the Cleared Amount field.
13. You can start over by clearing all lines. To clear the lines, click on the Actions Tab of the Ribbon and select
Clear Lines.
14. Repeat the steps above for the deposits and transfers.
15. Open the Adjustment FastTab and enter a new line with any transaction from the bank statement that
does not appear on the reconciliation lines, such as bank fees. Any amounts entered on the Adjustment
FastTab will post as a Journal Entry when the Bank Reconciliation is posted.
16. Open the General FastTab and confirm that Difference is $0. If not, verify the amounts you inputted and
the checks and deposits that are marked as cleared. The Bank Reconciliation cannot be posted until the
Difference is $0.
17. To print the Bank Reconciliation Test Report, click on the Actions FastTab of the Ribbon and select Test
Report.
18. From the Bank Rec Test Report Page, select what you want to print on the Report. The easiest way to do
this is to select Details (which checks all fields) and then un-check what you do not want to include.
19. In the below example, Adjustments, Outstanding Checks, and Outstanding Deposits were selected. Then
select Print to print a hardcopy or Preview to preview the Report.
20. To post the Bank Reconciliation, click on the Actions Tab of the Ribbon and select Post or Post and Print.
21. Posted bank reconciliations can be viewed from the Bank Account Card by clicking the Navigate Tab in the
Ribbon and selecting Posted Reconciliations.
22. Highlight the posted bank reconciliation you want to view and the click on the Home Tab of the Ribbon
and select View.
Related Topics
Bank Deposits AP Check Processing AP Check Voiding Ceres5.01.04 - Posted Bank Recon Report does not show collapsed deposits correctly
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article