Financial reports
To assist with reconciling your actual takings with the amount tendered through your EPOS terminal(s) (your 'computed takings'), ProEPOS provides an end of day cashing-up sheet (as we will see in the next section). This allows you to compare the actual money you have taken through the day with the amount put through the POS terminal. If there have been no mistakes then these figures should tally up.
ProEPOS provides you with three financial reports:
- Cashing-up
- Banking Breakdown
- Petty Cash
- VAT reports
Report details
Note
Reports can be updated from the details below, these are accurate as of 17/01/2025.
Cashing Up
To assist with preparing your banking ProEPOS allows you to print a Cashing up report; a copy of the balance sheet with the compiled figures for a given range of days.
You should use this report to:
- Reconcile the cash and cheques you are about to bank with the amount processed through your POS terminal(s).
- Reconcile credit/debit card banking totals with the amount processed through your POS terminal(s).
- Reconcile the value of vouchers held with the amounts processed through your POS terminal(s).
It is recommended that you follow this process each and every time you bank to ensure that:
- Mistakes aren't being made.
- Staff theft is deterred and detected.
| Report Name |
Group columns |
Detail columns |
Total columns |
Pivot column |
Value column |
| Cashing up (by denomination) |
store |
denomination, amount |
amount |
|
|
| Cashing up (by denomination, by date) |
store |
denomination |
|
date |
amount |
| Cashing up (by denomination, by terminal) |
store |
denomination |
|
term |
amount |
| Cashing up (by denomination, by terminal, by date) |
store, term |
denomination |
|
date |
amount |
| Cashing-up (Card transaction details) |
store |
datetime, term, emp, amount |
amount |
|
|
| Cashing-up report |
store |
paymenttype, computed, actual, variance |
computed, actual, variance |
|
|
| Cashing-up report (Voucher type breakdown) |
store |
voucher_type, count, amount |
count, amount |
|
|
| Cashing-up report (Voucher type breakdown, details) |
store, voucher_type |
date_time, amount |
amount |
|
|
| Cashing-up report (with payouts) |
store, type |
paymenttype, computed, actual, variance |
computed, actual, variance |
|
|
Shift Cashing up
| Report Name |
Group columns |
Detail columns |
Total columns |
Pivot column |
Value column |
| Shift cashing-up (by date) |
store |
date_time, emp, paymenttype, computed, actual, variance |
computed, actual, variance |
|
|
| Shift cashing-up (by employee) |
store, emp |
paymenttype, computed, actual, variance |
computed, actual, variance |
|
|
| Shift cashing up variances (by date) |
store |
datetime, emp, paymenttype, computed, actual, variance |
computed, actual, variance |
|
|
| Shift cashing up variances (by employee) |
store, emp |
store, emp, datetime, paymenttype, computed, actual, variance |
computed, actual, variance |
|
|
Banking Breakdown
A Banking Breakdown report is also provided. Rather than giving a combined figure for each payment type, this report shows takings by media (i.e. cash, cheque, card and voucher) for each day of the given period.
| Report Name |
Group columns |
Detail columns |
Total columns |
Pivot column |
Value column |
| Banking Breakdown |
store |
date |
|
paymenttype |
amount |
Petty Cash
A Petty Cash report allows you to view details of petty cash disbursements for a given period of time.
| Report Name |
Group columns |
Detail columns |
Total columns |
Pivot column |
Value column |
| Petty Cash (Detail) |
store |
term, emp, date_and_time, reason, payee, inv_number, amount |
amount |
|
|
Cash drops
| Report Name |
Group columns |
Detail columns |
Total columns |
Pivot column |
Value column |
| Cashdrop Report (Detailed) |
store |
date, time, term, emp, cash_dropped |
cash_dropped |
|
|
| Cashdrop Report (Extended Summary) |
store |
date, term, no_drops, emp, cash_dropped |
no_drops, cash_dropped |
|
|
| Cashdrop Report (Summary) |
store |
date, no_drops, cash_dropped |
no_drops, cash_dropped |
|
|
Cash back
| Report Name |
Group columns |
Detail columns |
Total columns |
Pivot column |
Value column |
| Cashback Report |
store |
date, time, term, emp, description, total |
total |
|
|
Lottery payouts
| Report Name |
Group columns |
Detail columns |
Total columns |
Pivot column |
Value column |
| Lottery Payouts (by month) |
store |
description |
|
month |
payout |
| Lottery Payouts (detail) |
store |
datetime, description, payout |
payout |
|
|
| Lottery Payouts (summary) |
store |
description, payout |
payout |
|
|
Revenue & Margin Comparisons
| Report Name |
Group columns |
Detail columns |
Total columns |
Pivot column |
Value column |
| Average Baskets (by month) |
store |
month |
|
year |
basket |
| Daily Revenue Comparison |
store |
week |
|
day |
total |
| Monthly Margin Comparison (?) |
store |
year |
|
month |
margin |
| Monthly Margin Comparison (%) |
store |
year |
|
month |
margin_per |
| Monthly Revenue Comparison |
store |
year |
|
month |
total |
| Monthly Revenue Comparison (by department) |
store, dept |
year |
|
month |
total |
VAT reports
| Report Name |
Group columns |
Detail columns |
Total columns |
Pivot column |
Value column |
| VAT report |
store |
taxrate, revenue, vat, net |
revenue, vat, net |
|
|
| VAT report (by department) |
store, taxrate |
department, revenue, vat, net |
revenue, vat, net |
|
|
| VAT report (by month) |
store |
yearmonth, taxrate, revenue, vat, net |
revenue, vat, net |
|
|
| VAT report (by type) |
store, type |
taxrate, revenue, vat, net |
revenue, vat, net |
|
|
| VAT report (daily breakdown) |
store |
date, taxable, nontaxable, gross, net, vat, commissionable |
taxable, nontaxable, gross, net, vat, commissionable |
|
|
Purchase Invoices
| Report Name |
Group columns |
Detail columns |
Total columns |
Pivot column |
Value column |
| Purchase Invoices - List |
|
supplier, inv_no, date, due, net, tax, total_amount, paid |
net, tax, total_amount |
|
|
| Purchase Invoices - Overdue |
|
supplier, inv_no, date, due, net, tax, total_amount, paid |
net, tax, total_amount |
|
|
| Purchase Invoices - Unpaid |
|
supplier, inv_no, date, due, net, tax, total_amount, paid |
net, tax, total_amount |
|
|
Store Finance Summary
| Report Name |
Group columns |
Detail columns |
Total columns |
Pivot column |
Value column |
| Store Finance Summary |
|
store, startdate, enddate, sales_units, sales_value, returns_units, returns_value, total_units, gross_revenue, vat, cogs, margin, margin_per |
sales_units, sales_value, returns_units, returns_value, total_units, gross_revenue, vat, cogs, margin |
|
|
| Store Profitability |
|
store, revenue, cogs, vat, margin |
revenue, cogs, vat, margin |
|
|
| Store Profitability (Detailed) |
store |
type, revenue, cogs, vat, margin |
revenue, cogs, vat, margin |
|
|
Volumatic cashview
| Report Name |
Group columns |
Detail columns |
Total columns |
Pivot column |
Value column |
| Volumatic (CashView Balance) |
|
store, date, terminal, cash |
|
|
|