The Day Book Report is a powerful report which gives you relevant sales and profit information to effectively run your business.
To run these reports we first need to open the Day Book Report window.

Open the Day Book Report Window
	In the main menu go to => POS / Print Day Book Report.
	The Day Book Report window will appear
	If in a multi-store environment, then select the appropriate branch you want to get information on.

It is from this window we run various daily reports.

Day Book Report Window

The day book report winmdow is made up of a Header and 8 other areas that produce reports.

	Header
	Day Book Report Options
	New Product Report Options
	Bank Deposit Listing
	Debtor Balance Report Options
	Exception Report Options
	Sales Report Options
	Loyalty Report Options
	Loyalty Transaction Report Options

Print a Day Book Report
	Open the Day Book Report window. (see Open the Day Book Report Window)
	Check the Print Day Book Report box is ticked.
	Select the options you want to appear in the report.
	Hit F9 to generate the report

Sample Day Book Report

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

Bank Deposit Listing
	Open the Day Book Report window. (see Open the Day Book Report Window)
	Check the Print Bank Deposit Listing box is ticked.
	Enter amounts into Notes Counted and Coins Counted fields. or Hit Load Note/Coins if you want to load individual denominations and press F9 once all money is entered. (see Load Coins/Notes Window below)
	Hit F9 to generate the report

Handy Hint
This report can be printed out and taken to the bank with your cheques for easy bank deposits.

| |

Load Coins/Notes Window
*Enter amounts in the Quantity column and press F9 to save. It will auto populate the totals in step 3.*

Sample Bank Deposit Listing Report

Exception Report Options

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

Exception Report
	Open the Day Book Report window. (see Open the Day Book Report Window)
	Check the Print Exception Report box is ticked.
	Select All Prices Manually Changed from the drop down.
	Select Staff or Department code if required.
	Hit F9 to generate the report
*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

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

Below GP Percent Report
	Open the Day Book Report window. (see Open the Day Book Report Window)
	Check the Exception Report Options box is ticked.
	Select Below GP Percent from the drop down.
	Enter amount into Show GP% Lower than. You can also enter Staff or Department code if required.
	Hit F9 to generate the report

Sample Below GP Percent Report

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

Negative Qty Invoice and Credit Lines Report
	Open the Day Book Report window. (see Open the Day Book Report Window)
	Check the Exception Report Options box is ticked.
	Select Negative Qty Invoice and Credit Lines from the drop down.
	Enter Staff or Department code if required.
	Hit F9 to generate the report

Sample Negative Quantities Report

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

New Product Added Report
	Open the Day Book Report window. (see Open the Day Book Report Window)
	Check the Print New Product Report box is ticked.
	Enter Staff or Department code if required.
	Hit F9 to generate the report

Sample New Products Report

Debtor Balance Report
	Open the Day Book Report window. (see Open the Day Book Report Window)
	Check the Print Debtor Balance Report box is ticked.
	Enter Summary only or Show All Details from the drop down menu.
	Hit F9 to generate the report

Sample New Products Report

Sales Report Options

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

Generate a Sales Report
	Open the Day Book Report window. (see Open the Day Book Report Window)
	Put a tick in the report you wish to generate. Sample reports types are: Transaction Type Sales Report Department Sales Report Hourly Sales Report Customer Traffic Report Average Weekly Sales Report Station Sales Report
	Select MTD and YTD
	Hit F9 to generate the report

Open the Day Book Report Window

Day Book Report Window

Print a Day Book Report

Sample Day Book Report

Sample Day Book Report – Show Tender Details

Bank Deposit Listing

Load Coins/Notes Window

Sample Bank Deposit Listing Report

Exception Report Options