Originally written by John Hardwick, last updated Aug 25, 2023, on the Swan Retail knowledge base (FRS).
This suite of reports provider analysis relating to the following areas: customer finances, trading statistics, payments, deposits, invoicing data.
Accounts Not Posted Report
This audit is designed to be run before the accounts interface is operated and lists the transactions waiting to be sent to the accounts system. This report is not reproducible. Once the data has been sent to the accounts package, the data is flagged as processed and therefore ceases to appear on this report.
Accounts Posted Report
This audit is designed to be run after the accounts interface has been operated and lists the transactions sent to the accounts' system within a specified date range.
Accounts Status
This report is designed to show the financial status of customer accounts at a given date using a 30-day ageing principle.
Aged Debt Summary
The report lists all customers with an outstanding balance (excluding deposits / option to include zero balanced customers) on their account. The debt is identified as finance / non-finance (customer to pay) and then aged.
Allowances Processed
This report is designed to list all sales orders where a retrospective allowance has been added via the ‘issue credit’ option. This report should form part of your periodical reporting pack to ensure you are monitoring the use of this feature.
Amended Payment Audit
This report is designed to list payments that have been adjusted after initial entry and prior to cash reconciliation.
Cash Adjustments
This report produces a list of cash reconciliations where a cash adjustment value has been recorded.
Cash Receipt Reprint
This report uses the ‘banner’ logo to produce a reprint of payments received against a specified sales order.
Closing Costs
This report details the cost of sold goods, differentiating between supplier paid (invoiced) and supplier pending (goods received not invoiced) sequenced by SKU grouped by supplier within product group. The report forms two sections dependent upon supplier payment status, with a grand total.
Commission Statement (1214 onwards)
The report calculates commission using a user specified start and end date and in detail or summary the report may take time to complete due to the complexity of the calculations.
Customer Aged Debt
The report produces a financial statement of each customer, including or excluding those with zero balances at the operator’s request.
Customer Aged Debt Summary
The report produces a financial statement of each customer, including or excluding those with zero balances at the operator’s request.
Customer Balance
The customer balance report produces a statement for a user definable list of customers, grouped optionally by location and / or salesperson. The details show balances across sales orders, payments, and finances with an aged banding per transaction.
Customer Base Data Export (1214 onwards)
This report is designed to allow the retailer to produce a data export of their customer file containing most fields displayed when viewing the customer’s details within Find Customer.
Customer Credit Order Balance
This report produces a mini statement showing the order balance for a customer.
Customer Deposits Audit
This report offers the operator a date selection from which all payments received are reported, whether cash reconciled or not. In addition, all confirmed sales (deliveries and collections) are listed, presenting an audit detailing the impact on the deposit value held for customers.
Customer Export
This report is designed to allow the retailer to produce a data export of their customer file.
Customer Payment Report
The report details, for a specific user defined customer, all payments and refunds posted to the account. To use this report, it is necessary to obtain SwanFRS’s customer reference number first.
Customer Performance
The report details the top x number of customers ranked by payment or by deliveries.
Customer Performance Export
The report details the top x number of customers ranked by payment or by deliveries, with an output designed for import into a third party application.
Customer Source Analysis
This report produces an audit for systems where the source of business is recorded against the customer (separate to sales order source of business but shares the same codes)
Customer Source of Business
This report produces a list of products sold (SKU) level, using the customer source of business to collate the data. This report is of use for systems where the source of business is collated at customer level and is not linked to the source of business linked to the sales order.
Customer Statement
This report is designed to produce a financial customer statement for a date offering different degrees of information, ageing dates, and control of account balance inclusion.
Daily Payment Summary
The report produces an audit of how payments have been received.
Deposits
The report lists all deposits held for a user specified date and time. This report does not include ‘unallocated payments’ held against the customer, but not a sales order.
Detailed Profit Report
The report produces a profit value for the user specified week range. The report can be generated for a specific supplier and / or product group where necessary.
Detailed Profit Report by Invoice
The report produces a profit value for the user specified week range. The report can be generated for a specific supplier and / or product group where necessary, showing the invoice date.
Finance Claims
The report lists all sales orders / finance applications which, dependent upon selection criteria, will show all approved, unapproved claims for all or only fully delivered orders.
Finance Summary
This report details finance payments and / or refunds received within the reporting period.
Generated Commission
This audit is used with the ‘Advanced Commission Generation System’ and produces a commission statement for the salesperson.
Goods Received Not Invoiced (1214 onwards)
This report produces a list of goods receipted into stock that have not been invoiced (paid for) prior to a user specified date.
Goods Returned Not Credited
This report is designed to list all stock ‘sent’ back to the supplier where a credit note has not been processed.
Gross Profit By Branch Invoice
The report shows the profit generated collated by week.
Invoice List
This audit details invoices raised within the system.
Margin by Nominal Code
The report shows margin for the user selected analysis criteria. The output totals use the sales account code broken down by range within supplier, all grouped by location.
New Commission - General (1214 onwards)
This report is designed to calculate commission payable to sales staff.
New Commission - Salesperson (1214 onwards)
This report is designed to generate a commission statement for the current operator. They can only see their own sales data and require commission payable to sales staff.
New Commission - Supplier (1214 onwards)
This report is designed to produce a commission statement for a specified supplier (vendor).
Parameters
This report produces a listing of the current application parameters set in the system.
Payment Allocations
The report is designed to produce a log of payments allocated to or taken from (deallocated) from sales orders.
Payment Receipt Reprint
This report allows the operator to re-print a payment receipt for a specified sales order.
Payment Summary
This report details ‘customer’ payments and / or refunds received within the reporting period.
Performance Report
A very flexible report producing a list of the top or bottom ranked items. The ranking can be by quantity sold, cost or selling value, margin value or percentage and grouped by supplier, range, or SKU (with or without options taking into consideration). Ranked sales report lists can show either the top or bottom groupings, dependent upon selection criteria.
Performance Report Export
This audit replicates the content of the Performance report however the data is formatted to allow use with third party data systems, for example loading into a spreadsheet.
Profit Report
The report details sale, VAT and costs incurred for a user specified week with a year to date (selected week) shown alongside, broken down by supplier within product group within location.
Reconciled Cash Adjustment Audit
This report lists the date and time of when the cash reconciliation processed within the system, with the option to show only reconciliations where a cash adjustment was entered.
Reconciled Payments Summary
This report lists the date and time of when the cash reconciliation processed within the system, with the option to show only reconciliations where a cash adjustment was entered.
Reconcile Sales & Cash
This is a useful report when wishing to check the values accumulated during the financial period and checks values received, delivered, and posted to an accounting application.
Registered Invoice Report
This report is designed to show invoices entered / processed within the Invoice Matching routine.
Sales Invoice by Vat Code
This report lists deliveries (invoices) generated within a specified date range.
Sales Invoice Nominal
This report lists deliveries (invoices) generated within a specified date range.
Sales Tax Discrepancies
Primarily for the US market where tax is calculated at time of delivery, this report details variances between anticipated and actual tax.
Sales Tax History
This report designed for the US market shows tax breakdowns by sales order showing the constituent rates where set.
Sales Tax Report
Primarily for the US market, this report lists taxes due in respect of confirmed / Finalized deliveries (and collections)
Single Customer Balance
The customer balance report produces a statement for a specific customer, grouped optionally by location and / or salesperson. The details show balances across sales orders, payments, and finances with an aged banding per transaction.
Summary Analysis
This report provides summary booking and delivery analysis by day per week broken down by location with the ability to drill down into the stats.
Supplier Turnover and Profit
This report produces a list of turnover, sales and profit comparing sales of a range of weeks against year to date values.
SwanPay Audit (1214 onwards)
This report lists all payment requests sent to SwanPay within a given date range.
Taxware v Invoice
This report is used in partnership with the Taxware application, which calculates the taxes due for the American market.
Trial Balance
This report is available for companies using the ‘Sage’ accounting product and provides an audit of transactions sent from SwanFRS.
Unallocated Payments
The report details all unallocated payments grouped by location where the transaction was processed showing the SwanFRS customer number and value.
Unallocated Payments by Customer
The report details all unallocated payments grouped by location where the transaction was processed, showing the SwanFRS customer number and value.
This report is for use when operating with multi-companies.
Unallocated Receipt Reprint
This report allows the operator to re-print an unallocated payment receipt for a specified customer ID.
Uninvoiced Costs
This two-part report details all goods which are, at the time of running the report, not paid for. I.e., goods received but not yet invoice. The report details free to sell items, then items attached to sales orders.
Unreconciled Payments
This audit can be used to establish the ‘unreconciled’ payments waiting to be cash reconciled.
Warranty Summary
The report uses the application parameter settings to detail orders delivered which have a ‘warranty’ item on it. Useful for informing your ‘warranty insurance provider’ that goods have been delivered.
Weekly Payments Summary
The report shows, by week within financial year within user selected location(s) all payments received and / or refunds processed within the user specified date range.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article