Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To run these reports we first need to open the Day Book Report window. 

Print Day Book Report

1

In the main menu go to => POS / Print Day Book Report. (Alt, P, D)

2

The Day Book Report window will appear

3

If in a multi-store environment, then select the appropriate branch you want to get information on.

Image Modified

It is from this window we run various daily reports.

...

This report shows sales by tender type. Shows what each till has taken in a given timeframe. It provides a list of what the transactions taken in POS so you can compare with the bank settlement for card payments.


To print this report:

Open the Day Book Report window.  (Alt, P, D)

Check the Print Day Book Report box is ticked.

Select the options you want to appear in the report.

Press F9 to generate the report

Image Modified


Sample Day Book Report

Image Modified 




If Show Tender Details was selected, a listing of all Transaction for each Tender Type is printed.  This is handy if you have a balancing query where someone may have tendered a Sale with the incorrect Tender Type.


Sample Day Book Report – Show Tender Details

Image Modified 


  Day Book Report#Back to top


Print Bank Deposit Listing

1

Open the Day Book Report window.  (Alt, P, D)

2

Check the Print Bank Deposit Listing box is ticked.

3

Enter amounts into Notes Counted and Coins Counted fields.

or

Press Load Note/Coins if you want to load individual denominations and press F9 once all money is entered.  (see Load Coins/Notes Window below)

4

Press F9 to generate the report

Image Modified
5Image Modified


Sample Bank Deposit Listing Report


Image Modified 

  Day Book Report#Back to top

Exception

...

Reports


The Exception Reports section has 6 report options from the drop down menu. There are three options displayed below.

 

Exception Reports

1

Open the Day Book Report window.  (Alt, P, D)

POS, Print Day Book Report

image-20240208-052100.pngImage Added

2

Check the Print Exception Report box is ticked.

image-20240208-052152.pngImage Added

3

Select All Prices Manually Changed from the drop down.

4

Select Staff or Department code if required.

5

Press F9 to generate the report

Image Modified

To gain a report of all prices that have been manually changed with POS (by pressing F4 or F5), run the Exception Report with the Report Type set as “All Prices Manually Changed”.

  

Sample Exception Report

 Image Modified

 Please note that this report does not show price changes from discount matrices setup on particular debtors.

  Day Book Report#Back to top

 

...

Exception Report - Below GP Percent

Exception Report - Below GP Percent

1

Open the Day Book Report window.  (Alt, P, D)

POS, Print Day Book Report

image-20240208-052100.pngImage Added

2

Check the Exception Report Options box is ticked.

3

Select Below GP Percent from the drop down.

4

Enter amount into Show GP% Lower than. You can also enter Staff or Department code if required.

5

Press F9 to generate the report

Image Modified

  

Sample Below GP Percent Report

Image Modified 

This report should be run each day to see if you are selling items below cost

  Day Book Report#Back to top

 

...

Exception Report - Negative Qty Invoice and Credit Lines Report

Negative Qty Invoice and Credit Lines Report

1

Open the Day Book Report window.  (Alt, P, D)

2

Check the Exception Report Options box is ticked.

3

Select Negative Qty Invoice and Credit Lines from the drop down.

4

Enter Staff or Department code if required.

5

Press F9 to generate the report

Image Modified

 


Sample Negative Quantities Report




This report should be run each day to see if you are selling items below cost

  Day Book Report#Back to top

 

Exception Report - Discount Reason Codes

Exception Report - Discount Reason Codes

1

Open the Day Book Report window.  (Alt, P, D)

POS, Print Day Book Report

image-20240208-052100.pngImage Added

2

Check the Exception Report Options box is ticked.

3

Select Discount Reason Codes from the drop down.

4

You can also enter Staff or Department code if required.

5

Press F9 to generate the report

Image Added

  

Sample Discount Reason Codes

 

image-20240208-053728.pngImage Added

This report should be run each day to see how are change discounts

  Day Book Report#Back to top

New Product Added Report

New Product Added Report

1

Open the Day Book Report window.  (Alt, P, D)

2

Check the Print New Product Report box is ticked.

3

Enter Staff or Department code if required.

4

Press F9 to generate the report

Image Modified
5Image Modified

  Day Book Report#Back to top

 

 

 

Debtor Balance Report

1

Open the Day Book Report window.  (Alt, P, D)

2

Check the Print Debtor Balance Report box is ticked.

3

Enter Summary only or Show All Details from the drop down menu.

4

Press F9 to generate the report

Image Modified

 

Sample Debtor Activity Report


Image Modified 

  Day Book Report#Back to top

...

The Sales Options section has 6 reports. The steps and sample reports are listed below.


Generate a Sales Report

1

Open the Day Book Report window.  (Alt, P, D)

2

Put a tick in the report you wish to generate.

Sample reports types are:


3

Select MTD and YTD

4

Press F9 to generate the report

Image Modified

   Day Book Report#Back to top


Transaction Type Sales Report

This report shows the transaction type. It shows sales spilt up in to cash, account, lay-bye etc. 

Image Modified 

  Day Book Report#Back to top


Department Sales Report

This report shows sales by individual departments.   

Image Modified

  Day Book Report#Back to top

 

Hourly Sales Report

 This report shows the sales made every hour. It can help you identify your busiest or quietest trading hours are.

Image Modified



  Day Book Report#Back to top


Customer Traffic Report

 This report shows the number of customer sales made on that day.

Image Modified


  Day Book Report#Back to top

Average Weekly Sales Report

This report shows average customer spend in a week.

 Image Modified


  Day Book Report#Back to top

 

Station Sales Report

 This report shows the number of sale made on particular till.

Image Modified

 

 Day Book Report#Back to top 

...

Filter by label (Content by label)
page
showLabelsfalse
max5
spacesSD
showSpacefalse
sortmodified
showSpacetypefalsepage
reversetruetype
labelsDay Book Report Tills Balancing
cqllabel in ( "balancing" , "tills" , "book" , "report" , "day" ) and type = "page" and space = "SD"labelsDay Book Report Tills Balancing


Page Properties
hiddentrue

yout

Related issues



...