Sage 50 Canadian End of Day / 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, Go to Reports   Financials   General Ledger and select the Tender Summary account.

    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.

    cashsales reference number

 

  1. If you double click on AccuPOS Tendering, note the Journal Entry movements out of Tender Summary for all the sales. These are broken down based off the tendering codes.

    cashsales journal entry

 

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

    cashsales tender summary