Sage 50 End of Shift – STEP 4 – Check Tender Summary Account

At the end of each day, it is necessary to check the Tender Summary account in Sage 50, as it is used as an additional audit trail account.

The account balance should remain Zero ($0.00). Every day after Sage 50 is updated by AccuPOS, you should check the balance of this account.

If this account has a Zero balance that means that sales have posted correctly.

If this account is either positive or negative, there was a problem with the update and you should contact the AccuPOS Retail Technical Support immediately. 

Below is an example of how the information is imported into Sage 50:

  1. Once the till is reset, the Z Report is generated.  Notice at the top of the report is the breakdown of the sales for that sequence. 

    Bear in mind that if you are using AccuPOS for credit card processing, the Cash amount is reduced by the credit card tip amounts. 

    For example: if before adding tips, you have $100 Cash and $100 Mastercard and then you add a $10 credit card tip to that Mastercard transaction, your tendering totals will be $90 for Cash and $110 for Mastercard.

    reset report

  1. Go to Setup   User Preferences   Options and make sure the Terminology is set to Use Accounting Terms

    use accounting terms

  2. Once the sales have been imported into Sage 50, run a General Ledger report on the Tender Summary account (95000 by default).

    financials general ledger

  3. Note that reference number of the CashSales invoice is 1001

    The 100 represents the till number and the ending 1 represents the sequence number.

    general ledger

  1. Note the Journal Entry movements out of Tender Summary for all the different tendering codes.

    journal entry

  1. In the end, after the sequence has been imported, the balance of the Tender Summary account is zero.

    tender summary