Customer reports
Account Activity Report
Summary of report
View all account sales, payment adjustment, refunds and account opened or closed for a given date range.
Details able to be restricted by group, account format (layby, Credit etc), account type (work cover, TAC, etc) or Nursing Home.
Use for:
-
At a glance account summary of sales against payment and adjustments for a given date range
-
Workcover account activity for a given date range.
-
Nursing home account activity for a given date range.
-
Discover closed (non-active) accounts with recent activity.
-
Discover new accounts opened since a give date range.
-
Layby account activity.
-
Find account with a specific comment (entered at POS Till or in Fred Office Plus).
-
How much government recovery involved on accounts over a date range.
-
All account activity related to a specific cashier over a date range.
Column Definitions
| Column Heading | Definition/Calculation | Group by | Add from Column Chooser |
|---|---|---|---|
| Account # | Identifier of specific account if included in transaction (Account Number) | ||
| CRN | Customer Reference Number | ||
| Account Name | Identifier of specific account if included in transaction | ||
| Transaction # | Identifier for specific transaction (Transaction Number) | ||
| Transaction Date | Time and date of the Transaction | Y | |
| Sales Ex | Sales for all tenders (including “by account”) ex GST recorded through the register (and, if this is the “auto-charge” register, including scripts charged direct to account for the Batch).This value has not had ‘returns” deducted | Y | |
| Payments | Value of Payment received against this account | ||
| Adjustments | Value of adjustments (journal entries) made to Account | ||
| Account Type | personal; TAC; work cover; other | ||
| Address Line 1 | Y | ||
| Address Lines 2 | Y | ||
| Company | Company recorded on account details card for this Account (if any | Y | |
| Margin % | [(Sale value ex tax- extended cost ex tax)/(Sale value ex tax)] x 100 | Y | |
| Markup% | [(Sale value ex tax- extended cost ex tax)/(Extended cost ex tax)] x 100 | Y | |
| Gov Recov | Estimated value of Govt recovery attributable to Scripts “sold” | Y | |
| Total Sales ex | Value of Sales (ex GST) charged to account plus Govt Recov | Y | |
| Disc $ | Value of Discount allowed per Item/Transaction | Y | |
| Qty Sold | Count of items in a transaction | Y | |
| Cost ex | Unit cost of the item in a transaction | Y | |
| Cashier | Cashier details | ||
| Sales Inc | Value of sale (inc GST) charged to account | ||
| GST | Value of Tax collected | Y | |
| Total Sales Inc | Value of Sales (inc GST) charged to account plus Govt Recov | Y | |
| Activity Comments | Comments added to the activity at the register | Y | |
| Item Code | Item look-up code for item charged to account | Y | |
| Item Description | Detailed description of item | Y | |
| Script Number | Y | ||
| Profit | (Retail ex tax – Cost ex tax) | Y | |
| Email Statement | Y | ||
| Statement Email | Y |
Account Balance Preview
Summary of report
Preview the 30, 60, 90 day balance of accounts before generating statements. Can filter by Type, Account Group or Nursing Home.
Use for:
-
Allows users to determine overdue account for extra changes if applicable.
-
Allows quick overview of 30, 60, 90 day balances.
-
Summary of sales against payments and adjustments for overseeing accounts.
Column Definitions
| Column Heading | Definition/Calculation | Group by | Add from Column Chooser |
|---|---|---|---|
| Account # | Identifier of specific account if included in transaction (Account Number) | ||
| Opening Balance | Value of Balance at commencement of current statement period | ||
| Sales | |||
| Payament | Value of Payment received against this account | ||
| Adj. | Value of adjustments (journal entries) made to Account | ||
| Closing Balance | Value of balance as at time of creation of this report. | ||
| Start Date | Commencement date of the statement period | Y | |
| Last Payment | Date of payment received since commencement of statement period | ||
| Overdue | Sum of the values shown as 30 days, 60 days and 90 days. | Y | |
| Days 30 | Balance not cleared since commencement of statement period that had been current at time of commencement of statement period | ||
| Days 60 | Balance not cleared since commencement of statement period that had been Showing as owing 30 days at time of commencement of statement period | ||
| Days 90 | Balance not cleared since commencement of statement period that had been Showing as owing 60 days (or more) at time of commencement of statement period | ||
| Disc . $ | Value of Discount allowed per Item/Transaction | Y | |
| Visits | Count of individual transactions per account in the period | Y | |
| First Name | |||
| Last Name | |||
| Customer Company | Company recorded on account details card for this Account (if any | Y | |
| Name | Y | ||
| Alternate Address | Y | ||
| Email Statement | Y | ||
| Statement Email | Y | ||
| CRN | Customer Reference Number |
Account List
Summary of report
List of all accounts, their general information (name, Address etc) and balances.
Use for:
-
List of overdue accounts
-
The date any account customer last used their account in the past 12 months
-
All current active credit accounts at the store
-
All currently active layby accounts at the store
-
Total visits for any or all accounts in the last 12 months
-
Where all current account customer reside – City (suburb) of any or all accounts
-
The date any or all accounts where opened
Column Definitions
| Column Heading | Definition/Calculation | Group by | Add from Column Chooser |
|---|---|---|---|
| Account # | Identifier of specific account if included in transaction (Account Number) | ||
| Name | |||
| Address Line 1 | |||
| City | part of address for account | ||
| Balance | Current total balance at the time the report is run | ||
| Last Visit | Date of last visit | ||
| First Name | Y | ||
| Last Name | Y | ||
| Company | Company recorded on account details card for this Account (if any | Y | |
| Address Line 2 | Y | ||
| Post Code | part of address | Y | |
| Statement Email | Y | ||
| Acc. Opened | Y | ||
| Visits | Count of individual transactions per account in the period | Y | |
| Overdue | Sum of the values shown as 30 days, 60 days and 90 days. | Y | |
| Account Type | personal; TAC; work cover; other | Y | |
| Email Statement | Y | ||
| CRN | Customer Reference Number |
Customer Trends
Summary of Report
Provides an overview of the Number of customer, average number of lines per transaction, % of single item Sales and % of sales with scripts for today, current month to date and last month.
Use for:
-
Compare sales for the current month vs last month
-
Compare customer number for today, month to date and last month
-
Compare single items ales and sales with scripts for month to date and last month
Column Definitions
| Column Heading | Definition/Calculation | Group by | Add from Column Chooser |
|---|---|---|---|
| Period |
A Set range of time. Today: Transaction for today’s date MTD: Transaction in the current month, Month to date Last Month: Transaction in the immediate past month |
||
| Trans Count | Number of transactions in the period | ||
| Average lines per Trans | [Lines sold / Trans Count] in period | ||
| % Single Item Sales | [(Sum of Sales with 1 Item) / Trans Count ] x 100 | ||
| % Sales with Scripts | [(Sum of Sales with a script) / Trans Count ] x 100 |
Dispensary Patient by Suburb
Summary of report
View dispensary patient locations based on their postcodes.
Column Definitions
NIL
Loyalty Activity (Fred POS Plus Only)
Summary of Report
Provides an overview of loyalty activity by Department/Category, within a specific date range.
Use for:
-
Filter by loyalty scheme to see activity by Department or Category for a specified date range
Column Definitions
| Column Heading | Definition/Calculation | Group by | Add from Column Chooser |
|---|---|---|---|
| Department | Department the item belongs to | ||
| Category | Departmental Category the item belongs to | ||
| Points Accrued | Number of points accumulated for the specific date range | ||
| Points Redeemed | Number of points used for the specific data range |
Statement Summary
Summary of report
View statement summaries for specific account formats (Credit, Layby), by batch, account group or nursing home.
Use for:
-
List of overdue account
-
30/60/90 day balances
-
At a glance statement summary of sales against payments and adjustments
Column Definitions
| Column Heading | Definition/Calculation | Group by | Add from Column Chooser |
|---|---|---|---|
| Account # | Identifier of specific account if included in transaction (Account Number) | ||
| Opening Balance | Value of Balance at commencement of current statement period | ||
| Sales | Value of sale (inc GST) charged to account | ||
| Payment | Value of Payment received against this account | ||
| Adj. | Adjustments made to account since start of statement period | ||
| Closing Balance | Value of balance as at time of creation of this report. | ||
| Start Date | Commencement date of the statement period | Y | |
| Last Payment | Date of payment received since commencement of statement period | ||
| Overdue | Sum of the values shown as 30 days, 60 days and 90 days. | Y | |
| Days 30 | Balance not cleared since commencement of statement period that had been current at time of commencement of statement period | ||
| Days 60 | Balance not cleared since commencement of statement period that had been Showing as owing 30 days at time of commencement of statement period | ||
| Days 90 | Balance not cleared since commencement of statement period that had been Showing as owing 60 days (or more) at time of commencement of statement period | ||
| Disc . $ | Value of Discount allowed per Item/Transaction | Y | |
| Visits | Count of individual transactions per account in the period | Y | |
| First Name | |||
| Last Name | |||
| Customer Company | Company recorded on account details card for this Account (if any | Y | |
| Name | Y | ||
| Statement # | Y | ||
| Alternate Company | Alternate company designated via address tab on account card (if any) | Y | |
| Batch # | The batch created at the register (Batch Number) | Y | |
| Email Statement | Y | ||
| Statement Email | Y | ||
| CRN | Customer Reference Number |
Top Loyalty Customers (Fred POS Plus Only)
Summary of Report
Provides an overview of customer by loyalty points accrued in descending order, within a specified date range
Use for:
-
View your top loyalty customer by Department or Category.
Column Definitions
| Column Heading | Definition/Calculation | Group by | Add from Column Chooser |
|---|---|---|---|
| Customer Name | Name of the Loyalty Customer | ||
| PostCode | String of four numbers that represent specific geographical location | ||
| Department | Department the item belongs to | ||
| Category | Departmental Category the item belongs to | ||
| Item Description | Detailed description of item | ||
| Points Accrued | Number of points accumulated for the specific date range | ||
| Points redeemed | Number of points used for the specific data range | ||
| Last Visit | Date of last visit | ||
| Last redeemed | Date of last exchange if points |