The Layby Movement Report details all transactions that contribute to the movement in your Layby account in your Accounting Package within the period selected, including:
- Sales
- Vouchers
- Freight
- Payments
This report provides information at a detailed transactional level, however if you need help with account or summary level information, please refer to the article Verifying Data Imported to your Accounting Package.
Before you Begin
- The opening balance should match the Layby account balance in your Accounting Package as at the start of the date period you?re reporting
- The closing balance should match the Layby account balance in your Accounting Package as at the end of the date period you?re reporting on
- The opening and closing balances are not affected by the Movement Type filter and will always include all movement types
- This report only includes fulfilled products under ?sale? movements.
- Layby sales are not related to the fulfilment method selected at POS
- Layby sales include sales made to a non-account customer that is 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 web store 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.
Back to top
Using the Layby Movement Report
To use the Layby Movement Report:
- Navigate to Reports > Accounting Reports > Layby Movement Report
- Select the Filters as required (see below for more details)
- Click Search
- Results are displayed grouped by Outlet, and sorted by date.
- Click the arrow to expand/collapse each section
- Click the Export to Excel or CSV buttons to export a list of transactions for each outlet
- Click the Column Headings to re-sort the data
Filters
Most of the filtering fields are self-explanatory, however, see the detailed information below for the more advanced fields.
| Filter | Details |
| Ignore Date From |
Unticked by default, this option allows you to override the "Date From" and "Date To" date range. Tick the box to include all sales up to the "Date To" option (regardless of the "Date from" selection)
|
| Movement Type |
Used to filter by specific transaction types only:
- Sales - Fulfilled items on the date fulfilled
- Vouchers ? vouchers on the date purchased
- Freight ? freight charged on sales on the date applied to the sale
- Payment ? all payments made on the sale based on the Payment Date entered against the payment
|
| Store Type |
Filters based on the type of Outlet as selected in the Outlet Settings
|
Return to Top