Bank Account Summary

Bank Account Summary

The Bank Account Summary provides a comprehensive overview of all your bank accounts, their balances, and key banking activities in EquiBillBook. This guide will help you understand and use the bank account summary effectively.

Understanding Bank Account Summary

The Bank Account Summary shows:

• Overview of all bank accounts
• Current balances for each account
• Account details and information
• Quick statistics and metrics
• Recent transactions summary
• Account status and activity

Accessing Bank Account Summary

To view the bank account summary:

1. Navigate to the Banking module from the main menu
2. Click on Bank Account Summary, Account Summary, or Bank Accounts
3. The summary will display all bank accounts and their details

Summary Information Displayed

Account List

For each bank account, the summary shows:

• Account Name: Name of the bank account
• Bank Name: Name of the bank
• Account Number: Last few digits or masked account number
• Account Type: Bank Account or Credit Card
• Current Balance: Available balance as of the selected date
• Currency: Account currency (if multi-currency)
• Status: Active or Inactive

Balance Information

Balance details shown:

• Current Balance: Balance as of today or selected date
• Opening Balance: Balance at the start of the period
• Total Deposits: Total deposits in the period
• Total Withdrawals: Total withdrawals in the period
• Net Change: Net change in balance for the period

Activity Summary

Quick activity metrics:

• Transaction Count: Number of transactions in the period
• Last Transaction Date: Date of most recent transaction
• Reconciliation Status: Last reconciliation date
• Outstanding Items: Number of unmatched transactions

Viewing Account Details

Account Overview

Click on an account to view:

• Full account information
• Branch details and IFSC code
• Account opening date and balance
• Custom account fields

Account Balance

View balance information:

• Current balance
• Balance history over time
• Balance as of specific dates
• Projected balance (if applicable)

Recent Transactions

Quick view of recent activity:

• Last 5-10 transactions
• Recent deposits and withdrawals
• Transaction dates and amounts
• Quick links to full transaction history

Filtering and Sorting

Date Range Selection

View summary for different periods:

• Select date range (Today, This Week, This Month, This Year, Custom)
• View balances as of specific date
• Compare balances across periods

Account Filtering

Filter accounts displayed:

• All Accounts: View all bank accounts
• Active Only: View only active accounts
• By Bank: Filter by bank name
• By Type: Filter by account type

Sorting Options

Sort accounts by:

• Account name (alphabetical)
• Balance (highest to lowest or vice versa)
• Last transaction date
• Bank name

Summary Statistics

Total Balances

The summary may show:

• Total Bank Balance: Sum of all bank account balances
• Total Credit Card Balance: Sum of all credit card balances
• Net Bank Balance: Total bank minus total credit card

Period Summary

Activity summary for the period:

• Total deposits across all accounts
• Total withdrawals across all accounts
• Net cash flow for the period
• Average balance for the period

Account Actions

Quick Actions

From the summary, you can:

• View Transactions: Go to transaction history for the account
• Record Deposit: Quickly record a new deposit
• Record Withdrawal: Quickly record a new withdrawal
• Transfer Funds: Initiate a transfer from/to the account
• Reconcile: Start reconciliation for the account
• View Reports: Generate reports for the account

Account Management

Manage accounts:

• Edit account details
• View account settings
• Activate or deactivate accounts
• Delete accounts (if no transactions)

Exporting Summary

Export Options

Export the summary:

• Excel: Export to Excel for analysis
• PDF: Export to PDF for printing or sharing
• CSV: Export to CSV for data import

Export Process

1. Apply any filters or date ranges
2. Click "Export" or "Download"
3. Select export format
4. Choose columns to include
5. Download the exported file

Printing Summary

To print the summary:

• Apply filters to select accounts and date range
• Click "Print" or "Print Preview"
• Review the print preview
• Adjust print settings if needed
• Print or save as PDF

Best Practices

• Review bank account summary regularly (daily or weekly)
• Monitor balances to ensure sufficient funds
• Compare balances across periods to track trends
• Use filters to focus on specific accounts or periods
• Export summary for record-keeping and analysis
• Use quick actions for common tasks
• Review reconciliation status regularly
• Check for accounts with no recent activity

Troubleshooting

Balance not matching expected:

• Check if all transactions are recorded
• Verify the selected date for balance calculation
• Review recent transactions for errors
• Check if reconciliation is needed

Account not appearing in summary:

• Check if account is active
• Verify account filters applied
• Check user permissions for account access

Incorrect totals or calculations:

• Verify all transactions are properly recorded
• Check date range selected
• Review account balances individually
• Contact support if calculations seem incorrect