Financial report

Retail > End of day> Financial report

What is the view used for?

  • The report shows an overview for all financial transactions
    • for a specific statement
    • between dates
    • for a specific user/employee

Total sales

The following numbers are the gross sales for the selected store and terminal since the beginning.

Field Description
Total sales  
Amount Accumulative turnover sales since database was created for the selected store / terminal (not only the period in question)
Other sales  
Amount Accumulative turnover sales for the selected store / terminal excluding the period in question (Total sales – Turnover during the day = Other sales)

Note: All numbers from here on are based on the selected Store, Terminal, Start and End date

Sum of day(s)

Field Description
Turnover during the day

The numbers in this section are based on total entered when training transactions, voided items, voided transactions and returns have been subtracted

No. of transactions Number of sale transactions
No. of items Number of items sold
Amount Price paid for sold items
Total amount entered The numbers in this section are based on total entered
No. of transactions All started sale transactions
No. of items Number of all items sold in started sales transactions
Amount Amount of all items in started sales transactions
Training transactions  
No. of transactions Number of transactions completed in training mode
No. of items Number of items sold – (minus) items returned in training mode
Amount Total amount sold – (minus) returns in training mode
Voided items  
No. of items Number of items that have been voided in regular sales transactions. This does not include voided lines in voided transactions.
Amount Amount of voided lines in regular sales transactions. This does not include voided lines in voided transactions.
Voided transactions  
No. of transactions Count of transactions that have been voided. The POS can print a void transaction receipt if needed.
No. of items Number of items that would have been sold in voided transactions. Return items are subtracted from regular sale items so this number can be zero or negative even if number of transactions is above zero. Voided items are not included in this number.
Amount The amount with tax that customer would have been paid for voided transactions. Return amounts are subtracted from regular sale amounts so this number can be zero or negative even if number of transactions is above zero. Voided items are not included in this number.
Returns  
No. of transactions Number of transactions that include returns.
No. of items Number of items that have been returned, either through return transaction operations or return item.
Amount The amount with tax of returned items. This amount is the price of the item before discount. Discounts are added and subtracted from the total amount entered in the next lines.
Line discount  
No. of items Number of items discounted with line or periodic discounts. All items are counted also return items.
Amount The total amount discounted with line or periodic discounts. Return discounts added to sales discounts so this value can be zero even if number of items is above zero.
Total discount  
No. of items Number of items discounted with total discounts. All items are counted also return items.
Amount

The total amount discounted with total discounts. Return discounts added to sales discounts so this value can be zero even if number of items is above zero.

 

Totals  
Total sales Should be same number as Turnover during the day.
Rounding difference This is the rounding difference i.e. difference between price of item and the amount paid. It can vary by a few cents depending on rounding.
Total sales w-out rounding diff Total sales when rounding difference has been subtracted/added.
Income account  
No. of items Number of instances where money is added to POS through an income account. Sometimes used for tips.
Amount Amount added to POS through an income account
Expense account  
No. of items Number of instances where money is removed from POS through an expense account.
Amount Amount removed from POS through an expence account.
Float entry  
No. of items Number of instances where money is added to POS through a float entry. Sometimes used for tips.
Amount Amount added to POS through an float entry
Bankdrop  
No. of items Number of instances where money is removed from POS through a Bankdrop.
Amount Amount removed from POS through a Bankdrop.
Safedrop  
No. of items Number of instances where money is removed from POS through a Safedrop.
Amount Amount removed from POS through a Safedrop.
Deposit into customer account
No. of items Number of instances were amount is deposited to customer account.
Amount The total amount deposited into customer accounts. The individual deposits are printed in the x- and z- reports and can be viewed in the customer ledger report.
Totals  
Total other Sum of other totals than item sale totals
Total sales + other Sum of other totals + sales without rounding difference totals. This number should match the Payment total number.

Payment totals

Field Description
"Payment type"  
Count The number of payment transactions paid and tendered as cash back with this payment type.
Amount The total amount paid with this payment type.
"Card type"  
Count The number of payment transactions paid with this cardtype
Amount The total amount paid with this cardtype
Totals  
Total Total amount paid with all payment types

 

Scanner usage

Field Description
Registered items All items sold from button, item search, keyboard input or keyboard scanner input.
Scanned items (OPOS) All items scanned with OPOS scanner

 

Totals

Field Description
Drawer opened manually Drawer was opened with Open drawer operation
Tender declaration  
Count Number of times tender was counted on POS
Amount Amount counted
Negative transactions  
Count Count of all negative transactions, both sales and other
Amount Amount of negative transaction, bot sales and other
Number of sales transactions  
Count Number of sales transactions or customers
Number of items  
Count Number of items sold – (minus) returns. Voided and training items are not included in this number.

 

Hourly report

List of number of sales transactions, number of sold items and total amount of sales per hour.

 

Sales tax group breakdown

Field Description
Sales tax group ID  
Net amount Net amount sales for this sales tax group
Tax amount Tax amount sales for this sales tax group.
Gross amount Gross amount sales for this sales tax group.

 

Currency

Field Description
Currency type  
Number of trans. The number of transactions paid and tendered with this currency type.
Currency amount The amount paid with this currency type.
Store currency amount The amount paid with this currency in store currency amount.