Knowledgebase
Trading Software > Help Desk > Knowledgebase

Search help:


End Of Day: Takings Report

Solution

 

 

Date: 2018-10-11


 This document describes the output from the BMS stored procedure [sp_till_end_of_day]

 

End Of Day Taking Report

The BMS End Of Day Taking Report is distinct from a sales report in that

  • the Taking Report shows money in and out irrespective of order value
  • a Sales Report show sales order values irrespective of money taken or credited

As a result, a taking report for a given date will not necessarily equate to a sales total to the same period.

 

Access

Access the BMS Taking Report in the following way:

1) Via the Sales Register menu:

End Of Day -> End Of Day Quick Report
Limited to the current date / till
Formatted to print / email
 
End Of Day -> End Of Day By Account
Data grid of taking for the current data grouped by 'Bank Account' name
Presented in the common data viewer
 
End Of Day -> End Of Day By Account / Till
Data grid of taking for the current data grouped by 'Bank Account' name and Till name
Presented in the common data viewer

2) Via the snapshot reporting interface

Transaction -> Grouped
User-Defined-Date based report
User-Defined-Grouping

 

Sample output: Brief

----------  ---------  ---------  ---------  --------  ---------

Date        Till       Account    In         Out       Bal  

----------  ---------  ---------  ---------  --------  ---------

2018-10-06  TILL A     CRTRACKER  £125.00    £125.00        0.00

2018-10-06  TILL BB    CRTRACKER  £139.95    £139.95        0.00

2018-10-06  TILL A     CHEQUE     £40.00     £0.00         40.00

2018-10-06  TILL A     CASH       £111.58    £0.00        111.58

2018-10-06  TILL A     CARD       £1422.58   £0.00       1422.58

2018-10-06  TILL BB    CARD       £301.00    £0.00        301.00

----------  ---------  ---------  ---------  --------  ---------

Sample output: Extended (grouped by month)

---------  ---------  ---------  ---------  ---------  ---------  ---------  ---------  --------  ---------

Date       Till       Account    SaReceipt  SaPayment  PuPayment  PuReceipt  In         Out           Bal  

---------  ---------  ---------  ---------  ---------  ---------  ---------  ---------  --------  ---------

2018 M-10  TILL A     CARD         1422.58       0.00       0.00       0.00  £1422.58   £0.00       1422.58

2018 M-10  TILL BB    CARD          301.00       0.00       0.00       0.00  £301.00    £0.00        301.00

2018 M-10  TILL A     CASH          111.58       0.00       0.00       0.00  £111.58    £0.00        111.58

2018 M-10  TILL A     CHEQUE         40.00       0.00       0.00       0.00  £40.00     £0.00         40.00

2018 M-10  TILL A     CRTRACKER     125.00     125.00       0.00       0.00  £125.00    £125.00        0.00

2018 M-10  TILL BB    CRTRACKER     139.95     139.95       0.00       0.00  £139.95    £139.95        0.00

---------  ---------  ---------  ---------  ---------  ---------  ---------  ---------  --------  ---------

 

 

 

Object: http://trading-software.co.uk/helpdesk/knowledgebase.php?article=190

 

 

 
Was this article helpful? yes / no
Related articles Sales Register: Authorised Users
Receipt Printing Problems
Make this item a generic SALES ITEM
Stock Valuation By Date
Till Price Lookup
Article details
Article ID: 191
Category: Sales Register
Rating (Votes): Article rated 3.0/5.0 (16)

 
« Go back

 
Powered by Help Desk Software HESK, in partnership with SysAid Technologies