Pay reconciliation

Go to Accounting, select Pay reconciliation.

• Click here to upload Bank statement.

1. Choose the bank account.
2. Upload the bank file.
3. Enable auto expense or auto pay recipient, if required.
4. Click Upload to upload the bank file.

Reconciliation

Steps to Reconcile:

1. Select the Bank Account
   • Choose the appropriate bank account from the dropdown list (e.g., Corporate Account).
2. Select the Date Range
   • Define the time period for reconciliation (e.g., Last Month – 01/03/2025 to 31/03/2025).
3. Select the Pay Type
   • Choose the pay type (e.g., All, Debit, or Credit).
4. Filter by Match Status (Optional)
   • You can further filter by:
     • All Transactions
     • Matched Transactions
     • Unmatched Transactions
5. Filter by Debit/Credit (Optional)
   • View either All, only Debit transactions, or only Credit transactions.
6. Click Submit
   • After setting the filters, click the Submit button to view the reconciliation results.
7. View Transactions Summary
   • After submitting, a summary is displayed at the bottom, showing:
     • Total Transactions
     • Total Debit Amount
     • Total Credit Amount
     • Opening Balance
     • Closing Balance

Sample Output

Bank Accounts

Select Bank Account, the list of registered bank acc shows here.

• Click Edit to modify the bank account details.
• Click Opening Balance History to modify the opening balance.
• Click Delete to remove the bank details.

Adding new bank account:

Click Add new bank account,

• Specify the bank name (e.g., DBS/POSB).
• Enter the account number.
• Provide the customer ID associated with the account.
• Input the secure password for the account.
• Provide the URL for online banking or account access.
• Enter the name associated with the bank account.
• Specify the account category (e.g., Corporate).
• Enter the initial balance of the account.
• Provide the date when the account will be active or effective.

Recipient Mapping

Click Recipient mapping,

Click Add new,

• Enter the Mapping name.
• Choose the recipient name.

In Action,

• Click edit to modify to recipient.
• Click delete to remove the recipient.