Financial Reports

Created by Migration Bot, Modified on Fri, 23 Oct at 2:30 PM by Migration Bot

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. 

image-20240416-103214.png

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.

image-20250616-145539.png

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.

image-20250407-133702.png

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.

image-20240429-120339.png

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.

image-20241104-120107.png

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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article