🏦 Clearance Bank – Manage Bank Clearance Records #
1. Navigate to “Clearance Bank” #
- Log in to your restaurant management system.
- In the sidebar, click Payment Accounts.
- Under Payment Accounts, select Clearance Bank.
- The clearance bank page will open showing:
- A header with “Clearance Bank” title and subtitle “Manage Clearance Bank”.
- An “All Clearance Bank” section showing all clearance records.
- A purple + Add button to create new clearance entries.
- Export options for CSV, Excel, Print, Column visibility, and PDF.
- A data table with clearance bank records.
2. Understanding Clearance Bank #
The Clearance Bank module helps manage bank transaction clearances and reconciliation processes:
- Transaction Reconciliation – Match bank statements with internal records for accuracy.
- Clearance Tracking – Monitor which transactions have been cleared by the bank.
- Financial Control – Ensure all transactions are properly accounted for and cleared.
- Audit Trail – Maintain complete records of clearance activities for compliance.
- Cash Flow Management – Track actual cash position based on cleared transactions.
- Bank Reconciliation – Streamline monthly bank reconciliation processes.
Key Purpose: This module ensures accurate bank reconciliation and helps maintain precise financial records by tracking transaction clearance status.
3. View Clearance Bank Records #
- The main table displays all clearance bank entries with columns:
- Name – Description or reference name for the clearance entry.
- Created By – Staff member who created the clearance record.
- Date – Date when the clearance was processed or recorded.
- Action – Available actions for each clearance record (View, Edit, Delete).
- Use the Search box (top-right) to quickly find specific clearance records.
- Adjust Show entries dropdown to control how many records display per page (25, 50, 100).
- When no data is available, the table shows “No data available in table” message.
4. Add New Clearance Bank Entry #
- Click the purple + Add button (top-right area).
- A form will open with fields for creating a new clearance entry:
- Entry Name/Description – Descriptive name for the clearance record.
- Bank Account – Select the bank account being cleared.
- Transaction Details – Enter transaction information to be cleared.
- Clearance Date – Date when the transaction was cleared by the bank.
- Amount – Transaction amount being cleared.
- Reference Number – Bank reference or transaction ID.
- Notes – Additional details about the clearance.
- Fill in all required information and click Save.
- The new clearance entry will appear in the main table.
5. Manage Existing Clearance Records #
- Locate the clearance record you want to manage in the table.
- Use the Action column options:
- View – Display detailed information about the clearance entry.
- Edit – Modify clearance details, dates, or amounts.
- Delete – Remove the clearance record (with confirmation).
- For editing:
- Click Edit to open the modification form.
- Update necessary fields (description, date, amount, notes).
- Save changes to update the record.
- For deletion:
- Click Delete and confirm the action.
- Record will be permanently removed from the system.
6. Export and Reporting Options #
- Export Functions – Use the toolbar buttons:
Export to CSV– Download clearance data as CSV file for spreadsheet analysis.Export to Excel– Download as Excel spreadsheet with formatting.Print– Print the clearance records list for physical documentation.Column visibility– Show/hide specific columns before exporting.Export to PDF– Generate PDF report of clearance records.
- Reporting Benefits:
- Monthly bank reconciliation reports.
- Clearance status summaries for management review.
- Audit trail documentation for compliance purposes.
- Historical clearance data for trend analysis.
7. Bank Reconciliation Process #
Monthly Reconciliation Workflow:
- Gather Bank Statements – Obtain monthly bank statements from all accounts.
- Compare Transactions – Match bank statement entries with internal transaction records.
- Identify Discrepancies – Note any transactions that don’t match between systems.
- Create Clearance Entries – Use the + Add button to record cleared transactions.
- Document Differences – Record any timing differences or outstanding items.
- Generate Reports – Export clearance data for management review and filing.
- Archive Records – Maintain clearance records for audit and compliance purposes.
8. Clearance Entry Types and Categories #
| Entry Type | Description | Common Examples |
|---|---|---|
| Deposits Cleared | Customer payments and deposits that have cleared | Daily sales deposits, customer payments |
| Checks Cleared | Issued checks that have been cashed by recipients | Vendor payments, expense reimbursements |
| Electronic Transfers | Wire transfers and ACH transactions | Payroll deposits, supplier payments |
| Bank Fees | Service charges and fees deducted by bank | Monthly maintenance fees, transaction charges |
| Interest Earned | Interest credited to account by bank | Savings account interest, deposit interest |
| Returned Items | Checks or payments returned by bank | NSF checks, rejected payments |
| Adjustments | Bank corrections or adjustments | Error corrections, manual adjustments |
9. Handle Empty Clearance Records #
When no clearance records exist, you’ll see:
- “No data available in table” message in the main table area.
- “Showing 0 to 0 of 0 entries” at the bottom pagination.
- This situation occurs when:
- System is newly set up and no clearances have been recorded yet.
- All previous clearance records have been archived or deleted.
- Bank reconciliation process hasn’t been started for the current period.
- Filters or search terms are hiding existing records.
- Next Steps:
- Begin by adding clearance entries for recent bank transactions.
- Import historical data if migrating from another system.
- Set up regular reconciliation schedule to maintain current records.
10. Sort and Navigate Clearance Data #
- Column Sorting – Click on column headers to sort data:
- Name – Sort alphabetically by clearance entry description.
- Created By – Sort by staff member who created the entry.
- Date – Sort chronologically by clearance date (most useful for reconciliation).
- Pagination Controls:
- Previous/Next – Navigate between pages of results.
- Page Numbers – Jump directly to specific pages.
- Show Entries – Adjust number of records per page for easier viewing.
- Search Functionality:
- Use search box to find specific clearance entries by name or reference.
- Search is real-time and filters results as you type.
11. Integration with Payment Accounts #
Important: Clearance Bank works in conjunction with other Payment Account modules for complete financial management.
- List Accounts – Links to bank accounts being reconciled and cleared.
- Balance Sheet – Clearance data affects cash and bank balance reporting.
- Trial Balance – Cleared transactions impact trial balance accuracy.
- Cash Flow – Clearance timing affects cash flow reporting and forecasting.
- Payment Account Report – Clearance data feeds into comprehensive account reporting.
- Map Payment Accounts – Ensures proper account mapping for clearance processing.
- Import Sale Payment – Coordinates with sales payment imports for reconciliation.
12. Best Practices for Clearance Management #
- Regular Reconciliation – Perform bank reconciliation monthly or more frequently for high-volume accounts.
- Timely Entry – Record clearances promptly after receiving bank statements.
- Detailed Documentation – Include comprehensive notes and references for each clearance entry.
- Consistent Naming – Use standardized naming conventions for easy identification and searching.
- Verification Process – Double-check clearance amounts and dates against bank statements.
- Archive Management – Maintain historical clearance records for audit and compliance purposes.
- Access Control – Limit clearance entry permissions to authorized accounting staff.
- Backup Procedures – Regular backup of clearance data to prevent loss of reconciliation work.
13. Troubleshooting Common Issues #
| Issue | Possible Cause | Solution |
|---|---|---|
| Cannot add clearance entry | Missing required fields or permissions | Verify all required fields are completed and user has proper access |
| Clearance amounts don’t match | Data entry error or timing differences | Double-check bank statement and internal records for accuracy |
| Missing transactions | Transactions not yet cleared by bank | Check for outstanding items and timing differences |
| Duplicate clearance entries | Multiple users entering same transaction | Implement clear procedures and review existing entries before adding |
| Export not working | Browser issues or large data set | Try different browser or reduce date range for export |
| Search not finding records | Incorrect search terms or data entry variations | Try partial search terms or browse through date ranges |
14. Compliance and Audit Considerations #
- Audit Trail – Maintain complete records of who created, modified, or deleted clearance entries.
- Documentation Standards – Keep supporting bank statements and reconciliation worksheets.
- Segregation of Duties – Separate clearance entry from approval and review functions.
- Regular Reviews – Implement supervisory review of clearance entries and reconciliations.
- Retention Policies – Maintain clearance records according to legal and regulatory requirements.
- Internal Controls – Establish procedures for clearance entry, review, and approval.
- External Auditor Access – Ensure clearance records are accessible for external audit review.
15. Done! 🎉 #
You can now effectively manage bank clearance records, perform accurate reconciliations, and maintain proper financial controls for all your restaurant’s banking activities!