Bank Reconciliation Configuration Setup

Overview

For existing Accounting Seed users, there are some configuration changes that need to be made for using the new Bank Reconciliation. 

Note: These changes are not applicable to users who are installing Accounting Seed for the first time.

Prerequisites

• New Bank Reconciliation is only available for the Lightning UI. 
• My Domain in Salesforce must be enabled. To learn more, view the Salesforce My Domain knowledge article. 
  

Use this article to complete the following:

• Configure the Page Layouts
• Configure the Compact Layouts
• Add new Components to a Custom Lightning Record page
• Configure Permission Sets

Configure the Page Layouts

For help with editing page layouts, refer to the Edit Page Layouts Manually knowledge article.

Bank Reconciliation page layouts

1. Remove the following buttons:
   1. Create Reconciliation Report  
   2. Clear/Unclear Transactions.
2. Remove the Status field from the Additional Information section.
3. Add the following buttons:
   1. Create CSV File 
   2. Create PDF Summary
   3. Create Next.
4. Remove the Statement Start Date field.
5. Add the following fields:
   1. Override Beginning Balance
   2. Type 
   3. Status. 

Cash Disbursement page layouts

1. Add the Bank Reconciliation Date field.

Cash Receipt page layouts

1. Add the Bank Reconciliation Date field.

Journal Entry Line page layouts

1. Add the Bank Reconciliation Date field.

Bank Deposit page layouts

1. Add the following fields
   1. Bank Reconciliation Date
   2. Ledger Amount (only if multi-currency is enabled).

Return to top

Configure the Compact Layouts

Bank Reconciliation compact layouts
If you have multi-currency enabled, add the Currency field in the compact layouts (Bank Reconciliation object | Compact Layouts).

Add new Components to a Custom Lightning Record page

If you have a custom Lightning Record page for Bank Reconciliation, there are two new components that will need to be added onto the page. Use the steps below to add the new components. 

1. Access the Object Manager and display the Bank Reconciliation object. 
2. Select the Lightning Record Pages.
   
   
   Note: Click here to view the above image in full screen. 
   
   
3. Select the custom page and Edit it. 
4. Drag and drop the following two new components onto the page:
   bankRecCalculator and BankRec Data Table. 
   
   
   Note: Click here to view the above image in full screen. 
   
5. Click Save. 

Return to top

Configure Permission Sets

Bank Reconciliation has been configured to use the following three permission sets:

• AS Full Admin
• Accounting Manager
• Cash Out & Banking

Custom Permission Sets

If you used the legacy Bank Reconciliation and have custom permission sets, complete the steps below. 

1. On the Bank Reconciliation object, provide Edit access to the following fields:
   1. Type 
   2. Status
   3. Override Beginning Balance.
2. On the Bank Reconciliation object, provide Read access to the following fields:
   1. Uncleared Deposits
   2. Uncleared Payments
   3. Calculated Balance
   4. GL Ending Balance
   5. GL Difference
   6. Error.
3. Provide Read access to the Bank Reconciliation Date field on the following objects:
   
   1. Cash Receipt
   2. Cash Disbursement
   3. Journal Entry Line
   4. Bank Deposit.
4. Provide Read access to the Amount Number field on the following objects:
   
   1. Cash Receipt
   2. Journal Entry Line
5. On the Uncleared Bank Reconciliation Line object, provide the following access:
   Note: This is a new object with the Koali release. 
   1. Name - Read
   2. Bank Reconciliation - Read and Edit
   3. Related Source Document - Read and Edit
   4. Cash Receipt - Read
   5. Cash Disbursement - Read
   6. Journal Entry Line - Read
   7. Bank Deposit - Read
   8. Amount - Read and Edit
6. Add the following Apex Classes:
   1. AcctSeed.BankReconciliationHelper
   2. AcctSeed.BankReconciliationPDFReportNew
7. Add the following Visualforce page: BankReconciliationPDFReportNew.

Return to top