You can access the Daily Reconciliation page by expanding the 'Accounts' dropdown under the 'Reports' section in the left sidebar and clicking on 'Daily Reconciliation'. This page provides a comprehensive report of daily financial activity, allowing users to reconcile sales, deposits, and identify any discrepancies.
1. Report Filters
The report can be filtered using the following criteria:
- Created By: Filter by the sales agent who created the transactions.
- Booking Date: Filter by the specific date of the booking.
- Clear Filters button: Resets all applied filters to their default state.
2. Export Options
The report data can be exported in different formats:
- Export to Excel (
icon): Exports the current report data to an Excel spreadsheet. - Export to PDF (
icon): Exports the current report data to a PDF document.
3. Report Table
The main table displays detailed daily reconciliation information, including:
- #: Row number.
- Date: The date of the reconciliation entry.
- Sales Agent: The agent responsible for the sales.
- Cash: Total cash sales for the day.
- Online: Total online payments for the day.
- Account: Total account sales for the day.
- Cheque: Total cheque payments for the day.
- Direct Deposit: Total direct deposits for the day.
- Eftpos: Total EFTPOS transactions for the day.
- M-PAISA: Total M-PAiSA transactions for the day.
- Penalty: Total penalties recorded for the day.
- Total Sales: The sum of all sales for the day.
- Deposit Date(s): Dates of deposits made. An icon (
) allows adding new deposit amounts. - Deposit Amount(s): Amounts deposited. An edit icon (
) allows updating the amount. - Deposit Bags: Bag numbers associated with deposits.
- Bank Status: Indicates if the deposit has been reconciled with the bank (e.g., 'yes' or 'no'). An edit icon () allows updating the status.
- Variance Type: Indicates if there is a 'Short' (deposit less than sales) or 'Balanced' (deposit equals sales) variance.
- Variance Amount: The monetary difference between sales and deposits.
- Remarks: Any additional notes or comments. An edit icon () allows updating remarks.
The table also includes pagination controls and a search bar.