The Day Book Report is valuable to run Daily, Monthly or Yearly. It holds important information in relation to balancing, profit and customer details.

The Day Book Report is a powerful report which gives you relevant sales and profit information to effectively run your business.

What's on this page:

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

	Print Day Book Report

	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.

It is from this window we run various daily reports.

Day Book Report Window

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

Day Book Report#Back to top

Print a Day Book Report

Day Book Report options

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

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

Day Book Report#Back to top

	Print Bank Deposit Listing

	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
5

Sample Bank Deposit Listing Report

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.

All Prices Manually Changed Report
Below GP Percent Report
Negative Qty Invoice and Credit Lines Report

	Exception Reports

	Exception Reports
1	Open the Day Book Report window. (Alt, P, D) POS, Print Day Book Report
2	Check the Print Exception Report box is ticked.
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 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.

Day Book Report#Back to top

Exception Report - Below GP Percent

	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
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

Sample Below GP Percent 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 - Negative Qty Invoice and Credit Lines Report

	Steps

	Steps
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

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

	Exception Report - Discount Reason Codes
1	Open the Day Book Report window. (Alt, P, D) POS, Print Day Book Report
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

Sample Discount Reason Codes

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

	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
5

Day Book Report#Back to top

	Debtor Balance Report

	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

Sample Debtor Activity Report

Day Book Report#Back to top

Sales Report Options

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

	Generate a Sales Report

	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: Transaction Type Sales Report Department Sales Report Hourly Sales Report Customer Traffic Report Average Weekly Sales Report Station Sales Report
3	Select MTD and YTD
4	Press F9 to generate the report