Accounting entires from POS / Till system

Accounting entires from POS / Till system

Didn't find your answer?

Imagine a shop such as a Spar or Londis.
At the end of each day it has a number of totals that can be posted to a Nominal Ledger.

I am trying to get my head around what these postings might be. Can anyone make any suggestions as to what these should be?

These are some of the transactions totals / detail you would have.

1. The Opening Balance - Float
2. Total Sales broken down by a number of categories, dairy, tobacco, petrol confectionery.
3. Payment received. This can consist of different tender types such as cash cheque and credit cards. You might also have credit sales such as petrol accounts and manufacturer coupons.
4. Receipts for Credit accounts.
5. Expenses. You might pay some costs from the till, e.g. the window cleaner.
6. The closing balance.

And it starts all over the again the next day.

Would you run a separate account for undeposited cash etc.

Paul

Replies (1)

Please login or register to join the discussion.

avatar
By User deleted
04th May 2012 12:15

Starting point ....

Here is a starting point

Did this 10 years ago for export from EPos system to Sage 50 (v8?)

export - daily sales (excluding on account sales)
export - daily credits (excluding on account credits)
export - on account daily sales (on account sales only)
export - on account daily credits (on account credits only)
export - customer payments
export - InterBranch Sales
export - InterBranch Sales Credits
export - InterBranch Purchases
export - InterBranch Purchases Refunds
etc...

Tracking coupons reimbursement is always a pain

***************************************

Example Routine (from class)
=============
Public Function BuildDailySalesExOnAccountSQL(sRetailOutlet As String) As String
'Name:          BuildDailySalesExOnAccountSQL
'Description:
'Author:
'Date:
'Usage :
'Parameters:
'Return value:
'Notes :        must select by all records available for
'               transfer to accounts.
'
'               these could include composite records which are
'               part on account and part paid
'Example(s) :
'PDL :
'Amendment History
'--------------------------------------------------------------
'Reference      Date        Initials    Purpose   (in reverse date order)

'Set up default error handling
On Error GoTo Err_BuildDailySalesExOnAccountSQL:

'******** Coding starts here **********

Dim sSQL                    As String

    '------------------------------------------------------
    'sales ledger daily sales (ex on account) sql
    '------------------------------------------------------
    sSQL = "SELECT * FROM "
    sSQL = sSQL & "SaleMaster "
   
    sSQL = sSQL & "WHERE (SaleMaster.PytCustomerID = " & CheckString(0, " ")
    sSQL = sSQL & "OR SaleMaster.PytCustomerID = " & CheckString("", ") ")
   
    sSQL = sSQL & "AND RetailOutlet = " & CheckString(sRetailOutlet, " ")
    sSQL = sSQL & "AND AccountsStatus = " & eSageAccountStatus.eAccountsNotUpdated & " "
   
    sSQL = sSQL & "ORDER BY TransactionDate "
   
    '------------------------------------------------------
    'return value
    '------------------------------------------------------
    BuildDailySalesExOnAccountSQL = sSQL
   
'********** Coding ends here **********

End_BuildDailySalesExOnAccountSQL:
    Exit Function

'------------------------------------------------------
'Default error handler
'------------------------------------------------------
Err_BuildDailySalesExOnAccountSQL:

    etc.....
 
    '------------------------------------------------------
    'default behaviour exit function
    '------------------------------------------------------
    Resume End_BuildDailySalesExOnAccountSQL
End Function

***************************************

Also dont forget

VATOver/Under account for dicrepancies in the daily till z reading

Hope this is of some help

Thanks (1)