You can use the Layby Balances Report to view all transactions contributing to your current layby account balance as at a specific date, helping ensure accurate point-in-time reconciliation with your accounting package. This improves your retail operations by providing clear visibility into outstanding layby balances, promotional voucher handling, and non-account customer payment status, with properly configured layby balance tracking typically achieving better accounts management and faster period-end reconciliation.
Setting up layby balance reporting involves understanding fulfillment method versus sales type distinctions, promotional voucher inclusion options, and as-at date balance verification to help retail operators focus on the right layby account balances, ensuring your retail strategy consistently drives better financial accuracy outcomes.
This report will detail all transactions that contribute to the current balance in your Layby account as at a specific date.
Considerations when using this report:
- Layby sales are not related to the fulfilment method selected at POS
- Layby sales includes sales made to a non-account customer that are not fully fulfilled and fully paid on the same single day in the same store. This may include web sales that are fully paid through your webstore and fulfilled via delivery at a later date or from a different store. These sales will all move through your layby account in your accounting package.
To use the Layby Balances Report:
- Navigate to Reports > Accounting Reports > Layby Balances Report
- Select the As At date
- Tick to Include Promotional Vouchers if you want to include any vouchers issued via the Customer Activity Report
Promotional Vouchers issued through the Customer Activity Report are unpaid, and as such are uploaded to the Layby Account to be handled manually through the accounting program
- Update the remaining Filters as required
- Click Search
- The Results will be displayed grouped by Order Number
- Click the icons in the top right to export to Excel
Return to Top
Related Articles
Reporting & Analytics:
Point of Sale: