# Cash Advance Voucher Report
Cash advances and loans issued to employees over a date range. Groups vouchers by employee with amount and outstanding balance, optional bank details, and filters for category and status.
Overview
Go to Payroll → Payroll Reports → Cash Advance Voucher.
What it shows. Cash advance vouchers grouped by employee with total amount and balance, or individual voucher lines when Show Detailed is on.
When to use it. Track advances issued, monitor outstanding recovery balances, and prepare bank payment files with employee account details.
Use Cases
- Payroll — Which employees received advances this month and how much is still to recover?
- Finance — Export with bank details for disbursement reconciliation.
- Branch admin — Filter by branch via Advanced Filter.
Filters
| **Filter** | **Description** |
|------------|-----------------|
| Date range | Voucher dates (default: current month). |
| Category | All, Cash Advance (0), or Loan (1). |
| Status | Draft, Approved, Closed, or blank for default (Approved + Closed). |
| Employee | Optional employee filter. Respects payroll-module employee access filters. |
| Advanced Filter | Branch — applies user default branch filter when configured. |
Columns
| **Column** | **Description** |
|------------|-----------------|
| Emp Code | Employee code. |
| Employee | Employee name. |
| Bank Account / IFSC | From employee bank account master (when Show Bank Details is on). |
| ID | Voucher ID (detailed mode). |
| Date | Voucher date (detailed mode). |
| Category | Cash Advance or Loan (detailed mode). |
| Amount | Advance amount (summed per employee in summary mode). |
| Balance | Outstanding balance still to recover (summed per employee in summary mode). |
Actions
- Generate — run the report
- Show Detailed / Hide Detailed — toggle individual voucher lines
- Advanced Filter — branch filter; clear resets filters
- More — Show Bank Details / Hide Bank Details
- Export — export to Excel
- Print — print the report
FAQ
How is balance calculated?
Advance amount minus receipt vouchers and pay-run deductions recovered against the voucher.
Why don't I see some employees?
User employee filters for the payroll module may restrict visible employees.
What is the difference from Cash Advance Request Report?
This report lists issued Cash Advance Vouchers. The Cash Advance Request Report lists employee requests before vouchers are created.
Does balance include pay-run recovery?
Yes. Balance is advance amount minus receipt vouchers and pay-run deductions posted against the voucher.
Why is an open voucher not on the next pay run?
Pay run must be created or Refetched for the employee — auto-pull includes all open category-1 vouchers with remaining balance.
Can I filter by zero balance?
Use advanced filters or export to Excel — fully recovered vouchers show balance zero and status closed or paid.
Are opening balance vouchers included?
Yes when they match filter criteria — Is Opening vouchers use account 56 and still recover through pay run deductions.