Q1. What is Banks Summary?
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.
Q2. Where can I access Banks Summary?
Go to Reports > Summaries > Banks.
Q3. What is the Closing Balances tab?
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
Q4. How do I change the date in Closing Balances?
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
Q5. Can I filter bank accounts in Closing Balances?
Yes. Click Filter and apply filters such as:
Account Code
Account Name
Currency
Description
Balance
Statement Balance
Click Apply to activate filters.
Q6. Can I customize the columns in Closing Balances?
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.
Q7. Can I export the Closing Balances report?
Yes.
Click the download icon.
Choose Excel.
Click Download.
The export reflects your visible columns.
Q8. What is the Reconciliation Summary tab?
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
Q9. How do I change the date range in Reconciliation Summary?
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.
Q10. How do I select a bank account in Reconciliation Summary?
Click the Account dropdown.
Choose the bank account you want to review.
Q11. What does the Difference represent?
The Difference shows the variance between:
Bank closing balance
Cashflow records closing balance
A non-zero difference may indicate unreconciled transactions.
Q12. What is the Reconciliation Details tab?
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
Q13. What do Unreconciled and Reconciled mean?
Unreconciled shows transactions that have not yet been matched.
Reconciled shows transactions that have already been matched during reconciliation.
Q14. Can I filter transactions in Reconciliation Details?
Yes. Click Filter and apply filters such as:
Contact
Description
Reference
Payment Method
Amount (SGD)
Click Apply to activate filters.
Q15. Can I export Reconciliation Summary and Details?
Yes. Click the download icon to download the summary. The exported report reflects your selected date range and filters.