Banks Summary is an accounting report that provides an overview of:
Bank closing balances
Reconciliation summaries
Reconciliation details
It helps you monitor your bank balances and reconciliation status.
Go to Reports > Summaries > Banks.
The Closing Balances tab shows the current balance of all bank accounts as of a selected date.
It includes:
Account Code
Account Name
Account Description
Status
Account Currency
Balance
Statement Balance
Click on the Date dropdown.
Choose preset options such as:
Today
End of this Month
End of last Month
End of last Financial Quarter
End of last Financial Year
Yes. Click Filter and apply filters such as:
Account Code
Account Name
Currency
Description
Balance
Statement Balance
Click Apply to activate filters.
Yes. Click the adjust icon and select Adjust Columns.
You may:
Add or remove columns
Reorder selected columns
Examples of available columns include:
Account Code
Account Name
Account Description
Status
Account Currency
Balance
Statement Balance
Account Lock Date
Click Save after making changes.
Yes.
Click the download icon.
Choose Excel.
Click Download.
The export reflects your visible columns.
The Reconciliation Summary tab shows a summary of a selected bank account’s reconciliation for a specific date range.
It includes:
Bank Opening Balance
Reconciled Bank Records
Unreconciled Bank Records
Bank Closing Balance
Cashflow Records Opening Balance
Reconciled Cashflow Records
Unreconciled Cashflow Records
Cashflow Records Closing Balance
Difference
Click the Date Range dropdown.
Select preset options such as This Month, This Financial Quarter, or This Financial Year.
You may also manually set the start and end dates.
Click the Account dropdown.
Choose the bank account you want to review.
The Difference shows the variance between:
Bank closing balance
Cashflow records closing balance
A non-zero difference may indicate unreconciled transactions.
The Reconciliation Details tab shows detailed bank and cashflow records within the selected date range.
It includes columns such as:
Date
Description
Reference
Contact
Payment Method
Amount
Unreconciled shows transactions that have not yet been matched.
Reconciled shows transactions that have already been matched during reconciliation.
Yes. Click Filter and apply filters such as:
Contact
Description
Reference
Payment Method
Amount (PHP)
Click Apply to activate filters.
Yes. Click the download icon to download the summary. The exported report reflects your selected date range and filters.
